java.sql.SQLException

[Former Member]

Hi All,

While processing the XML file the following errors occured in the Audit log (sender Communication channel).

1.

Putting message into send queue failed, due to: com.sap.aii.af.ra.ms.api.DeliveryException: Problem inserting 3d2bb1d1-eb9e-4363-218d-83470849bc1f(OUTBOUND) into the database: java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP

2.

Returning to application. Exception: com.sap.aii.af.ra.ms.api.DeliveryException: Problem inserting 3d2bb1d1-eb9e-4363-218d-83470849bc1f(OUTBOUND) into the database: java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP

3.

Attempt to process file failed with com.sap.aii.af.ra.ms.api.DeliveryException: Problem inserting 3d2bb1d1-eb9e-4363-218d-83470849bc1f(OUTBOUND) into the database: java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP.

Thanks,

Satish.

[Former Member · Accepted solution]

Hi Satish

follow these steps

1)Temporary Tablespace is Empty

This error is the result of your oracle database which has been filled up. You need to extend your temp table space.

/thread/58277 [original link is broken]

/thread/174812 [original link is broken]

2) also .Check your authorization settings in XI and R/3. Whether the user has sufficient rights to execute the Function Module etc. This is the most common reason for this error.

3.If the XI system was brought online even before the R/3 system then re-activate the communication channels from the Integration directory.

Thanks

Sandeep

PS if helpful kindly reward points

[Former Member]

Hi Satish,

Go thru these discussions

Regards,

sri...

[Former Member]

Hi,

Thanks for your valuable suggestions.

Thanks,

Satish.

[Former Member]

hi ,

I have found sothing useful for you

which may help you to solve ur problem.

you can solve above problem by adding tempfile to existing tablespace or resize ex

w/o autoextend clause

sql> alter tablespace PSAPTEMP add tempfile '/<your location>tbs_psatemp_02.dbf' size 1000m;

with autoextend clause

sql> alter tablespace PSAPTEMP add tempfile '/<your location>tbs_psatemp_02.dbf' size 1000m autoextend on next 10m maxsize <size>;

you can also have a look into

kindly reward points if ussful

regards,

Sumit Gupta

[Former Member]

Hi,

Check authorization for your ID and the table space. Thanks.

Regards,

Indira D