Open Forum

  • 1.  Help with Batch whose Status is 'Posting Interrupted' please "A save operation on table 'PM_Transaction_OPEN' has created a duplicate key.

    Posted 26 days ago
    I"m in a bad maze and feel there is a tiny way out, but I can't find it. Batch recovery continually states 'Process Interrupted'.

    Initial error window:
    Batch recovery does nothing. I have researched and even tried running Checklinks, which found no errors. In the SY00500 table, I flipped BCHSTTUS to 0, was set to 7 in my initial investigation. Upon flipping to 0 and trying to reprocess it sets back to 7. Tried the processes again, nothing.



    I was able to open up the batch somehow and the edit list shows the below. Can anyone shed light on the below messages? The user cannot edit the transactions as it states to use the batch recovery, but that is a bad loop I get into.


    they show up in Financials > PMTRX

    SQL data
    Select * from DYNAMICS..SY00800 - No data
    Select * from DYNAMICS..SY00801 - No data
    Select * from TEMPDB..DEX_LOCK - No data
    Select * from TEMPDB..DEX_SESSION - No DEX row for this data/batch

    Please help me get out of this bad loop.

    ------------------------------
    Angela Morehouse
    CC Industries
    Chicago IL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Help with Batch whose Status is 'Posting Interrupted' please "A save operation on table 'PM_Transaction_OPEN' has created a duplicate key.

    Posted 26 days ago
    Adding that I do see the transactions in the following tables; PM10000 (--Work/Unposted Transactions, PSTGSTUS of 20 - saved and unposted transaction), PM10100 (--GL Distributions for Work and Open Transactions, and PSTGSTUS of 1, which is unposted), and PM20000 (--Open/Posted Transactions PSTGDATE with a date back in October).  Any insight?

    ------------------------------
    Angela Morehouse
    CC Industries
    Chicago IL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Help with Batch whose Status is 'Posting Interrupted' please "A save operation on table 'PM_Transaction_OPEN' has created a duplicate key.

    Posted 26 days ago
    I was at a loss, so I had the user delete and start over fresh. I flipped BCHSTTUS to 0, was set to 7 initially, and went into some transactions, poked around, and saved to get the batch to open back up.  It appears to have worked. I'm hoping there are no orphaned records that decide to cause an issue down the road.

    Have a great day!

    ------------------------------
    Angela Morehouse
    CC Industries
    Chicago IL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Help with Batch whose Status is 'Posting Interrupted' please "A save operation on table 'PM_Transaction_OPEN' has created a duplicate key.

    GPUG ALL STAR
    Posted 25 days ago
    @Angela Morehouse

    This article might have helped identifying the duplicates.

    https://winthropdc.wordpress.com/2008/12/04/identifying-duplicate-transactions/

    Regards

    David​

    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role