Query gives error invalid view or index DBMAN 305, DBMAN 099

[former_member515090]

Dear Experts,

We have a Bex query (input ready - planning) which is failing with the below error.. SAP BW 7.5 SP14

"Error reading the data of InfoProvider XXXX (DBMAN-305, YYY):

info: Object Name = "YYY"."0BW:BIA:XXXX", FM Name = TREX_DBS_AGGREGATE] (DBMAN-099, YYY)". The issue will be fixed after running the SE38 program RSDDB_LOGINDEX_CREATE. Is there any permanent solution ? or why this keeps occurring ?

Thanks in advance ...

[john_hawk]

Hi Akhil,

You are going to need to get an S-id and do some research ar

https://support.sap.com/en/index.html

Some hints to help you get going:

SAP Note 1977231 - DBMAN099: View or Procedure Invalidated;table or view name = 0BW:BIA:xxx:<ABC>

https://launchpad.support.sap.com/#/notes/1977231

Describes a situation similar to situation you have described.

According to the note,

Cause
The logical index(known as column view as well) of the object "ABC" on the HANA DB is corrupted. This could be caused by program errors.
Resolution

You can reconstruct the logical index using the report RSDDB_LOGINDEX_CREATE for object "ABC".

(SE38 ->run RSDDB_LOGINDEX_CREATE ->Enter "ABC" in field Infoprovier ->Execute)

Try reading data again and see if the error is solved.

Have you tried running the program?

What were the results?

Please let us know the results.

John Hawk

[itaresam_mc12]

Hello John

The Problem was solved after run report RSDDB_LOGINDEX_CREATE

Thank You !!!

[former_member869676]

Hello John

Thanks for sharing this great solution, my problem was solved.

Thank you!