Views invalidated

[Former Member]

Hi All,

We are having a strange issue where the cal and analytical and attribute views were working till couple of days back.

Suddenly we have started getting the error saying that invalidated views.

We have checked the note as well and checked for _SYS_REPO grants. But still we are getting this error.

Note : 1761917

[lucas_oliveira · Accepted solution]

Hello,

There must be an inactive/inexistent object (view/table) in the dependency chain of your invalid views.

If that's happening with attribute views then there are tables missing in the dependency list.

It should be easy to see those by checking the model directly (big red dot on the columns missing).

To reach those ATs try the SQL below:

select view_name from views where is_valid = 'FALSE' and view_name like '<your base package>%' and view_type = 'JOIN'

BRs,

Lucas de Oliveira

[Former Member · Accepted solution]

Hi Lucas,

I think you have hit the nail on the head. We fixed the issue last week but it took us a long time to figure out as you had mentioned. Table being invalid which affected the view directly.

Can you please guide us some more on this issue, how to check and get to know in advance so that we avoid this issue in future?

[lucas_oliveira · Accepted solution]

Hi,

Well, this should generally happen in the development system only. That's the kind of system where you have changeability. It's not really expected to change table names or make developments outside the development environment. However, there are exceptions.

Keeping that in the radar is actually more of a software quality assurance process. Adding an activity of unit/integration test prior to transport should save you from these sort of headaches and help guaranting consistency. Here's a nice blog post to get you started:

BRs,

Lucas de Oliveira