Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX2009 SP1 RU3 with MR...
Microsoft Dynamics AX (Archived)

AX2009 SP1 RU3 with MR2012 CU11 : I can't run all reports just 1 company : The source system provider was unable to complete the request (String or binary data would be truncated)

(0) ShareShare
ReportReport
Posted on by Tanyaboon 410

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.

2425.2018_2D00_10_2D00_30_5F00_16_2D00_45_2D00_16.png

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()

*This post is locked for comments

  • Tanyaboon Profile Picture
    Tanyaboon 410 on at
    RE: AX2009 SP1 RU3 with MR2012 CU11 : I can't run all reports just 1 company : The source system provider was unable to complete the request (String or binary data would be truncated)

    Thanks you very much Ludwig.

    This problem is about data on AX. I can solved it.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AX2009 SP1 RU3 with MR2012 CU11 : I can't run all reports just 1 company : The source system provider was unable to complete the request (String or binary data would be truncated)

    Hi,

    According to this list here:

    https://blogs.msdn.microsoft.com/dynamics_financial_reporting/2014/03/25/management-reporter-feature-and-version-number-summary/

    Your AX2009 version is not compatible with the MR CU11 version.

    Please try to upgrade at least the a AX 2009 RU8+ version.

    Best regards,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans