REPOST FROM ADMINISTRATION & IT
Hey y'all.
I already have a Support ticket open that I've had to reopen 3 times now, as this issue keeps circling back... We are a self-hosted environment running analytics between our Test (data warehouse) and Analytics (cubes) servers (this will change in FY21, but it is currently not feasible to throw these on the same server). About every two weeks, my incremental load fails on Step 2. PROCESS_CUBES with the following error:
Contributions cube build unsuccessful, the cube does not exist [SQLSTATE 42000] (Error 50001)
Checking the server console, I find my cubes have stopped, but I'm able to restart with no issue. I've restarted the following services (all set to Automatic Delayed Start) on our Analytics server.
Sisense.CLRConnectorsContainerSisense.DiscoverySisense.ECMLogsPersistenceServiceSisense.HouseKeeperSisense.JVMConnectorsContainerSisense.OrchestratorSisense.OxygenSisense.PulseSisense.Repository
All our servers are set to restart weekly - on Monday's at 4am. So far, I'm not seeing a direct correlation between the server restarts and the incremental loads failing. We were failing all through the holidays, so at this point, my log viewer doesn't go back far enough to compare time/dates of the last failure.
Anyone have ANY ideas as to what could be causing this error to continue to rear it's ugly head?
Please and thank you!
If anyone stumbles across this post, this was resolved in the original post: https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_technical-9/24134/analytics-load-error---every-two-weeks-ish---self-hosted