IBM Support

WebSphere Transformation Extender Oracle Database Adapter fails insert or update operation when there is a column mismatch between database table and type tree

Troubleshooting


Problem

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.

Symptom

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

Cause

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.

[{"Product":{"code":"SSVSD8","label":"IBM Transformation Extender"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Database Adapter","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.4;8.3;8.2","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Product Synonym

Mercator;DataStage TX;WTX;WebSphere Transformation Extender

Document Information

Modified date:
23 October 2019

UID

swg21614320