Hi all..
MR CU 16. Ever 5 minutes the event viewer reports the error "There is already an object named 'PK_ChangeTablee' in the database." This is preventing a DM rebuild from completing.
If there are no errors in the data mart integration log, that's a good sign. It means your integration is running correctly and data is integrating into the data mart. The error above looks like it is something with the Exchange Rates. But if they were failing, I would expect to see something in the data mart integration log -- for the ExchangeRateProvider to Exchange Rate task. But if that task completed successfully, I don't know that we have a problem with it. I would expect to see that the task had failed, with an error like this in the Event Viewer. If you check the integration log again, are there errors for the ExchangeRateProvider to Exchange Rate task?
I'm still not sure that the ChangeTable error is related to MR. Is there something with that error that indicates it is related to MR?
Thank you Greg.
There is no error in Data Mart Integration Log.
This error i see in Service Log and doesn't say what database.
There is another error that maybe you can relate
"The conversión of the varchar data type into datetime produced a value outside the range"
Component: Microsoft.Dynamics.Integration.Common.TraceLog
In Even Viewer
- <Event xmlns="">schemas.microsoft.com/.../event">
- <System>
<Provider Name="Microsoft-Dynamics-MR-Logger" Guid="{8D043B9F-5686-4786-B92C-35DA15DE02A4}" />
<EventID>6</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>5</Task>
<Opcode>0</Opcode>
<Keywords>0x4000000000000006</Keywords>
<TimeCreated SystemTime="2020-02-24T17:40:01.578229500Z" />
<EventRecordID>2034</EventRecordID>
<Correlation ActivityID="{1BCE09EE-81DD-4B4C-8298-B47E9273D0C1}" />
<Execution ProcessID="7328" ThreadID="940" />
<Channel>Microsoft-Dynamics-MR-Logger/Operational</Channel>
<Computer>SPOTRMX.uniformesdetampico.com</Computer>
<Security UserID="S-1-5-21-2582765582-1759889150-2059057023-6154" />
</System>
- <EventData>
<Data Name="source">ReportTaskTraceSource</Data>
<Data Name="id">-1</Data>
<Data Name="component">Microsoft.Dynamics.Integration.Common.TraceLog</Data>
<Data Name="errorMessage">La conversión del tipo de datos varchar en datetime produjo un valor fuera de intervalo.</Data>
<Data Name="exceptionMessage">La conversión del tipo de datos varchar en datetime produjo un valor fuera de intervalo.</Data>
<Data Name="exceptionSource">.Net SqlClient Data Provider</Data>
<Data Name="exceptionType">System.Data.SqlClient.SqlException</Data>
<Data Name="stackTrace">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.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at Microsoft.Dynamics.Performance.Integration.Reporting.Adapter.GP.ExchangeRateProvider.GetExchangeRates(String changeTrackingJoin, String changeTrackingWhere, String changeTrackingDelete, String changeTrackingTable) at Microsoft.Dynamics.Performance.Integration.Reporting.Adapter.GP.ExchangeRateProvider.ReadObjects(DateTime modifiedDateTime) at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.ReadObjectKeyList(String mapName, DbMap map, DateTime queryDate, Nullable`1& count, EventHandler onDone) at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.GetObjectKeys(String mapName, DbMap map, OperationType operationType, DateTime queryDate, Nullable`1& count, EventHandler onDone) at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.ProcessRecordsImplementation(OperationType operationType)</Data>
<Data Name="failureBucketId" />
<Data Name="appDomainId">2</Data>
<Data Name="buildVersion">2.12.16007.0</Data>
</EventData>
</Event>
Are there any errors in the Data Mart Integration log? You can find that in the MR Configuration Console.
Where in the Event Viewer do you see this error? MR will log errors under Applications and Services Logs | Microsoft | Dynamics | MR-Logger | Operational. The error doesn't say what database already has this object and I don't see a PK_ChangeTable in the data mart database.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
