SSMA Console for Oracle - Column Type Mapping Error (conflict with the existing one)

Question

Using SMA Console for Oracle I have added the following column type mapping:

<set-project-type-mapping type-mapping-schema="Columns type mapping" source-type-id="NUMBER@2" target-type-id="INT" />

However, when I execute this via the SSMA Console I get the following error:

FATALERR Invalid type mapping: The new type mapping from source 'NUMBER@2' to target 'INT' has a conflict with the existing one.

Please can someone advise how to avoid this mapping conflict. I am creating a new project with the script file.

Thank you,
Ben

Answer 1

Hi, as "NUMBER@2" expects two parameters and you want to overwrite the old mapping, then you need you specify the source type exactly the same as the existing one, which should be like this:

<set-project-type-mapping type-mapping-schema="Columns type mapping" source-type-id="NUMBER@2" target-type-id="INT">
    <source-type-param />
    <source-type-param />
</set-project-type-mapping>