CRM 7 Ehp 1: Interactive Reporting - data source - virtual provider
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?
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.