DB2 problem SqlCode=-514 on webi report

[dherla2]

Hello,

I have an univers that use DB2 on ZOS. To connect to DB2, I use JDBC connection.

There is a problem in some case. I have the following error :

Erreur de base de données : DB2 SQL Error: SQLCODE=-514, SQLSTATE=26501, SQLERRMC=SQL_CURLH200C1, DRIVER=3.61.75. (IES 10901) (WIS 10901)

When I make a search, I see the same error for Microsoft Access DB (http://support.microsoft.com/kb/321872)

If I understand correctly, it's a problem in the configuration of the connection.

For sure, I have copied the query from webi and I put the query in DBVisualizer. The query run perfectly in DBVisualizer.

Any help, will be very appreciate.

Thanks in advance.

Dimitri

[Former Member]

Hi Dimitri,

Your logic is correct. IES10901 & WIS10901 are common error when BO faces issues from Database driver. You can see following post on same lines.

http://scn.sap.com/thread/3298853

Regarding your driver issue, did you check following post from IBM:

http://pic.dhe.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.codes%2Fsrc%2Ft...

If above post did not provide much help, please raise support case with IBM as this is not a BO issue.

[dherla2]

Hello,

Thanks,

The problem is only a grant problem. The user doesn't have the correct right. I change the user right and now it's good.

Dimitri