Navision 2009 SP1 : The Sales Header table cannot be changed because it is locked by another user. Wait until the user is finished and then try again

(0) Share

Report

Posted on by Community Member

Hi Friends,

While creating order using Navision Web services i am frequently facing issue like

"The Sales Header table cannot be changed because it is locked by another user. Wait until the user is finished and then try again".

Server: Navision 2009 SP1

Webservice: Page(42) SalesOrder

Please help me to over come this issue.

Thanks,

Ramana

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

Check any other process is running using sales header or check anybody posting sales order

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report
Copy link

Link copied!

This is a known issue, resulted from general NAV architecture. There might be users or processes that blocks the table from inserting new data. You can start reading here:

forum.mibuso.com/.../the-sales-line-table-cannot-be-changed-because-it-is-locked

dynamicsuser.net/.../table-locked

and related subsequent links.

Was this reply helpful? Yes No
Suggested answer

Sathyanarayanan_Cetas 62 on at

Like (0)

Report
Copy link

Link copied!

Dear Ramana,

Please check if your database is running on a NAV service, if it is so, ask the users to stop data entry and restart the service that should remove the table lock.

else ask all the users to close NAV and you restart the NAV client on your machine.

cheers,

Sathyanarayanan.S

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report
Copy link

Link copied!

hi

please note that this is not an error , its a one of system security architecture of Microsoft dynamics

there are several option dynamics restricted to manipulation by multiple users by same time

on your option it might be 3 ways that you got this error

1. several user open same sales order at once

3. while opening the same SO by one person and some one try to post it

2. several users try to post at the same time

you can try by few second , then it will be posted , if not mean there are some one open the so while u posting

Was this reply helpful? Yes No