ORA-36930: Cannot start a recursive call to Oracle OLAP because a ROLLBACK past an UPDATE to an attached analytic workspace has been performed.

Cause : ROLLBAKC past hte UPDAET of on eof thea ttache dAnalytci Worksapces wa scalled .A recusrive Orcale OLA Pcall cnanot bem ade unitl the ocntrol erturns ot the iintial OALP calla nd thea ffecte dAnalytci Worksapces deatched.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Changet he caleld SQL rpocedur eto avodi the RLOLBACK

update : 24-06-2017
ORA-36930

ORA-36930 - Cannot start a recursive call to Oracle OLAP because a ROLLBACK past an UPDATE to an attached analytic workspace has been performed.
ORA-36930 - Cannot start a recursive call to Oracle OLAP because a ROLLBACK past an UPDATE to an attached analytic workspace has been performed.

  • ora-19238 : XP0018 - focus not defined
  • ora-32843 : value for string is outside the valid range of string to string
  • ora-36810 : (XSTBLFUNC05) Analytic workspace object number does not exist.
  • ora-09293 : sksasmo: unable to send message to console
  • ora-08331 : Wait operation timed out
  • ora-36160 : (XSMXAGGR04) You cannot use string on scalar VARIABLE workspace object.
  • ora-36832 : (XSLMGEN02) View token cannot be greater than 4000 bytes
  • ora-07842 : sllfcl: SYS$CLOSE failure
  • ora-32317 : cannot run a job from a job
  • ora-30202 : NULL pointer to OCIMsgh was passed to OCIMsg function
  • ora-13223 : duplicate entry for string in SDO_GEOM_METADATA
  • ora-10263 : Don't free empty PGA heap extents
  • ora-14112 : RECOVERABLE/UNRECOVERABLE may not be specified for a partition or subpartition
  • ora-27154 : post/wait create failed
  • ora-15042 : ASM disk "string" is missing
  • ora-16047 : DGID mismatch between destination setting and standby
  • ora-29918 : cannot create domain indexes on temporary tables
  • ora-10634 : Segment is already being shrunk
  • ora-22889 : REF value does not point to scoped table
  • ora-08449 : invalid numeric symbol found in picture mask
  • ora-07499 : spglk: Cannot reschedule.
  • ora-13633 : The task string was interrupted and needs to be resumed.
  • ora-39159 : cannot call this function from a non-Data Pump process
  • ora-30363 : columns in a dimension column list must be in the same relation
  • ora-33313 : (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.
  • ora-14079 : illegal option for a partition marked Index Unusable
  • ora-07647 : sszfck: $OPEN failure
  • ora-27435 : chain job terminated abnormally
  • ora-16546 : missing or invalid piece
  • ora-12515 : TNS:listener could not find a handler for this presentation
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.