Got error message when I pull the SP into report

[rajrev]

Hi,
We are using CR XI and DB2 database in Windows.

Using JDBC we tried to pull a stored procedre into the report which contains 2 parameters.
We got the following error:

"Failed to retrive data from the database. Details:SQL Exception:[SQL State:]07005 [Error Message:] [IBM][CLI Driver] CLI0101E The statement did not return a resutl set. SQLSTATE=07005 [Database Vendor Code: -99999]"

We checked the user access to the stored procedure. We tried through the IBM DB2 - Development Center and gave the parameter value and we got the result. But only at the time of using the sp in Crystal, we got this error.

Please let me know if you have any suggestion/questions.

Thanks,
-M

 

[synapsevampire]

Try ODBC, and keep in mind that the SP must ALWAYS return a recordset, even when the SP doesn't result in any rows.

The error message implies to me that this is NOT the case.

-k

 

[rajrev]

Thanks for your information -k. I'll check and come back.

-M

 

[rajrev]

I checked with ODBC and I got the following error:
Database Connector Error: '42884:[IBM][CLI Driver][DB2] SQL0440N No authorized routine named "XXX.SP10" of type "" having compatible arguments was found. SQLSTATE=42884
[Database vendor Code:-440]'

By the way, at the time of checking through the IBMDB2.. I got only one record as result. !

Please let me know if you need more info.

Thanks,
-M

 

[synapsevampire]

How did you check through DB2?

It sounds like there's either a privileges concern for the user signing in.

http://publib.boulder.ibm.com/infoc...sp?topic=/com.ibm.db2.udb.doc/ad/t0007054.htm

-k

 

[rajrev]

All Programms -->IBM DB2 --> Devlopment Tool --> Development Center. where we can check the SP.

If I have access to view the SP through IBM DB2 then it looks like i have rights to work on reports using that SP.

But I used the Tables. that works good. Only the SP making issues.

Pl. let me know if you have any comments.

Thanks,
-M

 

[synapsevampire]

The error returned states, and the link above appears to substabtiate that the difficulty is with executing the SP with the current user.

-k