Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / System Message 6909 - ...
Microsoft Dynamics SL (Archived)

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

(0) ShareShare
ReportReport
Posted on by Derrick0828 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.

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member 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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

#1
Community Member Profile Picture

Community Member 136

#2
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 102 Super User 2025 Season 1

#3
REUser Profile Picture

REUser 8

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans