Table /bic/b0000404000

[Former Member]

Hi Gurus,

Our Bases guy trying to improve performance of the systems.

He founds out the table /bic/b0000404000 got really huge in January this year.

Can anyone tell me which BI object he is referring to?

Thanks,

[former_member188080 · Accepted solution]

Hi,

This object is PSA table.

You are doing full load from this datasource and setting will be first in PSA and then datatarget in update.

so since you are not deleting PSA table is growing larger and larger day by day.

so what you need to do is to delete the older PSA request so say older than 7 days or 30 days whatever strategy you want to go with.

so once you are done with this you should not get this error. You also have process type in process chain which does this. Just you need to include same in PC.

Thanks and regards

Kiran

[Former Member]

Looks like a PSA table, which should have the request id, data package and the another third field as key fields.

You should delete old request in this table to avoid memory shortages on your database, recommendation not older than sixth month. If you load data very often you could also delete data in this table monthyl or even weekly.

[Former Member]

How to find which DataSource?

[Former Member]

Goto SE11 --> enter table name /bic/b0000404000 -

the datasource name can now be seen in the description field,

[Former Member]

Cool, so the DataSource is 0CO_OM_CCA_1 (3.X). There is only one InfoPackage (full load). In the process chain I do have the 'Delete overlaping request' from the cube so the cube is fine but the DataSource is getting bigger.

What should be the stratigy to clean up the DataSource?