Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / UAT refresh from prod ...
Finance | Project Operations, Human Resources, ...
Answered

UAT refresh from prod failed

(0) ShareShare
ReportReport
Posted on by vini_a 50

We trying  to refresh UAT DB with prod Db using database movement from LCS, but failed with following errors in log. any ideas please.

08/20/2021 22:24:24: Infolog diagnostic message: 'System Job should be scheduled to run within 7 day(s) of last execution time' on category 'Error'.
08/20/2021 22:24:24: Infolog diagnostic message: 'Recurrence validation failed' on category 'Error'.
08/20/2021 22:24:24: Infolog diagnostic message: 'Cannot edit a record in Batch job (BatchJob).
The corresponding AOS validation failed.' on category 'Error'.
08/20/2021 22:24:30: Application configuration sync failed. Microsoft.Dynamics.AX.Framework.Database.TableSyncException: Custom action threw exception(s), please investigate before synchronizing again: 'ErrorException:Cannot edit a record in Batch job (BatchJob).
The corresponding AOS validation failed.
at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue, interpret* ip)
at Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.update(IntPtr table)
at Microsoft.Dynamics.Ax.Xpp.Common.__Update_IntImpl__()
at Microsoft.Dynamics.Ax.Xpp.Common.Update()
at Dynamics.AX.Application.BatchJob.`update() in xppSource://Source/ApplicationPlatform\AxTable_BatchJob.xpp:line 339
at Dynamics.AX.Application.BatchJob.update()
at Dynamics.AX.Application.BatchHeader.`saveHeader(BatchStatus status, Boolean @status_IsDefaultSet) in xppSource://Source/ApplicationPlatform\AxClass_BatchHeader.xpp:line 588
at Dynamics.AX.Application.BatchHeader.saveHeader(BatchStatus status, Boolean @status_IsDefaultSet)
at Dynamics.AX.Application.BatchHeader.saveHeader(BatchStatus status)
at Dynamics.AX.Application.BatchHeader.`save(BatchStatus status, Boolean @status_IsDefaultSet) in xppSource://Source/ApplicationPlatform\AxClass_BatchHeader.xpp:line 481
at Dynamics.AX.Application.BatchHeader.save(BatchStatus status, Boolean @status_IsDefaultSet)
at Dynamics.AX.Application.BatchHeader.save(BatchStatus status)
at Dynamics.AX.Application.BatchHeader.`saveWithRetry(BatchStatus status, Boolean @status_IsDefaultSet) in xppSource://Source/ApplicationPlatform\AxClass_BatchHeader.xpp:line 536
at Dynamics.AX.Application.BatchHeader.saveWithRetry(BatchStatus status, Boolean @status_IsDefaultSet)
at Dynamics.AX.Application.BatchHeader.saveWithRetry()
at Dynamics.AX.Application.FeatureManagementMetadataDataPopulation.`populate() in xppSource://Source/ApplicationFoundation\AxClass_FeatureManagementMetadataDataPopulation.xpp:line 33
at Dynamics.AX.Application.FeatureManagementMetadataDataPopulation.populate()
at Dynamics.AX.Application.FeatureManagementSetup.`loadData() in xppSource://Source/ApplicationFoundation\AxClass_FeatureManagementSetup.xpp:line 55
at Dynamics.AX.Application.FeatureManagementSetup.loadData()
at Dynamics.AX.Application.SysSetupInstaller.`writeAllData() in xppSource://Source/ApplicationPlatform\AxClass_SysSetupInstaller.xpp:line 278
at Dynamics.AX.Application.SysSetupInstaller.writeAllData()
at Dynamics.AX.Application.SysSetupInstaller.`run() in xppSource://Source/ApplicationPlatform\AxClass_SysSetupInstaller.xpp:line 258
at Dynamics.AX.Application.SysSetupInstaller.run()
at Dynamics.AX.Application.SysSetupInstaller.`loadPartitionData(Object[] _c) in xppSource://Source/ApplicationPlatform\AxClass_SysSetupInstaller.xpp:line 365
at Dynamics.AX.Application.SysSetupInstaller.loadPartitionData(Object[] _c)
at Dynamics.AX.Application.SysSetupInstaller.`loadAllData(Boolean _allPartitions, Boolean @_allPartitions_IsDefaultSet) in xppSource://Source/ApplicationPlatform\AxClass_SysSetupInstaller.xpp:line 359
at Dynamics.AX.Application.SysSetupInstaller.loadAllData(Boolean _allPartitions, Boolean @_allPartitions_IsDefaultSet)
at Dynamics.AX.Application.SysSetupInstaller.loadAllData(Boolean _allPartitions)
at Dynamics.AX.Application.Application.`RaiseOnDbSynchronize(Int32 tableId, Boolean syncAsNeeded, Boolean continueOnError, Boolean showProgress, Object[] checkSyncTables, Boolean createAllIndexes, Boolean useLockForSingleTable, Boolean @tableId_IsDefaultSet, Boolean @syncAsNeeded_IsDefaultSet, Boolean @continueOnError_IsDefaultSet, Boolean @showProgress_IsDefaultSet, Boolean @checkSyncTables_IsDefaultSet, Boolean @createAllIndexes_IsDefaultSet, Boolean @useLockForSingleTable_IsDefaultSet) in xppSource://Source/ApplicationPlatform\AxClass_Application.xpp:line 433
at Dynamics.AX.Application.Application.RaiseOnDbSynchronize(Int32 tableId, Boolean syncAsNeeded, Boolean continueOnError, Boolean showProgress, Object[] checkSyncTables, Boolean createAllIndexes, Boolean useLockForSingleTable, Boolean @tableId_IsDefaultSet, Boolean @syncAsNeeded_IsDefaultSet, Boolean @continueOnError_IsDefaultSet, Boolean @showProgress_IsDefaultSet, Boolean @checkSyncTables_IsDefaultSet, Boolean @createAllIndexes_IsDefaultSet, Boolean @useLockForSingleTable_IsDefaultSet)
at Dynamics.AX.Application.Application.RaiseOnDbSynchronize(Int32 tableId, Boolean syncAsNeeded)
at Microsoft.Dynamics.AX.Deployment.Setup.AppOperations.RaiseOnDbsyncSyncApplEvent()
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c__DisplayClass34_0.<NOTE_LeavingSynchronizer_CallStackAboveThisLineIsCustomCode>b__0()
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.ExecuteWithinAOS(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Func`1 func, Action`1 errorHandler)' ---> Microsoft.Dynamics.Ax.Xpp.ErrorException: Cannot edit a record in Batch job (BatchJob).
The corresponding AOS validation failed.
at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue, interpret* ip)
at Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.update(IntPtr table)
at Microsoft.Dynamics.Ax.Xpp.Common.__Update_IntImpl__()
at Microsoft.Dynamics.Ax.Xpp.Common.Update()
at Dynamics.AX.Application.BatchJob.`update() in xppSource://Source/ApplicationPlatform\AxTable_BatchJob.xpp:line 339
at Dynamics.AX.Application.BatchJob.update()
at Dynamics.AX.Application.BatchHeader.`saveHeader(BatchStatus status, Boolean @status_IsDefaultSet) in xppSource://Source/ApplicationPlatform\AxClass_BatchHeader.xpp:line 588
at Dynamics.AX.Application.BatchHeader.saveHeader(BatchStatus status, Boolean @status_IsDefaultSet)
at Dynamics.AX.Application.BatchHeader.saveHeader(BatchStatus status)
at Dynamics.AX.Application.BatchHeader.`save(BatchStatus status, Boolean @status_IsDefaultSet) in xppSource://Source/ApplicationPlatform\AxClass_BatchHeader.xpp:line 481
at Dynamics.AX.Application.BatchHeader.save(BatchStatus status, Boolean @status_IsDefaultSet)
at Dynamics.AX.Application.BatchHeader.save(BatchStatus status)
at Dynamics.AX.Application.BatchHeader.`saveWithRetry(BatchStatus status, Boolean @status_IsDefaultSet) in xppSource://Source/ApplicationPlatform\AxClass_BatchHeader.xpp:line 536
at Dynamics.AX.Application.BatchHeader.saveWithRetry(BatchStatus status, Boolean @status_IsDefaultSet)
at Dynamics.AX.Application.BatchHeader.saveWithRetry()
at Dynamics.AX.Application.FeatureManagementMetadataDataPopulation.`populate() in xppSource://Source/ApplicationFoundation\AxClass_FeatureManagementMetadataDataPopulation.xpp:line 33
at Dynamics.AX.Application.FeatureManagementMetadataDataPopulation.populate()
at Dynamics.AX.Application.FeatureManagementSetup.`loadData() in xppSource://Source/ApplicationFoundation\AxClass_FeatureManagementSetup.xpp:line 55
at Dynamics.AX.Application.FeatureManagementSetup.loadData()
at Dynamics.AX.Application.SysSetupInstaller.`writeAllData() in xppSource://Source/ApplicationPlatform\AxClass_SysSetupInstaller.xpp:line 278
at Dynamics.AX.Application.SysSetupInstaller.writeAllData()
at Dynamics.AX.Application.SysSetupInstaller.`run() in xppSource://Source/ApplicationPlatform\AxClass_SysSetupInstaller.xpp:line 258
at Dynamics.AX.Application.SysSetupInstaller.run()
at Dynamics.AX.Application.SysSetupInstaller.`loadPartitionData(Object[] _c) in xppSource://Source/ApplicationPlatform\AxClass_SysSetupInstaller.xpp:line 365
at Dynamics.AX.Application.SysSetupInstaller.loadPartitionData(Object[] _c)
at Dynamics.AX.Application.SysSetupInstaller.`loadAllData(Boolean _allPartitions, Boolean @_allPartitions_IsDefaultSet) in xppSource://Source/ApplicationPlatform\AxClass_SysSetupInstaller.xpp:line 359
at Dynamics.AX.Application.SysSetupInstaller.loadAllData(Boolean _allPartitions, Boolean @_allPartitions_IsDefaultSet)
at Dynamics.AX.Application.SysSetupInstaller.loadAllData(Boolean _allPartitions)
at Dynamics.AX.Application.Application.`RaiseOnDbSynchronize(Int32 tableId, Boolean syncAsNeeded, Boolean continueOnError, Boolean showProgress, Object[] checkSyncTables, Boolean createAllIndexes, Boolean useLockForSingleTable, Boolean @tableId_IsDefaultSet, Boolean @syncAsNeeded_IsDefaultSet, Boolean @continueOnError_IsDefaultSet, Boolean @showProgress_IsDefaultSet, Boolean @checkSyncTables_IsDefaultSet, Boolean @createAllIndexes_IsDefaultSet, Boolean @useLockForSingleTable_IsDefaultSet) in xppSource://Source/ApplicationPlatform\AxClass_Application.xpp:line 433
at Dynamics.AX.Application.Application.RaiseOnDbSynchronize(Int32 tableId, Boolean syncAsNeeded, Boolean continueOnError, Boolean showProgress, Object[] checkSyncTables, Boolean createAllIndexes, Boolean useLockForSingleTable, Boolean @tableId_IsDefaultSet, Boolean @syncAsNeeded_IsDefaultSet, Boolean @continueOnError_IsDefaultSet, Boolean @showProgress_IsDefaultSet, Boolean @checkSyncTables_IsDefaultSet, Boolean @createAllIndexes_IsDefaultSet, Boolean @useLockForSingleTable_IsDefaultSet)
at Dynamics.AX.Application.Application.RaiseOnDbSynchronize(Int32 tableId, Boolean syncAsNeeded)
at Microsoft.Dynamics.AX.Deployment.Setup.AppOperations.RaiseOnDbsyncSyncApplEvent()
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c__DisplayClass34_0.<NOTE_LeavingSynchronizer_CallStackAboveThisLineIsCustomCode>b__0()
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.ExecuteWithinAOS(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Func`1 func, Action`1 errorHandler)
--- End of inner exception stack trace ---
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c.<NOTE_LeavingSynchronizer_CallStackAboveThisLineIsCustomCode>b__34_1(Tuple`2 result)
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.ExecuteWithinAOS(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Func`1 func, Action`1 errorHandler)
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.NOTE_LeavingSynchronizer_CallStackAboveThisLineIsCustomCode(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Action`1 a)
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.RunCustomAction(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Action`1 a)
at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.PostTableSync()
at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullSync()
at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.RunSync()
at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.Run(String metadataDirectory, String sqlConnectionString, SyncOptions options)
08/20/2021 22:24:30: The operation failed.

 

  • Lawrence500 Profile Picture
    Lawrence500 on at
    RE: UAT refresh from prod failed

    Thanks Vini, I also raised a ticket. The below steps were followed to resolve it

    Request JIT access to your test database and run the below steps.


    Step 1 : Select * from classidtable where name = 'SysFeatureTranslationPopulationBatch' 
    Step 2 : Get the ID, and  Run --> Select batchjobid from batch where classnumber = <<ID>>
    Step 3 : Get the batchjobid,  and Run --> Select * from BATCHJOB where RECID = << batchjobid >>
    Step 4: Update Batchjob set enddatetime=getdate()-1 where recid=<<recid>>

  • Verified answer
    vini_a Profile Picture
    vini_a 50 on at
    RE: UAT refresh from prod failed

    We raised ticket with Microsoft and they need to run some queries on their end. that worked for us.

    Thanks

  • Lawrence500 Profile Picture
    Lawrence500 on at
    RE: UAT refresh from prod failed

    Hi Vini,

    Have you been able to resolve this? If yes kindly share the solution, I am also experiencing this.

    Thanks

  • WillWU Profile Picture
    WillWU 22,352 on at
    RE: UAT refresh from prod failed

    Hi vini_a,

    Suggest you to raise a ticket to Microsoft.

    Have a nice day.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,661 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,379 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans