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:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.