MR: There is already an object named 'PK_ChangeTablee' in the database

(3) Share

Report

Posted on by Community Member

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.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (4)

Answers (0)

CU13021608-0 2 on at

Like (0)

Report

MR: There is already an object named 'PK_ChangeTablee' in the database

Is there anything further on this issue? I am receiving the same error.

The error exists in both the Service and Integration logs

I am currently doing a rebuild as our warehouse does not appear to be showing data for all periods on our financial statements.

Was this reply helpful? Yes No
Greg Byer 2,586 on at

Like (0)

Report

RE: MR: There is already an object named 'PK_ChangeTablee' in the database

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?

Was this reply helpful? Yes No
Alexis Pérez 5 on at

Like (0)

Report

RE: MR: There is already an object named 'PK_ChangeTablee' in the database

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>

Was this reply helpful? Yes No
Greg Byer 2,586 on at

Like (0)

Report

RE: MR: There is already an object named 'PK_ChangeTablee' in the database

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.

Was this reply helpful? Yes No