Short dump DBIF_RSQL_SQL_ERROR

[#1]

Hello,

We are facing a short dump in the ERP Production system - DBIF_RSQL_SQL_ERROR.

We don't understand why this sometimes happens!

I sent to you attached to this message the short dump (DBIF_RSQL_SQL_ERROR.txt).

The error text in the database is this: ORA-00060: deadlock detected while waiting for resource

Can you help us please in way to understand how can we solve this error?

Thank you,

samid raif

DBIF_RSQL_SQL_ERROR.txt.zip

[Reagan]

This is basically an issue with the application.

The database is working in the way it is designed.

UPDATE "ZGLT_REG_MAT" SET "STAT_ACCAO"=:A0,"STAT_EXP_CENTRO"=:A1,"STAT_EXP_ORGVEND"=:A2,"DATUM"=:A3 WHERE "MANDT"=:A4 AND "WEBSERVICE"=:A5 AND "CODIGO_MATERIAL"=:A6

The deadlock happened during an update in the table ZGLT_REG_MAT.

Check what the program ZGLR_ASTREIN_EXPANSAO_MAT2 is for.

Regards

RB