Why is noone mentioning having to recreate mappings when upgrading to Gen 3?
When upgrading from Gen 2 to Gen 3 it is fairly well known that the Instance ID goes from being a Number to a Char value.
If you are using the Instance ID in a mapping, storing it in a column, then you will have work to carry out.
Blog posts like this :
Adapting to the Instance ID Change when Upgrading to Oracle Integration 3
Go on to say that if you are using the Instance ID you have 2 choices (I am quoting here)
- Integration design: map a different numerical value to replace the instance ID.
- Database design: change the data type of the column holding the instance ID to string (CHAR/VARCHAR).
Tagged:
0