IBM Support

DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703 when running CDT and comparing source and target environment

Troubleshooting


Problem

DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703 when running CDT and comparing source and target environments

Symptom

You are running CDT tool and using Configuration Data Deployment option to compare source and target database. You are seeing the above mentioned error.

Environment

Sterling Order Management

Diagnosing The Problem

Error example:

<Error ErrorCode="-206"         ErrorDescription="DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=YFS_USER.EXTN_USER_ACTIVE, DRIVER=3.62.56" ErrorRelatedMoreInfo="">

This error suggests database is missing EXTN_USER_ACTIVE column in YFS_USER table.

Resolving The Problem

You have extended source database but did not apply same extensions on target environment. CDT can not add extended column(s) to target database, CDT migrates its data. Please apply same extensions to your target environment (database) to resolve the problem.

Note: At the moment, CDT does not migrate Shadow columns data. To populate Shadow columns please run YCPCaseInsensitiveDataLoaderAgent in the target environment.


[{"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Extensions","Platform":[{"code":"PF016","label":"Linux"}],"Version":"9.3","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21973994

Page Feedback