Error in sender file adapter

[Former Member]

Hello experts,

When we are trying to pick up files using file adapter, we are getting error:

Error: com.sap.aii.af.ra.ms.api.DeliveryException: Problem inserting 05962320-1e3d-11e2-8681-925f90002003(OUTBOUND) into the database: java.sql.SQLException: ORA-01691: unable to extend lob segment SAPSR3DB.SYS_LOB0000053311C00020$$ by 8192 in tablespace PSAPSR3DB

This looks like some issue with AF message tables.

Can you please help me in resolving the issue.

Thanks,

Monika

[Former Member]

Hi Monika,

To resolve the issue you increae table space PSAPSR3DB using brtool (Oracle)

Execute command brtools by use ORA<sid>

BR*Tools main menu

1 = Instance management
2 - Space management
3 - Segment management
4 - Backup and database copy
5 - Restore and recovery
6 - Check and verification
7 - Database statistics
8 - Additional functions
9 - Exit program

Choose option 2

Database space management

1 = Extend tablespace
2 - Create tablespace
3 - Drop tablespace
4 - Alter tablespace
5 - Alter data file
6 - Move data file
7 - Additional space functions
8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

Choose option

etc.............................

This may help you.

Regards

Ganesh Datt Tiwari

[Former Member]

Hi Ganesh,

How do we connect the brtool to PI system for executing these options ?

Thanks,

Monika

[Former Member]

Hi Monika,

What is plateform of your system ?

Regards

Ganesh Datt Tiwari

[Former Member]

Hi Ganesh,

It is on ORACLE 10.2.0.2.0.

[rajasekhar_reddy14]

Hi ,

Please check BC_MSG table space also,ask your basis team to change auto extend mode to extend table space and ask them to delete old entries from all tables.

Regards,

Raj

[Former Member]

Hi Raja,

We are running PI 7.0, is the table name you mentioned relevant for this version.

thanks,

Monika

[rajasekhar_reddy14]

BC_MSG is JAVA table , using SE11 is not possible to view but you can check entries at OS level .

[Former Member]

Hi Monika,

Oracle release is too old which is also out of suport.

Please plan to upgrade the same at least release 10.2.0.5.

You can run BRTOOLS tool

if OS is UNIX  then just execute comand brtools after login with ORA<SID> user

If Windows run brtools exe

Regards

Ganesh Datt Tiwari

[aashish_sinha]

Hi,

looks like Tablespace problem for the indicated tablespace PSAPSR3DB. It says that the table space you are using can not allocate more space

use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

Regards

Aashish Sinha