web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Management Reporter CU...
Microsoft Dynamics AX (Archived)

Management Reporter CU 10 integrated with Dynamics AX 2012 R2 CU7

(0) ShareShare
ReportReport
Posted on by E. R. 739

Dear Experts,

Please note that i am facing an error in the MR console Services which is:

One or more errors occurred.  --- Exception Dump ---  Caught Exception: [Microsoft.Dynamics.Integration.Service.Tasks.RecordException] One or more errors occurred.  Stack trace:

 Inner Exception: [System.AggregateException] One or more errors occurred.  

Stack trace:    at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)    at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)    at Microsoft.Dynamics.Performance.DDM.BulkLoader`1.SubmitChanges()    at Microsoft.Dynamics.Performance.DDM.BulkLoader`1.Save(Boolean forceWrite)    at Microsoft.Dynamics.Performance.DDM.BulkLoader`1.TrackItem(T item, Task taskToWaitFor)    at Microsoft.Dynamics.Integration.Service.Tasks.RecordWork.DoRecordWork(DbMap map, Object key, OperationType operationType, String loggingSourceName)

 Inner Exception: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.  

Stack trace:    at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value)    at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime value)    at System.Data.SqlClient.MetaType.FromDateTime(DateTime dateTime, Byte cb)    at System.Data.SqlClient.TdsParser.WriteUnterminatedValue(Object value, MetaType type, Byte scale, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj, Int32 paramSize, Boolean isDataFeed)    at System.Data.SqlClient.TdsParser.WriteBulkCopyValue(Object value, SqlMetaDataPriv metadata, TdsParserStateObject stateObj, Boolean isSqlType, Boolean isDataFeed, Boolean isNull)    at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col)    at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source)    at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source)    at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)    at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)    at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)    at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)    at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)    at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)    at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)    at Microsoft.Dynamics.Performance.DDM.FactLoader.InsertFacts()    at Microsoft.Dynamics.Performance.DDM.BulkLoader`1.<SubmitChanges>b__1()    at System.Threading.Tasks.Task.Execute()

N.b: the MR is fully integrated

Please advise how can i fix the above error.

Regards,

Elie

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Elie,

    When did you experience this error message?

    What has been done before it was triggered?

    Best regards,

    Ludwig

  • E. R. Profile Picture
    E. R. 739 on at

    Hi Ludwig,

    I have no idea, it is a running environment and suddenly i found this error in the MR Console Services.

    last week the following error was appearing:

    You don't have permission to perform this operation.

                   --- Exception Dump ---

                   Caught Exception: [System.ServiceModel.FaultException`1[Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceFault]] You don't have permission to perform this operation.

                   Stack trace:

      at Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceBase.HandleException(Exception exceptionToHandle, ReportingException exceptionToThrow, Boolean logError)

      at Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceBase.BaseExecute[TResult](Func`1 executor)

      at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecurityService.RetrieveUsersBySource(String sourceName, String sourceDiscriminator)

      at Microsoft.Dynamics.Performance.Integration.Reporting.Adapter.CompanyProvider.DeleteUsers(HashSet`1 integratedUsers)

      at Microsoft.Dynamics.Performance.Integration.Reporting.Adapter.CompanyProvider.Finish()

      at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.CommitBulkWriter()

      at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.GetTaskExecutionResult(Task`1 processRecordsTask)

      at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.Run()

      at Microsoft.Dynamics.Integration.Service.Tasks.MapTask.Run()

    your suggestion are highly appreciated,

    Regards,

    Elie

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Elie,

    Do you have the security admin role assigned? The second message indicates that you might not have sufficient user rights.

    In regards to the first message:

    Have you tried restarting all your services and checked whether the error message disappears?

    Have you actually identified some inconsistencies / Errors in MR if you compare those data with the ones psoted in GL?

    Best regards,

    Ludwig

  • E. R. Profile Picture
    E. R. 739 on at

    Hi Ludwig,

    thank you for your continuous support,

    Yeah you're right, after restarting the service the first error disappear but the second NO taking into consideration that the user has a system administrator, security administrator, accounting manager and supervisor roles.

    how can we solve the second error?

    Regards,

    Elie

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Elie,

    I think the only chance to get rid of this error is by upgrading to a newer MR version.

    I found a very similar issue on LCS where MS recommends to upgrade to the next MR version and it looks as if you issue is similar / related. For details, please see:

    fix.lcs.dynamics.com/.../ResolvedDynamics;qc=807ecfc3f014055e6a497f1e26b2105ce17adc85eb541c8d5f707e2da132bf34

    Best regards,

    Ludwig

  • E. R. Profile Picture
    E. R. 739 on at

    Thank you Ludwig. i will install CU13.

    if i installed it using the same databases is it possible? or i need to install it alone than i will import reports from the old databases?

    Regards,

    Elie

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Elie,

    I would create a new data mart. The existing reports can be exported and imported through the building block functionality.

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans