I can't run report just 1 company that is new company on AX2009. I try to run on MR2.0 (Old version) but is failed. The new version CU16 still failed too. Maybe this about a dimension.
I run AX2009 SP1 RU3 with MR2012 CU11. Error log as below.
I think this is a actually problem : String or binary data would be truncated
Microsoft.Dynamics.Performance.DataProvider.Core.RequestException: The source system request did not complete successfully. ---> Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.AX.Common.DataAccessException: SQL error occurred. ---> System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.AX.Data.ChartRequestDataAccess.InsertIntoChartValuesTable(DataConnector dataConnector, SqlConnection sqlConnection, ChartElementCollection chartCollection, ParametrizedQuery accountTableQuery, String tableName, String entityDatabase)
--- End of inner exception stack trace ---
at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.AX.Data.ChartRequestDataAccess.InsertIntoChartValuesTable(DataConnector dataConnector, SqlConnection sqlConnection, ChartElementCollection chartCollection, ParametrizedQuery accountTableQuery, String tableName, String entityDatabase)
at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.AX.GLProvider.PopulateBalanceRowTable(DataConnector dataConnector, SqlConnection sqlConnection, BalanceRowCollection balanceRows, String balanceRowTableName)
at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.AX.GLProvider.HandleBalanceRequest(GLBalanceRequest request)
at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLSystemProvider.HandleRequest(GLBalanceRequest request)
at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemRequest.Handle[TRequest](SourceSystemProvider provider, TRequest request)
at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.SubmitRequest(SourceSystemRequest request)
--- End of inner exception stack trace ---
at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.SubmitRequest(SourceSystemRequest request)
at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.HandleSubmit(SourceSystemRequest request)
at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemConnection.Submit(SourceSystemRequest request)
at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService.SubmitRequestDirect(SourceSystemConnection connection, GLRequest request)
at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ProviderLink.SubmitRequest(GLRequest request, ProviderConnection context)
at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ProviderLink.SubmitBalanceRequest(ProviderConnection context, GLBalanceRequest balanceRequest)
at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLLinkAdapter.RetrieveGLDataBatch(Int32 rowNumber)
at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLLinkAdapter.GetData()
