I am having an issue during step 8, Final DB Sync for data upgrade for D365 F&O.
From Version: AX 2012 R2 CU8. Upgrade hotfix was applied prior to data upgrade.
To version: 10.0.8.
I am working in a local DEV VM.
Before the data upgrade, I had a successful build and data sync against the demo database.
I have validated the data upgrade package and the software version are the same.
Checked the ID's for the views in the SQLDictionary table against the SysTableIdView table. Both match.
The two objects below have not been modified or extended.
Error:
04/14/2020 11:24:20: Infolog diagnostic message: 'Specified datasource CustCollectionsBICreditView of View CustCollectionsBICredit is a temp table.' on category 'Error'.
04/14/2020 11:24:20: Unexpected error occurred while execute computed column method: creditRemaining on view/ data entity CustCollectionsBICredit
Microsoft.Dynamics.Ax.Xpp.ErrorException: Specified datasource CustCollectionsBICreditView of View CustCollectionsBICredit is a temp table.
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.DictView.computedColumnString(String text1, String text2, FieldNameGenerationMode mode1)
at Dynamics.AX.Application.SysComputedColumn.`returnField(String _viewName, String _dataSourceName, String _fieldName) in xppSource://Source/ApplicationFoundation\AxClass_SysComputedColumn.xpp:line 833
at Dynamics.AX.Application.SysComputedColumn.returnField(String _viewName, String _dataSourceName, String _fieldName)
at Dynamics.AX.Application.CustCollectionsBICredit.`creditRemaining() in xppSource://Source/Foundation\AxDataEntityView_CustCollectionsBICredit.xpp:line 11
at Dynamics.AX.Application.CustCollectionsBICredit.creditRemaining() at CustCollectionsBICredit::creditRemaining(Object[] , Boolean& )
at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)
at Microsoft.Dynamics.AX.DataAccess.StatementGenerator.UnboundField.get_ComputedValue()
The step failed
Any ideas on what to try next?
Best Regards,
Mark
