DBIF_REPO_SQL_ERROR

[Former Member]

Hi,

Whenever I try to activate a new source system or any other objects it gets terminated.

It generates a dump DBIF_REPO_SQL_ERROR

I am on MaxDB and I checked for the free space it is about 45%.

Following is displayed in SM21 System Log in red:

Database error -1000 at INS access to table RSOLTPSOUR

> POS(1) Too many lock requests

Database error -1000 at OPC access to table REPOLOAD

> POS(1) Too many lock requests

Run-time error "DBIF_REPO_SQL_ERROR" occurred

> Short dump "070601 212500 firefox_ NSP_00 " generated

But when I check SM12 then there are no locks displayed. Even i try search with above tables.

Details of the dump:

Runtime Errors DBIF_REPO_SQL_ERROR

Short text SQL error "-1000" occurred when accessing program

Trigger Location of Runtime Error

Program SAPLRSAOSINT

Include LRSAOSINTU08

Row 308

Module type (FUNCTION)

Module Name RSAOSINT_PSEUDO_DVERSION_WRITE

Please advice on how to get rid of this error.

Thank you,

sam

[jasonmuzzy]

For any others that wind up here with the same problem I had to go into the MaxDB Database Manager and change the MAXLOCKS parameter from 30,000 to 800,000. See SAP note <a href="https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bc_upg/~form/handler">817463</a>