Abap Dump DBIF_RSQL_SQL_ERROR

[Former Member]

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

[Former Member]

Hi,

Use

sqlplus / as sysdba
alter tablespace PSAPTEMP drop tempfile '/oracle/QAS/sapdata2/temp_1/temp_data2';

Regards,

Mark

[Former Member]

Thanks Marks, for your good reply.Now my Problem has been solved.

kallis

[Former Member]

Yes,

PSAPTEMP has size 0; in order to be able to use it, you will have to add at least one file, using either one of the methods you mentioned.

regards

PS: In case you are going to use SQL:

You will have to give the full path name. And this is probably a bit longer than '/sapdata2/temp.data1'.

Edited by: Joe Bo. on Apr 7, 2009 10:00 AM

[Former Member]

Thanks for your reply. I have added via BRTOOLS. But by mistake i have add one file system without .data extension.

quality :/oracle/QAS/sapdata2#ll

total 0

drwxr-xr-x 2 root root 96 Feb 17 16:19 lost+found

drwxrwxrwx 2 oraqas dba 96 Feb 18 14:29 sr3700_5

drwxrwxrwx 2 oraqas dba 96 Feb 18 14:32 sr3700_6

drwxrwxrwx 2 oraqas dba 96 Feb 18 14:35 sr3700_7

drwxrwxrwx 2 oraqas dba 96 Feb 18 14:38 sr3700_8

drwxrwxrwx 2 oraqas dba 96 Feb 18 13:58 sr3_10

drwxrwxrwx 2 oraqas dba 96 Feb 18 13:59 sr3_6

drwxrwxrwx 2 oraqas dba 96 Feb 18 14:00 sr3_7

drwxrwxrwx 2 oraqas dba 96 Feb 18 14:00 sr3_8

drwxrwxrwx 2 oraqas dba 96 Feb 18 14:01 sr3_9

drwxrwxrwx 2 oraqas dba 96 Apr 7 14:12 temp_1

drwxrwxrwx 2 oraqas dba 96 Apr 7 14:31 temp_2

quality :/oracle/QAS/sapdata2#cd temp_1

quality :/oracle/QAS/sapdata2/temp_1#ll

total 4546752

-rw-rw-rw- 1 oraqas dba 2097160192 Feb 17 18:41 temp.data1

-rw-rw---- 1 oraqas dba 2097160192 Apr 7 14:41 temp_data2

quality :/oracle/QAS/sapdata2/temp_1#

How I can remove temp_data2* file

Thanks

kallis