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.
importing Metadata through ODBC error
Moderators: chulett, rschirm, roy
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?
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
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
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
ovidiu
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle