The given ColumnMapping does not match up with any column in the source or destination

Finance and Operations/AX
1

Hello Tech!,

I have issue in my AX 2012 IDMF Archive as shown below, I really appreciate if you anyone can share me some idea on how to resolve it.

AX 2012 IDMF:

ExecutionResult: Bulk copy in Archive DB Rolledback.System.InvalidOperationException: The given ColumnMapping does not match up with any column in the source or destination.
at System.Data.SqlClient.SqlBulkCopy.AnalyzeTargetAndCreateUpdateBulkCommand(BulkCopySimpleResultSet internalResults)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource1 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(IDataReader reader)
at Microsoft.Dynamics.AX.DataManagement.Framework.ArchiveData.ArchiveEx.StartArchiving(String archiveObjectName, DataRow dr, Hashtable archiveTraceDetails, AxArchiveTrace& archTrace)

image
image981×493 62.6 KB

2

To resolve the issue, need to run the IDMF Metadata Synchronize again due to some changes in the schema such as adding new Tables, Indexes and others related.