From 41ecad7e49a93c493832282b5ecd6c69f464b648 Mon Sep 17 00:00:00 2001 From: yzh <snbbt@21cn.com> Date: 星期一, 23 五月 2022 01:07:51 +0800 Subject: [PATCH] 日志文件合并处理 --- web/web/logs/err.txt | 885 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 885 insertions(+), 0 deletions(-) diff --git a/web/web/logs/err.txt b/web/web/logs/err.txt index eaf8683..e833da2 100644 --- a/web/web/logs/err.txt +++ b/web/web/logs/err.txt @@ -535,3 +535,888 @@ Process ID: 7904 Session ID: 6 Serial number: 11866 +<<<<<<< HEAD +#60 2021-09-03 18:15:41,682 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20210903 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: end-of-file on communication channel +Process ID: 15796 +Session ID: 204 Serial number: 5465 +======= +#6 2021-09-03 11:07:11,651 Common.dll OracleHelper.ExecuteReader ORA-00933: SQL 命令未正确结束 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:行号 219 + +#6 2021-09-03 11:07:17,336 Dao.dll GwSmDao.LoadInfoList ORA-00933: SQL 命令未正确结束select count(*) as count from LG_SM_20210903 sm left join GW_OP op on sm.op_id=op.op_id where 1=1from LG_SM_20210903 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:行号 227 + 在 Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex, String Resend) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 408 + +#9 2021-09-03 11:07:17,644 Common.dll OracleHelper.ExecuteReader ORA-00933: SQL 命令未正确结束 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:行号 219 + +#9 2021-09-03 11:07:18,930 Dao.dll GwSmDao.LoadInfoList ORA-00933: SQL 命令未正确结束select count(*) as count from LG_SM_20210903 sm left join GW_OP op on sm.op_id=op.op_id where 1=1from LG_SM_20210903 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:行号 227 + 在 Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex, String Resend) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 408 + +#6 2021-09-03 11:07:24,386 Common.dll OracleHelper.ExecuteReader ORA-00933: SQL 命令未正确结束 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:行号 219 + +#6 2021-09-03 11:08:09,005 Dao.dll GwSmDao.LoadInfoList ORA-00933: SQL 命令未正确结束select count(*) as count from LG_SM_20210902 sm left join GW_OP op on sm.op_id=op.op_id where 1=1from LG_SM_20210902 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:行号 227 + 在 Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex, String Resend) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 408 + +#7 2021-09-03 11:08:45,659 Common.dll OracleHelper.ExecuteReader ORA-00933: SQL 命令未正确结束 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:行号 219 + +#7 2021-09-03 11:09:27,156 Dao.dll GwSmDao.LoadInfoList ORA-00933: SQL 命令未正确结束select count(*) as count from LG_SM_20210903 sm left join GW_OP op on sm.op_id=op.op_id where 1=1 from LG_SM_20210903 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewCode\web\Common\OracleHelper.cs:行号 227 + 在 Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex, String Resend) + +<<<<<<< Updated upstream +#8 2021-09-15 15:08:29,581 Common.dll OracleHelper.ExecuteReader ORA-00918: 未明确定义列 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#8 2021-09-15 15:08:29,616 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210915 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 5) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227 + 在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 197 + +#5 2021-09-15 15:19:02,877 Common.dll OracleHelper.ExecuteReader ORA-00918: 未明确定义列 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#5 2021-09-15 15:19:02,902 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210915 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 8) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227 + 在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) + +#19 2021-09-15 15:26:27,580 Common.dll OracleHelper.ExecuteReader ORA-00918: 未明确定义列 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#19 2021-09-15 15:26:27,610 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210915 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 8) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227 + 在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) + +#19 2021-09-15 15:26:27,878 Common.dll OracleHelper.Execute SQL=select * from (select rownum r,t.* from (select AP_MID,CLIENT_ID,a.SP_ID,AP_ID,b.OP_NAME,a.ACCESS_CODE,MOBILE,PK_NUMBER,PK_TOTAL,AP_FEE_COUNT,OP_FEE_COUNT,TPUDHI,a.PRIORITY,RD_FLAG,a.MSG_FORMAT,MSG_LENGTH,AP_RESULT,OP_MID,OP_RESULT,AP_SUBMIT_TIME,OP_SUBMIT_TIME,OP_DELIVER_TIME,MSG_CONTENT,STAT,b.op_name,ROUND(TO_NUMBER(a.op_deliver_time-a.ap_submit_time)*24*60*60,0) as OUT_TIME from LG_SM_20210915 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME) t where rownum <= 100000) Message=ORA-00918: 未明确定义列 + +#19 2021-09-15 15:27:44,480 Common.dll OracleHelper.ExecuteReader ORA-00918: 未明确定义列 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#19 2021-09-15 15:27:44,509 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210915 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 8) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227 + 在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) + +#19 2021-09-15 15:27:44,559 Common.dll OracleHelper.Execute SQL=select * from (select rownum r,t.* from (select AP_MID,CLIENT_ID,a.SP_ID,AP_ID,b.OP_NAME,a.ACCESS_CODE,MOBILE,PK_NUMBER,PK_TOTAL,AP_FEE_COUNT,OP_FEE_COUNT,TPUDHI,a.PRIORITY,RD_FLAG,a.MSG_FORMAT,MSG_LENGTH,AP_RESULT,OP_MID,OP_RESULT,AP_SUBMIT_TIME,OP_SUBMIT_TIME,OP_DELIVER_TIME,MSG_CONTENT,STAT,b.op_name,ROUND(TO_NUMBER(a.op_deliver_time-a.ap_submit_time)*24*60*60,0) as OUT_TIME from LG_SM_20210915 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME) t where rownum <= 100000) Message=ORA-00918: 未明确定义列 + +#8 2021-09-15 15:31:58,906 Common.dll OracleHelper.ExecuteReader ORA-00918: 未明确定义列 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#8 2021-09-15 15:31:58,942 Dao.dll GwSmDao.LoadInfoListcount ORA-00918: 未明确定义列select * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20210915 a left join gw_op b on a.op_id=b.op_id where 1=1 and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 8) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227 + 在 Dao.GwSmDao.LoadInfoListcount(String apID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 D:\Company\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 197 +>>>>>>> Release +======= +#15 2022-02-16 17:16:59,360 Common.dll OracleHelper.ExecuteScalar SQL=select count(1) FROM GW_AUDIT_CACHE ca left join gw_op op on ca.op_id=op.op_id WHERE 0 ca.AP_SUBMIT_TIME BETWEEN :START_TIME AND :END_TIME AND (ca.MSG_CONTENT LIKE :CONTENT OR :CONTENT='%%') AND ca.AUDITING_STATUS=:AUDITING_STATUS Message=ORA-00920: 无效的关系运算符 + +#20 2022-02-16 17:24:53,794 Common.dll OracleHelper.ExecuteScalar SQL=select count(1) FROM GW_AUDIT_CACHE ca left join gw_op op on ca.op_id=op.op_id WHERE ca.AP_SUBMIT_TIME BETWEEN :START_TIME AND :END_TIME AND (ca.MSG_CONTENT LIKE :CONTENT OR :CONTENT='%%') AND ca.AUDITING_STATUS=:AUDITING_STATUS and op.OP_NAME=移动通道 Message=ORA-00904: "移动通道": 标识符无效 +>>>>>>> Stashed changes + +#36 2022-03-21 00:37:11,743 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 7008 +会话 ID: 73 序列号: 3456 + +#9 2022-03-21 00:37:11,744 Common.dll OracleHelper.ExecuteReader ORA-03113: 通信通道的文件结尾 +进程 ID: 7784 +会话 ID: 200 序列号: 3327 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#7 2022-03-21 00:40:12,986 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_AP Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 1160 +会话 ID: 14 序列号: 6599 + +#7 2022-03-21 00:42:12,726 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220321 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 7676 +会话 ID: 134 序列号: 3609 + +#35 2022-03-21 00:48:59,108 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 7488 +会话 ID: 72 序列号: 2827 + +#22 2022-03-21 00:49:18,562 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220321 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 7180 +会话 ID: 16 序列号: 4733 + +#39 2022-03-21 00:51:08,010 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_AP Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 7308 +会话 ID: 195 序列号: 4472 + +#16 2022-03-21 00:51:35,782 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_AP Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 712 +会话 ID: 139 序列号: 389 + +#40 2022-03-21 00:58:01,084 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220321 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 7172 +会话 ID: 206 序列号: 104 + +#34 2022-03-21 00:58:20,626 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 3328 +会话 ID: 77 序列号: 28 + +#68 2022-03-31 02:38:57,384 Common.dll OracleHelper.ExecuteReader ORA-03113: 通信通道的文件结尾 +进程 ID: 12584 +会话 ID: 133 序列号: 58839 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#61 2022-03-31 03:41:16,261 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-03-30 AND 2022-04-01 ) T Message=ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + +#61 2022-03-31 03:41:16,301 Dao.dll GwOrderDao.LoadInfoList ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, String startDate, String endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwOrderDao.cs:行号 88 + +#29 2022-03-31 03:43:54,989 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-03-30 AND 2022-04-01 ) T Message=ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + +#29 2022-03-31 03:43:55,017 Dao.dll GwOrderDao.LoadInfoList ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, String startDate, String endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwOrderDao.cs:行号 88 + +#45 2022-03-31 03:44:03,573 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-03-23 AND 2022-04-01 ) T Message=ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + +#45 2022-03-31 03:44:03,589 Dao.dll GwOrderDao.LoadInfoList ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, String startDate, String endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwOrderDao.cs:行号 88 + +#61 2022-03-31 03:44:23,873 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220331 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 1116 +会话 ID: 207 序列号: 37854 + +#29 2022-03-31 03:44:43,222 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 11496 +会话 ID: 74 序列号: 5973 + +#45 2022-03-31 03:45:02,368 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-03-23 AND 2022-04-01 ) T Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 7596 +会话 ID: 201 序列号: 49901 + +#45 2022-03-31 03:45:02,385 Dao.dll GwOrderDao.LoadInfoList ORA-03113: 通信通道的文件结尾 +进程 ID: 7596 +会话 ID: 201 序列号: 49901 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, String startDate, String endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwOrderDao.cs:行号 88 + +#61 2022-03-31 03:45:13,034 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-03-23 AND 2022-04-01 ) T Message=ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + +#61 2022-03-31 03:45:13,050 Dao.dll GwOrderDao.LoadInfoList ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, String startDate, String endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwOrderDao.cs:行号 88 + +#61 2022-03-31 03:46:12,333 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-04-01 AND 2022-04-01 ) T Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 6272 +会话 ID: 72 序列号: 18963 + +#61 2022-03-31 03:46:12,349 Dao.dll GwOrderDao.LoadInfoList ORA-03113: 通信通道的文件结尾 +进程 ID: 6272 +会话 ID: 72 序列号: 18963 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, String startDate, String endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwOrderDao.cs:行号 88 + +#45 2022-03-31 03:46:15,419 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-03-30 AND 2022-04-01 ) T Message=ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + +#45 2022-03-31 03:46:15,442 Dao.dll GwOrderDao.LoadInfoList ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, String startDate, String endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwOrderDao.cs:行号 88 + +#64 2022-03-31 03:47:30,072 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-03-30 AND 2022-04-01 ) T Message=ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + +#64 2022-03-31 03:47:30,088 Dao.dll GwOrderDao.LoadInfoList ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, String startDate, String endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwOrderDao.cs:行号 88 + +#64 2022-03-31 03:47:37,216 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-03-10 AND 2022-04-01 ) T Message=ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + +#64 2022-03-31 03:47:37,236 Dao.dll GwOrderDao.LoadInfoList ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, String startDate, String endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwOrderDao.cs:行号 88 + +#64 2022-03-31 03:50:06,744 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-03-10 AND 2022-04-01 ) T Message=ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + +#64 2022-03-31 03:50:06,761 Dao.dll GwOrderDao.LoadInfoList ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, String startDate, String endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwOrderDao.cs:行号 88 + +#17 2022-03-31 03:50:37,525 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_OP order BY OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 7160 +会话 ID: 15 序列号: 40808 + +#64 2022-03-31 03:56:17,282 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-03-30 AND 2022-04-01 ) T Message=ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + +#64 2022-03-31 03:56:17,306 Dao.dll GwOrderDao.LoadInfoList ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, String startDate, String endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwOrderDao.cs:行号 88 + +#17 2022-03-31 03:56:25,686 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-03-10 AND 2022-04-01 ) T Message=ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + +#17 2022-03-31 03:57:30,596 Dao.dll GwOrderDao.LoadInfoList ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, String startDate, String endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwOrderDao.cs:行号 88 + +#61 2022-03-31 03:59:48,236 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-03-10 AND 2022-04-01 ) T Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 9200 +会话 ID: 133 序列号: 61737 + +#61 2022-03-31 04:01:34,816 Dao.dll GwOrderDao.LoadInfoList ORA-03113: 通信通道的文件结尾 +进程 ID: 9200 +会话 ID: 133 序列号: 61737 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, String startDate, String endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) + +#61 2022-03-31 04:02:00,393 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_OP order BY OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 1340 +会话 ID: 200 序列号: 25647 + +#28 2022-03-31 04:02:15,016 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN '2022-03-30' AND '2022-04-01' ) T Message=ORA-01861: 文字与格式字符串不匹配 + +#28 2022-03-31 04:02:15,041 Dao.dll GwOrderDao.LoadInfoList ORA-01861: 文字与格式字符串不匹配 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, String startDate, String endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) + +#61 2022-03-31 04:02:25,909 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN '2022-03-23' AND '2022-04-01' ) T Message=ORA-01861: 文字与格式字符串不匹配 + +#61 2022-03-31 04:03:37,152 Dao.dll GwOrderDao.LoadInfoList ORA-01861: 文字与格式字符串不匹配 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, String startDate, String endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) + +#61 2022-03-31 04:08:54,008 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_OP order BY OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 11356 +会话 ID: 11 序列号: 1737 + +#7 2022-03-31 04:10:03,457 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-03-30 00:00:00 AND 2022-04-01 00:00:00 ) T Message=ORA-00905: 缺失关键字 + +#7 2022-03-31 04:10:03,492 Dao.dll GwOrderDao.LoadInfoList ORA-00905: 缺失关键字 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, DateTime startDate, DateTime endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwOrderDao.cs:行号 88 + +#11 2022-03-31 04:10:11,724 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-03-23 00:00:00 AND 2022-04-01 00:00:00 ) T Message=ORA-00905: 缺失关键字 + +#11 2022-03-31 04:10:11,740 Dao.dll GwOrderDao.LoadInfoList ORA-00905: 缺失关键字 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, DateTime startDate, DateTime endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwOrderDao.cs:行号 88 + +#9 2022-03-31 04:10:29,921 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-03-23 00:00:00 AND 2022-04-01 00:00:00 ) T Message=ORA-00905: 缺失关键字 + +#9 2022-03-31 04:10:29,937 Dao.dll GwOrderDao.LoadInfoList ORA-00905: 缺失关键字 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, DateTime startDate, DateTime endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwOrderDao.cs:行号 88 + +#8 2022-03-31 04:11:30,513 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-03-23 00:00:00 AND 2022-04-01 00:00:00 ) T Message=ORA-00905: 缺失关键字 + +#8 2022-03-31 04:11:30,529 Dao.dll GwOrderDao.LoadInfoList ORA-00905: 缺失关键字 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, DateTime startDate, DateTime endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwOrderDao.cs:行号 88 + +#9 2022-03-31 04:14:02,931 Common.dll OracleHelper.ExecuteReader SQL=select count(*) as count FROM ( SELECT GWO.*, GWC.CLIENT_NAME FROM GW_ORDER GWO LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID WHERE 1=1 AND GWO.STATUS IN (0, 1) AND GWO.CREATE_TIME BETWEEN 2022-03-23 00:00:00 AND 2022-04-01 00:00:00 ) T Message=ORA-00905: 缺失关键字 + +#9 2022-03-31 04:14:45,999 Dao.dll GwOrderDao.LoadInfoList ORA-00905: 缺失关键字 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 113 + 在 Dao.GwOrderDao.LoadInfoList(String spId, String clientId, String clientName, Int32 flag, DateTime startDate, DateTime endDate, Int32 pageSize, Int32 PageIndex, Int32& recordcount) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwOrderDao.cs:行号 88 + +#7 2022-03-31 04:33:17,699 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 7880 +会话 ID: 145 序列号: 10 + +#25 2022-03-31 04:38:29,628 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220331 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 1152 +会话 ID: 17 序列号: 1772 + +#23 2022-03-31 16:46:15,119 Common.dll OracleHelper.ExecuteReader ORA-03113: 通信通道的文件结尾 +进程 ID: 11340 +会话 ID: 205 序列号: 50957 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#8 2022-03-31 16:53:15,014 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 2000 +会话 ID: 79 序列号: 1018 + +#21 2022-03-31 16:53:34,118 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220331 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 9296 +会话 ID: 212 序列号: 3228 + +#18 2022-03-31 17:05:15,999 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 7400 +会话 ID: 139 序列号: 57391 + +#20 2022-03-31 17:11:15,191 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_OP order BY OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 12896 +会话 ID: 205 序列号: 52285 + +#42 2022-04-01 09:34:46,186 Common.dll OracleHelper.ExecuteReader ORA-00942: 表或视图不存在 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#42 2022-04-01 09:34:50,161 Dao.dll GwSmDao.LoadInfoList ORA-00942: 表或视图不存在select count(*) as count from LG_SM_20220131 sm left join GW_OP op on sm.op_id=op.op_id where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227 + 在 Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex, String ReSend) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 406 + +#39 2022-04-01 09:35:00,742 Common.dll OracleHelper.ExecuteReader ORA-00942: 表或视图不存在 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#39 2022-04-01 09:35:00,763 Dao.dll GwSmDao.LoadInfoList ORA-00942: 表或视图不存在select count(*) as count from LG_SM_20211001 sm left join GW_OP op on sm.op_id=op.op_id where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227 + 在 Dao.GwSmDao.LoadInfoList(String apMID, String opName, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex, String ReSend) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwSmDao.cs:行号 406 + +#39 2022-04-01 09:35:23,454 Common.dll OracleHelper.ExecuteReader ORA-00942: 表或视图不存在 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#39 2022-04-01 09:35:23,481 Dao.dll GwDmDao.LoadInfoList ORA-00942: 表或视图不存在 select count(*) as count from LG_DM_20211201 where 1=1 + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227 + 在 Dao.GwDmDao.LoadInfoList(String ApID, String OpID, String spID, String DestnationId, String sDate, Int32& recordcount, Int32 pageSize, Int32 PageIndex) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwDmDao.cs:行号 52 + +#39 2022-04-01 09:35:34,169 Common.dll OracleHelper.ExecuteReader ORA-00942: 表或视图不存在 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#39 2022-04-01 09:35:34,185 Dao.dll GwDmDao.LoadInfoList ORA-00942: 表或视图不存在 select count(*) as count from LG_DM_20200115 where 1=1 + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 227 + 在 Dao.GwDmDao.LoadInfoList(String ApID, String OpID, String spID, String DestnationId, String sDate, Int32& recordcount, Int32 pageSize, Int32 PageIndex) 位置 C:\AYZH\work\Git_Rep\SMGW_NewWeb\web\Dao\GwDmDao.cs:行号 52 + +#62 2022-04-13 10:25:04,410 Common.dll OracleHelper.ExecuteReader ORA-03113: 通信通道的文件结尾 +进程 ID: 9504 +会话 ID: 205 序列号: 25061 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#7 2022-04-13 10:30:50,008 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220413 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 9916 +会话 ID: 204 序列号: 37226 + +#61 2022-04-13 10:31:09,611 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 9400 +会话 ID: 146 序列号: 45532 + +#7 2022-04-13 10:33:42,410 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_AP Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 10060 +会话 ID: 72 序列号: 27318 + +#7 2022-04-13 10:39:48,992 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220413 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 7744 +会话 ID: 139 序列号: 33341 + +#60 2022-04-13 10:40:08,472 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 12772 +会话 ID: 19 序列号: 45105 + +#35 2022-04-13 15:04:17,914 Common.dll OracleHelper.ExecuteReader ORA-03113: 通信通道的文件结尾 +进程 ID: 12212 +会话 ID: 77 序列号: 17059 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#29 2022-04-14 09:01:27,250 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_CLIENT Message=ORA-12571: TNS: 包写入程序失败 + +#11 2022-04-18 12:12:48,369 Common.dll OracleHelper.ExecuteReader ORA-03113: 通信通道的文件结尾 +进程 ID: 11472 +会话 ID: 145 序列号: 57954 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#56 2022-04-18 12:18:50,712 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220418 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 11044 +会话 ID: 146 序列号: 57041 + +#12 2022-04-18 12:19:09,861 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 1008 +会话 ID: 77 序列号: 25608 + +#11 2022-04-18 12:21:07,679 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_CLIENT Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 4996 +会话 ID: 78 序列号: 39675 + +#20 2022-04-18 12:21:42,286 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_CLIENT Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 7264 +会话 ID: 19 序列号: 1251 + +#32 2022-04-19 16:25:21,592 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220419 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: 表或视图不存在 + +#57 2022-04-19 16:31:38,212 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 11472 +会话 ID: 72 序列号: 40490 + +#77 2022-04-19 18:35:29,267 Common.dll OracleHelper.ExecuteReader ORA-03113: 通信通道的文件结尾 +进程 ID: 10872 +会话 ID: 82 序列号: 36454 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#25 2022-04-19 18:35:33,119 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220419 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: 表或视图不存在 + +#77 2022-04-19 18:41:31,055 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 992 +会话 ID: 11 序列号: 28892 + +#28 2022-04-19 18:52:42,815 Common.dll OracleHelper.ExecuteReader ORA-03113: 通信通道的文件结尾 +进程 ID: 10212 +会话 ID: 212 序列号: 18440 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#14 2022-04-22 08:23:38,988 Common.dll OracleHelper.ExecuteReader ORA-12571: TNS: 包写入程序失败 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#13 2022-04-22 08:33:11,967 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220422 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 9836 +会话 ID: 209 序列号: 57680 + +#17 2022-04-22 08:33:31,194 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 7540 +会话 ID: 139 序列号: 8489 + +#56 2022-04-22 08:33:50,278 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_AP Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 5408 +会话 ID: 203 序列号: 19804 + +#84 2022-04-22 08:44:13,910 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_AP Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 5184 +会话 ID: 143 序列号: 11866 + +#88 2022-04-22 11:31:06,133 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 11156 +会话 ID: 11 序列号: 38047 + +#7 2022-04-25 22:58:25,334 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 13228 +会话 ID: 17 序列号: 34550 + +#51 2022-04-25 23:19:53,698 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220425 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 6084 +会话 ID: 136 序列号: 3887 + +#54 2022-04-25 23:20:12,944 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 1432 +会话 ID: 78 序列号: 49284 + +#7 2022-04-25 23:27:51,078 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220425 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 12944 +会话 ID: 69 序列号: 25109 + +#5 2022-04-25 23:28:10,137 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 13524 +会话 ID: 18 序列号: 45820 + +#145 2022-04-26 23:59:45,129 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220426 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 11156 +会话 ID: 21 序列号: 17536 + +#7 2022-04-27 00:00:04,598 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 4184 +会话 ID: 205 序列号: 40173 + +#145 2022-04-27 00:05:39,944 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_AP Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 1448 +会话 ID: 133 序列号: 30900 + +#124 2022-04-27 00:15:37,087 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 344 +会话 ID: 69 序列号: 26594 + +#69 2022-04-27 00:15:56,553 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220427 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 13748 +会话 ID: 209 序列号: 64653 + +#37 2022-04-27 00:55:01,177 Dao.dll SysFlowDao.Get 未将对象引用设置到对象的实例。 + 在 Dao.SysFlowDao.Get(SysFlow sysFlow) + +#23 2022-04-27 11:32:27,691 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220427 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 10716 +会话 ID: 20 序列号: 9639 + +#32 2022-04-27 11:32:47,001 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 8244 +会话 ID: 136 序列号: 9702 + +#19 2022-04-27 14:47:06,194 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 4364 +会话 ID: 18 序列号: 53123 + +#64 2022-04-27 14:47:25,594 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220427 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 12472 +会话 ID: 67 序列号: 107 + +#30 2022-04-27 15:10:12,093 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220427 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 11728 +会话 ID: 15 序列号: 43421 + +#21 2022-04-27 15:10:31,612 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 8000 +会话 ID: 196 序列号: 37075 + +#46 2022-04-27 15:33:12,950 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_AP Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 6180 +会话 ID: 17 序列号: 37044 + +#46 2022-04-27 15:33:41,213 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_AP Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 8448 +会话 ID: 203 序列号: 41050 + +#5 2022-04-27 22:21:06,598 Common.dll OracleHelper.ExecuteReader ORA-03113: 通信通道的文件结尾 +进程 ID: 7780 +会话 ID: 209 序列号: 5557 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#15 2022-04-27 22:51:51,165 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220427 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 4844 +会话 ID: 17 序列号: 37683 + +#14 2022-04-27 22:57:48,002 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 6864 +会话 ID: 196 序列号: 38297 + +#37 2022-04-27 22:58:12,732 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_AP Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 12960 +会话 ID: 136 序列号: 10086 + +#26 2022-04-27 22:58:39,974 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_AP Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 10032 +会话 ID: 142 序列号: 21220 + +#47 2022-04-29 07:55:52,772 Common.dll OracleHelper.ExecuteReader ORA-03113: 通信通道的文件结尾 +进程 ID: 16256 +会话 ID: 209 序列号: 7045 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#50 2022-04-29 08:01:26,368 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220429 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 10744 +会话 ID: 21 序列号: 27701 + +#63 2022-04-29 08:01:45,600 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 11040 +会话 ID: 144 序列号: 9728 + +#56 2022-04-29 15:16:51,387 Common.dll OracleHelper.ExecuteReader ORA-03113: 通信通道的文件结尾 +进程 ID: 16404 +会话 ID: 208 序列号: 5357 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#56 2022-04-29 15:17:27,946 Common.dll OracleHelper.ExecuteReader ORA-03113: 通信通道的文件结尾 +进程 ID: 5848 +会话 ID: 16 序列号: 32693 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#16 2022-04-29 15:17:46,940 Common.dll OracleHelper.ExecuteReader ORA-03113: 通信通道的文件结尾 +进程 ID: 8556 +会话 ID: 207 序列号: 51867 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#80 2022-04-29 15:18:06,212 Common.dll OracleHelper.ExecuteReader ORA-03113: 通信通道的文件结尾 +进程 ID: 8032 +会话 ID: 15 序列号: 49369 + 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) + 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior) + 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) 位置 D:\Company\SMGW_NewWeb\web\Common\OracleHelper.cs:行号 219 + +#53 2022-04-29 16:19:34,117 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220429 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 7444 +会话 ID: 16 序列号: 33621 + +#17 2022-04-29 16:19:53,591 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 4800 +会话 ID: 212 序列号: 60930 + +#46 2022-04-29 16:23:07,992 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_CLIENT Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 16392 +会话 ID: 21 序列号: 29658 + +#66 2022-04-29 16:23:38,585 Common.dll OracleHelper.ExecuteReader SQL=SELECT * FROM GW_CLIENT Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 15364 +会话 ID: 208 序列号: 6082 + +#54 2022-04-29 17:24:38,130 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220429 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 12724 +会话 ID: 75 序列号: 64336 + +#54 2022-04-29 17:25:28,389 Common.dll OracleHelper.Execute SQL=SELECT * FROM GW_ALARM_LOG WHERE RESTORE_FLAG=0 and rownum < 10 ORDER BY ALARM_ID DESC Message=ORA-03113: 通信通道的文件结尾 +进程 ID: 7264 +会话 ID: 142 序列号: 27463 + +#20 2022-05-05 10:20:03,397 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220505 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: 表或视图不存在 + +#31 2022-05-05 10:36:20,926 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN + (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT, + NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT, + NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT + from LG_SM_20220505 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-00942: 表或视图不存在 + -- Gitblit v1.9.1