DBIF_REPO_SQL_ERROR dump while executing the queries

[Former Member]

Hi Friends,

Iam in a big mess . I have one query based on one my Zinfocube.This query ia attached in the workbook .. Previuolsy all was fine , but now whever iam executing this query it is throwing me the exception

Query 0: Runtime error SQL error 3114 occurred when accessing program CX_ with parallel processing via RFC.

When I checked in ST22 i got the following dump,

DBIF_REPO_SQL_ERROR

Short text

SQL error 3114 occurred when accessing program

What happened?

The system is no longer linked to an ORACLE instance.

No further operations can be performed on the database.

What can you do?

You cannot eliminate this error yourself.

Please inform your database administrator.

Note which actions and input led to the error.

For further help in handling the problem, contact your SAP administrator

.

You can use the ABAP dump analysis transaction ST22 to view and manage

termination messages, in particular for long term reference.

Note which actions and input led to the error.

For further help in handling the problem, contact your SAP administrator

.

You can use the ABAP dump analysis transaction ST22 to view and manage

termination messages, in particular for long term reference.

Error analysis

The system attempted to access an ORACLE instance to which

it is no longer linked.

This situation may arise because the ORACLE instance

has been stopped due to an error or an external operation.

How to correct the error

Database error text........: "ORA-03114: not connected to ORACLE"

Triggering SQL statement...: "CX_SQL_EXCEPTION==============CP "

The current status of the ORACLE instance cannot be determined.

It may be still inactive or the database administrator may have

restarted it.

In any case, all systems that have accessed the ORACLE instance

must be restarted after the ORACLE instance has been restarted.

If you were working on a central system, inform

your system administrator.

If you were working on an external local system, inform

the person responsible for this system.

If you were working on your own local system, restart

the system yourself.

If the error occures in a non-modified SAP program, you may be able to

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following

keywords:

"DBIF_REPO_SQL_ERROR" " "

"CL_SQL_RESULT_SET=============CP" or "CL_SQL_RESULT_SET=============CM006"

"NEXT_PACKAGE"

If you cannot solve the problem yourself and want to send an error

notification to SAP, include the following information:

1. The description of the current problem (short dump)

To save the description, choose "System->List->Save->Local File

(Unconverted)".

2. Corresponding system log

Display the system log by calling transaction SM21.

Restrict the time interval to 10 minutes before and five minutes

after the short dump. Then choose "System->List->Save->Local File

(Unconverted)".

3. If the problem occurs in a problem of your own or a modified SAP

program: The source code of the program

In the editor, choose "Utilities->More

Utilities->Upload/Download->Download".

4. Details about the conditions under which the error occurred or which

actions and input led to the error.

If the error occures in a non-modified SAP program, you may be able to

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following

keywords:

"DBIF_REPO_SQL_ERROR" " "

"CL_SQL_RESULT_SET=============CP" or "CL_SQL_RESULT_SET=============CM006"

"NEXT_PACKAGE"

.

My Basis guy is saying that he has checked the data base parameters , and all are fine.

Thanks in advance.

[Former Member · Accepted solution]

Hi Akash,

"ORA-03114: not connected to ORACLE". We had a similar problem and it was some problem with the database. The DBA guys should fix it. Either it should be tablespace or some parameters. Try working with them.

-Ram.

[Former Member]

Hi All, thanks for replying,

Ram we have BASIS guy with us but he has already checked the data base parameters and other things. Could u please tell me wht setting ur BASIS guy did to resolve this issue as its a very crictical issue in BW production.

Thanks and Regards ,

Akash,..

[Former Member]

Hi Akash,

did you solve your problem? We are facing exactly the same situation with some (only some!) queries...

Many thanks,

Rodolphe

[Former Member]

Hi

Did you check SAP Note 568768 - Analysis of SQL Errors causing Shortdumps or Error messages

See whether it is applicable

Thanks

CK

[Former Member]

By any chance is any characteristic in the report restricted by several single values and ranges?

[Former Member]

Hi Akash,

First check if the system is up and running by logging on the sys through SAP Logon.

Check with the BASIS is all servers r running.

if the sys is up ,the go to the query definition,and run the check on that and see if there is any error in the query definition.

Let us knwo ur observations..

Regards,

Dhanya.

[former_member186358]

Hi Akash,

You may wish to refer Note 568768 - Analysis of SQL Errors causing Shortdumps or Error messages.

Regards,

Anil