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!
We are also having this issue with 15.1.4. After repeated attempts of re-installs, we are running into non-existing cubes. For us, it is at the stage of missing of the Finance cube.
We're on 15.1.3 - I thought that made it into my original post. :/