Strange error when inserting new sales order

manthano
Member Posts: 10
We've been running Navision for over three years now, and all of a sudden today, when we tried to insert a new sales order we got this error.
You do not have read permission for the Sales Header Archive table
Which is correct, we don't have that granual (5160 i think).
I ran the debugger and this is the code from Sales Header OnInsert that was triggering the error (the IF FIND('+') line in the called codeunit actually caused it to "break on error")
This, afaik, is standard navision code, and I haven't modified it, or the codeunit it calls.
For the time being, since we don't the archiving granual anyway, i commented it out and put "Doc. No. Occurrence" := 1; so we could create sales orders again.
Anybody have any idea what would have triggered this problem? I'm at a loss.
If it makes any difference we're running 3.10 on a MSSQL server. We also have a development database that is identical to our production db, other than the data is old, and it doesn't give the error. Weird.
You do not have read permission for the Sales Header Archive table
Which is correct, we don't have that granual (5160 i think).
I ran the debugger and this is the code from Sales Header OnInsert that was triggering the error (the IF FIND('+') line in the called codeunit actually caused it to "break on error")
"Doc. No. Occurrence" := ArchiveManagement.GetNextOccurrenceNo(DATABASE::"Sales Header","Document Type","No.");
This, afaik, is standard navision code, and I haven't modified it, or the codeunit it calls.
For the time being, since we don't the archiving granual anyway, i commented it out and put "Doc. No. Occurrence" := 1; so we could create sales orders again.
Anybody have any idea what would have triggered this problem? I'm at a loss.
If it makes any difference we're running 3.10 on a MSSQL server. We also have a development database that is identical to our production db, other than the data is old, and it doesn't give the error. Weird.
0
Answers
-
Looks like somebody used a developer license and created a sales order. WHat you need to do is delete all the recrods from sales archive header and lines. This has to be done with a developer license.0
-
Thanks. That fixed it. I can't believe we haven't run into that before in either of our databases . Guess we were lucky.0
-
You are welcome. I'm just curios on how a developer license has been used in production. If it was an NSC developer, I'm sure they would know about this issue.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions