web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Upgrade from AX 2009 t...
Microsoft Dynamics AX (Archived)

Upgrade from AX 2009 to Ax 2012 R2

(0) ShareShare
ReportReport
Posted on by Mostafa Abu Taleb 1,880

Hi, all

when i made upgrade in this step' Data Upgrade cockpit (Ax 2009 -> Ax 2012) ', i face this error

any idea.

thanks all

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Kevin Kidder Profile Picture
    Kevin Kidder Microsoft Employee on at

    There are a few possible reasons for this that I can think of. To track down the root cause, if you issue the command "select * from RELEASEUPDATEBULKCOPYTABLE where OLDTABLENAME = 'bomtable'" against your AX2012 database after you get the error, see if anything is listed in the DIRECTSQL field of that row. If there isn't anything in that row, check your Event Viewer to see if the full SQL statement that was attempted is listed out so that you can see what the statement looks like. The SQL statement listed should be able to run against your AX 2009 source database and return the data from the BOMTABLE.

    If that doesn't lead you to the cause of the error, make sure the Bills of Materials config key is marked (or unmarked) in both your AX 2009 and AX 2012 versions. If the config keys are the same in both versions, then check for extra columns in the table and make sure they exist in both versions.

  • Mostafa Abu Taleb Profile Picture
    Mostafa Abu Taleb 1,880 on at

    Dear  Kevin:

    Thank you for your answer, i run this command "select * from RELEASEUPDATEBULKCOPYTABLE where OLDTABLENAME = 'bomtable'" and i found  a sql query in DIRECTSQL field .

    the answer is in this lines,

    make sure the Bills of Materials config key is marked (or unmarked) in both your AX 2009 and AX 2012 versions.


    Thanks

  • Mostafa Abu Taleb Profile Picture
    Mostafa Abu Taleb 1,880 on at

    Dear kevin :

    there is an error in  new INDEX  , what can i do  , try to delete the duplication ,or what ? 


    Error Message (12:12:55 pm) Cannot execute a data definition language command on  ().

    The SQL database has issued an error.

    Error Message (12:12:55 pm) Object Server 01:

    Error Message (12:12:55 pm) [Microsoft][SQL Server Native Client 10.0][SQL Server]The CREATE UNIQUE INDEX statement terminated

    because a duplicate key was found for the object name 'dbo.VENDPACKINGSLIPPURCHLINK' and the index

    name 'I_1508JOURIDX'. The duplicate key value is (5637144576, saj, 0, AJM-24572-DXB).

    Error Message (12:12:55 pm) CREATE UNIQUE  INDEX I_1508JOURIDX ON "DBO".VENDPACKINGSLIPPURCHLINK (PARTITION,DATAAREAID,VENDPACKINGSLIPJOUR,ORIGPURCHID)

    Error Message (12:12:55 pm) session 5 (Admin)

    Error Message (12:12:55 pm) Problems during SQL data dictionary synchronization.

    The operation failed.

    Info Message (12:12:55 pm) Synchronize failed on 1 table(s)

    Error Message (12:12:55 pm)\Synchronize database Microsoft.Dynamics.Ax.Xpp.ErrorException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.ErrorException' was thrown.

      at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue)

      at Microsoft.Dynamics.Ax.MSIL.cqlClassIL.callReturn(Int32 rc, interpret* ip)

      at Microsoft.Dynamics.Ax.MSIL.cqlClassIL.Call(IntPtr c, String methodName, Object[] parameters, Type[] types, Object[] varargs, Type[] varargsTypes)

      at Microsoft.Dynamics.Ax.Xpp.xApplication.Dbsynchronize(Int32 tableId, Boolean checkAsNeeded, Boolean continueOnError, Boolean showProgress, Object[] checkSyncTables, Boolean createAllIndexes, Boolean useLockForSingleTable)

      at Dynamics.Ax.Application.Application.Dbsynchronize(Int32 tableId, Boolean syncAsNeeded, Boolean continueOnError, Boolean showProgress, Object[] checkSyncTables, Boolean createAllIndexes, Boolean useLockForSingleTable, Boolean , Boolean , Boolean , Boolean , Boolean , Boolean , Boolean ) in Application.dbSynchronize.xpp:line 22

      at Dynamics.Ax.Application.Application.@Dbsynchronize(Int32 tableId, Boolean syncAsNeeded, Boolean continueOnError, Boolean showProgress, Object[] checkSyncTables, Boolean createAllIndexes, Boolean , Boolean , Boolean , Boolean , Boolean , Boolean )

      at Dynamics.Ax.Application.Application.@Dbsynchronize(Int32 tableId, Boolean syncAsNeeded, Boolean continueOnError, Boolean showProgress, Object[] checkSyncTables, Boolean , Boolean , Boolean , Boolean , Boolean )

      at Dynamics.Ax.Application.Application.@Dbsynchronize(Int32 tableId, Boolean syncAsNeeded, Boolean continueOnError, Boolean showProgress, Boolean , Boolean , Boolean , Boolean )

      at Dynamics.Ax.Application.Application.Dbsynchronize(Int32 tableId, Boolean syncAsNeeded, Boolean continueOnError, Boolean showProgress)

      at Dynamics.Ax.Application.ReleaseUpdateDB.indexAllowNoDup(DictIndex _dictIndex) in ReleaseUpdateDB.indexAllowNoDup.xpp:line 15

      at Dynamics.Ax.Application.ReleaseUpdateDB60_Vend.Allownodupvendpackingslippurchlinkjourid() in ReleaseUpdateDB60_Vend.allowNoDupVendPackingSlipPurchLinkJourId.xpp:line 10

      at ReleaseUpdateDB60_Vend::allowNoDupVendPackingSlipPurchLinkJourId(Object , Object[] )

      at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters)

  • Kevin Kidder Profile Picture
    Kevin Kidder Microsoft Employee on at

    Mostafa - sorry for not seeing your question on the previously answered thread. Your index error to me would indicate that there was a failure of some sort during the execution of the updateVendPackingSlipPurchLinCC method which assigns the vendPackingSlipJour RecID value to the vendPackingSlipPurchLink table. If that isn't enough to help you out, then can you please open a new thread or open a support request.

  • Mostafa Abu Taleb Profile Picture
    Mostafa Abu Taleb 1,880 on at

    Dear kevin :

    Thanks for replay ,but what did you mean about " failure of some sort during the execution"

  • Kevin Kidder Profile Picture
    Kevin Kidder Microsoft Employee on at

    Either that the script generated some error that you were unable to overcome so possibly the script was Disabled in the cockpit or that some other factor exists with your data so that the update recordset statement in the updateVendPackingSlipPurchLinCC method was not able to find a 1-1 join to the vendPackingSlipJour table to be able to update the value of the vendPackingSlipJour recID value in the vendPackingSlipPurchLink table.

  • Mostafa Abu Taleb Profile Picture
    Mostafa Abu Taleb 1,880 on at

    thanks kevin

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 24

#2
Michel ROY Profile Picture

Michel ROY 14

#3
Jagadabi Profile Picture

Jagadabi 6

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans