After restoing latest production backup onto QA environment, we are getting below error message when inserting data into table
com.ibm.db2.jcc.c.SqlException: An error occurred during implicit system action type "7". Information returned for the error includes SQLCODE "-117", SQLSTATE "42802" and message tokens "42802".
I found below explanation through internet but still dont know how to address the issue.
An error occurred during implicit system action type action-type. Information returned for the error includes SQLCODE sqlcode, SQLSTATE sqlstate and message tokens token-list.
Action type 7 --> implicit regeneration of a trigger
Check the message associated with the SQLCODE of the SQL statement that failed. Follow the action suggested by that message.
For an invalid package, the REBIND command can be used to recreate the error or to explicitly validate the package once the cause of the error has been resolved.
Information returned for the error includes SQLCODE "-117", SQLSTATE "42802" and message tokens "42802".
SQLCode"-117" THE NUMBER OF INSERT VALUES IS NOT THE SAME AS THE NUMBER OF OBJECT COLUMNS
Short Description: THE NUMBER OF VALUES ASSIGNED IS NOT THE SAME AS THE NUMBER OF SPECIFIED OR IMPLIED COLUMNS
The number of insert values in the value list of the INSERT statement is not the same as the number of object columns specified. Alternatively, the number of values on the right side of an assignment in a SET assignment statement or the SET clause of an UPDATE statement does not match the number of columns on the left side. System action: The statement cannot be executed. No data was inserted into the object table. Programmer response: Correct the statement to specify one and only one value for each of the specified object columns.