Errors accessing partition parameters for table /BIC/B0000670001

[Former Member]

Hello All,

I am new to BW administration. When loading the infocube ZOM_FID from itself, the load fails. When checking in RSMO, it gives the error message "Errors accessing partition parameters for table /BIC/B0000670001( -> long text).

Diagnosis - According to the storage parameter for database utility in the ABAP dictionary, the PSA table had been created with partitions on database &1. An error occured while accessing the partition information.

System response - The system terminates the process.

System Information - BI 7.0, SP10.

There is a note 1010672 which refers to similar problem and mentions to go to SP12 level but we have our development system which is on the same level as this system and the load was succesful there.

Please help me resolve this.

Thanks.

Fahad

[Former Member]

Also you can use the program RSAR_PSA_PARTITION_CHECK.

Execute through TC SE38 and leave default parameters.

[Former Member]

The note Chetan mentions should solve your problem.

After implementing the note try to activate the transfer rules.

If you still have problems, emtpy the PSA.

[Former Member]

Hello.

We have the same problem in our BI system 7.0 patch 11.

We implemented the Oss note 1010672 mentioned but we still have the same problem.

Mario

[Former Member]

Hello.

We solved the problem deleting PSA data and after recreating it.

Thanks.

[Former Member]

Hi Tatankam,

Can you please provide more details on how you solved this problem. I am kind of new to BW world.

Thanks,

Fahad

[Former Member]

Hello.

We had the problem that you mentioned on a partition table /BIC/B0000220002 when we activated transmission rules on 0CUSTOMER infoobjects.

We executed RSRV and we checked the partition /BIC/B0000220002 obtaining no errors but that it is not a table partitioned.

So we saw the Oss note 1010672 and we applied it but the problem wasn't solved.

So, from SE14 if we choose /BIC/B0000220002 we could see that it wasn't partitioned so this was the problem.

The table contained some records that wasn't crtitical for us so we decided to delete the table /BIC/B0000220002 and to recreate it cleanly.

To do this, we execeuted RSA1OLD transaction, go to PSA, choose the PSA related to 0CUSTOMER object e and choose delete.

After this, reactivated transmission rules on 0CUSTOMER infoobjects, and we found that /BIC/B0000220002 was recreated as empty but partioned correctly table.

I think that you could proceed in analog way but investigating on Infocube object that contains the partition /BIC/B0000670001 affected on your system.

I hope that this helps.

Mario

[former_member417211]

Hi,

I had the same problem with the activation of transfer rule of a transactional Infosource and I solved it applying the note 1010672 and its prerequirements.

I hope that this helps.

Romina

[Former Member]

Can you go to RSRV transaction code and go to PSA consistency check..

give PSA table name /BIC/B0000670001 and if it shows errors ..click on correct error and execute..

[Former Member]

Thanks for the reply Manga. I did the PSA consistency check and it did not give me any errors. The log says "PSA Table /BIC/B0000670001 is not partitioned (according to RSTSODS). Please let me know how to proceed.

Thanks,

Fahad

[Former Member]

Can you go to All Combined Tests -->Test of Partitioning Column for All Basis InfoCubes --> it displays all infocubes but you need to search your cube and ten click execute and check the log.. and correct error.

[Former Member]

Manga,

It shows that there are no partitioned Infocubes. Please help.

Fahad

[Former Member]

Check with SAP if this OSS suits you.

Note 1010672 - RSAODS 001: Error when accessing partition parameters

Raise customer message to SAP.

Hope it Helps

Chetan

@CP..