importing Metadata through ODBC error

[ovidiu]

Hi,

I am connecting, through ODBC, to a HP Neoview box and I am getting this error message. It seems that the metadata that DataStage is trying to fetch is too long, but it shouldn't be. Any ideea how to solve this issue?

Thank you,

Florin

DSR.MetaGeta(GET.TABLES)(SQLFetch): BCI Error:
SQLSTATE=01004,CODE=0,[DataStage][SQL Client]Data has been truncated
SQLSTATE=01004,CODE=0,[DataStage][SQL Client]Data has been truncated
SQLSTATE=01004,CODE=0,[DataStage][SQL Client]Data has been truncated
SQLSTATE=01004,CODE=0,[DataStage][SQL Client]Data has been truncated

SQLWARN1 SQLSTATE 01004
Explanation: The value of a string column was truncated when assigned to a host variable.

[kcbland]

What database, version, and ODBC driver are you using? Is this a new database? Is this a new DS installation? Does the import metadata function work against other databases using the same driver?

[ovidiu]

Hi Ken,

Yes, is a new database. I am using the ODBC driver provided by HP Neoview.

These are my entries in uvodbc.config ( both) ...

<HPODBC>
DBMSTYPE = ODBC
network = TCP/IP
service = ods
host = 172.99.99.99,18650

...and .odbc.ini
[HPODBC]
Driver=/usr/lib/libhpodbc.so
Description=FRY Neoview ODBC Protocol
DataLang=0
FetchBufferSize=
SQL_ATTR_CONNECTION_TIMEOUT=
SQL_LOGIN_TIMEOUT=
SQL_QUERY_TIMEOUT=NO_TIMEOUT
ServiceName=HP_DEFAULT_SERVICE
Catalog=NEO
Schema=DEV_XXX
LogonID=xxxxxxx
Password=xxxxxxx
Server=172.99.99.99,18650
QuotedId=No
AnsiNPW=No

Regards,

Florin

[kcbland]

Is this ODBC driver supported by DS? I'm not familiar with anything other than the included drivers. I know that there is some work to do to get other drivers bound to the ODBC driver manager. You're probably going to have to work with technical support on this one.