Oracle Solution for Error ora-37027

ORA-37027: (XSMLTRESYNC02) Object workspace object

cannot be resynced without modified object workspace object

because they share a modified composite dimension.

What triggered the Error:

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.

What should we do to fix it:

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.