An ODBC error occurred, but no error information

Sog
Member Posts: 1,023
SLQ 2008 R2
NAV 4.0 SP3
Scenario: Sales-post is called by a document, in codeunit 22, the insertitemledgerentry function is going into error on a random document line when it is called by itemqtyposting function. (although it's always the same line in a document, no relation between the different lines that give the error is detected)
Error:
"An ODBC error occurred, but no error information could be retrieved.
Contact your system manager."
And I can't find anything that might give me more information, no erors in eventvwr or sqllog.
client montior shows me this:
Compile everything again and synchronise users.
I'm at a loss, has anyone seen a similar error and/or behaviour, or does anyone have suggestions to try some steps?
NAV 4.0 SP3
Scenario: Sales-post is called by a document, in codeunit 22, the insertitemledgerentry function is going into error on a random document line when it is called by itemqtyposting function. (although it's always the same line in a document, no relation between the different lines that give the error is detected)
Error:
"An ODBC error occurred, but no error information could be retrieved.
Contact your system manager."
And I can't find anything that might give me more information, no erors in eventvwr or sqllog.
client montior shows me this:
Item ledger entry:[??][item ledger entry no][item no.],[date],[sourcetype (customer) ],[Source No],[location code],[quantity],[quantity remaining], ... This one works: previous lines aswell that are applied (this one isen't, see remaining quantiyt -6.0000) exec sp_execute 99,20831957,'B7167','2012-06-13 00:00:00',1,'12270','SH212009290','','NEWWHS',-6.00000000000000000000,-6.00000000000000000000,0,0,1,'','',0,1,0,'','','FR','','2012-06-13 00:00:00','A1223-0166','','','S-SHPT','','',1.00000000000000000000,'PC',0,'','','',0,'203',0,'','','',0,'1753-01-01 00:00:00',0,0,0,0,'','','','1753-01-01 00:00:00','1753-01-01 00:00:00','' This one does not work, exec sp_execute 99,20831958,'B7189','2012-06-13 00:00:00',1,'12270','SH212009290','','NEWWHS',-1.00000000000000000000,0,0,0,0,'','',0,1,0,'','','FR','','2012-06-13 00:00:00','A1223-0166','','','S-SHPT','','',1.00000000000000000000,'PC',0,'','','',0,'203',0,'','','',0,'1753-01-01 00:00:00',0,0,0,0,'','','','1753-01-01 00:00:00','1753-01-01 00:00:00',''Steps taken:
Compile everything again and synchronise users.
I'm at a loss, has anyone seen a similar error and/or behaviour, or does anyone have suggestions to try some steps?
0
Comments
-
do you have any custom code that is adding item ledger entries? Possibly you have duplicate primary keys because the entry no. is being used twice in some circumstances.David Machanick
http://mibuso.com/blogs/davidmachanick/0 -
No custom code has been added in cu 22.
The ledger entry no. is unique, but it probalby has something to do with the sbs problems we had.
We're currently rebuilding the indexes, we hope that that might resolve the issue.0 -
Thanks & Regards,
Saurav Dhyani
Do you Know this About NAV?
Connect - Twitter | Facebook | Google + | YouTube
Follow - Blog | Facebook Page | Google + Page0 -
Hi @postsaurav ,
It's been years since I've had this issue. Unfortunately, I can't recall if and how we've solved this issue. But the last attempt I've mentioned may be the solution, since I didn't respond/update the topic after this.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