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.

Similar Posts:

• APP Report DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.17.29
• How to quickly locate problems in error reporting of db2-407 sqlcode: – 407, sqlstate: 23502
• How to quickly locate problems in error reporting of db2-407 sqlcode: – 407, sqlstate: 23502
• Solutions for DB2 SQL error: sqlcode = – 420, sqlstate = 22018
• DB2 Errors and How to Solve them
• DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016mistake
• DB2 Database table operation error SQL0668N Operation not allowed for reason code “1” on table “db”. S…
• java.sql.SQLException: Fail to convert to internal
• DB2 error: sqlcode = – 802, sqlstate = 22003
• DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002 Resolution