Skip to Content
0
Former Member
Mar 03, 2011 at 10:35 AM

DBIF_RSQL_SQL_ERROR which are related to BW ods Activation

97 Views

Hi friends,

I dont know whether this is the right thread i am posting or not. But technical people can definately help me.

Recently we have upgraded patch from SP 22 to SP 25 for BI 7.0. From that time onwards i am facing issues like anything.

Here is the impact.

1. Data loads not triggering for process Chains as per schedules. we are running emegency chains manually. We have raised an issue to SAP, waiting for reply.

Short Dumps:

b)

DBIF_REPO_SQL_ERROR

Short text

SQL error 3114 occurred when accessing program "SAPLRS_EXCEPTION " part "LOAD".

What happened?

The system is no longer linked to an ORACLE instance.

No further operations can be performed on the database.

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...: "SAPLRS_EXCEPTION "

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" " "

"SAPLRRMS" or "LRRMSU14"

"RRMS_EXCEPTION_HANDLING"

c)

DBIF_RSQL_SQL_ERROR

CX_SY_OPEN_SQL_DB

How to correct the error

Database error text........: "ORA-03135: connection lost contact"

Internal call code.........: "[RSQL/RDUP/TADIR ]"

Please check the entries in the system log (Transaction SM21).

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_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

"SAPLSDI0" or "LSDI0U01"

"TRINT_TADIR_UPDATE"

2. Especially ODS activation (through process chains) failing in every process Chain. if you run maual activation , then its ok.

All Batch are got struck when accessing table TADIR. Dump C which is mensioned above impact is very high on the system.

Anyone know about to resolve the above dumps, Please help me.

If you want to analyze more detailed level, please let me know

Thanks in Advance.

Venkat