Dynamics 2013 GET not returning a record
Toddy_Boy
Member Posts: 232
I've created a new company and copied data from the original company using SQL INSERT INTO ... SELECT FROM .
I can log into the new company fine, create a sales order fine but, if I try to delete the Sales Order I get an error message on SourceCodeSetup.GET; saying the record cannot be found, however the record is there with the same blank key as the original company. The SQL copy must be doing something to the Primary Key value but I can't figure out what and it's bugging me. Does anyone know why the GET does not work in this instance?
I can log into the new company fine, create a sales order fine but, if I try to delete the Sales Order I get an error message on SourceCodeSetup.GET; saying the record cannot be found, however the record is there with the same blank key as the original company. The SQL copy must be doing something to the Primary Key value but I can't figure out what and it's bugging me. Does anyone know why the GET does not work in this instance?
Life is for enjoying ... if you find yourself frowning you're doing something wrong
0
Best Answer
-
Try restarting the service tier, moving data in SQL won't refresh the cache.
If it still doesn't work, I'd have a look for white space characters in the PK5
Answers
-
Try restarting the service tier, moving data in SQL won't refresh the cache.
If it still doesn't work, I'd have a look for white space characters in the PK5 -
Restarting the service seems to have worked. Thought I tried that
. Life is for enjoying ... if you find yourself frowning you're doing something wrong0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions