How do you restart automatically an IAL that has errored?
We get this quite a lot, and I’m not sure why, the IAL is simple enough, to create data for a lobby.
This is the error:
Table was recreated empty due to error [ORA-20105: IalObject.ERRDIMSQL: Error when executing statement. Reported error is "ORA-04061: existing state of has been invalidated"]. Redo replication manually ORA-20105: IalObject.REPTABEMPTY
Once I set off the job again, it goes back to it’s routine, running every hour.
Any thoughts?