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
- 304 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
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