ORA-37028: (XSMLTRESYNC03) Object workspace object cannot be
resynced without modified object workspace object because
they share a modified dimension map.



ORA-37028: (XSMLTRESYNC03) Object workspace object cannot be resynced without modified object works..

Answer / guest

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 resyncning the first object), resync
the first object, and release the other object.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-09265: spwat: error temporarily suspending process

1 Answers  


ORA-33003: (XSAGDIMDROP) workspace object, to be transformed during data load, must be a base dimension and not otherwise referenced in the AGGMAP.

1 Answers  


ORA-06601: LU6.2 Driver: Invalid database ID string

1 Answers  


SQL*Loader-00285: %s may be used only in conventional path.

1 Answers  


ORA-02049: timeout: distributed transaction waiting for lock

1 Answers  






ORA-07705: sksaprs: device name buffer too small

1 Answers  


ORA-06256: NETNTT: remote fork failed

1 Answers  


PCB-00901: Pro*COBOL internal error condition detected (Code = number)

1 Answers  


UDI-00017: Data Pump job is already executing.

1 Answers  


ORA-25277: cannot grant or revoke object privilege on release 8.0 compatible queues

1 Answers  


QSM-01618: equivalence, string, is enabled for text match rewrite only

1 Answers  


ORA-29371: pending area is not active

1 Answers  


Categories