Page 1 of 1

DataStage ODBC connector not working properly

Posted: Wed Feb 19, 2014 1:09 am
by shukla_krishna
My job was working fine till 2 days back.
There was upgrade in the AS400 box and we started getting errors.

Our errors are mostly related to while reading data and if column has # in the name.

We get error if we read data

Select
M5HOSP,
"M5PAT#" as M5PATNO
From <>

But if we replace sql like

Select
M5HOSP,
Integer("M5PAT#") as M5PATNO
From <>

then its works with warning.

Warnings are like

APT_CombinedOperatorController,1: Invalid character(s) ([xFC]) found converting string (code point(s): [xFC][x04]C[xAB] ) from codepage UTF-8 to Unicode, substituting.
APT_CombinedOperatorController,2: Invalid character(s) ([xE2]) found converting string (code point(s): ^[xE2][x01][x02] ) from codepage UTF-8 to Unicode, substituting.
AS400_db2_ICD9PROC,0: *** glibc detected *** /opt/IBM/InformationServer/Server/PXEngine/bin/osh: munmap_chunk(): invalid pointer: 0x00000000050905f0 ***
AS400_db2_ICD9PROC,0: ======= Backtrace: =========
AS400_db2_ICD9PROC,0: /lib64/libc.so.6(cfree+0x166)[0x3d31272886]
AS400_db2_ICD9PROC,0: /opt/IBM/InformationServer/Server/DSComponents/bin/libccodbc.so(_ZN18CC_OdbcDBStatement8dbsFetchEv+0x121)[0x2aaaaaad407d]


Can some one can help.

Same table is getting read from server jobs and it works fine without change.

Posted: Wed Feb 19, 2014 8:15 am
by chulett
What kind of an "upgrade" was done?