Invalid string or buffer length. SQLSTATE=HY090

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Anjan Roy
Participant
Posts: 46
Joined: Mon Apr 12, 2004 9:51 am
Location: USA

Invalid string or buffer length. SQLSTATE=HY090

Post by Anjan Roy »

Hi All.

I have a DB2 stage that is selecting data from multiple tables and writing into a flat file. I am using a column generated sql. When I validate my job I don't get any errors. However, when I run the job, I get the following error -

Code: Select all

[IBM][CLI Driver] CLI0131E  Invalid string or buffer length. SQLSTATE=HY090
SQLTables: Error retrieving system catalog information for requested tables(s). 
I searched the forum but did not find an effective resultion.

Any Ideas?

-Thanks in advance
Anjan
vcannadevula
Charter Member
Charter Member
Posts: 143
Joined: Thu Nov 04, 2004 6:53 am

Re: Invalid string or buffer length. SQLSTATE=HY090

Post by vcannadevula »

Anjan Roy wrote:Hi All.

I have a DB2 stage that is selecting data from multiple tables and writing into a flat file. I am using a column generated sql. When I validate my job I don't get any errors. However, when I run the job, I get the following error -

Code: Select all

[IBM][CLI Driver] CLI0131E  Invalid string or buffer length. SQLSTATE=HY090
SQLTables: Error retrieving system catalog information for requested tables(s). 
I searched the forum but did not find an effective resultion.

Any Ideas?

-Thanks in advance
Anjan


Add this environment variable "DS_NO_PROCESS_METADATA" in the admnistrator and set it to 1 and try to compile and run the job. This is needed if you are using the DB2 8 version
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Can you import table definitions?

Check that you have requisite SELECT priveleges to the system tables.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chivl627
Charter Member
Charter Member
Posts: 5
Joined: Fri Oct 14, 2005 10:54 am

Post by chivl627 »

Hi vcannadevula,

Your suggestion worked! :P

We just did an upgrade to DS7.5.1.A in our dev server and started doing a shakeout on our jobs and got this error in 3 jobs so far:
[IBM][CLI Driver] CLI0131E Invalid string or buffer length. SQLSTATE=HY090
SQLTables: Error retrieving system catalog information for requested tables(s).

So I added that environment variable as you suggested and the jobs ran fine this time.

What's that env variable for? You mentioned we need this if we're using DB2 8? Can you pls tell me more abt it?

Thanks much!!
Post Reply