MTS/COM+ Finishes Inserts But Commit Minutes Later
(Doc ID 369277.1)
Last updated on FEBRUARY 08, 2019
Applies to:
Oracle Services for Microsoft Transaction Server - Version 8.1.7.1 to 9.2.0.1 [Release 8.1.7 to 9.2]Information in this document applies to any platform.
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.
Changes
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 |
Changes |
Cause |
Solution |
References |