Is there a place in AX where table mappings for a database sync are stored?

(0) Share

Report

Posted on by Brandt Fundak

2,007

We are having an issue in one of our test environments that when someone attempts a database sync, we get errors on five custom tables, because we have DMF tables that are trying to write the data to the custom tables and the data types don't match so it fails. I have noted that the table IDs of both of the fields of the source (DMF) and target (custom) tables are the same, but I was wondering if there is somewhere AX is looking for the mapping of the source to target, which do not have the same table Ids. We looked in SQL dictionary, but since the field Ids are correct, we know the problem doesn't reside there. To be honest, we don't want this DMF table syncing with the custom table as they don't have the same data in them.

We are running the version of DIXF prior to the one that came out in CU7. Can anyone point me in the right direction?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Brandt Fundak 2,007 on at

Like (0)

Report

RE: Is there a place in AX where table mappings for a database sync are stored?

Nitesh,

You wouldn't happen to know which of the DMF tables these mappings reside in, do you?

Brandt

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Is there a place in AX where table mappings for a database sync are stored?

Please list which five custome table having database sync issue, try to investigate on those five table in SQLDictionary table

as you said ... table IDs of both of the fields of the source (DMF) and target (custom) tables are the same...

if so you have some issue in DMF entity and mapping.. please inventigate then and correnct it as it very unusual.

As per my understanding DMF will not look to SQLDictionary Table for DMF mapping from Source to Target... it will be in Some DMF* tables

if you have some bad mapping of Source and Traget tables in DMF, then you sould delete the mapping and recreate it in DMF Mapping Tool

Please verify and update us with your findings

Was this reply helpful? Yes No
Brandt Fundak 2,007 on at

Like (0)

Report

RE: Is there a place in AX where table mappings for a database sync are stored?

Personally, if we don't have to manipulate anything, that would be best.

When we query the SQLDictionary for the custom table by name in the affected environment, we don't get anything back. I find that odd, but I can't explain to you why this is happening. This would kind of feed into what you are saying Martin--that the DMF table thinks it should be mapping to a table with that id...because the tableId of the DMF table and the id of the custom table are not the same.

However, I'm not sure exactly how we fix this...

I'm going to sleep on it and maybe I'll have more questions in the morning.

Thanks for the responses guys.

Was this reply helpful? Yes No
Martin Dráb 236,192 Most Valuable Professional on at

Like (0)

Report

RE: Is there a place in AX where table mappings for a database sync are stored?

You can manipulate SQLSYNCINFO, but if everything was really all right, you wouldn't get this error. It seems that you have a collision at table-level, i.e. that the IDs used by your tables before are now used by DIXF tables and DIXF tables try to synchronize with what was left in DB by the other tables.

Maybe you've moved code or data from a system with different IDs?

Was this reply helpful? Yes No
Suggested answer

Joris dG 17,775 on at

Like (0)

Report

RE: Is there a place in AX where table mappings for a database sync are stored?

SQLDICTIONARY

However, be careful in there. Remember that there's more things using table IDs than the sync. For example, the system that tracks RecIDs uses it as well - so you could have some nasty consequences.

Was this reply helpful? Yes No