My Oracle Support Banner

MTS/COM+ Finishes Inserts But Commit Minutes Later (Doc ID 369277.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Services for Microsoft Transaction Server - Version: 8.1.7 to 9.2.0
This problem can occur on any platform.

Symptoms

Using VB6,MDAC 2.8 and MTS/COM+.

A dll placed in COM+ which
inserts records in a table and finally query the table with 'Select Count(*)
from Table'.

Sometimes, some of the records are not returned by the query for
no apparent reason. There is a gap in between the time that MTS/COM+
finishes the inserts and the time that they are actually committed. After a few
minutes if queried again- the rows appear.

MTS/COM+ completes the inserts but it seems that Oracle has
not committed them. After a few minutes Oracle must insert the records and then
they show up.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.