How to resolve the ERROR DBMAN 305: Error in reading the data of the InfoProvider

The issue is generally encountered when a query is executed in SAP BW. The query throws this error and does not display any data.

Issue:

Query based on a multiprovider is executed. Below error message is displayed:

Root cause:

Query is not able to find SIDs for the data. This usually happens when we try to built a query on a DataStore Object having the setting “Never Create SIDs”.

Also a query on a Multiprovider which contains at least one DSO with the setting “Never Create SIDs” will throw this error.

Resolution:

Go to the Multiprovider, find the DSO with the setting “Never Create SIDs”. Change the setting to “SID generation during Reporting” or “SID generation during Activation”. Save and activate your DSO. Activate your Multiprovider.

Please Note: The setting “SID generation during Activation” should only be checked if we want to built queries on the DSO which will be used regularly by the users. In such cases, use a cube instead of DSO as cube has star schema which is optimized for reporting if your database is ORACLE. If you are on HANA, this rule doesn’t hold valid. This setting will increase the activation time of your DSO during the data load process.

The setting “SID generation during Reporting” will create SIDs on the DSO data once the query is executed. This is optimal setting for one time adhoc queries based on the DSO. This setting will not hamper the data load times but it may create some time lapse in reports if the DSO has millions of records.

Ebooks by How2bw

Blog Stats

43,676 hits

About This Site

how2bw is a website to help SAP users mainly in BW/BI. The authors are working in projects themselves and have written posts here about the issues they faced and any concepts they want to share. how2hana.com is another such initiative for helping BW Developers to smoothly transition to BW on HANA.

Get Used to HANA

Copyright @how2bw.com, 2016. Commercial use is prohibited. How2BW is not associated with SAP AG. We have made every effort to provide accurate information. Use the content of this site at your own risk. Images on this website are copyright free or belong to the software.

how2bw is a website started by IT professional working in Business warehousing and analytics using tools like SAP BW and Query Designer with more than 6 years of experience.
The mission of this initiative is to provide handy information which is easy to understand and implement and may turn out to be very useful for those working in projects.
Mostly the software help documents are not so easy to comprehend and search for specific issues. Also the software communities may be difficult to search for.
In such cases, this website information becomes helpful as these are live scenarios experienced in the ongoing projects.
How2hana.com is another such initiative to provide smooth transition of those working in BW to BW on HANA