Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Error on Data Upgrade frpm 2013 R2 to 2015
Ryden
Member Posts: 24
I'm running an upgrade frpm 2013 R2 to 2015 and have reached task 10 in the "Upgrading the data" document
https://msdn.microsoft.com/en-us/librar ... 8(v=nav.80).aspx
I get this error and I'm not quite sure what to do about it
It's an upgrade object and should be consistent with the script.
The Start-NavDataUpgrade script is imported from a DLL, is there any way I can get the source code of this script to see what might generate the error?
https://msdn.microsoft.com/en-us/librar ... 8(v=nav.80).aspx
I get this error and I'm not quite sure what to do about it
SessionId : 2654 CodeunitId : 104025 FunctionName : UpdateSourceCodeSetup CompanyName : CompanyName Master StartTime : 2015-02-04 10:02:43 Duration : State : FailedPendingResume Error : The Source Code already exists. Identification fields and values: Code='PAYMTRECON'
It's an upgrade object and should be consistent with the script.
The Start-NavDataUpgrade script is imported from a DLL, is there any way I can get the source code of this script to see what might generate the error?
--
www.nabsolutions.se
www.nabsolutions.se
0
Comments
A QaD fix allowed me to run the task to completion.
Still not sure if this I s a bug or not...
[Upgrade] UpdateSourceCodeSetup() WITH SourceCodeSetup DO BEGIN GET; "Payment Reconciliation Journal" := 'PAYMTRECON'; MODIFY; END; WITH SourceCode DO BEGIN INIT; Code := SourceCodeSetup."Payment Reconciliation Journal"; Description := COPYSTR( ObjectTranslation.TranslateObject( ObjectTranslation."Object Type"::Page,PAGE::"Payment Reconciliation Journal"),1,30); // ADJ0000 // INSERT; IF NOT INSERT THEN; //0000 END;www.nabsolutions.se
regards, Gunnar
QaD is short for "Quick and Dirty", I just treated the symptoms instead of the cause.
If you look at the source code below you'll see that I changed the INSERT; statement into IF NOT INSERT THEN; which is a quick way of ignoring any errors.
It's bad programming, much like the IF NOT INSERT THEN MODIFY approach, but it will get us through the upgrade.
I just keep on overwriting the record with the same data until the process is through.
Ha det!
//Anders
WITH SourceCode DO BEGIN INIT; Code := SourceCodeSetup."Payment Reconciliation Journal"; Description := COPYSTR( ObjectTranslation.TranslateObject( ObjectTranslation."Object Type"::Page,PAGE::"Payment Reconciliation Journal"),1,30); // ADJ0000 // INSERT; IF NOT INSERT THEN; //0000 END;www.nabsolutions.se
QaD, I see. Like swallowing exceptions. Not good, but a fix.
Thanks, Gunnar
Not sure what the underlaying issue is, I've had some upgrades pass this obstacle without a hitch and others stuck on this error
www.nabsolutions.se
Hej Anders!