In IBM WebSphere Transformation Extender 8.0 version, the Oracle Database Adapter can perform insert and update operations when there is a mismatch between the database table columns and the type tree associated with the output card.
In later WebSphere Transformation Extender 8.1 and above versions, the Oracle Database Adapter fails to perform insert and update operations when there is a mismatch between the database table columns and the type tree associated with the output card.
The Oracle Database Adapter .dbl trace file may contain the following error message.
<16251-018>: No type definition could be found matching column name <column_name>. The type tree needs to be re-generated due to the column mismatch.
<16251-018>: The data could not be converted to the column override definitions
The current behavior is intended and needs to remain the default behavior. The reason for the change from WTX 8.0 is because a mismatch presents data corruption issues on the code level and poses a potential problem when maps are designed with a different table structure.
Resolving the problem
Since Oracle specific code changes can be made to avoid the corruption issues, the older WTX 8.0 behavior can be retained with the addition of an environment variable.
The WTX_ADAPTER_DB_IGNORE_TYPETREE_MISMATCH environment variable to ignore the type tree mismatch will be available in next release. The default behavior will not change but the environment variable may be used to override the default behavior.
On a Windows platform:
1. select Control Panel
2. select System
3. select Advanced tab
4. select Environment Variables
5. create new System variable,
set Variable name = WTX_ADAPTER_DB_IGNORE_TYPETREE_MISMATCH
set Variable value = 1
On a Unix / Linux platform, set the environment variable using an export command: export WTX_ADAPTER_DB_IGNORE_TYPETREE_MISMATCH=1
The next product release will include the fix.
If needed, a patch may be requested for current version by contacting the WebSphere Transformation Extender support team.
WebSphere Transformation Extender