ORA-37027: (XSMLTRESYNC02) Object workspace object cannot be resynced without modified object workspace object because they share a modified composite dimension.

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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:51

ORA-37027：（XSMLTRESYNC02）对象工作空间对象不能在没有修改对象工作空间对象的情况下重新同步，因为它们共享修改的复合维度。,
.原因：当一个对象由复合维度重新同步时，复合维度将自动重新同步，删除所有新的元组。但是，如果复合维度的自动重新同步可能导致共享复合维度的对象中的数据变为NA，则无法完成此操作。,
.操作：将两个对象重新同步在一起。或者，您可以尝试获取其他对象（这将确保复合维度在最新一代中被锁定，并且在重新同步第一个对象时不会被重新同步），重新同步第一个对象，并释放其他对象。,
.

aiaiDBA

13718043309

010-86462881

ORA-37027: (XSMLTRESYNC02) Object workspace object cannot be resynced without modified object workspace object because they share a modified composite dimension.

1 个回答

相似问题