DBIF_REPO_SQL_ERROR dump

[former_member190390]

Hello Experts,

I am getting the dume DBIF_REPO_SQL_ERROR when displaying Infocube's data with selection values for FiscYear.

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 ORACL

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.

Can anyone can help to solve this problem?

Thanks in advance

Venky

[former_member184494]

Check if your Database instance is up and also if the necessary authorizations for the DB instance is working.

Arun

[Former Member]

Hi,

what about following the suggestion given in the message?

Siggi

[former_member190390]

Hi,

i am not understanding the solution, and why problem occured.

Thanks,

Venky

[Former Member]

As siggi suggested - the message told you what had happend and what to do

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.

you did cotanct your dba and tell him thjt didnt you before goign to all the problem of typing this message on the forum