on 10-05-2011 12:11 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
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
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.