Step Execution Progress
This execution is estimated to be 100% complete after 1343 ms based on end time (already finished)
History of Step Execution for Step=step3
Summary after total of 30 executions:
| Property | Min | Max | Mean | Sigma |
|---|---|---|---|---|
| Duration per Read | 0 | 0 | 0 | 0 |
| Duration | 1,343 | 2,111 | 1,799.667 | 131.28 |
| Commits | 0 | 1 | 0.967 | 0.18 |
| Rollbacks | 0 | 1 | 0.033 | 0.18 |
| 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,908,558 |
| Job Execution | 3,927,016 |
| Job Name | sapMatchingJob |
| Step Name | step3 |
| Start Date | 2026-04-28 |
| Start Time | 01:30:03 |
| Duration | 00:00:01 |
| 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.dao.DataIntegrityViolationException: ### Error updating database. Cause: java.sql.SQLException: JDBC-11048:"EAAR"."MD_SAP_0003"."PSTLZ" The value is too large for the column. (Actual value: 15, Maximum value: 10) ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: INSERT INTO MD_SAP_0003 ( USER_ID, OBJECT_ID, USER_NAME, USER_NAME_E, USER_BIRTH, USER_GENDER, DEPARTMENT_ID, USER_ZORG_CD, USER_NAMZU, USER_NO, USER_GRADE, USER_SESSION, USER_MASTER_ID, CM_USER_STAT, PHONE_HOME, PHONE_MOBILE, EMAIL, PICTURE_URL, PICTURE_EXT, PIC_MOD_DATE, STGRP, PSTLZ, ZADDR1, ZADDR2, ZECHKFR, REG_DT ) SELECT USER_ID, OBJECT_ID, USER_NAME, USER_NAME_E, USER_BIRTH, USER_GENDER, DEPARTMENT_ID, USER_ZORG_CD, USER_NAMZU, USER_NO, USER_GRADE, USER_SESSION, USER_MASTER_ID, CM_USER_STAT, PHONE_HOME, PHONE_MOBILE, EMAIL, PICTURE_URL, PICTURE_EXT, PIC_MOD_DATE, STGRP, PSTLZ, ZADDR1, ZADDR2, ZECHKFR, TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') REG_DT FROM TMP_SAP_0003@oraeaar ### Cause: java.sql.SQLException: JDBC-11048:"EAAR"."MD_SAP_0003"."PSTLZ" The value is too large for the column. (Actual value: 15, Maximum value: 10) ; SQL []; JDBC-11048:"EAAR"."MD_SAP_0003"."PSTLZ" The value is too large for the column. (Actual value: 15, Maximum value: 10); nested exception is java.sql.SQLException: JDBC-11048:"EAAR"."MD_SAP_0003"."PSTLZ" The value is too large for the column. (Actual value: 15, Maximum value: 10) at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:102) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447) at com.sun.proxy.$Proxy75.update(Unknown Source) at org.myba |