DSXchange

Hi All,

I am getting unknow error SQLCODE 536631..

the job is getting aborted after 2 million records processed whereas source query has to fetch 5 million records..

source query is fetching 5 million records when executed in db2 toad.

job design is as follows.,

ODBC--->MODIFY--->TRF---->ODBC

modify stage has to handle null : handle_null(field 3,0)

transformer stage has constraint: field4>= 50000

job is running fine in production but recently it aborts with following error,

SRC,0: [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]Unknown error: SQLCODE 536631


SRC: When checking operator: When binding output interface field "field2" to field "field2": Implicit conversion from source type "int32" to result type "string[max=10]": Converting number to string.


when i tried removing modify stage and handled null in the source query again the following error message at the same record say 2 million processed.

Job is fetching 2 million records and passed upto transformer input but it aborts with following error with warnings

SRC,0: [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]Unknown error: SQLCODE -16777208


APT_CombinedOperatorController,0: Field 'Field4' from input dataset '0' is NULL. Record dropped.

I searched in the forum for related topic but in vain

Suggestions to overcome this error are most welcome.

thanks in advance

Hi all,

Is anyone faced similar type of error.

Kindly share your views to overcome the mentioned error.

thanks in advance

If someone has and feels like sharing, they will. Patience.

For the "unknown error" I'm not sure what you can do other than open a case with your official support provider. For the other, add $APT_DISABLE_COMBINATION to the job and set it to True. That will give you more information regarding the "implicit conversion" warning.