Unknown error SQLCODE 536631

[pxraja]

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

[pxraja]

Hi all,

Is anyone faced similar type of error.

Kindly share your views to overcome the mentioned error.

thanks in advance

[chulett]

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.