BW upgrade - Reporting Agent - SQL error 3114

[Former Member]

Hi ,

We have just upgraded the dev box from BW3.5 to BI7.3 version.

Post Upgrade check shows that one of the process chain fails with dump at the process - Precalculation of Values Sets(Reporting Agent).

Error Message at ST22 :

Category - ABAP Server Installation and Administration Errors

Runtime Errors - DBIF_REPO_SQL_ERROR

Short text - SQL error 3114 occurred when accessing program

What happened? - Database error text: "ORA-03114: not connected to ORACLE"

Error analysis- Database error text: "ORA-03114: not connected to ORACLE" Triggering SQL statement: "CX_RS_SQL_ERROR_SILENT========CP "

I found one sdn post without resolve status :

Appreciate feedback from anyone who's familiar on this.

Regards

Maili

[former_member210630]

Hi Maili,

As you told that there was a recent upgrade, since then you process chain is failing with the SQL error 3114, where according to the definataion from Oracle..

"ORA-03114: not connected to ORACLE "usually occurs when a call to Oracle is attempted & when no connection was established. Usually this happens because a user-written program has not logged on. It may happen if communication trouble causes a disconnection. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client's connection to the database is terminated without waiting for the client to issue a request.

Please try again after some time. If the message recurs then check with the Basis person or you DBA if the proper connection to database is there?

Also as a check please ensure that you have made the necessary database settings as per SAP Note 1005758 and apply the patches if required. Also, ensure that you have enabled the required parameters as discussed in SAP Note 964858.

Hope this helps

Thanks

[Former Member]

hi Pavan and Kiran,

thank you for your valuable feedback.

These notes are for the SAP on Oracle 10 but our Oracle version is 11.

Basis team escalated it to SAP OSS Consultant to check on this.

Hoping for a reply soon on how to fix it.

thanks.

regards

maili

[Former Member]

Solution :

Sap note 1643673 and 1540916 implemented.

Installed u2018Patch 600 for BI AddOn 7.00 (SAPgui 7.20) --> (bi720sp06_600-20006596.exe)u2019

[former_member188080]

Hi,

These errors are specific to oracle database,pl get in touch with basis on this.Check following threads for discussion with them

Also check any job which are running in system running more than its specified frequency. For eg it suppose to run 2-3 times and it is rnning 20 times.Check with basis.

Thanks and regards

Kiran