SQL error 1652 occured while executing EXEC SQL

[Former Member]

Hi Friends,

SAP is performing some conversions and it is getting this error

Database error text........: "ORA-01652: unable to extend temp segment by 1280

in tablespace PSAPTEMP#"

Triggering SQL statement...: "FETCH NEXT "

Internal call code.........: "[DBDS/NEW DSQL]"

Please check the entries in the system log (Transaction SM21).

If the error occurred in a non-modified SAP program, you may be

able to find a solution in the SAP note system.

If you have access to the note system yourself, use the following

search criteria:

"DBIF_DSQL2_SQL_ERROR"

"SAPLSTD1 " or "LSTD1U18 "

"DB_ORA_EXCLUSIVE_LOCK_WAITERS"

Information on where termination occurred

The termination occurred in the ABAP/4 program "SAPLSTD1 " in

"DB_ORA_EXCLUSIVE_LOCK_WAITERS".

The main program was "EWULISLS ".

The termination occurred in line 89

of the source code of program "LSTD1U18 " (when calling the editor 890).

The program "SAPLSTD1 " was started as a background job.

Also i have extended temp table space and kept auto extended even the the issue is not resolved.

Please let me know what to do.

Thanks in advance for the help,

Regards,

Raj

Edited by: rajkum on Aug 28, 2009 10:05 AM

[stefan_koehler · Accepted solution]

Hello Raj,

it still seems that the temporary tablespace is too small to handle the SQL request.

Can you please post the corresponding SQL statement that is causing the dump?

Regards

Stefan

[Former Member · Accepted solution]

Hi Koehler,

Thanks for your response,please see the below where the termination occured.

Information on where termination occurred

The termination occurred in the ABAP/4 program "SAPLSTD1 " in

"DB_ORA_EXCLUSIVE_LOCK_WAITERS".

The main program was "EWULISLS ".

The termination occurred in line 89

of the source code of program "LSTD1U18 " (when calling the editor 890).

The program "SAPLSTD1 " was started as a background job.

Please let me know what i need to do and also i have run the program "EWULISLS" successfully as a backgroung job.

Please let me know what i need to do

Thanks,

kumar

[former_member204746 · Accepted solution]

is your name "Raj" or "Kumar" ?

your name keeps on changing.

[Former Member]

Ah yes, lets see whether you do a "lazy close"...

[former_member204746]

resize PSAPTEMP to a higher value

brspace -c -u / -f dfalter