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

Technote (troubleshooting)


Problem(Abstract)

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 Alias/Synonym

Mercator
DataStage TX
WTX
WebSphere Transformation Extender

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Transformation Extender
Database Adapter

Software version:

8.2, 8.3, 8.4

Operating system(s):

AIX, HP Itanium, HP-UX, Linux, Linux zSeries, Solaris, Windows

Reference #:

1614320

Modified date:

2013-01-11

Translate my page

Machine Translation

Content navigation