Oracle Database Errors or Warnings from Error ORA-37026 to ORA-37038

SQLServerF1

ORA-37026: (XSMLTRESYNC01) Object workspace object cannot be resynced without dimension workspace object.
Cause: One cannot resync an object if it is dimensioned by a maintained dimension without updating that dimension or if the object is a relation and the dimension is its target.
Action: Include the maintained dimension in the update list
ORA-37027: (XSMLTRESYNC02) Object workspace object cannot be resynced without modified object workspace object because they share a modified composite dimension.
Cause: When one resyncs an object that is dimensioned by a composite dimension, the composite dimension is resynced automatically, dropping all new tuples. This cannot be done, however, if the automatic resync of the composite dimension might cause data in an object that shares the composite dimension to become NA.
Action: Resync both objects together. Alternatively, you can try to acquire the other object (that will ensure that the composite dimension is locked in the latest generation and will not be resynced when resyncing the first object), resync the first object, and release the other object.
ORA-37028: (XSMLTRESYNC03) Object workspace object cannot be resynced without modified object workspace object because they share a modified dimension map.
Cause: When one resyncs an object that is dimensioned by a dimension map, the dimension map is resynced automatically, dropping all changes. This cannot be done, however, if the automatic resync of the dimension map might cause data in an object that shares the dimension map to become NA.
Action: Resync both objects together. Alternatively, you can try to acquire the other object (that will ensure that the dimensions map is locked in the latest generation and will not be resynced when resyncing the first object), resync the first object, and release the other object.

ORA-37030: (XSMLTMAINT01) You cannot maintain workspace object because it is not ACQUIRED.
Cause: One cannot maintain a dimension in a multiwriter AW if it is not acquired.
Action: Acquire the dimension first.
ORA-37031: (XSMLTMAINT02) You cannot DELETE values of dimension workspace object in MULTI mode.
Cause: DELETE is allowed in multiwriter mode only for SESSION dimension members
Action: Attach the AW in a R/W mode and perform the DELETE operation
ORA-37032: (XSMLTMAINT03) You cannot MAINTAIN partition template workspace object in MULTI mode.
Cause: User attempted to add or remove values from a LIST partition template’s lists while the AW containing the partition template was attached in multiwriter mode.
Action: Do the maintenance in read only or read-write mode.
ORA-37035: (XSMLTDCL01) You can only DEFINE SESSION objects in analytic workspace string because it is attached in MULTI mode.
Cause: Persistent object definition in multiwriter mode is not allowed.
Action: Do all persistent object definitions in read-write mode.

ORA-37036: (XSMLTDCL02) You cannot DELETE objects in analytic workspace string because it is attached in MULTI mode.
Cause: One cannot delete objects in an analytic workspace attached in MULTI mode.
Action: Do all object in read-only or read-write mode.
ORA-37037: (XSMLTDCL03) You cannot RENAME objects in analytic workspace string because it is attached in MULTI mode.
Cause: One cannot rename objects in an analytic workspace attached in MULTI mode.
Action: Do all persistent object maintenance in read-write mode.
ORA-37038: (XSMLTDCL04) You cannot change definitions of objects in analytic workspace string because it is attached in MULTI mode.
Cause: One cannot used CHGDFN command on objects in an analytic workspace attached in MULTI mode.
Action: Do all persistent object maintenance in read-write mode.

Above are list of Oracle Database Errors or Warnings from Error ORA-37026 to ORA-37038 received while performing certain operation against Oracle Database or related products.

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *