Skip to Content
0
Former Member
Aug 28, 2009 at 08:04 AM

SQL error 1652 occured while executing EXEC SQL

638 Views

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