From 3c42ad866ca12d43571e8a0cd8fd22ca2b15edb1 Mon Sep 17 00:00:00 2001 From: yzh <snbbt@21cn.com> Date: 星期四, 30 六月 2022 13:05:41 +0800 Subject: [PATCH] 删除日志文件版本控制 --- /dev/null | 1 - 1 files changed, 0 insertions(+), 1 deletions(-) diff --git a/web/web/log/err.txt b/web/web/log/err.txt deleted file mode 100644 index 683ab9d..0000000 --- a/web/web/log/err.txt +++ /dev/null @@ -1,641 +0,0 @@ -#14 2019-08-20 13:45:06,287 Common.DLL OracleHelper.ExecuteReader ORA-12571: TNS:packet writer failure - 在 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) - -#9 2019-08-20 14:51:22,416 Common.DLL OracleHelper.ExecuteReader ORA-01722: invalid 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, OracleParameter[] cmdParms) - -#9 2019-08-20 14:51:22,429 Dao.DLL GwSmDao.LoadInfoList ORA-01722: invalid numberselect count(*) as count from LG_SM_20190820 where 1=1 and AP_ID=:ApID and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) - -#14 2019-08-20 14:51:25,423 Common.DLL OracleHelper.ExecuteReader ORA-01722: invalid 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, OracleParameter[] cmdParms) - -#14 2019-08-20 14:51:25,428 Dao.DLL GwSmDao.LoadInfoList ORA-01722: invalid numberselect count(*) as count from LG_SM_20190820 where 1=1 and AP_ID=:ApID and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) - -#8 2019-08-20 14:51:25,905 Common.DLL OracleHelper.ExecuteReader ORA-01722: invalid 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, OracleParameter[] cmdParms) - -#8 2019-08-20 14:51:25,908 Dao.DLL GwSmDao.LoadInfoList ORA-01722: invalid numberselect count(*) as count from LG_SM_20190820 where 1=1 and AP_ID=:ApID and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) - -#12 2019-08-20 16:16:51,964 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis - 在 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) - -#12 2019-08-20 16:16:51,979 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 0) where r > 0 - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 376 - -#8 2019-08-20 16:16:57,245 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis - 在 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) - -#8 2019-08-20 16:16:57,248 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0 - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 376 - -#13 2019-08-20 16:16:59,480 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis - 在 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) - -#13 2019-08-20 16:16:59,484 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0 - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 376 - -#5 2019-08-20 16:17:00,085 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis - 在 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) - -#5 2019-08-20 16:17:00,089 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0 - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 376 - -#9 2019-08-20 16:17:00,592 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis - 在 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) - -#9 2019-08-20 16:17:00,597 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0 - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 376 - -#5 2019-08-20 16:17:01,170 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis - 在 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) - -#5 2019-08-20 16:17:01,182 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0 - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 376 - -#8 2019-08-20 16:17:11,696 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis - 在 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) - -#8 2019-08-20 16:17:11,703 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0 - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 376 - -#9 2019-08-20 16:17:19,648 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis - 在 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) - -#9 2019-08-20 16:17:19,653 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0 - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 376 - -#8 2019-08-20 16:17:20,224 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis - 在 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) - -#8 2019-08-20 16:17:20,227 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0 - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 376 - -#8 2019-08-20 16:17:20,433 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis - 在 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) - -#8 2019-08-20 16:17:20,436 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0 - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 376 - -#9 2019-08-20 16:17:41,580 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis - 在 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) - -#9 2019-08-20 16:17:41,584 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 0) where r > 0 - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 376 - -#5 2019-08-20 16:17:46,254 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis - 在 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) - -#5 2019-08-20 16:17:46,259 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0 - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 376 - -#8 2019-08-20 16:17:54,820 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis - 在 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) - -#8 2019-08-20 16:17:54,824 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0 - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 376 - -#13 2019-08-20 16:19:42,222 Common.DLL OracleHelper.ExecuteReader ORA-00907: missing right parenthesis - 在 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) - -#13 2019-08-20 16:22:27,363 Dao.DLL GwSmDao.LoadInfoList ORA-00907: missing right parenthesisselect * from (select rownum r,t.* from (select sm.*,op.OP_NAME from LG_SM_20190820 sm where 1=1 and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME left join GW_OP op on sm.op_id=op.op_id ORDER BY sm.AP_SUBMIT_TIME DESC) t where rownum <= 2) where r > 0 - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoList(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount, Int32 pageSize, Int32 pageIndex) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 376 - -#14 2019-08-21 16:03:22,734 Common.DLL OracleHelper.Execute SQL=select * from (select rownum r,t.* from (SELECT op.op_name,ca.SP_ID,ca.OP_ID,ca.MSG_CONTENT,ca.KEYWORD,ca.HASH_CODE,COUNT(*) CNT 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 - GROUP BY ca.SP_ID,ca.OP_ID,ca.MSG_CONTENT,ca.KEYWORD,ca.HASH_CODE) t where rownum <=1) where r > 0 Message=ORA-00979: not a GROUP BY expression - -#14 2019-08-21 16:03:24,584 Common.DLL OracleHelper.Execute SQL=select * from (select rownum r,t.* from (SELECT op.op_name,ca.SP_ID,ca.OP_ID,ca.MSG_CONTENT,ca.KEYWORD,ca.HASH_CODE,COUNT(*) CNT 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 - GROUP BY ca.SP_ID,ca.OP_ID,ca.MSG_CONTENT,ca.KEYWORD,ca.HASH_CODE) t where rownum <=1) where r > 0 Message=ORA-00979: not a GROUP BY expression - -#14 2019-08-21 17:41:41,439 Common.DLL OracleHelper.ExecuteReader ORA-12571: TNS:packet writer failure - 在 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) - -#4 2019-09-10 11:12:33,228 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_20190910 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-12571: TNS:packet writer failure - -#4 2019-09-10 11:13:03,726 Dao.DLL GwSmDao.LoadInfoList ORA-12505: TNS:listener does not currently know of SID given in connect descriptor - 在 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, IntPtr opsErrCtx, Object src) - 在 Oracle.DataAccess.Client.OracleConnection.Open() - 在 Common.OracleHelper.PrepareConnection() - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 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) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 368 - -#4 2019-09-10 11:13:04,780 Dao.DLL GwSmDao.LoadInfoList ORA-12505: TNS:listener does not currently know of SID given in connect descriptor - 在 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, IntPtr opsErrCtx, Object src) - 在 Oracle.DataAccess.Client.OracleConnection.Open() - 在 Common.OracleHelper.PrepareConnection() - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 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) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 368 - -#5 2019-09-10 11:13:05,507 Dao.DLL GwSmDao.LoadInfoList ORA-12505: TNS:listener does not currently know of SID given in connect descriptor - 在 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, IntPtr opsErrCtx, Object src) - 在 Oracle.DataAccess.Client.OracleConnection.Open() - 在 Common.OracleHelper.PrepareConnection() - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 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) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 368 - -#5 2019-09-10 11:13:06,135 Dao.DLL GwSmDao.LoadInfoList ORA-12505: TNS:listener does not currently know of SID given in connect descriptor - 在 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, IntPtr opsErrCtx, Object src) - 在 Oracle.DataAccess.Client.OracleConnection.Open() - 在 Common.OracleHelper.PrepareConnection() - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 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) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 368 - -#12 2019-09-10 11:33:32,386 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 - Message=ORA-12571: TNS:packet writer failure - -#14 2019-09-10 11:40:15,711 Common.DLL OracleHelper.ExecuteReader ORA-01722: invalid 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, OracleParameter[] cmdParms) - -#14 2019-09-10 11:40:15,717 Dao.DLL GwSmDao.LoadInfoListcount ORA-01722: invalid numberselect count(*) as count from LG_SM_20190910 where 1=1 and AP_ID=:ApID and OP_ID=:OpID and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwSmDao.LoadInfoListcount(String apID, String opId, String clientID, String spID, String destnationId, String sDate, String beginTime, String endTime, String content, String opstat, Int32 TStatus, Int32& recordcount) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 160 - -#14 2019-09-10 11:40:15,734 Common.DLL OracleHelper.Execute SQL=select * from (select rownum r,t.* from (select AP_MID,CLIENT_ID,SP_ID,AP_ID,OP_ID,ACCESS_CODE,MOBILE,PK_NUMBER,AP_FEE_COUNT,OP_FEE_COUNT,TPUDHI,PRIORITY,RD_FLAG,MSG_FORMAT,MSG_LENGTH,AP_RESULT,OP_MID,OP_RESULT,AP_SUBMIT_TIME,OP_SUBMIT_TIME,OP_DELIVER_TIME,MSG_CONTENT,STAT from LG_SM_20190910 where 1=1 and AP_ID=:ApID and OP_ID=:OpID and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME) t where rownum <= 100000) Message=ORA-01722: invalid number - -#5 2019-09-20 15:47:37,022 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_20190920 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: table or view does not exist - -#13 2019-09-20 15:56:52,984 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_20190920 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: table or view does not exist - -#10 2019-10-14 17:41:49,731 Common.DLL OracleHelper.ExecuteReader ORA-00918: column ambiguously defined - 在 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) - -#10 2019-10-14 17:41:49,751 Dao.DLL GwSmDao.LoadInfoListcount ORA-00918: column ambiguously definedselect * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20191014 a left join gw_op b on a.op_id=b.op_id where 1=1 and b.OP_Name LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 0) - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 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) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 197 - -#10 2019-10-14 17:41:49,791 Common.DLL OracleHelper.Execute SQL=select * from (select rownum r,t.* from (select AP_MID,CLIENT_ID,SP_ID,AP_ID,a.OP_ID,ACCESS_CODE,MOBILE,PK_NUMBER,AP_FEE_COUNT,OP_FEE_COUNT,TPUDHI,PRIORITY,RD_FLAG,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 from LG_SM_20191014 a left join gw_op on a.op_id=b.op_id where 1=1 and b.OP_NAME LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME) t where rownum <= 100000) Message=ORA-00904: "B"."OP_ID": invalid identifier - -#12 2019-10-14 17:43:25,328 Common.DLL OracleHelper.ExecuteReader ORA-00918: column ambiguously defined - 在 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) - -#12 2019-10-14 17:43:25,337 Dao.DLL GwSmDao.LoadInfoListcount ORA-00918: column ambiguously definedselect * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20191014 a left join gw_op b on a.op_id=b.op_id where 1=1 and b.OP_Name LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 0) - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 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) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 197 - -#12 2019-10-14 17:43:25,365 Common.DLL OracleHelper.Execute SQL=select * from (select rownum r,t.* from (select AP_MID,CLIENT_ID,SP_ID,AP_ID,a.OP_ID,ACCESS_CODE,MOBILE,PK_NUMBER,AP_FEE_COUNT,OP_FEE_COUNT,TPUDHI,PRIORITY,RD_FLAG,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 from LG_SM_20191014 a left join gw_op on a.op_id=b.op_id where 1=1 and b.OP_NAME LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME) t where rownum <= 100000) Message=ORA-00904: "B"."OP_ID": invalid identifier - -#5 2019-10-14 17:43:44,224 Common.DLL OracleHelper.ExecuteReader ORA-00918: column ambiguously defined - 在 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) - -#5 2019-10-14 17:43:44,239 Dao.DLL GwSmDao.LoadInfoListcount ORA-00918: column ambiguously definedselect * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20191014 a left join gw_op b on a.op_id=b.op_id where 1=1 and b.OP_Name LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 0) - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 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) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 197 - -#5 2019-10-14 17:45:54,786 Common.DLL OracleHelper.Execute SQL=select * from (select rownum r,t.* from (select AP_MID,CLIENT_ID,SP_ID,AP_ID,a.OP_ID,ACCESS_CODE,MOBILE,PK_NUMBER,AP_FEE_COUNT,OP_FEE_COUNT,TPUDHI,PRIORITY,RD_FLAG,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 from LG_SM_20191014 a left join gw_op on a.op_id=b.op_id where 1=1 and b.OP_NAME LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME) t where rownum <= 100000) Message=ORA-00904: "B"."OP_ID": invalid identifier - -#10 2019-10-14 17:47:34,151 Common.DLL OracleHelper.ExecuteReader ORA-00918: column ambiguously defined - 在 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) - -#10 2019-10-14 17:47:34,174 Dao.DLL GwSmDao.LoadInfoListcount ORA-00918: column ambiguously definedselect * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20191014 a left join gw_op b on a.op_id=b.op_id where 1=1 and b.OP_Name LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 0) - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 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) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 197 - -#10 2019-10-14 17:47:34,203 Common.DLL OracleHelper.Execute SQL=select * from (select rownum r,t.* from (select AP_MID,CLIENT_ID,a.SP_ID,AP_ID,a.OP_ID,a.ACCESS_CODE,MOBILE,PK_NUMBER,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 from LG_SM_20191014 a left join gw_op on a.op_id=b.op_id where 1=1 and b.OP_NAME LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME) t where rownum <= 100000) Message=ORA-00904: "B"."OP_ID": invalid identifier - -#12 2019-10-14 17:49:12,645 Common.DLL OracleHelper.ExecuteReader ORA-00918: column ambiguously defined - 在 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) - -#12 2019-10-14 17:49:12,662 Dao.DLL GwSmDao.LoadInfoListcount ORA-00918: column ambiguously definedselect * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20191014 a left join gw_op b on a.op_id=b.op_id where 1=1 and b.OP_Name LIKE :OpName and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 0) - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 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) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 197 - -#10 2019-10-14 17:49:21,425 Common.DLL OracleHelper.ExecuteReader ORA-00918: column ambiguously defined - 在 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) - -#10 2019-10-14 17:49:21,435 Dao.DLL GwSmDao.LoadInfoListcount ORA-00918: column ambiguously definedselect * from (select rownum r,t.* from (select a.*,b.op_id,b.op_name from LG_SM_20191014 a left join gw_op b on a.op_id=b.op_id where 1=1 and b.OP_Name LIKE :OpName and MOBILE=:DestnationId and AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME ORDER BY AP_SUBMIT_TIME DESC) t where rownum <= 0) - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 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) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 197 - -#13 2020-03-04 10:33:03,802 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_20200304 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: table or view does not exist - -#11 2020-03-11 10:50:58,862 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: end-of-file on communication channel -Process ID: 4176 -Session ID: 22 Serial number: 8520 - -#12 2020-03-18 15:21:27,817 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_20200318 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: table or view does not exist - -#11 2020-05-20 17:33:11,140 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_20200520 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: table or view does not exist - -#11 2020-05-20 17:33:18,366 Common.DLL OracleHelper.ExecuteReader ORA-00942: table or view does not exist - 在 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) - -#11 2020-05-20 17:33:30,304 Dao.DLL GwSmDao.LoadInfoList ORA-00942: table or view does not existselect count(*) as count from LG_SM_20200520 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) - 在 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) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwSmDao.cs:行号 399 - -#9 2020-05-20 17:37:41,531 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: end-of-file on communication channel -Process ID: 1324 -Session ID: 21 Serial number: 4 - -#4 2020-05-26 16:17:57,963 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_20200526 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: table or view does not exist - -#9 2020-05-26 16:22:34,058 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_20200526 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: table or view does not exist - -#9 2020-05-26 16:35:35,256 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_20200526 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: table or view does not exist - -#11 2020-05-26 16:42:21,621 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_20200526 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: table or view does not exist - -#12 2020-05-26 16:49:55,469 Common.DLL OracleHelper.ExecuteReader ORA-00942: table or view does not exist - 在 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) - -#12 2020-05-26 16:49:55,481 Dao.DLL GwTransferDao.LoadInfoList ORA-00942: table or view does not existselect count(*) as count from GwTransfer b where 1=1 order by Id DESC - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwTransferDao.LoadInfoList(String phone, Int32& recordcount, Int32 PageIndex, Int32 pageSize) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwTransferDao.cs:行号 51 - -#13 2020-05-26 16:50:29,949 Common.DLL OracleHelper.ExecuteReader ORA-00942: table or view does not exist - 在 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) - -#13 2020-05-26 16:50:29,956 Dao.DLL GwTransferDao.LoadInfoList ORA-00942: table or view does not existselect count(*) as count from GwTransfer b where 1=1 order by Id DESC - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwTransferDao.LoadInfoList(String phone, Int32& recordcount, Int32 PageIndex, Int32 pageSize) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwTransferDao.cs:行号 51 - -#5 2020-05-26 16:52:50,091 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_20200526 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: table or view does not exist - -#5 2020-05-26 16:52:58,704 Common.DLL OracleHelper.ExecuteReader ORA-00942: table or view does not exist - 在 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) - -#5 2020-05-26 16:52:58,715 Dao.DLL GwTransferDao.LoadInfoList ORA-00942: table or view does not existselect count(*) as count from GwTransfer b where 1=1 order by Id DESC - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwTransferDao.LoadInfoList(String phone, Int32& recordcount, Int32 PageIndex, Int32 pageSize) 位置 C:\Users\mac\Desktop\Archives\SMGW\SMGW\web\Dao\GwTransferDao.cs:行号 51 - -#9 2020-05-26 16:54:53,404 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_20200526 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: table or view does not exist - -#4 2020-05-26 17:13:27,295 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_20200526 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: table or view does not exist - -#11 2020-05-26 17:39:23,789 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_20200526 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: table or view does not exist - -#4 2020-05-26 17:48:03,946 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_20200526 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: table or view does not exist - -#5 2020-05-26 17:50:26,523 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_20200526 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: table or view does not exist - -#11 2020-05-26 17:59:24,940 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_20200526 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: table or view does not exist - -#13 2020-09-09 18:19:45,462 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_20200909 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: table or view does not exist - -#16 2021-01-18 13:47:49,504 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: end-of-file on communication channel -Process ID: 13948 -Session ID: 73 Serial number: 20339 - -#8 2021-01-21 12:07:43,015 Common.dll OracleHelper.ExecuteReader ORA-00904: "ID": invalid identifier - 在 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) - -#23 2021-01-21 12:08:02,652 Common.dll OracleHelper.ExecuteReader ORA-00942: table or view does not exist - 在 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) - -#23 2021-01-21 12:08:02,672 Dao.dll GwTransferDao.LoadInfoList ORA-00942: table or view does not existselect count(*) as count from Gw_Transfer b where 1=1 order by Id DESC - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwTransferDao.LoadInfoList(String phone, Int32& recordcount, Int32 PageIndex, Int32 pageSize) 位置 F:\源码\掌骏云后台\web\Dao\GwTransferDao.cs:行号 50 - -#10 2021-01-21 16:35:44,754 Common.dll OracleHelper.ExecuteReader ORA-00942: table or view does not exist - 在 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) - -#10 2021-01-21 16:35:44,783 Dao.dll GwTransferDao.LoadInfoList ORA-00942: table or view does not existselect count(*) as count from Gw_Transfer b where 1=1 order by Id DESC - 在 Common.OracleHelper.ExecuteReader(String sql, OracleConnection x, OracleParameter[] cmdParms) - 在 Dao.GwTransferDao.LoadInfoList(String phone, Int32& recordcount, Int32 PageIndex, Int32 pageSize) 位置 C:\Users\Administrator\Desktop\Archives\Git\SMGW\SMGW_CODE\web\Dao\GwTransferDao.cs:行号 50 - -#16 2021-01-27 17:49:04,357 Common.dll OracleHelper.ExecuteReader ORA-00904: "ID": invalid identifier - 在 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) - -#8 2021-07-23 16:10:06,286 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: end-of-file on communication channel -Process ID: 12064 -Session ID: 6 Serial number: 27293 - -#6 2021-07-28 10:02:21,208 Common.dll OracleHelper.ExecuteReader SQL=select A.*,NVL(B.AP_IN_COUNT,0) AP_IN_COUNT,NVL(b.AP_PENDING_COUNT,0) AP_PENDING_COUNT FROM GW_AP A LEFT JOIN - (SELECT AP_ID,NVL(SUM(AP_FEE_COUNT),0) AP_IN_COUNT, NVL(SUM(CASE WHEN STATUS=0 THEN AP_FEE_COUNT ELSE 0 END),0) AP_PENDING_COUNT FROM LG_SM_20210728 where AP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY AP_ID) b ON A.AP_ID = b.AP_ID Message=ORA-03113: end-of-file on communication channel -Process ID: 7904 -Session ID: 6 Serial number: 11866 - -#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) - -#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 - diff --git a/web/web/log/log.txt b/web/web/log/log.txt deleted file mode 100644 index c51403c..0000000 --- a/web/web/log/log.txt +++ /dev/null @@ -1 +0,0 @@ -[Header][Footer][Header][Footer] \ No newline at end of file -- Gitblit v1.9.1