CTE00247S Rolling back, error getting list of entry_ids to remove. Rollback stopped. Exception is: xxx

Explanation

Transaction Server

When an error occurs during a CPCS extract, any modifications that were made to the database during the extract are rolled back so the database appears the same as before the extract started. This error indicates that the database rollback did not complete when it tried to get a list of the entry IDs that were created as part of this CPCS extract. As a result, all entry IDs that were created as part of this CPCS extract still exist in the database and the entries are referred to in other tables. The exception message that was received when the database was queried is xxx.

Operator response

You can choose to manually roll back any changes by deleting any entry that was created during the CPCS extraction and removing all references to these entries. The manual rollback can be done by running the following example SQL statements but replacing the variables with the real values. Replace www with the WIP ID of the WIP that failed and replace nnn with the actual values that are returned from the first query.
select unique cpcs_entry_id from presentment,
  where presentment_id in
 (select presentment_id from pres_wip_xref where wip_id=www)
update presentment set cpcs_entry_id=null where cpcs_entry_id=nnn
update segment set entry_id=0, tracer_group=0 where entry_id=nnn
delete from entry where entry_id=nnn
You might need to run the update and delete statements multiple times with different values.