From 1a81b518e0edd87a310a5b477773657e23d49cbd Mon Sep 17 00:00:00 2001
From: yzh <snbbt@21cn.com>
Date: 星期四, 30 九月 2021 17:53:10 +0800
Subject: [PATCH] 产品管理
---
web/web/logs/err.txt | 34 ++++++++++++++++++++++++++++++++++
1 files changed, 34 insertions(+), 0 deletions(-)
diff --git a/web/web/logs/err.txt b/web/web/logs/err.txt
index 13b3e3b..c6d2578 100644
--- a/web/web/logs/err.txt
+++ b/web/web/logs/err.txt
@@ -535,6 +535,15 @@
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)
@@ -637,4 +646,29 @@
#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
+
+#35 2021-09-26 14:19:27,636 Common.dll OracleHelper.ExecuteReader ORA-03113: 通信通道的文件结尾
+进程 ID: 7248
+会话 ID: 81 序列号: 9801
+ 在 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_NewWeb\web\Common\OracleHelper.cs:行号 219
+
+#42 2021-09-26 14:32:56,924 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: 5640
+会话 ID: 208 序列号: 44898
+
+#22 2021-09-27 16:49:48,131 Common.dll OracleHelper.ExecuteReader ORA-00904: "OP_GROUP_ID": 标识符无效
+ 在 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_NewWeb\web\Common\OracleHelper.cs:行号 219
+
+#27 2021-09-30 10:17:56,581 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: 17820
+会话 ID: 14 序列号: 14066
--
Gitblit v1.9.1