Step Execution Progress
This execution is estimated to be 100% complete after 7 ms based on end time (already finished)
History of Step Execution for Step=step1
Summary after total of 1,711 executions:
| Property | Min | Max | Mean | Sigma |
|---|---|---|---|---|
| Duration per Read | 0 | 0 | 0 | 0 |
| Duration | 6 | 1,504 | 348.564 | 205.773 |
| Commits | 0 | 1 | 0.996 | 0.064 |
| Rollbacks | 0 | 1 | 0.004 | 0.064 |
| Reads | 0 | 0 | 0 | 0 |
| Writes | 0 | 0 | 0 | 0 |
| Filters | 0 | 0 | 0 | 0 |
| Read Skips | 0 | 0 | 0 | 0 |
| Write Skips | 0 | 0 | 0 | 0 |
| Process Skips | 0 | 0 | 0 | 0 |
Details for Step Execution
| Property | Value |
|---|---|
| ID | 3,532,176 |
| Job Execution | 3,547,256 |
| Job Name | sapRfc0009MatchingJob |
| Step Name | step1 |
| Start Date | 2025-07-21 |
| Start Time | 11:15:03 |
| Duration | 00:00:00 |
| Status | FAILED |
| Reads | 0 |
| Writes | 0 |
| Filters | 0 |
| Read Skips | 0 |
| Write Skips | 0 |
| Process Skips | 0 |
| Commits | 0 |
| Rollbacks | 1 |
| Exit Code | FAILED |
| Exit Message | org.springframework.jdbc.UncategorizedSQLException: ### Error updating database. Cause: java.sql.SQLException: JDBC-12130:Unable to connect to remote database(RemoteDB_name=ORAEAAR). ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: INSERT INTO TMP_SAP_0009@oraeaar ( ZYEAR, ZREQ_NO, ZCODE, ZDESC, ZCODE1, ZDESC1, DONG_CD, DONG_PLTXT, HO_CD, HO_PLTXT, REQ_PERNO, USE_PERNO, USE_DATE, USE_FLAG, APP_STA, USE_OBJ, REQ_TXT, REG_DT ) SELECT (SELECT SUBSTR(HYHG, 0, 4) FROM TBL_LECTURE WHERE LEC_SEQ = C.LEC_SEQ) ZYEAR, CONCAT('9', LPAD(SEQ_ZREQ.NEXTVAL, 9, '0')) ZREQ_NO, '' ZCODE, '' ZDESC, '' ZCODE1, '' ZDESC1, (SELECT DONG_CD FROM TBL_ROOM WHERE ROOM = C.ROOM) DONG_CD, (SELECT DONG_PLTXT FROM TBL_ROOM WHERE ROOM = C.ROOM) DONG_PLTXT, (SELECT HO_CD FROM TBL_ROOM WHERE ROOM = C.ROOM) HO_CD, (SELECT HO_PLTXT FROM TBL_ROOM WHERE ROOM = C.ROOM) HO_PLTXT, (SELECT PCODE FROM TBL_PROFESSOR WHERE OWNER_TYPE = 'P' AND LEC_SEQ = C.LEC_SEQ) REQ_PERNO, (SELECT PCODE FROM TBL_PROFESSOR WHERE OWNER_TYPE = 'P' AND LEC_SEQ = C.LEC_SEQ) USE_PERNO, USE_DATE, USE_FLAG, '6' APP_STA, '정규 강의' USE_OBJ, '' REQ_TXT, TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') REG_DT FROM ( SELECT LEC_SEQ, ROOM, CONCAT(CONCAT(CLASS_DT, STARTTIME), '00') USE_DATE, '1' USE_FLAG FROM TBL_CLASS C WHERE CLASS_DT BETWEEN TO_CHAR(ADD_MONTHS(SYSDATE, -1), 'YYYYMMDD') AND TO_CHAR(ADD_MONTHS(SYSDATE, +1), 'YYYYMMDD') UNION ALL SELECT LEC_SEQ, ROOM, CONCAT(CONCAT(CLASS_DT, ENDTIME), '00') USE_DATE, '2' USE_FLAG FROM TBL_CLASS C WHERE CLASS_DT BETWEEN TO_CHAR(ADD_MONTHS(SYSDATE, -1), 'YYYYMMDD') AND TO_CHAR(ADD_MONTHS(SYSDATE, +1), 'YYYYMMDD') ) C ### Cause: java.sql.SQLException: JDBC-12130:Unable to connect to remote database(RemoteDB_name=ORAEAAR). ; uncategorized SQLException for SQL []; SQL state [ERRFR]; error code [-12130]; JDBC-12130:Unable to connect to remote database(RemoteDB_name=ORAEAAR).; nested exception is java.sql.SQLException: JDBC-12130:Unable to connect to remote database(RemoteDB_name=ORAEAAR). at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:90) at org.springframew |