HANA Analytic Views become unusuable

[meiyalagan_kulandhivelu]

Hi,

We are using native HANA and we have created various views using the tables. But the analytic views become unusable after sometime and we end up creating it again.

Not sure, whats causing this issue.

If you look at the above screen, I can see the Red dot / red cross mark in the coloums. Any comments are welcome.

There is no change to the underlying table.

Regards,

Meiyalagan

[former_member199876]

Does it work if you recreate the exact same view again?

As Lars has mentioned,  it looks like either the table has been dropped, altered, moved to another schema or the columns renamed.

[lbreddemann]

Are the underlying tables by any chance dropped and recreated?

[meiyalagan_kulandhivelu]

Hi lars,

No, the underlying tables was created a month ago and no changes done for last couple of weeks. This view was created last friday.

@ Ajay, Yes, I can simply recreate the view again and it works fine.

Regards,

Meiyalagan