Howdy, Stranger!
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
- 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
- 305 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Help with a serious problem NAV crashes
Kisu
Member Posts: 381
Okays, I got the xml import done and after I import the purchase invoices in, they dont seems to work properly.
If I delete the line 0 or delete the whole invoice it crashes Navision. it just simply shuts down without warning..
I tryed to make normal purch invoice on the form and then delete it, it does not crash. It only seems to crash if I delete the imported invoices.
I double checked that every required line comes to the table from the import.
But I also tested if I could change a random text column from SQL server. It wont let me change any line or column even the column property is set Editable.
I receive this error from SQL server:
No row was updated.
The data in row xx was not committed.
Error Source: .Net SqlClient Data Provider.
Error Message: Conversion failed when converting the varchar value 'Receive' to datatype int.
Correct the errors and retry or press ESC to cancel the change(s).
Weird is that I havent even touched the Receive columm, also its Boolean field and all its rows are set to zero.
Has anyone hit same sort of problem?
If I delete the line 0 or delete the whole invoice it crashes Navision. it just simply shuts down without warning..
I tryed to make normal purch invoice on the form and then delete it, it does not crash. It only seems to crash if I delete the imported invoices.
I double checked that every required line comes to the table from the import.
But I also tested if I could change a random text column from SQL server. It wont let me change any line or column even the column property is set Editable.
I receive this error from SQL server:
No row was updated.
The data in row xx was not committed.
Error Source: .Net SqlClient Data Provider.
Error Message: Conversion failed when converting the varchar value 'Receive' to datatype int.
Correct the errors and retry or press ESC to cancel the change(s).
Weird is that I havent even touched the Receive columm, also its Boolean field and all its rows are set to zero.
Has anyone hit same sort of problem?
K.S.
0
Answers
The port imported lines starting with line number 0 instead of 10000.
Problem solved #-o
I have the same error. When I try to change any column on 'Purchase Header' or 'Sales Header' under SQL Management Studio it gives me an error:
"Conversion failed when converting the varchar value 'Receive' to data type int"
Generally strange...
p.s.
enviroment: Nav 4.03 , SQL Server 2005
https://connect.microsoft.com/SQLServer/feedback/details/548129/cannot-updaate-table-with-column-named-receive-or-send