We are getting the Dump DBIF_DSQL2_SQL_ERROR

[Former Member]

Hi Friends,

We are getting the dump DBIF_DSQL2_SQL_ERROR in our BW system.

We have seen that when a program run by user SAPSYS in client 000 and we have 6 DI but this dump is coming only on one instance.

The error 12805 occurred in the current database connection "DEFAULT".

Database error text........: "ORA-12805: parallel query server died
unexpectedly"
Database error code........: 12805
Triggering SQL statement...: "FETCH NEXT "
Internal call code.........: "[DBDS/NEW DSQL]"
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_DSQL2_SQL_ERROR" " "
"SAPLSDO0" or "LSDO0U19"
"SDO0_GET_DF_SPACE_INFO"

Regards

Ganesh

[Former Member]

Hello Ganesh,

please check notes

1173713 ORA-00904 in RZ20 Oracle remote monitoring with  Version 9.X

  363546  ORA-12805 or ORA-7445[kkehbs()] or ora-3113

if this does not help we will need the whole dump if you can attach it to the thread.

Regards,

Javier

[former_member207463]

Hi,

The ORA-12805 error indicates that a parallel query process terminated in a hard way. In this case you have to analyze trace files and the alert log.

Best regards,

Jeisson Leonel

[Former Member]

Hi,

can you please check the database alert log.

• ORA-12805: parallel query server died unexpectedly

           This error indicates that a parallel query process terminated in a hard way. In this case you have to analyze trace files and the alert log for more information.

Please check that all the tablespace have space.

Alos check the below note.

Thanks

Rishi Abrol

[Former Member]

Hi Rishi,

Thanks for your reply.

Note is missed in your communication.

Regards

Ganesh

[Reagan]

Hello

Have you checked the trace files and also the alert log ?

There should be more information to analyze what the issue is.

Regards

RB

[Former Member]

Hi RB,

Thanks for your reply.

Where can i find the tace and log file ?

Regards

Ganesh

[Reagan]

Hello

If you are on 10G it should be under /oracle/SID/saptrace/background

on 11G /oracle/SID/saptrace/diag/rdbms/sid/SID/trace

Regards

RB

[Former Member]

Hi,

I dint paste the note as it was very old version. What Basis patch you are at.

Why i asked you to check the table space as this function tryies to tell you if enouf space is there in database ore temporary table space.

Thanks

Rishi abrol

[Former Member]

Hi Rishi,

Thanks for your reply.

We have Oracle 11.2.0.3 and Linux 2.6.

SAP_BASIS 701 Patch 6.

Regards

Ganesh

[former_member188883]

Hi Ganesh,

Please refer this SAP note

Note 1528754 - Incorrect space display for PSAPTEMP in RZ20 with Oracle 11g

Regards,

Deepak Kori