Invalid string or buffer length. SQLSTATE=HY090

supernova2005 · Post by **supernova2005** » Wed Jun 15, 2005 4:19 am

Hi everyone,

This error message appears on some of my DB2 stages, and if I replace the DB2 stage with a DRS stage, the error message disappeared. Does anyone know what's going on?

here is the error message:

APT_CombinedOperatorController,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0131E Invalid string or buffer length. SQLSTATE=HY090
SQLTables: Error retrieving system catalog information for requested tables(s).

elavenil · Post by **elavenil** » Wed Jun 15, 2005 5:27 am

Had faced the same problem for two different reasons.

1. Specified the alias for a table, but this alias was mentioned wrongly and that caused this issue. DataStage should not allow us to compile When alias wronly specified but we were able to compile.

2. Change all char datatype to varchar data type then run the job. And this could resolve the issue.

Regards
Saravanan

supernova2005 · Post by **supernova2005** » Wed Jun 15, 2005 9:48 am

Saravanan, Thank you for the reply. I remove the alias on the input and output db2 tables, and changed all chars to VarChars, but the problem still exists. Is there any other possible solution?

elavenil wrote:Had faced the same problem for two different reasons.

1. Specified the alias for a table, but this alias was mentioned wrongly and that caused this issue. DataStage should not allow us to compile When alias wronly specified but we were able to compile.

2. Change all char datatype to varchar data type then run the job. And this could resolve the issue.

Regards
Saravanan

elavenil · Post by **elavenil** » Wed Jun 15, 2005 10:19 am

Looked at one of IBM DB2 doc, it says as follows.

HY090 Invalid string or buffer length. The value specified for the argument BufferLength was less than 0 or the values specified for the argument DataLinkLength was less than 0 and not equal to SQL_NTS.

You can check your client libraries for DB2.

Regards
Saravanan

bcarlson · Post by **bcarlson** » Wed Jun 15, 2005 4:39 pm

What is your DB2 stage doing? Is it a write? Can you provide more details?

supernova2005 · Post by **supernova2005** » Thu Jun 16, 2005 3:32 am

The DB2 stage is simply reading a table. There is no trick at all.

bcarlson wrote:What is your DB2 stage doing? Is it a write? Can you provide more details?

roy · Post by **roy** » Thu Jun 16, 2005 3:38 am

Hi,
Disable operator combination to get the exact stage causing the error and if you still need help repost the new error you get (add an env var of APT_DISABLE_COMBINATION with true value in your parameters list for that job or set it project wide).

other then that it seems you don't have the required permitions for using px stages to read the table (usually you need permitions to some system/schema tables - all in the installation notes)

IHTH,

ray.wurlod · Post by **ray.wurlod** » Thu Jun 16, 2005 9:20 pm

DataStage does not prepare SQL when compiling, so it could not detect SQL syntax errors at this time.

Validating the job would have picked up the SQL syntax error.