Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 295 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
Empty tables [Updated]
Ploeg
Member Posts: 70
Hello everybody,
We received an ERROR in the Sales Order page. This error was invoked by the Sales Line table because of two calls of PAGE.RUNMODAL in one command. Sloppy programming, but nothing serious.... we thought. Right after these errors (which we triggered on purpose for debugging) we got a call from our client: two tables were completely empty! Tables Sales Line and Purchase Line were stripped from their data.
We checked our code, we checked reported bugs, we tried to reproduce it in a local environment, but we found nothing. We had the same errors, but the tables where never truncated.
Worried as we are, we are turning to you. Does anyone know what could have happend?
This is one of the errors which was caught in the windows log.
-- UPDATE --
See post below for the explanation of this problem.
We received an ERROR in the Sales Order page. This error was invoked by the Sales Line table because of two calls of PAGE.RUNMODAL in one command. Sloppy programming, but nothing serious.... we thought. Right after these errors (which we triggered on purpose for debugging) we got a call from our client: two tables were completely empty! Tables Sales Line and Purchase Line were stripped from their data.
We checked our code, we checked reported bugs, we tried to reproduce it in a local environment, but we found nothing. We had the same errors, but the tables where never truncated.
Worried as we are, we are turning to you. Does anyone know what could have happend?
This is one of the errors which was caught in the windows log.
Type: System.Data.SqlClient.SqlException
ClientConnectionId: 82040483-0d44-4d08-9f6e-8075da5c787b
Class: 16
LineNumber: 1
Number: 208
Server: [******]\NAVISION
State: 1
Source: .Net SqlClient Data Provider
ErrorCode: -2146232060
Message:
Invalid object name '[DB].dbo.[Company]$Purchase Line'.
Statement(s) could not be prepared.
-- UPDATE --
See post below for the explanation of this problem.
0
Comments
http://blogs.msdn.com/b/nav/archive/2014/02/28/important-information-potential-data-loss-in-nav2013r2.aspx