Hi All,
while deploying packages from LCS it keeps failing with the below error message. Has anyone come across this issue. Sync engine works fine while I try to do sync manually from the server using VS database Sync or using Command line.
FYI, Deployable packages from Microsoft also gives same error.
09/24/2018 07:42:46: Infolog diagnostic message: 'Cannot execute the required database operation.
The SQL database has issued an error.' on category 'Error'.
09/24/2018 07:42:46: Infolog diagnostic message: 'Object Server Database Synchronizer: ' on category 'Error'.
The process cannot access the file 'C:\DynamicsAX\RunbookExecution-ExecuteParallelRunbook-c4943f70-0a7a-4387-b029-7368883124b3_I0_R0\output\Step10\dbsync.log' because it is being used by another process.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.StreamWriter.CreateFile(String path, Boolean append, Boolean checkHost)
at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize, Boolean checkHost)
at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding)
at System.IO.File.InternalAppendAllText(String path, String contents, Encoding encoding)
at Microsoft.Dynamics.AX.Deployment.Setup.Log.FlushLog()
at Microsoft.Dynamics.AX.Deployment.Setup.Log.<>c__DisplayClass12_0.<LogImpl>b__0(Object x)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
at System.Threading.ThreadPoolWorkQueue.Dispatch()
***** Updating post after reviewing logs **********
09/24/2018 15:52:14: Beginning sync step: Raise database synchronization application event.
09/24/2018 15:52:15: Infolog diagnostic message: 'Cannot execute the required database operation.
The SQL database has issued an error.' on category 'Error'.
09/24/2018 15:52:15: Infolog diagnostic message: 'Object Server Database Synchronizer: ' on category 'Error'.
09/24/2018 15:52:15: Infolog diagnostic message: 'session 1015 (Admin)' on category 'Error'.
09/24/2018 15:52:15: Infolog diagnostic message: 'CREATE VIEW INVENTSITEONHANDAGGREGATEDVIEW AS SELECT INVENTSITEONHANDVIEW.ITEMNUMBER AS ITEMNUMBER, INVENTSITEONHANDVIEW.PRODUCTNAME AS PRODUCTNAME, INVENTSITEONHANDVIEW. AS , INVENTSITEONHANDVIEW.INVENTORYSITEID AS INVENTORYSITEID, INVENTSITEONHANDVIEW.ONHANDQUANTITY AS ONHANDQUANTITY, INVENTSITEONHANDVIEW.RESERVEDONHANDQUANTITY AS RESERVEDONHANDQUANTITYMAPPED, INVENTSITEONHANDVIEW.AVAILABLEONHANDQUANTITY AS AVAILABLEONHANDQUANTITYMAPPED, INVENTSITEONHANDVIEW.ORDEREDQUANTITY AS ORDEREDQUANTITYMAPPED, INVENTSITEONHANDVIEW.RESERVEDORDEREDQUANTITY AS RESERVEDORDEREDQUANTITYMAPPED, INVENTSITEONHANDVIEW.AVAILABLEORDEREDQUANTITY AS AVAILABLEORDEREDQUANTITYMAPPED, INVENTSITEONHANDVIEW.ONORDERQUANTITY AS ONORDERQUANTITY, INVENTSITEONHANDVIEW.TOTALAVAILABLEQUANTITY AS TOTALAVAILABLEQUANTITY, INVENTSITEONHANDVIEW.AREWAREHOUSEMANAGEMENTPROCESSESUSED AS AREWAREHOUSEMANAGEMENTPROCESSESUSED, CALCULATIONS.RESERVEDONHANDQUANTITY AS RESERVEDONHANDQUANTITY, (INVENTSITEONHANDVIEW.ONHANDQUANTITY - CALCULATIONS.RESERVEDONHANDQUANTITY) AS AVAILABLEONHANDQUANTITY, CALCULATIONS.ORDEREDQUANTITY AS ORDEREDQUANTITY, CALCULATIONS.RESERVEDORDEREDQUANTITY AS RESERVEDORDEREDQUANTITY, (CALCULATIONS.ORDEREDQUANTITY - CALCULATIONS.RESERVEDORDEREDQUANTITY) AS AVAILABLEORDEREDQUANTITY, INVENTSITEONHANDVIEW.RECID AS RECID, INVENTSITEONHANDVIEW.DATAAREAID AS DATAAREAID, INVENTSITEONHANDVIEW.PARTITION AS PARTITION FROM INVENTSITEONHANDVIEW CROSS APPLY ( SELECT COALESCE(SUM(WHSINVENTRESERVE.RESERVPHYSICAL), 0) AS RESERVPHYSICAL, COALESCE(SUM(WHSINVENTRESERVE.RESERVORDERED), 0) AS RESERVORDERED, COALESCE(SUM(WHSINVENTRESERVE.AVAILORDERED), 0) AS AVAILORDERED, COALESCE(SUM(WHSINVENTRESERVE.AVAILPHYSICAL), 0) AS AVAILPHYSICAL FROM WHSINVENTRESERVE WHERE WHSINVENTRESERVE.ITEMID = INVENTSITEONHANDVIEW.ITEMNUMBER AND WHSINVENTRESERVE.PARTITION = INVENTSITEONHANDVIEW.PARTITION AND WHSINVENTRESERVE.DATAAREAID = INVENTSITEONHANDVIEW.DATAAREAID AND EXISTS ( SELECT TOP 1 INVENTDIM.INVENTDIMID FROM INVENTDIM WHERE INVENTDIM.DATAAREAID = WHSINVENTRESERVE.DATAAREAID AND INVENTDIM.INVENTDIMID = WHSINVENTRESERVE.INVENTDIMID AND INVENTDIM.PARTITION = WHSINVENTRESERVE.PARTITION AND (INVENTDIM. = INVENTSITEONHANDVIEW. OR INVENTSITEONHANDVIEW. = '') AND (INVENTDIM.INVENTSITEID = INVENTSITEONHANDVIEW.INVENTORYSITEID OR INVENTSITEONHANDVIEW.INVENTORYSITEID = '') AND WHSINVENTRESERVE.HIERARCHYLEVEL = ( SELECT MAX(WHSRESERVATIONHIERARCHYELEMENT.RESERVATIONHIERARCHYLEVEL) FROM WHSRESERVATIONHIERARCHYELEMENT JOIN WHSRESERVATIONHIERARCHYITEM ON WHSRESERVATIONHIERARCHYITEM.ITEMDATAAREAID = INVENTSITEONHANDVIEW.DATAAREAID AND WHSRESERVATIONHIERARCHYELEMENT.PARTITION = INVENTSITEONHANDVIEW.PARTITION AND WHSRESERVATIONHIERARCHYELEMENT.RESERVATIONHIERARCHY = WHSRESERVATIONHIERARCHYITEM.RESERVATIONHIERARCHY AND WHSRESERVATIONHIERARCHYITEM.ITEMID = INVENTSITEONHANDVIEW.ITEMNUMBER WHERE (WHSRESERVATIONHIERARCHYELEMENT.DIMENSIONFIELDID = 20 AND INVENTSITEONHANDVIEW.INVENTORYSITEID != '')))) INVENTRESERVES CROSS APPLY ( SELECT (CASE WHEN INVENTSITEONHANDVIEW.AREWAREHOUSEMANAGEMENTPROCESSESUSED = 1 THEN INVENTRESERVES.AVAILORDERED + INVENTRESERVES.RESERVORDERED - INVENTRESERVES.AVAILPHYSICAL ELSE INVENTSITEONHANDVIEW.ORDEREDQUANTITY END) AS ORDEREDQUANTITY, (CASE WHEN INVENTSITEONHANDVIEW.AREWAREHOUSEMANAGEMENTPROCESSESUSED = 1 THEN INVENTRESERVES.RESERVORDERED ELSE INVENTSITEONHANDVIEW.RESERVEDORDEREDQUANTITY END) AS RESERVEDORDEREDQUANTITY, (CASE WHEN INVENTSITEONHANDVIEW.AREWAREHOUSEMANAGEMENTPROCESSESUSED = 1 THEN INVENTRESERVES.RESERVPHYSICAL ELSE INVENTSITEONHANDVIEW.RESERVEDONHANDQUANTITY END) AS RESERVEDONHANDQUANTITY) CALCULATIONS' on category 'Error'.
09/24/2018 15:52:15: Infolog diagnostic message: '[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'AS'.' on category 'Error'.
09/24/2018 15:52:17: 2018-09-24T15:52:17.3835623+00:00 post-sync custom action: '<RunFullSync>b__15_9' finished. Time elapsed: 00:03:070.
09/24/2018 15:52:17: 2018-09-24T15:52:17.3835623+00:00 PostTableViewSyncActions finished. Time elapsed: 00:25:643.
09/24/2018 15:52:17: Application configuration sync failed. Microsoft.Dynamics.AX.Framework.Database.TableSyncException: Custom action sync failed with error: 'ErrorException:Cannot execute the required database operation.
The SQL database has issued an error.
at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue, 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.XppObjectBase.Call(String methodName, Object[] parameters, Type[] types, Object[] varargs)
at Dynamics.AX.Application.NativeStatementImplementation.executeUpdate(String _statement)
at Dynamics.AX.Application.Statement.executeUpdate(String _statement)
at Dynamics.AX.Application.ApplicationSQLObjects.`executeSqlStatement(String _sqlStatementText) in xppSource://Source/ApplicationFoundation\AxClass_ApplicationSQLObjects.xpp:line 182
at Dynamics.AX.Application.ApplicationSQLObjects.ApplicationSQLObjectsCoCHelper.`executeSqlStatement(ApplicationSQLObjects instance, String arg0)
at Dynamics.AX.Application.ApplicationSQLObjects.executeSqlStatement(String _sqlStatementText)
at Dynamics.AX.Application.InventOnHandAggregatedViewBuilder.`createViews() in xppSource://Source/Foundation\AxClass_InventOnHandAggregatedViewBuilder.xpp:line 48
at Dynamics.AX.Application.InventOnHandAggregatedViewBuilder.InventOnHandAggregatedViewBuilderCoCHelper.`createViews(InventOnHandAggregatedViewBuilder instance)
at Dynamics.AX.Application.InventOnHandAggregatedViewBuilder.createViews()
at Dynamics.AX.Application.ApplicationSQLObjects.`createSqlObjects() in xppSource://Source/ApplicationFoundation\AxClass_ApplicationSQLObjects.xpp:line 368
at Dynamics.AX.Application.ApplicationSQLObjects.ApplicationSQLObjectsCoCHelper.`createSqlObjects(ApplicationSQLObjects instance)
at Dynamics.AX.Application.ApplicationSQLObjects.createSqlObjects()
at Dynamics.AX.Application.InventSiteOnHandAggregatedViewBuilder.`dbSynchronize(Int32 _tableId, Boolean _syncAsNeeded, Boolean _continueOnError, Boolean _showProgress, Object[] _checkSyncTables, Boolean _createAllIndexes, Boolean _useLockForSingleTable) in xppSource://Source/Foundation\AxClass_InventSiteOnHandAggregatedViewBuilder.xpp:line 32
at Dynamics.AX.Application.InventSiteOnHandAggregatedViewBuilder.InventSiteOnHandAggregatedViewBuilderCoCHelper.`dbSynchronize(InventSiteOnHandAggregatedViewBuilder instance, Int32 arg0, Boolean arg1, Boolean arg2, Boolean arg3, Object[] arg4, Boolean arg5, Boolean arg6)
at Dynamics.AX.Application.InventSiteOnHandAggregatedViewBuilder.dbSynchronize(Int32 _tableId, Boolean _syncAsNeeded, Boolean _continueOnError, Boolean _showProgress, Object[] _checkSyncTables, Boolean _createAllIndexes, Boolean _useLockForSingleTable)
at Dynamics.AX.Application.Application.onDbSynchronizeType.Invoke(Int32 , Boolean , Boolean , Boolean , Object[] , Boolean , Boolean )
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 379
at Dynamics.AX.Application.Application.ApplicationCoCHelper.`RaiseOnDbSynchronize(Application instance, Int32 arg0, Boolean arg1, Boolean arg2, Boolean arg3, Object[] arg4, Boolean arg5, Boolean arg6, Boolean , Boolean , Boolean , Boolean , Boolean , Boolean , Boolean )
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__DisplayClass28_0.<RunCustomAction>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 execute the required database operation.
The SQL database has issued an error.
at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue, 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.XppObjectBase.Call(String methodName, Object[] parameters, Type[] types, Object[] varargs)
at Dynamics.AX.Application.NativeStatementImplementation.executeUpdate(String _statement)
at Dynamics.AX.Application.Statement.executeUpdate(String _statement)
at Dynamics.AX.Application.ApplicationSQLObjects.`executeSqlStatement(String _sqlStatementText) in xppSource://Source/ApplicationFoundation\AxClass_ApplicationSQLObjects.xpp:line 182
at Dynamics.AX.Application.ApplicationSQLObjects.ApplicationSQLObjectsCoCHelper.`executeSqlStatement(ApplicationSQLObjects instance, String arg0)
at Dynamics.AX.Application.ApplicationSQLObjects.executeSqlStatement(String _sqlStatementText)
at Dynamics.AX.Application.InventOnHandAggregatedViewBuilder.`createViews() in xppSource://Source/Foundation\AxClass_InventOnHandAggregatedViewBuilder.xpp:line 48
at Dynamics.AX.Application.InventOnHandAggregatedViewBuilder.InventOnHandAggregatedViewBuilderCoCHelper.`createViews(InventOnHandAggregatedViewBuilder instance)
at Dynamics.AX.Application.InventOnHandAggregatedViewBuilder.createViews()
at Dynamics.AX.Application.ApplicationSQLObjects.`createSqlObjects() in xppSource://Source/ApplicationFoundation\AxClass_ApplicationSQLObjects.xpp:line 368
at Dynamics.AX.Application.ApplicationSQLObjects.ApplicationSQLObjectsCoCHelper.`createSqlObjects(ApplicationSQLObjects instance)
at Dynamics.AX.Application.ApplicationSQLObjects.createSqlObjects()
at Dynamics.AX.Application.InventSiteOnHandAggregatedViewBuilder.`dbSynchronize(Int32 _tableId, Boolean _syncAsNeeded, Boolean _continueOnError, Boolean _showProgress, Object[] _checkSyncTables, Boolean _createAllIndexes, Boolean _useLockForSingleTable) in xppSource://Source/Foundation\AxClass_InventSiteOnHandAggregatedViewBuilder.xpp:line 32
at Dynamics.AX.Application.InventSiteOnHandAggregatedViewBuilder.InventSiteOnHandAggregatedViewBuilderCoCHelper.`dbSynchronize(InventSiteOnHandAggregatedViewBuilder instance, Int32 arg0, Boolean arg1, Boolean arg2, Boolean arg3, Object[] arg4, Boolean arg5, Boolean arg6)
at Dynamics.AX.Application.InventSiteOnHandAggregatedViewBuilder.dbSynchronize(Int32 _tableId, Boolean _syncAsNeeded, Boolean _continueOnError, Boolean _showProgress, Object[] _checkSyncTables, Boolean _createAllIndexes, Boolean _useLockForSingleTable)
at Dynamics.AX.Application.Application.onDbSynchronizeType.Invoke(Int32 , Boolean , Boolean , Boolean , Object[] , Boolean , Boolean )
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 379
at Dynamics.AX.Application.Application.ApplicationCoCHelper.`RaiseOnDbSynchronize(Application instance, Int32 arg0, Boolean arg1, Boolean arg2, Boolean arg3, Object[] arg4, Boolean arg5, Boolean arg6, Boolean , Boolean , Boolean , Boolean , Boolean , Boolean , Boolean )
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__DisplayClass28_0.<RunCustomAction>b__0()
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.ExecuteWithinAOS(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Func`1 func, Action`1 errorHandler)
Thanks,
Manish