cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to activate infocube in BW

Former Member
0 Kudos

Hello,

I have a problem to activate any infocube in DEV BW (and also in PROD BW).

During activation of infocube these errors occures:

Activation of objects with type Infocube

Internal activation ( Infocube)

Activate all dictionary objects (15)

Error / warning in dict. activator, detailed log --> Detail

Table /BIC/DZSD_C031 must be created in the database

The SQL statement was not executed

Table /BIC/DZSD_C031 (Error adjusting the database)

Any idea?

Thanks a lot.

Best regards,

Martin Laurinec

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hello,

thanks to all.

It was solved with the help of our basis team. There was an error in program which creates tables on database. SAP Note 2035350

Best regards,

Martin Laurinec

Former Member
0 Kudos

Hi,

Please check the number of records in the cube which is modified?

Pl check the SM21 log and contact your basis team if they can adjust and activate the dimension table with out deleting data.

Ideally if there is large volume it is advised follow the following steps in order .

  1. Create a back up cube taking the reference of the orignal cube.
  2. Load data from the original to back up cube
  3. Compare the data between original and back up cube.
  4. Delete data from original cube.
  5. Send the transport to modify the cube structure (dimension in this case).
  6. Load data back from back up cube to the original cube.

Regards

RamanKorrapati
Active Contributor
0 Kudos

Hi Martin,

At Dev system,

Try to do the RSRV tests on Cube E/F Fact tables and rectify it if any issues exist.

Later with help of Basis team you can adjust E/F fact tables thru SE14.

Thanks

prakashsingh14
Explorer
0 Kudos

Hi Martine

Have you added new infoobj to your cube. If yes, please check if they are active. Also check if this dim table is present in your cube. Try using se14 for activating the same.

Thanks

Prakash

former_member202257
Contributor
0 Kudos

Try running RSRV tests on the mentioned cube. Also, you can try FM RSDG_CUBE_ACTIVATE to try activating the cube