select count(1) from where TS_MYSINGLEREL=7 Incorrect syntax near the keyword 'where'. If you open the Event Viewer on the Application Engine server and look in the Application Log you may see the following errors related to this situation.
This is not a Purge issue per se but because it tries to shrink the tables . You will need to check if or tables are compressed or how your autosegment space is managed.
/ Details Looking at the Common Log after upgrading you may see an error with message of "Invalid item id 0 for table 0." Reviewing the common log and orchestration, it will appear that the field is being passed as expected. This error can be caused by the following situation.
For relational fields (a multi-relational and a single relational field) that point to a primary table to get their values there is an icon next to each of these fields with the text "Click to Create or View the Change Request in a Popup Window". When there isn't an item selected yet and the icon is clicked you get a window that looks like an error. You can view an item if one is already selected, but you cannot create a new record by clicking the icon.