DBIF_RSQL_SQL_ERROR

[Former Member]

while i was trying to open transation MIRO i got this run time error:

Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

i am using an IDES system on DB Oracle 10g and windows 2003 server

[markus_doehr2 · Accepted solution]

Please check the "analysis" section of the dump in ST22. Also have a look in SM21 for the error at the time it occured.

DBIF_RSQL* errors are "Database Interface" errors which are generic.

Markus

[Former Member · Accepted solution]

this is what i found in SM21 :

13:38:22 DIA 000 800 WASEEM MIRO Q0 E Signal c00 received by operating system

13:38:24 DIA 000 800 WASEEM MIRO BY 4 Database error 24909 at SEL access to table REPOLOAD

13:38:24 DIA 000 800 WASEEM MIRO BY 0 > ORA-24909: call in progress. Current operation cancelled

13:38:24 DIA 000 800 WASEEM MIRO AB 2 > Include ??? line 0000.

13:38:24 DIA 000 800 WASEEM MIRO AB 0 Run-time error "DBIF_REPO_SQL_ERROR" occurred

13:38:24 DIA 000 800 WASEEM MIRO BY 2 Database error 24909 at FET

13:38:24 DIA 000 800 WASEEM MIRO BY 0 > ORA-24909: call in progress. Current operation cancelled

13:38:24 DIA 000 800 WASEEM MIRO BY 2 Database error 3114 at FET

13:38:24 DIA 000 800 WASEEM MIRO BY 0 > ORA-03114: not connected to ORACLE

13:38:24 DIA 000 800 WASEEM MIRO BY 2 Database error 3114 at FET

13:38:24 DIA 000 800 WASEEM MIRO BY 0 > ORA-03114: not connected to ORACLE

13:38:24 DIA 000 800 WASEEM MIRO BY M SQL error 3114 . Work processes in reconnect status

13:38:24 DIA 000 800 WASEEM MIRO AB 2 > Include ??? line 0000.

13:38:24 DIA 000 800 WASEEM MIRO AB 0 Run-time error "DBIF_REPO_SQL_ERROR" occurred

13:38:24 DIA 000 800 WASEEM MIRO AB 2 > Include ??? line 0000.

13:38:24 DIA 000 800 WASEEM MIRO AB 0 Run-time error "DBIF_REPO_SQL_ERROR" occurred

13:38:24 DIA 000 800 WASEEM MIRO AB 2 > Include ??? line 0000.

13:38:24 DIA 000 800 WASEEM MIRO AB 0 Run-time error "DBIF_REPO_SQL_ERROR" occurred

13:38:24 DIA 000 800 WASEEM MIRO AB 2 > Include ??? line 0000.

13:38:24 DIA 000 800 WASEEM MIRO AB 0 Run-time error "DBIF_REPO_SQL_ERROR" occurred

13:38:24 DIA 000 800 WASEEM MIRO AB 2 > Include ??? line 0000.

13:38:24 DIA 000 800 WASEEM MIRO AB 0 Run-time error "DBIF_REPO_SQL_ERROR" occurred

13:38:24 DIA 000 800 WASEEM MIRO Q0 2 Stop Workproc 0, PID 2712

[markus_doehr2 · Accepted solution]

Your database is struggling/dumping too.

What exact version and patch do you have installed?

Markus

[Former Member · Accepted solution]

DB Release: 10.2.0.1.0

DBSL Version: 700.8

DBSL Patch Level: 107

[markus_doehr2 · Accepted solution]

> DB Release: 10.2.0.1.0

This database version was only supported during RampUp, that's long gone --> Unsupported.

I suggest to upgrade your database to 10.2.0.4 and apply the latest minipatch.

See

Note 871096 - Oracle Database 10g: Patch sets/patches for 10.2.0

Note 1137346 - Oracle Database 10g: Patches for Release 10.2.0.4

Many many errors have been fixed since.

Markus

[Former Member · Accepted solution]

after i upgrade to 10.2.0.4 do i have to re install the SAP system?

[markus_doehr2 · Accepted solution]

No.

Follow the notes and the README that comes with the patch.

Markus

[Former Member · Accepted solution]

No Waseem, you need not reinstall SAP after you upgrade Oracle..

[Former Member · Accepted solution]

Just take care that your SAP is down and then the best thing to upgarde to 4.0 is to read the readme.htm file which gives you step by step information of how to go and what needs to be done.( its on the patch cd)..

Once done, you can start SAP and then try to connect it.

Regards,

[fidel_vales · Accepted solution]

>

> this is what i found in SM21 :

>

> 13:38:22 DIA 000 800 WASEEM MIRO Q0 E Signal c00 received by operating system

> 13:38:24 DIA 000 800 WASEEM MIRO BY 4 Database error 24909 at SEL access to table REPOLOAD

> 13:38:24 DIA 000 800 WASEEM MIRO BY 0 > ORA-24909: call in progress. Current operation cancelled

> 13:38:24 DIA 000 800 WASEEM MIRO AB 2 > Include ??? line 0000.

> 13:38:24 DIA 000 800 WASEEM MIRO AB 0 Run-time error "DBIF_REPO_SQL_ERROR" occurred

> 13:38:24 DIA 000 800 WASEEM MIRO BY 2 Database error 24909 at FET

Further the recommendations given of installing a supported oracle patch set I do think that your oracle client is not correct. upgrade also the client installation to the last version.

[Former Member]

can anyone help me with this error?