Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Error creating view: ERROR: relation "XXX" does not exist

I'm periodically seeing transform components invalidate with this error message. Sometimes I can clear it by rebuilding tables and sometimes by removing connections and recreating them. Does anyone know the cause of this error and whether there is some systematic way to determine the source, rather than trial and error?

Thanks!

1 Community Answers

Matillion Agent  

Ian Funnell —

Hi Dov,

Thanks for this question. That error means something has caused one of Matillion’s views to be dropped.

It’s usually because one of the source objects has been dropped, with CASCADE specified. There are probably processes in (or maybe outside) Matillion which are dropping or recreating tables which Matillion jobs use.

Best regards,
Ian

Post Your Community Answer

To add an answer please login