08/30/26 12:59:13 Port 51244: SQLDELAYTOTAL -11- [thread_id=0000000000000000]: sqlconnect 08/30/26 12:59:56 Port 51244: SQLDELAY -7- [thread_id=0000000000000000]: sqlconnect 08/30/26 12:59:56 Port 51244: SQLDELAYTOTAL -7- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:00:26 Port 51244: SQLDELAY -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:00:26 Port 51244: SQLDELAYTOTAL -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:01:15 Port 51244: SQLDELAY -13- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:01:15 Port 51244: SQLDELAYTOTAL -13- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:02:37 Port 51244: SQLDELAY -9- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:02:37 Port 51244: SQLDELAYTOTAL -9- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:03:25 Port 51244: SQLDELAY -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:03:25 Port 51244: SQLDELAYTOTAL -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:04:14 Port 51244: SQLDELAY -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:04:14 Port 51244: SQLDELAYTOTAL -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:06:22 Port 51244: SQLDELAY -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:06:22 Port 51244: SQLDELAYTOTAL -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:07:15 Port 51244: SQLDELAY -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:07:15 Port 51244: SQLDELAYTOTAL -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:07:45 Port 51244: SQLDELAY -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:07:45 Port 51244: SQLDELAYTOTAL -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:11:38 Port 51244: SQLDELAY -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:11:38 Port 51244: SQLDELAYTOTAL -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:14:47 Port 51244: SQLDELAY -8- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:14:47 Port 51244: SQLDELAYTOTAL -8- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:15:16 Port 51244: SQLDELAY -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:15:16 Port 51244: SQLDELAYTOTAL -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:18:12 Port 51244: SQLDELAY -11- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:18:12 Port 51244: SQLDELAYTOTAL -11- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:18:42 Port 51244: SQLDELAY -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:18:42 Port 51244: SQLDELAYTOTAL -12- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:20:28 Port 51244: SQLDELAY -11- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:20:28 Port 51244: SQLDELAYTOTAL -11- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:21:32 Port 51244: SQLDELAY -46- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:21:32 Port 51244: SQLDELAYTOTAL -46- [thread_id=0000000000000000]: sqlconnect 08/30/26 13:22:08 Port 51244: SQLDELAY -31- [thread_id=000001CEC85328F0]: sql_threadconnect 08/30/26 13:22:08 Port 51244: SQLDELAYTOTAL -31- [thread_id=000001CEC85328F0]: sql_threadconnect 08/30/26 14:01:24 Port 51244: [thread_id=00007FF70EDACEC0] sql_select: emsapp_dbaliv831 SQLERR ORA: 3113, Error occurred at OcilibStatementExecuteInternal: ORA-03113: end-of-file on communication channel Process ID: 12688 Session ID: 136 Serial number: 16966 SELECT is_alive FROM SYS_CHECK ------------------------- 08/30/26 14:01:24 Port 51244: SQLDELAY -19- [thread_id=0000000000000000]: SELECT is_alive FROM SYS_CHECK 08/30/26 14:01:24 Port 51244: SQLDELAYTOTAL -19- [thread_id=0000000000000000]: SELECT is_alive FROM SYS_CHECK 08/30/26 14:01:33 Port 51244: [thread_id=000001CEC85328F0] sql_select: dbconn_check832 SQLERR ORA: 3113, Error occurred at OcilibStatementExecuteInternal: ORA-03113: end-of-file on communication channel Process ID: 4076 Session ID: 259 Serial number: 45738 SELECT SYSDATE FROM DUAL ------------------------- 08/30/26 14:01:33 Port 51244: SQLDELAY -19- [thread_id=000001CEC85328F0]: SELECT SYSDATE FROM DUAL 08/30/26 14:01:33 Port 51244: SQLDELAYTOTAL -19- [thread_id=000001CEC85328F0]: SELECT SYSDATE FROM DUAL 08/30/26 14:01:33 Port 51244: Removing bad DB connection: [thread_id=000001CEC85328F0] ------------------------- 08/30/26 14:01:54 Port 51244: [thread_id=0000007F9CDFF128] sql_select: GENERIC_CURSOR SQLERR ORA: 12170, Error occurred at OcilibConnectionAttach: ORA-12170: TNS:Connect timeout occurred ------------------------- 08/30/26 14:01:54 Port 51244: SQLDELAY -21- [thread_id=0000000000000000]: sql_threadconnect 08/30/26 14:01:54 Port 51244: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sql_threadconnect 08/30/26 14:01:59 Port 51244: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect 08/30/26 14:01:59 Port 51244: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect 08/30/26 14:02:15 Port 51244: [thread_id=0000007F9CDFF128] sql_select: GENERIC_CURSOR SQLERR ORA: 12170, Error occurred at OcilibConnectionAttach: ORA-12170: TNS:Connect timeout occurred ------------------------- 08/30/26 14:02:15 Port 51244: SQLDELAY -21- [thread_id=0000000000000000]: sql_threadconnect 08/30/26 14:02:15 Port 51244: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sql_threadconnect 08/30/26 14:02:16 Port 51244: [thread_id=0000007F9CDFF3D8] sql_select: GENERIC_CURSOR SQLERR ORA: 3114, Error occurred at OcilibConnectionCommit: ORA-03114: not connected to ORACLE ------------------------- 08/30/26 14:02:16 Port 51244: [thread_id=00007FF70EDACEC0] sql_select: fes_cursor833 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:51244' group by LOC_loc_code, loc_year, loc_month order by LOC_loc_code, loc_year desc, loc_month desc ------------------------- 08/30/26 14:02:16 Port 51244: [thread_id=0000007F9CDFF4D8] sql_select: GENERIC_CURSOR SQLERR ORA: 3114, Error occurred at OcilibConnectionRollback: ORA-03114: not connected to ORACLE ------------------------- 08/30/26 14:02:16 Port 51244: [thread_id=0000007F9B5EF028] sql_select: GENERIC_CURSOR SQLERR ORA: 3114, Error occurred at OcilibConnectionCommit: ORA-03114: not connected to ORACLE ------------------------- 08/30/26 14:02:37 Port 51244: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect 08/30/26 14:02:37 Port 51244: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect 08/30/26 14:03:16 Port 51244: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect 08/30/26 14:03:16 Port 51244: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect 08/30/26 14:03:54 Port 51244: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect 08/30/26 14:03:54 Port 51244: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect 08/30/26 14:04:33 Port 51244: SQLDELAY -22- [thread_id=0000000000000000]: sqlconnect 08/30/26 14:04:33 Port 51244: SQLDELAYTOTAL -22- [thread_id=0000000000000000]: sqlconnect 08/30/26 14:05:11 Port 51244: SQLDELAY -21- [thread_id=0000000000000000]: sqlconnect 08/30/26 14:05:11 Port 51244: SQLDELAYTOTAL -21- [thread_id=0000000000000000]: sqlconnect 08/30/26 14:06:30 Port 51244: SQLDELAY -62- [thread_id=0000000000000000]: sqlconnect 08/30/26 14:06:30 Port 51244: SQLDELAYTOTAL -62- [thread_id=0000000000000000]: sqlconnect 08/30/26 14:07:00 Port 51244: SQLDELAY -30- [thread_id=0000029F91D3A6A0]: sql_threadconnect 08/30/26 14:07:00 Port 51244: SQLDELAYTOTAL -30- [thread_id=0000029F91D3A6A0]: sql_threadconnect