Waning in test, abort in prod

diamondabhi · Post by **diamondabhi** » Wed Jul 13, 2005 9:08 am

Hi All,
When I run a job in test box I get the following message as warning but the job runs successfully where as I get the same message in the prod box the job aborts, can anybody tell me what needs to be done. I am usng DB2 plugin stage.

Error Message:
[IBM][CLI Driver][DB2] SQL0471N Invocation of routine "SYSIBM .SQLTABLES " failed due to reason "00E7900C". SQLSTATE=55023

SQLTables: Error retrieving system catalog information for requested tables(s).

Thanks,
Abhi.

roy · Post by **roy** » Wed Jul 13, 2005 9:10 am

Hi,
The most probable reason would be you didn't get the privilages required on the production DB as you have on the test DB.
IHTH,

ray.wurlod · Post by **ray.wurlod** » Thu Jul 14, 2005 5:18 am

Specifically, you lack SELECT privilege on the system tables in which names of tables, views, columns and so on are stored. Negotiate with your DBA, pointing out that SELECT privilege alone can not engender any damage,

diamondabhi · Post by **diamondabhi** » Thu Jul 14, 2005 8:14 am

Thanks Ray,
But I have the same privileges I have in the test box. The job is running with warnings in test and its fatal in prod. What exactly needs to be done with system tables.

Sai.

roy · Post by **roy** » Thu Jul 14, 2005 8:19 am

Hmm,
Are both projects same in configuration?
How did you promote the job to production?
make sure the users used have exactly the same profile on both DBs.

did you find anything along those lines?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jul 14, 2005 8:21 am

Did you try connecting outside DS?

diamondabhi · Post by **diamondabhi** » Thu Jul 14, 2005 8:38 am

Hi,
Ray I promoted the jobs using version control and have the same configurations.
Sai, I tried connecting to ouside DS and I am able to connect to the DataBase.

Thanks,
Sai.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jul 14, 2005 8:41 am

Maybe there was more words in the message....something like the one below

"Error: [IBM][CLI Driver][DB2]SQL0471N Invocation of routine "SYSIBM. SQLTABLES " failed due to reason "00E7900C". SQLSTATE=55023, Connector 'db2', Method -Catalog[Metadata]- (-471)$$BUILDLIST:210"

Find the full error description and give it to your dba as it is the DB2 error that is stopping.

Note - all actions are to be checked from the DS server and not from the client.

roy · Post by **roy** » Sun Jul 17, 2005 3:03 am

I'd also recommend trying a manual export import of the job via manager to see if you get a different error code.

I had something similar in EE and a no warning job came up with warning after being promoted via VC.
I exported/imported it and got another warning, So it's worth a check.

IHTH,