cancel
Showing results for 
Search instead for 
Did you mean: 

CRM 7 Ehp 1: Interactive Reporting - data source - virtual provider

Former Member
0 Kudos

Hi All

I have completed all the config necessary for interactive reporting on my CRM an BI client.

When I run the config wizard (/crmbw/config_wizard) I am getting the following errors....

"There is still no data source assigned to VirtualProvider /CRMBW/SVRQ_C01"

"No direct access for InfoProvider /CRMBW/SVRQ_C01 and source system (SOURCECLNT)"

I cannot figure out what I'm missing from the config.

Has anybody come across this problem?

Accepted Solutions (1)

Accepted Solutions (1)

joaquin_fornas
Active Contributor
0 Kudos

Hi, Clayton

Can you please activate the direct access for the virtual providers.

For activating the direct access Go to TX: RSA1->infoproviders-> Business Information-> BI Statistics->select Virtual provider->

Go to context menu of the virtual cubes-> Activate Direct Access

Also, the most common errors are explained in SAP notes [1263075 |https://service.sap.com/sap/support/notes/1263075] and [1146395|https://service.sap.com/sap/support/notes/1146395].

Please check that all infoproviders there is a transfer structure /transfer rule assigned for all systems.

Regards

Joaquin

Former Member
0 Kudos

Thanks, activating the direct access helped to resolve many of the issues. However, I'm still getting the same error for two more providers, ie: /CRMBW/TA_ID and /CRMBW/SLQ_ID.

When I try activating the direct accesses for these two there is no source client to choose from.

Could I try reinstalling these info providers?

Former Member
0 Kudos

Hi!

The objects are part of Report Areas Sales Quotation and Sales Order. Try re-activating those report areas.

For the direct access problem: If you are in a single-client environment (only one CRM client as source system for the BW client), you should set parameter OLTP_LOCKMODE in table RSADMIN to "PER_LOGSYS" (or delete that parameter). In a multi-client environment (more than one CRM client) you should set this parameter to "PER_USER", and additionally apply note 1044155.

Those configuration steps (except applying the note) an be done directly from within the config wizard.

Best regards

Former Member
0 Kudos

Thanks!!

nelson_raj2
Active Participant
0 Kudos

Thanks Sven, saved my life today

Answers (0)