Dynamics Community Forum Thread Details

Hi All,

our production new deployment database synchronization is failing with the below error, AXService is still in build state more than 24 hours with the below error on database synchronization event viewer on AOS server

DBSYNCHFailureMessage Infolog diagnostic message: 'The number sequence for party records is not set.' on category 'Error'.

any idea how to fix the synch issue, am using empty database. on UAT it didn't give any error.

01/30/2020 08:45:54: Managed Data Sync Entity Worker encountered an exception, but is continuing because ContinueOnError is true. View Name and ID: 'SysDataSharingNumberSequenceRef(11021)' Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'NUMBERSEQUENCEDATATYPE'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.SqlCommandExtensions.<>c__DisplayClass1.<ExecuteNonQueryWithRetry>b__0()
at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.<ExecuteNonQuery>b__30_0(SqlCommand c)
at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.ExecuteSql[T](SqlCommand cmd, Func`2 sqlFunc)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.HandleException(ExceptionDispatchInfo edi, SqlExecutionInfo execInfo)
at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.ExecuteSql[T](SqlCommand cmd, Func`2 sqlFunc)
at Microsoft.Dynamics.AX.Data.Management.DBExecute.RefreshView(String viewName)
at Microsoft.Dynamics.AX.Data.Management.DataEntity.ManagedSyncDataEntityWorker.SyncAllAction[T](ViewSyncGraphNode viewToSync, Dictionary`2 oldViewDefinitions, StringCollection dataEntityViewList, StringCollection compositeEntityViewList)
at Microsoft.Dynamics.AX.Data.Management.DataEntity.ManagedSyncDataEntityWorker.RetrySyncAllForFailedViews[T](IEnumerable`1 viewsToResync, Dictionary`2 oldViewDefinitions, List`1 exceptions, StringCollection dataEntityViewList, StringCollection compositeEntityViewList, Boolean shouldRetryAgain)
ClientConnectionId:2277fed9-9c0e-43a8-a114-9bec27600822
Error Number:208,State:1,Class:16

Thank you,

Hi Mohammad,

Try to run a manual sync using the sample syntax below (you'll need to change the path, servers, user ids, db name and password as needed. Also ensure you have the folder C:\Temp for the log):

SET SFAOSPATH=C:\ProgramData\SF\AOS1\Fabric\work\Applications\AXSFType_App38\AXSF.Code.1.0.20181102150341

%SFAOSPATH%\bin\Microsoft.dynamics.ax.deployment.setup.exe --metadatadir %SFAOSPATH%\Packages --bindir %SFAOSPATH%\Packages --sqlserver <servername> --sqldatabase <dbname> --sqluser <userid_axdbadmin> --sqlpwd <password> --setupmode sync --syncmode fullall --isazuresql false --verbose true > "c:\temp\outputSyncLog.txt"

If the sync is already running on the AOS node, then run this command on one of the other AOS nodes. Also, for the sync to complete, you do need around 8GB of RAM on the AOS node servers.

Thanks, Tom