| | |
|---|
| | | 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)
|
|---|
| | |
|---|
| | | #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
|
|---|
| | |
|
|---|
