Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Error 1185 in module 19
Lars_Westman
Member Posts: 116
I've ran into some problems today at a clients site and wonder if anyone else has seen the same thing.
There was an error in the primary key för table 37 Sales Line. The error message vas 1185 in module 19. No other table/key was damaged. As soon as we tried to open the table, or a form/report that has the table as SourceDataItem, all free space in the database was consumed. We also tried to make a backup with client in read-only mode with no success. We also tried testing, optimizing and rebuild of keyes with no success.
The last action that the customer know was done was a conversion from Sales Quote to an Sales Order.
We have had exactly the same problem one Year ago in this database. Then the system was running on C/SIDE version 2.60D. At that time we also was running on a different hardware. So. We have upgraded C/SIDE and hardware but the problem still exists.
The database is running on C/SIDE version 3.01A, is 13Gb on 4 files and 45 users. At the time of the failure there was only five users logged on.
There was an error in the primary key för table 37 Sales Line. The error message vas 1185 in module 19. No other table/key was damaged. As soon as we tried to open the table, or a form/report that has the table as SourceDataItem, all free space in the database was consumed. We also tried to make a backup with client in read-only mode with no success. We also tried testing, optimizing and rebuild of keyes with no success.
The last action that the customer know was done was a conversion from Sales Quote to an Sales Order.
We have had exactly the same problem one Year ago in this database. Then the system was running on C/SIDE version 2.60D. At that time we also was running on a different hardware. So. We have upgraded C/SIDE and hardware but the problem still exists.
The database is running on C/SIDE version 3.01A, is 13Gb on 4 files and 45 users. At the time of the failure there was only five users logged on.
Lars Westman
http://www.linkedin.com/in/larswestman
http://www.linkedin.com/in/larswestman
0
Comments
I had the same sort of problem about a month ago, fortunately on a test database. Then only thing I could do was to edit the Sales Line table, save it as Sales Line Temp, then wrote a routine to transfer what records I could across from the damaged table, making sure to do a COMMIT after each entry since the corrupt one will crash you out every time. You may need to try different keys, also try starting at the last record and reading backwards.
After doing this I was able to delete all records in Sales Line and transfer them back from Sales Line Temp, and only lost one. I don't know what happened to cause the problem but I'm glad it was a test database!
Good luck,
Dan.
I also got the information that there has been a fix in 3.01B that could prevent these cind of errors
http://www.linkedin.com/in/larswestman