RSPC1 error on table partition

[Former Member]

Hi,

we have an issue about the execution of a process chain in BI 7.0 system.

The error log says (LOAD DATA step):

Start InfoPackage xxxxx

SQL: 01.06.2011 14:17:56 BWREMOTE

ALTER TABLE "/BIC/xxxxx" ADD PARTITION

"/BIC/xxxxxxxxxxxxxxx005036" VALUES LESS THAN

(0000005036 ) TABLESPACE "PSAPBIW"

SQL-END: 01.06.2011 14:17:56 00:00:00

SQL: 01.06.2011 14:17:56 BWREMOTE

ALTER TABLE "/BIC/xxxxxxxx" MODIFY PARTITION

"/BIC/xxxxxxxxxxxxx5036" REBUILD UNUSABLE

LOCAL INDEXES

SQL-END: 01.06.2011 14:17:56 00:00:00

InfoPackage xxxxxxxxxxxxx created request xxxxxxxxxxxxxxxxx

InfoPackage xxxxxxxxxxxxx Started In Process Chain xxxxxxxxxxx; Generated Request: xxxxxxxxxxxxxx

Job finished

Can someone help us to solve this problem?

Thank you

[former_member640134 · Accepted solution]

Hello,

You need to extend the size of the Tablespace for which the PSA table belongs to.

Ask your basis team to extend the size of the Tablespace.

To find out the Tablespace to which your PSA Table belongs to :

1. Go to Tcode DB02 , on the left hand side go to Space >>> Segments >>>detailed analysis

2. In the Popup screen give the PSA table name in the field 'Segment / Object'.

3.Take the Tablspace name from the result on the righthand side

4.Check the size of the Table space name in Same DB02 TCode>>>Space >>Tablespaces>>>Overview.

Regards,

Ugendhar

[Former Member · Accepted solution]

Hi,

we checked all tablespaces in the system and no one needs to be extended (all of them are under 90%).

[Former Member]

Start InfoPackage xxxxx

SQL: 01.06.2011 14:17:56 BWREMOTE

ALTER TABLE "/BIC/xxxxx" ADD PARTITION

"/BIC/xxxxxxxxxxxxxxx005036" VALUES LESS THAN

(0000005036 ) TABLESPACE "PSAPBIW"

SQL-END: 01.06.2011 14:17:56 00:00:00

SQL: 01.06.2011 14:17:56 BWREMOTE

ALTER TABLE "/BIC/xxxxxxxx" MODIFY PARTITION

"/BIC/xxxxxxxxxxxxx5036" REBUILD UNUSABLE

LOCAL INDEXES

SQL-END: 01.06.2011 14:17:56 00:00:00

InfoPackage xxxxxxxxxxxxx created request xxxxxxxxxxxxxxxxx

InfoPackage xxxxxxxxxxxxx Started In Process Chain xxxxxxxxxxx; Generated Request: xxxxxxxxxxxxxx

Job finished

The above two Statements doesn't show us any data load step, they are regarding rebuilding and partitioning, we need the data load log.

Thanks

SM