Error while infocube repartitioning.

[Former Member]

Hi,

While repartitioning infocubes i always get an error as soon as the request starts. ( no matter if the repartitioning is add/merge or complete i still get the error) The first step CREA_SHD_EFACT cannot be completed.

We did found an oss note (1272885) and apply it with basis team members and manage to do one successfull repartitioning (made an add), but when i try to do another one (for example merge for the same cube or complete for an other one) i got the same error again.

Could anyone help?

Thanks.

Dogan.

[former_member223744 · Accepted solution]

Hi.

I don't know what is your database nor your system level.

I found some notes which talk about this issue for 2 databases and explain this process.

1060552 Complete repartitioning terminates in step CREA_SHD_EFACT

1019725 MSSQL: Supplementary SAP Note for repartitioning: Amendments

1016185 ORA Repartitioning: Merging partitions

1016184 ORA repartitioning: Attaching partitions

1008833 Supplementary SAP Note about repartitioning

I hope I can be helpful.

Thanks.

Walter Oliveira.

[Former Member · Accepted solution]

Hi,

Our database is oracle and system level is 17.

Thanks,

Dogan.

[former_member223744]

Hi Dong.

I guess the better way to solve this issue is opening a SAP OSS Ticket.

Them SAP Consultants can check this issue more deeply in your system.

I hope I could be a lit bit helpful.

Thanks.

Walter Oliveira.

[Former Member]

Hi Walter,

You've been very helpfull and thank you very much for that.

Regards,

Dogan.

PS: it's not Dong, it's Dogan by the way

[former_member223744]

Hi,

Check also if some ORA error happened during the process in SM21 transaction.

Thanks,

Walter Oliveira.

[Former Member]

Hi,

Thanks for all your efforts but we couldn't manage to solve the problem with the existing notes,

also there are no ORA errors seen in SM21 transaction.

We'll be opening a new OSS note i think.

Regars,

Dogan.

[former_member223744]

Hi.

Then please check the notes below to check this issue.

1016185 ORA Repartitioning: Merging partitions

1016184 ORA repartitioning: Attaching partitions

1008833 Supplementary SAP Note about repartitioning

Could you plase explain in more details the error found?

Please copy exactly the error message and paste in this thread.

Thanks,

Walter Oliveira.