DBIF_DSQL2_SQL_ERROR

[Former Member]

Hi All,

I get the following error in st22 :

ABAP runtime errors DBIF_DSQL2_SQL_ERROR

Occurred on 28.06.2009 at 12:18:05

-

---

SQL error 1652 occurred when executing EXEC SQL.

-

---

What happened?

-

---

The error occurred in the current database connection "DEFAULT".

-

---

What can you do?

-

---

Note the actions and input that caused the error.

Inform your SAP system administrator.

You can print out this message by choosing "Print". Transaction ST22

allows you to display and manage termination messages, including keeping

them beyond their normal deletion date.

-

---

Error analysis

-

---

-

---

How to correct the 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"

Thanks in advance

Shams

[markus_doehr2 · Accepted solution]

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

> in tablespace PSAPTEMP

Your temp segment is too small.

Try the following:

- http://service.sap.com/notes

- Enter "ORA-01652" as search term

Markus

[anindya_bose]

Hi

Increase your PSAPTEMP tablespace. This should resolve our issue

Thanks and Regards

Anindya

[Former Member]

Hi Anindya/Markus,

When i type sapdba-u / iam getting following error:

SAPDBA: SELECT USERID FROM "OPS$DL3ADM".SAPUSER

ORA-01002: fetch out of sequence

(2009-06-29 11.34.38)

SAPDBA: Error reading all SAP% schemas.

Can you please let me know what to do.

Thanks in advance.

Shams

[markus_doehr2]

> When i type sapdba-u / iam getting following error:

sapdba?

What database version is that?

Markus

[Former Member]

Hi Markus,

Its working fine now .don't know why it not worked earlier.

Thanks for your response

Shams

[Former Member]

hello,

ORA-01652: unable to extend temp segment by 1280

in tablespace PSAPTEMP.

Check for PSATEMP table space using the brtools.

thanks,

Prasanna