http://forum.murexusers.org/tags/transaction Forum for the new Murex User Group. en-US Fri, 10 Sep 2010 01:21:17 +0000 http://bbpress.org/?v=1.0.2 q http://forum.murexusers.org/search.php http://forum.murexusers.org/topic/problems-with-transaction-purge#post-40 Mon, 22 Sep 2008 06:18:25 +0000 Markus Linke 40@http://forum.murexusers.org/ <p>Be careful with any advise you might get here, because this is an old version, where things might be very different! Don't forget to do some extra testing on a dev environment! </p> http://forum.murexusers.org/topic/problems-with-transaction-purge#post-36 Wed, 10 Sep 2008 10:28:54 +0000 chrisjej 36@http://forum.murexusers.org/ <p>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:<br /> "Overflow in MPX_IN (line ignored): _REPLICAT_"</p> <p>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.</p> <p>There does not appear to have been a problem with space in tempdb.</p> <p>We are using Murex external version 2.2.9.87 (internal version v2000.2.9.87) with Sybase ASE 12.5.3.</p> <p>Does anyone have any ideas?</p> <p>TIA<br /> Chris </p>