Error While executing upgrade codeunit-ID-104025

maheshroyal34
Member Posts: 19
Hi Experts,
While trying to upgrade the database from NAV2013R2 to NAV 2015, facing some problem with execution of upgrade code unit.(Codeunit-104025)
Microsoft Dynamics NAV
De volgende SQL-fout werd niet verwacht.
Cannot insert the value NULL into column 'Ledger Entry Amount', table 'Test Company$Detailed Cust_ Ledg_ Entry'; column does not allow nulls. INSERT fails.
The statement has been terminated.
OK
The block of code in updating a field of boolean type.
Can any one have clue on this.
While trying to upgrade the database from NAV2013R2 to NAV 2015, facing some problem with execution of upgrade code unit.(Codeunit-104025)
Microsoft Dynamics NAV
De volgende SQL-fout werd niet verwacht.
Cannot insert the value NULL into column 'Ledger Entry Amount', table 'Test Company$Detailed Cust_ Ledg_ Entry'; column does not allow nulls. INSERT fails.
The statement has been terminated.
OK
The block of code in updating a field of boolean type.
Can any one have clue on this.
0
Best Answer
-
Please check whether there are any SQL stored procedures running in the back end.5
Answers
-
Hi Did you get a solution to your problem?0
-
Please check whether there are any SQL stored procedures running in the back end.5
-
Hey Mahesh,
This error normally generates when there is a Query running from SQL side - an Insert query where you have skipped a column to assign manually hence SQL is trying to insert NULL value to it which NAV doesnt allows.Thanks
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/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