We are using the "Purge : Transaction tables" to test out a planned transaction purge. This has previously worked for a similar volume of data, but we are currently getting a dialog box with the error:
"Overflow in MPX_IN (line ignored): _REPLICAT_"
The details of the purge show in the Transactions section 673,867 transactions found over which around 13,329 are marked as purgeable giving a total of 687,196. There are similar numbers in the Market Operations section and nothing listed under Linked Trades. We are doing the purge on and before 31 Dec 2007 with both the "Consolidation after" filter and "Select transaction type" off.
There does not appear to have been a problem with space in tempdb.
We are using Murex external version 2.2.9.87 (internal version v2000.2.9.87) with Sybase ASE 12.5.3.
Does anyone have any ideas?
TIA
Chris