Resolution:
Description:
============
While modifying a rejected record the following error is thrown after hitting Save and Process in the UI: SQL-8201: Database error.


Environment:
============
TIBCO Product name and version: TIBCO Collaborative Information Manager 8.x
Operating System(s): All Operating Systems

Symptoms:
============
Following error is thrown after hitting Save and Process in the UI:

SQL-8201: Database error. SQL state Unknown. Database specific error code (if any) was Unknown. Database error message (if any) was: Unknown. GEN-7001: Requested operation failed. See associated error messages and log files. Additional information: Unknown , java.lang.RuntimeException: Attempt is made to save a non existing product!.

Cause:
============
The issue only occurs when there is no previous confirmed version of the record that is in the workflow (you should see Version = -1 for the rejected record that you are modifying).  If you already have a confirmed version of the record then the modify operation works fine.

Resolution:
============
The only solution in this scenario is to recreate the rejected record rather than modifying it i.e., create a new record with all the data (including PRODUCTID and PRODUCTIDEXT) same as the rejected record.  This way a new version of the rejected record would get created (version 1).

While modifying a rejected record the following error is thrown after hitting Save and Process in the UI: SQL-8201: Database error.