Background Maintenance Of Analytic Workspace Stops With Can Not Start a Job
(Doc ID 760540.1)
Last updated on NOVEMBER 26, 2019
Applies to:Oracle OLAP - Version 18.104.22.168 and later
Information in this document applies to any platform.
This problem can occur on any platform.
NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.
- We have an Analytic Workspace (AW) maintenance / refresh script or procedure that contains BuildType="BACKGROUND", so that the AW maintenance task will be sent to the Oracle Job queue.
- When we execute the AW maintenance / refresh script or procedure, we do not get any errors in the foreground, the script/procedure has been executed successfully.
- However when we look into the build/refresh log (see <Note 351688.1> for details) we see that the maintenance/refresh task failed with:
02:53:43 Job# AWXML$_8960 to Build(Refresh) Analytic Workspace <user>.<awname> Submitted to the Queue.
02:53:44 ***Error Occured: Failed to Build(Refresh)
<user>.<awname> Analytic Workspace. Can not start a job.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document