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
-
Ah stupid me, figured the problem out
The port imported lines starting with line number 0 instead of 10000.
Problem solved #-oK.S.0 -
Hi,
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
http://www.reinwestuj.pl Inwestuj w nieruchomości. Condohotele, aparthotele.0 -
Here is the description and workaround of this problem:
https://connect.microsoft.com/SQLServer/feedback/details/548129/cannot-updaate-table-with-column-named-receive-or-send
http://www.reinwestuj.pl Inwestuj w nieruchomości. Condohotele, aparthotele.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