DBIF_RSQL_SQL_ERROR

[Former Member]

Hi SAP Guru's

I am getting DBIF_RSQL_SQL_ERROR every 15 minutes. I am pasting the full dup here. Please suggest the solution

-

---

Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

Date and Time 21.12.2007 16:19:38

Short text

SQL error in the database when accessing a table.

What can you do?

Note which actions and input led to the error.

For further help in handling the problem, contact your SAP administrator

.

You can use the ABAP dump analysis transaction ST22 to view and manage

termination messages, in particular for long term reference.

How to correct the error

Database error text........: "ORA-00604: error occurred at recursive SQL level

1

ORA-01013: user requested cancel of current operation"

Internal call code.........: "[RSQL/INSR/ALCLASTOOL ]"

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_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

"SAPLSALU" or "LSALUU26"

"SALU_TOOL_SET_FROM_DB"

If you cannot solve the problem yourself and want to send an error

notification to SAP, include the following information:

1. The description of the current problem (short dump)

To save the description, choose "System->List->Save->Local File

(Unconverted)".

-

---

Vinay Patel

[Former Member]

Please check note: 1573235 also

[Former Member]

Hi Vinay,

Run brtools and check the datafiles freespace.

Ensure that you don't have any datafiles with 90% of utilization.

Extend if necesary.

[Former Member]

Thanx

[Former Member]

Hi

Cause is job SAP_RSICFDLT which is run as one of the SAP stats collector programs.

See SAP note 966631.

You should consider whether the job ought to be running or not (is the SAP Internet Connector Framework active in your system, for HTTP/ HTTPS/ SMTP comms? Have parameters been configured in profile? Did you do a system copy without replicating necessary profile parameters?).

Run ST03N and modify your stats collection requirements if needed (I reverted to the default collectors, which excludes the above job).

Hope this helps someone... I was getting it on ECC6 and NW700 on Oracle 10.2 (Windows Server 2003).

Cheers...

[Former Member]

HI Vinay

Errors occur that are triggered by the runtime error dbif_rsql_sql_error with the exception cx_sy_open_sql_db. This error is caused by a deadlock at database level in the table crmd_orderadm_h. The relevant dump displays the termination in the function module BBP_HEADER_DB_UPDATE.

This problem is caused by a program error.

Regards,

Gokul B

[stefan_koehler]

Hello Vinay,

have a look at sapnote #618861 ... it is describing the problem with ORA-00604 in conjunction with ORA-01013.

Regards

Stefan

[Former Member]

Check If any Table Space is more then 90% of use...!!

[Former Member]

Hi,

The manual interface change can be made as follows:

Call transaction SE37.

Change the 'TSTR_GENERATE' function module.

Change the 'Exceptions' screen.

Add a new ENQUEUE_NOT_POSSIBLE exception with a 'Lock not possible' short text.

Save the function module.

Hope this helps,

Regards,

Rajesh

[Former Member]

If you have not already done it, check SM37 for jobs that are running every 15 minutes. Then view the job log for these to find any errors. Use what you find in the logs to search the notes (to find any known issues) or these forums for further hints.

Hope that helps.

J. Haynes

Denver