CC Cockpit and DB2 database

[former_member1954]

Hi,

The CC Cockpit can work with DB2 database.

In the configuration file there is also description how to define JDBC connection for DB2. I mean parameter sqlhelper.jdbc.uri. And it works fine.

Most of Fiori apps works fine in such setup, but...

in some apps, or when changing filters on working apps, an error appear(or nothing) and no result of queries.

In the server logs we can find errors during some SQL queries. For example:

Error reason: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=LIMIT;;FETCH FIRST <n> ROWS ONLY, DRIVER=4.19.66. Next exception: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-104;42601;LIMIT||FETCH FIRST <n> ROWS ONLY, DRIVER=4.19.66. Next exception: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-104;42601;LIMIT||FETCH FIRST <n> ROWS ONLY, DRIVER=4.19.66.#

On DB2 support pages I found that this is due to using LIMIT at the end of SQL query instead of FETCH FIRST n ROWS.

Any idea what else I need to change or setup for DB2?

best regards

Rafal

[francois_thimon · Accepted solution]

Hi Rafal,

Thanks for your help.

Actually, I've just sent a reply to your ticket on BCP, and I think the root cause has now been identified: actually, the LIMIT/OFFSET clause was introduced in DB2 some years ago, but is not part of the IBM standard. Because of this, in order to get it to work, you have to enable it explicitly, as explained by the Convergent Charging installation guide ("Preparing the IBM DB2 Core Database (w/o pureScale Feature)" chapter):
https://help.sap.com/viewer/d1d04c0d65964a9b91589ae7afc1bd45/5.0.4/en-US/c15e086769d143c5a424c32e852...

There, in the "Procedure" section, just before step 3, you will find a set of DB2 statements to enable the settings necessary to Convergent Charging.
As explained in the BCP ticket, please apply all these steps, and do not hesitate to let us know if you need any more help with this.

Best regards.

François
SAP Convergent Charging Support

[former_member1954 · Accepted solution]

Hi Francois,

it helps. Now everything works fine.

Thanks a lot

Rafal

[francois_thimon · Accepted solution]

Hi Rafal,

Thank you for your feedback.
Will you please "accept" the answer here, so that future users facing the same problem can find this solution more easily?

Best regards.

François
SAP Convergent Charging Support

[francois_thimon]

Hi Rafal,

This issue was never reported before and it does not seem like something you can fix in your configuration.

Will you please open a support ticket about this, on IS-CC?
Then, we will need you to enable the debug traces in Cockpit, reproduce the issue, and send us the TRC and LOG files of Cockpit, so that we can locate and reproduce the issue on our own test systems.
If needed, we can guide you through this.

[EDIT] Can you please also send us the link to the DB2 documentation you mentioned?
We have found some IBM documentation that rather seems to point to a different kind of root cause.

Best regards.

François
SAP Convergent Charging Support

[former_member1954]

Hi,

thanks a lot.

I have prepared logs and I have created a new ticket.