Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Business Central updates!Learn about the key capabilities and features of Dynamics 365 Business Central and experience some of the new features.
Overview | Guided Tour | Free Trial
2022 Release Wave 2Check out the latest updates and new features of Dynamics 365 released from October 2022 through March 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I have upgraded 2009 database into Business Central Version 14. Everything is working fine. Then I am upgrading Version 14 to version17. when I do data upgrade, it stops and here is event viewer. I followed "Upgrading Unmodified C/AL Application to Version 17" from Microsoft website.
Message Unhanded excpetion during upgrade workflow on tenant default, clientSessionId = d036ecd7-2a6e-465a-9701-fcc42c58b947, exceptionSourceInstanceId: 42, exceptionSource activity: Base Application_Microsoft_17.9.28504.0_OnUpgradePerCompany, workflow instanceId: bcfa2319-2298-4cd9-b0b7-2f7fa275fa23, unhandledException: You cannot change the value of an AutoIncrement field.
Field: Dimension Value IDTable: Dimension Value
Identification fields and values:Dimension Code='BATCH',Code='132P'ProcessId: 6468
Anyone get this problem when do the upgrade ?
First, You must be member of the SQL Server db_owner database permission set. after that Check if you have any duplicate records in dimension values. you can easily discover by running sql trace.
Anther, set AutoIncrement property set to true AutoIncrement Property - Business Central | Microsoft Docs If you want to manually assign a value to it.
Yes, missed the last part of event view :Dimension Code='BATCH',Code='132P', there is a duplicate record. Thank you.
Business Applications communities