cancel
Showing results for 
Search instead for 
Did you mean: 

BI Content Activation Error in Solution Manager 7.1 SPS10

Former Member
0 Kudos

Hi Guys,

I have issues on start the BI Content Activation in Technical Monitoring --> Configure Infrastructure --> Reporting-Settings with error as below in SM37:-

Job started

Step 001 started (program CCMSBI_SETUP_BATCH, variant , user ID SM_BW_ACT)

Scenarios to be Activated:  ALM KPI_REP

Authorization check failed: S_DEVELOP

Authorization check failed: S_RS_ADMWB

Authorization check failed: S_RS_ICUBE

Authorization check failed: S_RS_ODSO

Authorization check failed: S_RS_ISOUR

Authorization check failed: S_BDS_DS

Note: Role SAP_SM_BI_ADMIN contains all required authorization

Prerequisites check failed

Job cancelled

Created all SM users in solman_workcenter and all requires roles are assigned, do you guys experienced this and is there any solution for this ?

Many Thanks in advance,

Dan

Accepted Solutions (1)

Accepted Solutions (1)

roland_hennessy
Contributor
0 Kudos

Hi Dan,

The user SM_BW_ACT that is used for content activation requires
role SAP_BI_E2E. Please check follwiong note and update this role,
ensure it is fully generated and assigned to the user:

1570399 - Solution Manager BI reporting .Additionally, please also update the role for user SM_EXTERN_WS as indicated in this KBA:
1830873  Roles for user SM_EXTERN_WS - Solution Manager 7.1

This should help.

Kind regards,

Roland

Former Member
0 Kudos

Hi Roland,

Found the root cause was due to role "SAP_SM_BI_ADMIN" needs to be regenerated.

After that issues were resolved.

But now came out with another errors as below:-

Job started

Step 001 started (program CCMSBI_SETUP_CONTROLLER, variant , user ID SM_BW_ACT)

Job CCMS_BI_SETUP_20140228033515 successfully scheduled.

RUNNING: Current Status: RUNNING

INFO: Job CCMS_BI_SETUP successfully scheduled

INFO: Scenarios to be Activated:  ALM KPI_REP

INFO: 707 0005

INFO: Setup step SPECIAL_CHARS started (28.02.2014 04:07:25)

INFO: 710 0008

INFO: Setup step SPECIAL_CHARS complete (28.02.2014 04:07:25)

INFO: Setup step CONTENT_REPAIR started (28.02.2014 04:07:25)

INFO: Setup step CONTENT_REPAIR complete (28.02.2014 04:07:25)

INFO: Setup step ACTIVATE_CRITICAL started (28.02.2014 04:07:25)

INFO: Setup step ACTIVATE_CRITICAL complete (28.02.2014 04:07:50)

INFO: Setup step ACTIVATE_INFOOBJ started (28.02.2014 04:07:50)

INFO: Setup step ACTIVATE_INFOOBJ complete (28.02.2014 04:09:03)

INFO: Setup step ACTIVATE_INFOAREA started (28.02.2014 04:09:03)

INFO: Setup step ACTIVATE_INFOAREA complete (28.02.2014 04:09:09)

INFO: Setup step ACTIVATE_CATALOG started (28.02.2014 04:09:09)

INFO: Setup step ACTIVATE_CATALOG complete (28.02.2014 04:09:35)

INFO: Setup step ACTIVATE_INFOPROV_F started (28.02.2014 04:09:35)

ERROR:  errors while content activation occured

ERROR: RFC destination XXXCLNT100 for BW is not maintained in source system

ERROR: RFC destination XXXCLNT100 for BW is not maintained in source system

ERROR: RFC destination XXXCLNT100 for BW is not maintained in source system

ERROR: Error when creating the export DataSource and dependent Objects

ERROR: Error when activating DataStore Object 0CCMCURR

ERROR: RFC destination XXXCLNT100 for BW is not maintained in source system

ERROR: RFC destination XXXCLNT100 for BW is not maintained in source system

ERROR: RFC destination XXXCLNT100 for BW is not maintained in source system

ERROR: Error when creating the export DataSource and dependent Objects

ERROR: Error when resetting DataStore Object 0CCMCURR to the active version.

I have checked in RSA1 the source system has defined and activated and RFC is working.

Do you have any idea what was causing the errors ?

Many Thanks,

Dan

0 Kudos

Dear Dan,

did you get a solution for your problem? I have a similar one.

Job started

Step 001 started (program CCMSBI_SETUP_CONTROLLER, variant , user

Job CCMS_BI_SETUP_20150722170531 successfully scheduled.

RUNNING: Current Status: RUNNING

INFO: Job CCMS_BI_SETUP successfully scheduled

INFO: Scenarios to be Activated:  UPL

INFO: 707 0007

INFO: Setup step SPECIAL_CHARS started (22.07.2015 17:05:36)

INFO: 710 0010

INFO: Setup step SPECIAL_CHARS complete (22.07.2015 17:05:38)

INFO: Setup step CONTENT_REPAIR started (22.07.2015 17:05:38)

INFO: Setup step CONTENT_REPAIR complete (22.07.2015 17:05:38)

INFO: Setup step ACTIVATE_INFOOBJ started (22.07.2015 17:05:38)

INFO: Setup step ACTIVATE_INFOOBJ complete (22.07.2015 17:10:50)

INFO: Setup step ACTIVATE_CATALOG started (22.07.2015 17:10:50)

INFO: Setup step ACTIVATE_CATALOG complete (22.07.2015 17:11:04)

INFO: Setup step ACTIVATE_INFOPROV_F started (22.07.2015 17:11:04

ERROR:  errors while content activation occured

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

ERROR: The SQL statement was not executed

ERROR: Table /BI0/F0SM_UPL_M (Error adjusting the database)

ERROR: The SQL statement was not executed

ERROR: Table /BI0/F0SM_UPL_W (Error adjusting the database)

ERROR: Table /BI0/F0SM_UPL_M could not be activated

ERROR: Table /BI0/F0SM_UPL_W could not be activated

ERROR: Return code..............: 8

The different is we are on SP12.

best regards

Andreas Adler

Answers (0)