RSDDB_LOGINDEX_CREATE / RSDDB_INDEX_CREATE_MASS :
After we migrate a BW system to a BW on SAP HANA, all InfoProviders must have so called column views. These views are needed for reporting. If a new BW Infoprovider(InfoObject) is created, the associated column view is generated during activation.
If column views do not exist (or are incorrect), the provider is inconsistent and BW queries based on it will fail. With the report mentioned below screenshot and you need to recreate column views: in order to fix.
- For single InfoProviders, also the report RSDDB_LOGINDEX_CREATE can also be used to recreate the views. More details see: 1977231
- The report RSDDB_INDEX_CREATE_MASS can be used to (re-)create or delete these column views (e.g. all views for a certain type of InfoProvider). It was delivered with SAP note: 1982150 - Deletion / creation of InfoProvider column views on SAP HANA not possible for TLOGO types
As mentioned in note 1977231, there is no way to check the consistency of column views. In case of issue, please recreate the views by using these function modules to the corrupted providers
After apply some notes to fix known issues, the ABAP code will be correct. However the column views that are generated based on previous code might be still inconsistent with currect code. This may lead to DBMAN error, or even wrong query result. Therefore it is always recommended to rebuild the logic index by using reports above. For HCPR, please also make sure all column views of providers are recreated/regenerated
Example:
We have an issue while accessing reports like shown in below screenshot
We have recreated by using the program "RSDDB_LOGINDEX_CREATE" for the corrupted provider "DBSDSO09" DSO
Please find the below screenshots for reference.
(1)
(2)
. We have to give Object type(TLOGO) , Here we are recreating it for DSO, SO we gave as "ODSO"
. We have to give the Corrupted info provider name in "Infoprovider" tab.
(3) Click on Execute
After completion it will throw a message like Column views have generated
(4) Now you can refresh the report to fetch the data