Cannot rename Vendor No. (NAV 2013 R2:Unable to convert)

apap
Member Posts: 67
Hi everyone,
we have the following problem. We cannot rename any Vendor No. in our production server. The same code is running in stage and development servers with no problem.
The error message from NAV is "Unable to convert from Microsoft.Dynamics.NAV.Runtime.NAVCode to System.DateTime."
The error is raised after the code in the Rename trigger in Vendor table is completed. So we do not have any indications of what is going on, because the debugger isn't stopped in any error.
Obviously, if we put a new field (e.g.an autoincrement) as Primary key in the vendor table we can modify the Vendor No
The problem exists even if we delete all vendors and create a new one with Vendor No. = 1.
We have rebuilt all indexes in the db, and make the known steps for db's maintenance, but with no positive result. ](*,) ](*,) ](*,)
Any proposal, solution or thought is welcomed.
Kind Regards
we have the following problem. We cannot rename any Vendor No. in our production server. The same code is running in stage and development servers with no problem.
The error message from NAV is "Unable to convert from Microsoft.Dynamics.NAV.Runtime.NAVCode to System.DateTime."
The error is raised after the code in the Rename trigger in Vendor table is completed. So we do not have any indications of what is going on, because the debugger isn't stopped in any error.
Obviously, if we put a new field (e.g.an autoincrement) as Primary key in the vendor table we can modify the Vendor No
The problem exists even if we delete all vendors and create a new one with Vendor No. = 1.
We have rebuilt all indexes in the db, and make the known steps for db's maintenance, but with no positive result. ](*,) ](*,) ](*,)
Any proposal, solution or thought is welcomed.
Kind Regards
0
Comments
-
I am aware of this post http://www.mibuso.com/forum/viewtopic.php?f=32&t=57611 , and we have searched all the tables for a wrong relationsip with Vendor.No. but we haven't found anything0
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