Code:
[casupport@wycvlapph048 epagent]$ tail -10f IntroscopeEPA.log
4/26/17 12:00:57 PM BST [DEBUG] [OraclePlugin] [FAILEDTRANSACTIONS] query: SELECT STATUS, UPDATED_TIMESTAMP FROM VMS_SCHEMA.VEND_STATUS_HISTORY WHERE UPDATED_TIMESTAMP > to_timestamp('26-04-17 11.00.26.235','DD-MM-RR HH24.MI.SS.FF') AND STATUS IN (10,15,20,25,30,35,40,50,55,300,310,350,60,70,75,80,125,45,65,105,106,107,108,109,110,40,320,330,340,145,109) ORDER BY UPDATED_TIMESTAMP ASC ;
4/26/17 12:00:57 PM BST [DEBUG] [OraclePlugin] FailedTransactions polling took: 35ms
4/26/17 12:00:57 PM BST [DEBUG] [OraclePlugin] [VENDATTEMPTS] normal: 26-04-17 11.00.26.235
4/26/17 12:00:57 PM BST [DEBUG] [OraclePlugin] [VENDATTEMPTS] reference: 27-04-17 00.00.00.000
4/26/17 12:00:57 PM BST [DEBUG] [OraclePlugin] [VENDATTEMPTS] current: 26-04-17 12.00.57.101
4/26/17 12:00:57 PM BST [DEBUG] [OraclePlugin] [VENDATTEMPTS] query: SELECT SOURCE, STATUS, PAN, VENDCODE, VEND_TRANSACTION.TRANSACTION_ID, MSN, CREATED_TIMESTAMP, UPDATED_TIMESTAMP FROM VMS_SCHEMA.VEND_TRANSACTION INNER JOIN VMS_SCHEMA.VEND_STATUS_HISTORY ON VEND_TRANSACTION.TRANSACTION_ID = VEND_STATUS_HISTORY.TRANSACTION_ID WHERE UPDATED_TIMESTAMP > to_timestamp('26-04-17 11.00.26.235','DD-MM-RR HH24.MI.SS.FF') AND STATUS IN (100,10,15,20,25,30,35,40,50,55,300,310,350,60,70,75,80,125,45,65,105,106,107,108,109,110,40,320,330,340,145,109) AND CREATED_TIMESTAMP IS NOT NULL ORDER BY UPDATED_TIMESTAMP ASC ;
4/26/17 12:00:57 PM BST [DEBUG] [OraclePlugin] [VENDATTEMPTS] result counter: 10
4/26/17 12:00:57 PM BST [DEBUG] [OraclePlugin] VendAttempts polling took: 38ms
4/26/17 12:00:57 PM BST [DEBUG] [OraclePlugin] Complete polling took: 263ms
4/26/17 12:00:57 PM BST [INFO] [OraclePlugin] Run finished in 0s
4/26/17 12:00:57 PM BST [DEBUG] [OraclePlugin] Heartbeat!