Knowledge Base > Data Architect > DataType Mappings Causes The Product To Crash

Need Support?

Can't find the answer you're looking for? We're here to help.

DataType Mappings Causes The Product To Crash

Description

In some situations, like when generating a physical model, running the Compare and Merge, or launching the Datatype Mapping editor causes the product to crash and close.

Our investigation has found that when using Custom Datatypes or making modification to the DatatypeMappings_SystemDefault.xml inside of the DatatypesMapping folder (By default this folder is stored in the C:\ProgramData\Idera\ERStudioDA_19.3\DatatypeMappings directory) corruption can happen on the xml file, causing a crash.

Steps To Fix This

The easiest way to fix this is to restore the original Datatype Mappings file by reinstalling the product. 

A second workaround is to manually delete the Datatype Mappings file and replace it with the default one. This file can be provided either by Support or by a Colleague. Once you have it, here are the steps to follow:

  1. Navigate to the C:\ProgramData\Idera\ERStudioDA_20.0\DatatypeMappings directory
  2. Remove the DatatypeMappings_SystemDefault.xml from this directory
  3. Add the default DatatypeMappings_SystemDefault.xml  file again
  4. Restart the tool

Additional Notes

If you are able to identify that this is happening to a single database platform, then the problem is with only the code for that DB platform datatypes with the DatatypeMappings_SystemDefault.xml  file. You could potentially replace this segment of code with the same one from the default file and not lose the rest of the custom datatypes you created.

If you need additonal assistance, please contact Support.
Copyright © 2026 Idera, Inc.