Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Abap Dump DBIF_RSQL_SQL_ERROR

Dear Team,

I am facing abap Dump in my Server.

Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

Date and Time 07.04.2009 12:03:38

How to correct the error

Database error text........: "ORA-25153: Temporary Tablespace is Empty"

Internal call code.........: "[RSQL/READ/BSEG ]"

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"

"J_1IEWT_PROVISIONS" or "J_1IEWT_PROVISIONS"

"VALIDATE_GSBER"

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

When I check my Temporary Tablespace via brtoools

List of database tablespaces

Pos. Tablespace Type Status ExtMan. SegMan. Backup Files/AuExt.

Total[KB] Used[%] Free[KB] ExtSize[KB] FreeExt. Largest[KB]

1 - PSAPSR3 DATA ONLINE LOCAL AUTO NO 30/30

72417280 74.88 18191552 91955200 8 8192000:8192000:8192000:8192000:8192000+

2 - PSAPSR3700 DATA ONLINE LOCAL AUTO NO 28/28

98267136 77.36 22250816 84549632 27 6471680:6430720:6225920:6205440:6205440+

3 - PSAPSR3USR DATA ONLINE LOCAL AUTO NO 1/1

20480 9.69 18496 10219520 1 10219520+:18496:0:0:0

4 - PSAPTEMP TEMP ONLINE LOCAL MANUAL NO 0/0

0 0.00 0 0 0 0:0:0:0:0

5 - PSAPUNDO UNDO ONLINE LOCAL MANUAL NO 1/1

9154560 1.53 9014848 1085440 45 4063232:3206144:1085440+:1028032:266240

6 - SYSAUX DATA ONLINE LOCAL AUTO NO 2/2

450560 59.87 180800 10838016 48 10014720:823296:159680:3072:1600

7 - SYSTEM DATA ONLINE LOCAL MANUAL NO 2/2

1679360 51.89 807872 10657792 5 9400320:1257472:783296:12288:11200

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


here PSAPTEMP is 00.

So can I add one data file in 4 option.

via

SQL>alter tablespace temp add tempfile

'/sapdata2/temp.data1' size 200M reuse

autoextend on next 10M maxsize 20000M

or via BRtools

thanks

Not what you were looking for? View more on this topic or Ask a question