Tag Archives: SQLERRMC=7

[Solved] SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7

Error Log:

com.ecc.liana.exception.TranFailException: com.ecc.emp.jdbc.EMPJDBCException: Failed to execute procedure[ED_PCKG_LOGON_USER_LOGON]! caused by: DB2 SQL Er

ror: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7;NDS.SP_ORG, DRIVER=3.52.110 cause: com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-668, SQLSTATE=570

16, SQLERRMC=7;NDS.SP_ORG, DRIVER=3.52.110 caused by: Failed to execute procedure[ED_PCKG_LOGON_USER_LOGON]! caused by: DB2 SQL Error: SQLCODE=-668, SQLST

ATE=57016, SQLERRMC=7;NDS.SP_ORG, DRIVER=3.52.110 cause: com.ecc.emp.jdbc.EMPJDBCException:
Failed to execute procedure[ED_PCKG_LOGON_USER_LOGON]! caused

by: DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7;NDS.SP_ORG, DRIVER=3.52.110 cause: com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-668

, SQLSTATE=57016, SQLERRMC=7;NDS.SP_ORG, DRIVER=3.52.110

Cause: An exception occurred in the execution of the stored procedure at sp_org because the operation of reorg was not performed after deleting a field of table sp_org before.

Solution: db2 reorg table sp_org.