When trying to update a cloud hosted VM for FnO development to service update 10.0.31, it fails at step 25 with following message.
GlobalUpdate script for service model: AOSService on machine: xxxx
Error i found in runbook logs is:
02/10/2023 12:54:04: Infolog diagnostic message: 'Cannot execute the required database operation.
The SQL database has issued an error.' on category 'Error'.
02/10/2023 12:54:09: Infolog diagnostic message: 'Object Server Database Synchronizer: ' on category 'Error'.
02/10/2023 12:54:09: Infolog diagnostic message: '[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]An object or column name is missing or empty.
For SELECT INTO statements, verify each column has a name. For other statements, look for empty
alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.' on category 'Error'.
02/10/2023 12:54:09: Infolog diagnostic message: '
IF EXISTS
(SELECT 1
FROM sys.views v WITH (NOLOCK)
WHERE v.[name] = N''
)
BEGIN
DROP VIEW [];
END;
' on category 'Error'.
02/10/2023 12:54:09: Infolog diagnostic message: 'session 1041 (Admin)' on category 'Error'.
02/10/2023 12:54:24: Infolog diagnostic message: 'Cannot execute the required database operation.
The SQL database has issued an error.' on category 'Error'.
02/10/2023 12:54:24: Infolog diagnostic message: 'Object Server Database Synchronizer: ' on category 'Error'.
02/10/2023 12:54:24: Infolog diagnostic message: '[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]An object or column name is missing or empty.
For SELECT INTO statements, verify each column has a name. For other statements, look for empty
alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.' on category 'Error'.
02/10/2023 12:54:24: Infolog diagnostic message: '
IF EXISTS
(SELECT 1
FROM sys.views v WITH (NOLOCK)
WHERE v.[name] = N''
)
BEGIN
DROP VIEW [];
END;
' on category 'Error'.
02/10/2023 12:54:24: Infolog diagnostic message: 'session 1028 (Admin)' on category 'Error'.
02/10/2023 12:54:24: New SyssetupInstaller exception System.AggregateException: One or more errors occurred. ---> 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) in D:\dbs\sh\l23t\1215_211537\cmd\10\Source\Kernel\serveril\Server.Core\Server.Core\XppObjectBase.cs:line 268
at Dynamics.AX.Application.NativeStatementImplementation.executeUpdate(String _statement, String _loggableStatement) in D:\dbs\sh\l23t\1215_211537\cmd\l\Source\Kernel\xppil\XppSupport\XppKernelClasses\Impl\Native\NativeStatementImplementation.cs:line 69
at Dynamics.AX.Application.Statement.executeUpdateWithParameters(String statement, Map parameters) in D:\dbs\sh\l23t\1215_211537\cmd\l\Source\Kernel\xppil\XppSupport\XppKernelClasses\Statement.cs:line 230
at Dynamics.AX.Application.ApplicationSQLObjects.`executeSqlStatementWithParameters(String _sqlStatementText, Map _parameters)
at Dynamics.AX.Application.ApplicationSQLObjects.executeSqlStatementWithParameters(String _sqlStatementText, Map _parameters)
at Dynamics.AX.Application.ApplicationSQLObjects.`executeSqlStatement(String _sqlStatementText)
at Dynamics.AX.Application.ApplicationSQLObjects.executeSqlStatement(String _sqlStatementText)
at Dynamics.AX.Application.ApplicationSQLObjects.`dropView(String _viewName)
at Dynamics.AX.Application.ApplicationSQLObjects.dropView(String _viewName)
at Dynamics.AX.Application.MpsMultiSourcePolicyAssignmentVendorBalanceBuilder.`createViews()
at Dynamics.AX.Application.MpsMultiSourcePolicyAssignmentVendorBalanceBuilder.createViews()
at Dynamics.AX.Application.ApplicationSQLObjects.`createSqlObjects()
at Dynamics.AX.Application.ApplicationSQLObjects.createSqlObjects()
at Dynamics.AX.Application.MpsMultiSourcePolicyAssignmentVendorBalanceBuilder.buildView()
at Dynamics.AX.Application.MpsMultiSourcePolicyAssignmentVendorBalanceSetup.loadData()
at MpsMultiSourcePolicyAssignmentVendorBalanceSetup::loadData(Object , Object[] , Boolean& )
at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters) in D:\dbs\sh\l23t\1215_211537\cmd\l\Source\Kernel\xppil\XppSupport\ReflectionCallHelper.cs:line 1992
at Microsoft.Dynamics.AX.Framework.Syssetup.SysSetupTaskHelper.<>c__DisplayClass1_0.<ExecuteMethodInNewTask>b__0()
at System.Threading.Tasks.Task`1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of inner exception stack trace ---
Is there a way to fix this. Since this is a platform update, so i am not sure why should this come here?
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,836
Most Valuable Professional
nmaenpaa
101,156