| | |
|---|
| | | 进程 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: 表或视图不存在
|
|---|
| | |
|
|---|
