Skip to Content
author's profile photo Former Member
Former Member

BW upgrade - Reporting Agent - SQL error 3114

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Sep 20, 2011 at 10:53 AM

    Hi,

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

    DBIF_RSQL_SQL_ERROR which are related to BW ods Activation

    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.

    Issue when using filter in the portal.

    Thanks and regards

    Kiran

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 20, 2011 at 12:20 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.