File: C:\AssetWorks\FASuite\QA-Mario-ora\Logs\202607\20260703\AppServer\51001\sqlerr.log
07/03/26 01:27:55 Port 51001: [thread_id=00007FF75D0081D0] sql_select: emsapp_dbaliv338147
SQLERR ORA: 3113, Error occurred at OcilibStatementExecuteInternal: ORA-03113: end-of-file on communication channel
Process ID: 15584
Session ID: 135 Serial number: 178
SELECT is_alive FROM SYS_CHECK
-------------------------
07/03/26 01:27:55 Port 51001: SQLDELAY -18- [thread_id=0000000000000000]: SELECT is_alive FROM SYS_CHECK
07/03/26 01:27:56 Port 51001: SQLDELAYTOTAL -19- [thread_id=0000000000000000]: SELECT is_alive FROM SYS_CHECK
07/03/26 01:28:03 Port 51001: [thread_id=0000019A726FFF80] sql_select: dbconn_check338148
SQLERR ORA: 3113, Error occurred at OcilibStatementExecuteInternal: ORA-03113: end-of-file on communication channel
Process ID: 20408
Session ID: 1124 Serial number: 4346
SELECT SYSDATE FROM DUAL
-------------------------
07/03/26 01:28:03 Port 51001: SQLDELAY -19- [thread_id=0000019A726FFF80]: SELECT SYSDATE FROM DUAL
07/03/26 01:28:03 Port 51001: SQLDELAYTOTAL -19- [thread_id=0000019A726FFF80]: SELECT SYSDATE FROM DUAL
07/03/26 01:28:03 Port 51001: Removing bad DB connection: [thread_id=0000019A726FFF80]
-------------------------
07/03/26 01:28:24 Port 51001: [thread_id=00000021171FF118] sql_select: GENERIC_CURSOR
SQLERR ORA: 12170, Error occurred at OcilibConnectionAttach: ORA-12170: TNS:Connect timeout occurred
-------------------------
07/03/26 01:28:24 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sql_threadconnect
07/03/26 01:28:24 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sql_threadconnect
07/03/26 01:28:32 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 01:28:32 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 01:28:46 Port 51001: [thread_id=00000021171FF118] sql_select: GENERIC_CURSOR
SQLERR ORA: 12170, Error occurred at OcilibConnectionAttach: ORA-12170: TNS:Connect timeout occurred
-------------------------
07/03/26 01:28:46 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sql_threadconnect
07/03/26 01:28:46 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sql_threadconnect
07/03/26 01:28:46 Port 51001: [thread_id=00000021171FF3C8] sql_select: GENERIC_CURSOR
SQLERR ORA: 3114, Error occurred at OcilibConnectionCommit: ORA-03114: not connected to ORACLE
-------------------------
07/03/26 01:28:46 Port 51001: [thread_id=00007FF75D0081D0] sql_select: fes_cursor338149
SQLERR ORA: 3114, Error occurred at OcilibStatementPrepareInternal: ORA-03114: not connected to ORACLE
SELECT LOC_loc_code, loc_year, loc_month, max(row_id) as maxRowID, max(x_datetime_insert) as maxDateTimeInsert,sum(pm_ords_opened) as pmOrdersOpened, sum(pm_ords_closed) as pmOrdersClosed, sum(qty_pm_labor_hrs) as XXFLT1202_qtyPmLaborHours, sum(value_pm_labor) as XXFLT1202_valuePmLabor, sum(value_pm_parts) as XXFLT1202_valuePmParts, sum(value_pm_coml_labor) as XXFLT1202_valuePmCmlLabor, sum(value_pm_coml_parts) as XXFLT1202_valuePmCmlParts, sum(repr_ords_opened) as repairOrdersOpened, sum(repr_ords_closed) as repairOrdersClosed, sum(qty_repair_labor_hrs) as XXFLT1202_repairLaborHours, sum(value_repair_labor) as XXFLT1202_valueRepairLabor, sum(value_repair_parts) as XXFLT1202_valueRepairParts, sum(value_repr_cml_labor) as XXFLT1202_valueRepairCmlLabor, sum(value_repr_cml_parts) as XXFLT1202_valueRepairCmlParts, sum(repr_tasks_done) as repairTasksDone, sum(down_hours_closed) as XXFLT1202_downHoursClosed, sum(qty_comeback_tasks) as qtyComebackTasks, sum(qty_indir_labor_hrs) as XXFLT1202_qtyIndirectLaborHours, sum(value_indirect_labor) as XXFLT1202_valueIndirectLabor, sum(value_indirect_parts) as XXFLT1202_valueIndirectParts, sum(value_parts_received) as XXFLT1202_valuePartsReceived, sum(value_parts_trans_in) as XXFLT1202_valuePartsTransferIn, sum(value_parts_trf_out) as XXFLT1202_valuePartsTransferOut, sum(value_parts_adj_dol) as XXFLT1202_valuePartsAdjustment, sum(qty_parts_recvd_late) as XXFLT1402_qtyPartsReceivedLate, sum(parts_tot_days_late) as partsTotalDaysLate, sum(value_parts_issued) as XXFLT1202_valuePartsIssued, sum(inv_rb_ords_opened) as invRebuildOrdersOpened, sum(inv_rb_ords_closed) as invRebuildOrdersClosed, sum(qty_inv_rb_labor_hrs) as XXFLT1202_invRebuildLaborHours, sum(value_inv_rb_labor) as XXFLT1202_valueRebuildLabor, sum(value_inv_rb_parts) as XXFLT1202_valueRebuildParts, sum(value_inv_rb_cml_labor) as XXFLT1202_valueRebuildCmlLabor, sum(value_inv_rb_cml_parts) as XXFLT1202_valueRebuildCmlParts FROM FAC_MAIN_EVENT WHERE APP_id = 'fa-eam-rls01:51001' group by LOC_loc_code, loc_year, loc_month order by LOC_loc_code, loc_year desc, loc_month desc
-------Bind SQL-------
SELECT LOC_loc_code, loc_year, loc_month, max(row_id) as maxRowID, max(x_datetime_insert) as maxDateTimeInsert,sum(pm_ords_opened) as pmOrdersOpened, sum(pm_ords_closed) as pmOrdersClosed, sum(qty_pm_labor_hrs) as XXFLT1202_qtyPmLaborHours, sum(value_pm_labor) as XXFLT1202_valuePmLabor, sum(value_pm_parts) as XXFLT1202_valuePmParts, sum(value_pm_coml_labor) as XXFLT1202_valuePmCmlLabor, sum(value_pm_coml_parts) as XXFLT1202_valuePmCmlParts, sum(repr_ords_opened) as repairOrdersOpened, sum(repr_ords_closed) as repairOrdersClosed, sum(qty_repair_labor_hrs) as XXFLT1202_repairLaborHours, sum(value_repair_labor) as XXFLT1202_valueRepairLabor, sum(value_repair_parts) as XXFLT1202_valueRepairParts, sum(value_repr_cml_labor) as XXFLT1202_valueRepairCmlLabor, sum(value_repr_cml_parts) as XXFLT1202_valueRepairCmlParts, sum(repr_tasks_done) as repairTasksDone, sum(down_hours_closed) as XXFLT1202_downHoursClosed, sum(qty_comeback_tasks) as qtyComebackTasks, sum(qty_indir_labor_hrs) as XXFLT1202_qtyIndirectLaborHours, sum(value_indirect_labor) as XXFLT1202_valueIndirectLabor, sum(value_indirect_parts) as XXFLT1202_valueIndirectParts, sum(value_parts_received) as XXFLT1202_valuePartsReceived, sum(value_parts_trans_in) as XXFLT1202_valuePartsTransferIn, sum(value_parts_trf_out) as XXFLT1202_valuePartsTransferOut, sum(value_parts_adj_dol) as XXFLT1202_valuePartsAdjustment, sum(qty_parts_recvd_late) as XXFLT1402_qtyPartsReceivedLate, sum(parts_tot_days_late) as partsTotalDaysLate, sum(value_parts_issued) as XXFLT1202_valuePartsIssued, sum(inv_rb_ords_opened) as invRebuildOrdersOpened, sum(inv_rb_ords_closed) as invRebuildOrdersClosed, sum(qty_inv_rb_labor_hrs) as XXFLT1202_invRebuildLaborHours, sum(value_inv_rb_labor) as XXFLT1202_valueRebuildLabor, sum(value_inv_rb_parts) as XXFLT1202_valueRebuildParts, sum(value_inv_rb_cml_labor) as XXFLT1202_valueRebuildCmlLabor, sum(value_inv_rb_cml_parts) as XXFLT1202_valueRebuildCmlParts FROM FAC_MAIN_EVENT WHERE APP_id = :s_0 group by LOC_loc_code, loc_year, loc_month order by LOC_loc_code, loc_year desc, loc_month desc
---Bind Var : Value---
Bind Var: :s_0 Value: fa-eam-rls01:51001
-------------------------
07/03/26 01:28:46 Port 51001: [thread_id=00000021171FF4C8] sql_select: GENERIC_CURSOR
SQLERR ORA: 3114, Error occurred at OcilibConnectionRollback: ORA-03114: not connected to ORACLE
-------------------------
07/03/26 01:28:46 Port 51001: [thread_id=00000021158FF6A8] sql_select: GENERIC_CURSOR
SQLERR ORA: 3114, Error occurred at OcilibConnectionCommit: ORA-03114: not connected to ORACLE
-------------------------
07/03/26 01:29:10 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 01:29:10 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 01:29:49 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 01:29:49 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 01:30:53 Port 51001: SQLDELAY -47- [thread_id=0000000000000000]: sqlconnect
07/03/26 01:30:53 Port 51001: SQLDELAYTOTAL -47- [thread_id=0000000000000000]: sqlconnect
07/03/26 01:31:26 Port 51001: SQLDELAY -30- [thread_id=000001D9695CB540]: sql_threadconnect
07/03/26 01:31:26 Port 51001: SQLDELAYTOTAL -30- [thread_id=000001D9695CB540]: sql_threadconnect
07/03/26 01:58:04 Port 51001: [thread_id=000001D9695CB540] sql_select: dbconn_check579
SQLERR ORA: 3135, Error occurred at OcilibStatementExecuteInternal: ORA-03135: connection lost contact
Process ID: 36056
Session ID: 507 Serial number: 39578
SELECT SYSDATE FROM DUAL
-------------------------
07/03/26 01:58:04 Port 51001: Removing bad DB connection: [thread_id=000001D9695CB540]
-------------------------
07/03/26 01:58:04 Port 51001: [thread_id=000000760F1FEE68] sql_select: GENERIC_CURSOR
SQLERR ORA: 12514, Error occurred at OcilibConnectionAttach: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
-------------------------
07/03/26 01:58:05 Port 51001: [thread_id=000000760F1FEE68] sql_select: GENERIC_CURSOR
SQLERR ORA: 12514, Error occurred at OcilibConnectionAttach: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
-------------------------
07/03/26 01:58:05 Port 51001: [thread_id=000000760F1FEE68] sql_select: GENERIC_CURSOR
SQLERR ORA: 12514, Error occurred at OcilibConnectionAttach: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
-------------------------
07/03/26 01:58:06 Port 51001: [thread_id=000000760F1FEE68] sql_select: GENERIC_CURSOR
SQLERR ORA: 12514, Error occurred at OcilibConnectionAttach: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
-------------------------
07/03/26 01:58:06 Port 51001: [thread_id=000000760F1FEE68] sql_select: GENERIC_CURSOR
SQLERR ORA: 12514, Error occurred at OcilibConnectionAttach: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
-------------------------
07/03/26 01:58:08 Port 51001: [thread_id=00007FF75D0081D0] sql_select: emsapp_dbaliv580
SQLERR ORA: 3135, Error occurred at OcilibStatementExecuteInternal: ORA-03135: connection lost contact
Process ID: 25280
Session ID: 384 Serial number: 22111
SELECT is_alive FROM SYS_CHECK
-------------------------
07/03/26 01:58:35 Port 51001: SQLDELAY -15- [thread_id=0000000000000000]: sqlconnect
07/03/26 01:58:35 Port 51001: SQLDELAYTOTAL -15- [thread_id=0000000000000000]: sqlconnect
07/03/26 02:00:15 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 02:00:15 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 02:03:04 Port 51001: SQLDELAY -9- [thread_id=0000000000000000]: sqlconnect
07/03/26 02:03:04 Port 51001: SQLDELAYTOTAL -9- [thread_id=0000000000000000]: sqlconnect
07/03/26 02:09:40 Port 51001: SQLDELAY -46- [thread_id=0000000000000000]: sqlconnect
07/03/26 02:09:40 Port 51001: SQLDELAYTOTAL -46- [thread_id=0000000000000000]: sqlconnect
07/03/26 02:10:14 Port 51001: SQLDELAY -31- [thread_id=000002E952EEE380]: sql_threadconnect
07/03/26 02:10:14 Port 51001: SQLDELAYTOTAL -31- [thread_id=000002E952EEE380]: sql_threadconnect
07/03/26 03:29:44 Port 51001: [thread_id=000002E952EEE380] sql_select: dbconn_check1633
SQLERR ORA: 3113, Error occurred at OcilibStatementExecuteInternal: ORA-03113: end-of-file on communication channel
Process ID: 1484
Session ID: 876 Serial number: 2743
SELECT SYSDATE FROM DUAL
-------------------------
07/03/26 03:29:44 Port 51001: SQLDELAY -19- [thread_id=000002E952EEE380]: SELECT SYSDATE FROM DUAL
07/03/26 03:29:44 Port 51001: SQLDELAYTOTAL -19- [thread_id=000002E952EEE380]: SELECT SYSDATE FROM DUAL
07/03/26 03:29:44 Port 51001: Removing bad DB connection: [thread_id=000002E952EEE380]
-------------------------
07/03/26 03:29:45 Port 51001: [thread_id=00007FF75D0081D0] sql_select: emsapp_dbaliv1634
SQLERR ORA: 3113, Error occurred at OcilibStatementExecuteInternal: ORA-03113: end-of-file on communication channel
Process ID: 4372
Session ID: 1120 Serial number: 25383
SELECT is_alive FROM SYS_CHECK
-------------------------
07/03/26 03:29:45 Port 51001: SQLDELAY -18- [thread_id=0000000000000000]: SELECT is_alive FROM SYS_CHECK
07/03/26 03:29:45 Port 51001: SQLDELAYTOTAL -18- [thread_id=0000000000000000]: SELECT is_alive FROM SYS_CHECK
07/03/26 03:30:05 Port 51001: [thread_id=000000B1CEDFF1A8] sql_select: GENERIC_CURSOR
SQLERR ORA: 12170, Error occurred at OcilibConnectionAttach: ORA-12170: TNS:Connect timeout occurred
-------------------------
07/03/26 03:30:05 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sql_threadconnect
07/03/26 03:30:05 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sql_threadconnect
07/03/26 03:30:19 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:30:19 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:30:27 Port 51001: [thread_id=000000B1CEDFF1A8] sql_select: GENERIC_CURSOR
SQLERR ORA: 12170, Error occurred at OcilibConnectionAttach: ORA-12170: TNS:Connect timeout occurred
-------------------------
07/03/26 03:30:27 Port 51001: SQLDELAY -22- [thread_id=0000000000000000]: sql_threadconnect
07/03/26 03:30:27 Port 51001: SQLDELAYTOTAL -22- [thread_id=0000000000000000]: sql_threadconnect
07/03/26 03:30:27 Port 51001: [thread_id=000000B1CEDFF458] sql_select: GENERIC_CURSOR
SQLERR ORA: 3114, Error occurred at OcilibConnectionCommit: ORA-03114: not connected to ORACLE
-------------------------
07/03/26 03:30:27 Port 51001: [thread_id=00007FF75D0081D0] sql_select: fes_cursor1635
SQLERR ORA: 3114, Error occurred at OcilibStatementPrepareInternal: ORA-03114: not connected to ORACLE
SELECT LOC_loc_code, loc_year, loc_month, max(row_id) as maxRowID, max(x_datetime_insert) as maxDateTimeInsert,sum(pm_ords_opened) as pmOrdersOpened, sum(pm_ords_closed) as pmOrdersClosed, sum(qty_pm_labor_hrs) as XXFLT1202_qtyPmLaborHours, sum(value_pm_labor) as XXFLT1202_valuePmLabor, sum(value_pm_parts) as XXFLT1202_valuePmParts, sum(value_pm_coml_labor) as XXFLT1202_valuePmCmlLabor, sum(value_pm_coml_parts) as XXFLT1202_valuePmCmlParts, sum(repr_ords_opened) as repairOrdersOpened, sum(repr_ords_closed) as repairOrdersClosed, sum(qty_repair_labor_hrs) as XXFLT1202_repairLaborHours, sum(value_repair_labor) as XXFLT1202_valueRepairLabor, sum(value_repair_parts) as XXFLT1202_valueRepairParts, sum(value_repr_cml_labor) as XXFLT1202_valueRepairCmlLabor, sum(value_repr_cml_parts) as XXFLT1202_valueRepairCmlParts, sum(repr_tasks_done) as repairTasksDone, sum(down_hours_closed) as XXFLT1202_downHoursClosed, sum(qty_comeback_tasks) as qtyComebackTasks, sum(qty_indir_labor_hrs) as XXFLT1202_qtyIndirectLaborHours, sum(value_indirect_labor) as XXFLT1202_valueIndirectLabor, sum(value_indirect_parts) as XXFLT1202_valueIndirectParts, sum(value_parts_received) as XXFLT1202_valuePartsReceived, sum(value_parts_trans_in) as XXFLT1202_valuePartsTransferIn, sum(value_parts_trf_out) as XXFLT1202_valuePartsTransferOut, sum(value_parts_adj_dol) as XXFLT1202_valuePartsAdjustment, sum(qty_parts_recvd_late) as XXFLT1402_qtyPartsReceivedLate, sum(parts_tot_days_late) as partsTotalDaysLate, sum(value_parts_issued) as XXFLT1202_valuePartsIssued, sum(inv_rb_ords_opened) as invRebuildOrdersOpened, sum(inv_rb_ords_closed) as invRebuildOrdersClosed, sum(qty_inv_rb_labor_hrs) as XXFLT1202_invRebuildLaborHours, sum(value_inv_rb_labor) as XXFLT1202_valueRebuildLabor, sum(value_inv_rb_parts) as XXFLT1202_valueRebuildParts, sum(value_inv_rb_cml_labor) as XXFLT1202_valueRebuildCmlLabor, sum(value_inv_rb_cml_parts) as XXFLT1202_valueRebuildCmlParts FROM FAC_MAIN_EVENT WHERE APP_id = 'fa-eam-rls01:51001' group by LOC_loc_code, loc_year, loc_month order by LOC_loc_code, loc_year desc, loc_month desc
-------Bind SQL-------
SELECT LOC_loc_code, loc_year, loc_month, max(row_id) as maxRowID, max(x_datetime_insert) as maxDateTimeInsert,sum(pm_ords_opened) as pmOrdersOpened, sum(pm_ords_closed) as pmOrdersClosed, sum(qty_pm_labor_hrs) as XXFLT1202_qtyPmLaborHours, sum(value_pm_labor) as XXFLT1202_valuePmLabor, sum(value_pm_parts) as XXFLT1202_valuePmParts, sum(value_pm_coml_labor) as XXFLT1202_valuePmCmlLabor, sum(value_pm_coml_parts) as XXFLT1202_valuePmCmlParts, sum(repr_ords_opened) as repairOrdersOpened, sum(repr_ords_closed) as repairOrdersClosed, sum(qty_repair_labor_hrs) as XXFLT1202_repairLaborHours, sum(value_repair_labor) as XXFLT1202_valueRepairLabor, sum(value_repair_parts) as XXFLT1202_valueRepairParts, sum(value_repr_cml_labor) as XXFLT1202_valueRepairCmlLabor, sum(value_repr_cml_parts) as XXFLT1202_valueRepairCmlParts, sum(repr_tasks_done) as repairTasksDone, sum(down_hours_closed) as XXFLT1202_downHoursClosed, sum(qty_comeback_tasks) as qtyComebackTasks, sum(qty_indir_labor_hrs) as XXFLT1202_qtyIndirectLaborHours, sum(value_indirect_labor) as XXFLT1202_valueIndirectLabor, sum(value_indirect_parts) as XXFLT1202_valueIndirectParts, sum(value_parts_received) as XXFLT1202_valuePartsReceived, sum(value_parts_trans_in) as XXFLT1202_valuePartsTransferIn, sum(value_parts_trf_out) as XXFLT1202_valuePartsTransferOut, sum(value_parts_adj_dol) as XXFLT1202_valuePartsAdjustment, sum(qty_parts_recvd_late) as XXFLT1402_qtyPartsReceivedLate, sum(parts_tot_days_late) as partsTotalDaysLate, sum(value_parts_issued) as XXFLT1202_valuePartsIssued, sum(inv_rb_ords_opened) as invRebuildOrdersOpened, sum(inv_rb_ords_closed) as invRebuildOrdersClosed, sum(qty_inv_rb_labor_hrs) as XXFLT1202_invRebuildLaborHours, sum(value_inv_rb_labor) as XXFLT1202_valueRebuildLabor, sum(value_inv_rb_parts) as XXFLT1202_valueRebuildParts, sum(value_inv_rb_cml_labor) as XXFLT1202_valueRebuildCmlLabor, sum(value_inv_rb_cml_parts) as XXFLT1202_valueRebuildCmlParts FROM FAC_MAIN_EVENT WHERE APP_id = :s_0 group by LOC_loc_code, loc_year, loc_month order by LOC_loc_code, loc_year desc, loc_month desc
---Bind Var : Value---
Bind Var: :s_0 Value: fa-eam-rls01:51001
-------------------------
07/03/26 03:30:27 Port 51001: [thread_id=000000B1CEDFF558] sql_select: GENERIC_CURSOR
SQLERR ORA: 3114, Error occurred at OcilibConnectionRollback: ORA-03114: not connected to ORACLE
-------------------------
07/03/26 03:30:27 Port 51001: [thread_id=000000B1CD5FF148] sql_select: GENERIC_CURSOR
SQLERR ORA: 3114, Error occurred at OcilibConnectionCommit: ORA-03114: not connected to ORACLE
-------------------------
07/03/26 03:30:57 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:30:57 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:31:36 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:31:36 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:32:14 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:32:14 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:32:53 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:32:53 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:33:31 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:33:31 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:34:09 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:34:09 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:34:48 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:34:48 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:35:26 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:35:26 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:36:05 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:36:05 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:36:45 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:36:45 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:37:25 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:37:25 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:38:04 Port 51001: SQLDELAY -22- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:38:04 Port 51001: SQLDELAYTOTAL -22- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:38:42 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:38:42 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:39:20 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:39:20 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:39:59 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:39:59 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:40:37 Port 51001: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 03:40:37 Port 51001: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect
07/03/26 04:00:55 Port 51001: SQLDELAY -47- [thread_id=0000000000000000]: sqlconnect
07/03/26 04:00:55 Port 51001: SQLDELAYTOTAL -47- [thread_id=0000000000000000]: sqlconnect
07/03/26 04:02:00 Port 51001: SQLDELAY -47- [thread_id=0000000000000000]: sqlconnect
07/03/26 04:02:00 Port 51001: SQLDELAYTOTAL -47- [thread_id=0000000000000000]: sqlconnect
07/03/26 04:03:04 Port 51001: SQLDELAY -47- [thread_id=0000000000000000]: sqlconnect
07/03/26 04:03:04 Port 51001: SQLDELAYTOTAL -47- [thread_id=0000000000000000]: sqlconnect
07/03/26 04:04:09 Port 51001: SQLDELAY -47- [thread_id=0000000000000000]: sqlconnect
07/03/26 04:04:09 Port 51001: SQLDELAYTOTAL -47- [thread_id=0000000000000000]: sqlconnect
07/03/26 04:05:13 Port 51001: SQLDELAY -46- [thread_id=0000000000000000]: sqlconnect
07/03/26 04:05:13 Port 51001: SQLDELAYTOTAL -46- [thread_id=0000000000000000]: sqlconnect
07/03/26 04:05:20 Port 51001: SQLDELAY -7- [thread_id=0000000000000000]: SELECT count(*) from EQ_MAIN, PRS_MAIN WHERE asset_type IN ( SELECT asset_type FROM ASSET_TYPE WHERE legacy_type = 'ASSET') AND EQ_MAIN.procst_proc_status = PRS_MAIN.procst_proc_status AND PRS_MAIN.unit_is_active = 'Y'
07/03/26 04:05:20 Port 51001: SQLDELAYTOTAL -7- [thread_id=0000000000000000]: SELECT count(*) from EQ_MAIN, PRS_MAIN WHERE asset_type IN ( SELECT asset_type FROM ASSET_TYPE WHERE legacy_type = 'ASSET') AND EQ_MAIN.procst_proc_status = PRS_MAIN.procst_proc_status AND PRS_MAIN.unit_is_active = 'Y'
07/03/26 04:05:28 Port 51001: SQLDELAY -8- [thread_id=0000000000000000]: UPDATE SYS_COUNT SET cur_count = 13672 WHERE count_id = 1
07/03/26 04:05:28 Port 51001: SQLDELAYTOTAL -8- [thread_id=0000000000000000]: UPDATE SYS_COUNT SET cur_count = 13672 WHERE count_id = 1
07/03/26 04:05:58 Port 51001: SQLDELAY -30- [thread_id=0000021782F1ED60]: sql_threadconnect
07/03/26 04:05:58 Port 51001: SQLDELAYTOTAL -30- [thread_id=0000021782F1ED60]: sql_threadconnect