Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

System Message 6909 - Another process has already added the cursor=DefaultCreated Item. The program must be terminated.

Posted on by 65

We are experiencing System Message 6909 - Another process has already added the cursor=DefaultCreated Item. The program must be terminated. in Release AP Batches. Mostly the affected batch are those that came from Edit/Select Documents for Payments and Check Printing/Update. Already referred to Knowledge Based didn't found anything close to this scenario. I've run the APDEBUG and below is the  message:

(1 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

Msg 2627, Level 14, State 1, Procedure APDebug, Line 9

Violation of PRIMARY KEY constraint 'WrkRelease0'. Cannot insert duplicate key in object 'dbo.wrkrelease'.

The statement has been terminated.

13 May 2011 00:38:24:060

Debug...Step 250: Get EditScrnNbr

 

Batch Diagnostics

Batch okay, will release normally.

 

Rolling back transaction

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(1 row(s) affected)

Can someone help me with this problem as we already have several batches with this scenario.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: System Message 6909 - Another process has already added the cursor=DefaultCreated Item. The program must be terminated.

    We had this problem as well. Entering voucher numbers in the Select for Payment screen, then while processing, received error "System Message 6909 - Another process has already added the cursor=21 item" followed by the screen crashing. Problem occurred when batch had two of the same voucher numbers (duplicate) that was not caught by data entry nor the screen. Deduping in Excel prior to entry in this screen caused the error to not occur again.

  • Suggested answer
    Jeff Trotman Profile Picture
    Jeff Trotman 275 on at
    Re: System Message 6909 - Another process has already added the cursor=DefaultCreated Item. The program must be terminated.

    Run "select * from wrkrelease" and I think you will find a record already there with the BatNbr value you are trying to release.  This table is normally empty and is only used temporarily during the release process.  Sounds like a release process died and these records didn't get cleaned up.

    If you delete those records from wrkrelease, you will probably be able to release the batches.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,835 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans