DBIF_RSQL_SQL_ERROR

Former Member — Wed, 12 Jan 2011 12:46:36 GMT

Hi Experts,

We are doing upgradation from 4.7EE to ECC6.

I have runned the BSEG table in background in the client 000 for activation. The job got cancelled and its showing the following error.

DBIF_RSQL_SQL_ERROR.

Short text

SQL error in the database when accessing a table.

How to correct the error

Database error text........: "ORA-01653: unable to extend table SAPDEV.QCMBSEG

by 8192 in tablespace PSAPDEV"

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

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"

"%_T00320" or "%_T00320"

"DATA_COPY"

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)".

2. Corresponding system log

Display the system log by calling transaction SM21.

Restrict the time interval to 10 minutes before and five minutes

after the short dump. Then choose "System->List->Save->Local File

(Unconverted)".

3. If the problem occurs in a problem of your own or a modified SAP

program: The source code of the program

In the editor, choose "Utilities->More

Utilities->Upload/Download->Download".

4. Details about the conditions under which the error occurred or which

actions and input led to the error.

The exception must either be prevented, caught within proedure

"DATA_COPY" "(FORM)", or its possible occurrence must be declared in the

RAISING clause of the procedure.

To prevent the exception, note the following:

Please suggest <removed by moderator>. Thanks in advance.

Thanks & Regards,

Tanuja.

Edited by: Thomas Zloch on Jan 12, 2011 2:37 PM - priority normalized

Re: DBIF_RSQL_SQL_ERROR

ThomasZloch — Wed, 12 Jan 2011 13:41:24 GMT

The system tried to adjust table BSEG, creating a temporary table QCMBSEG, which duplicates the disk space needed to store the data. I assume your BSEG is very large, as usual.

Talk to your system admins to make some more room available in tablespace PSAPDEV, then adjusting BSEG can be continued, probably via SE14, but once again, talk to your system admins (sometimes called "basis people"), they should now how to handle such errors during system upgrades.

Thomas

P.S. please don't tell me that you are the system admin

Re: DBIF_RSQL_SQL_ERROR

Former Member — Thu, 13 Jan 2011 12:10:03 GMT

Probably you don't really want to convert table BSEG.

Look for SAP notes how to avoid it.

For a start have a look at Note 24864 - No conversion of the table BSEG

Re: DBIF_RSQL_SQL_ERROR

Former Member — Thu, 13 Jan 2011 13:02:13 GMT

Thank you Thomas. I consulted my basis team regarding this.

My issue got solved.

topic Re: DBIF_RSQL_SQL_ERROR in Application Development and Automation Discussions

DBIF_RSQL_SQL_ERROR

Re: DBIF_RSQL_SQL_ERROR

Re: DBIF_RSQL_SQL_ERROR

Re: DBIF_RSQL_SQL_ERROR