| | |
|---|
| | | Process ID: 7904 |
|---|
| | | Session ID: 6 Serial number: 11866
|
|---|
| | |
|
|---|
| | | #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
|
|---|
| | |
|
|---|
