Conference orarep::nomahs::dbintegrator_public_public

1167.0. "Just in case anyone stumbles across a "RMS-E-DDTM_ERR" with the RMS Gateway..." by BROKE::WRIGHT (NYO&W-Trains Spoken Here-SUSIEQ) Mon May 19 1997 15:55

Just in case you stumble across a "RMS-E-DDTM_ERR" with the RMS Gateway this may
save you some time.



The following error stack can be generated by executing a query in a READ/WRITE
transaction when Run Unit Journaling is enabled and either SQL$DISABLE_CONTEXT
or NSDS$DISABLE_CONTEXT defined.

SQL> select * from foo ;
%RDB-F-SYS_REQUEST, error from system services request
-NSDS-E-REWINDFAIL, Could not rewind data relation
-RMS-E-DDTM_ERR, error returned by Digital Distributed Transaction Manager
-NONAME-W-NOMSG, Message number 00000000

To prevent this remove one of the conditions.

  o Make the transaction READ ONLY.

    OR

  o DEASSIGN SQL$DISABLE_CONTEXT and NSDS$DISABLE_CONTEXT.

    OR

  o Disable Run Unit Journaling.