Oninit
Talk to an expert →

Informix Error -32003: A condition that violates the integrity of the resources was detected.

Cause and resolution

A condition that violates the integrity of the resources was detected.

This error is same as XA_RBINTEGRITY in the X/OPEN XA Specification Standard. For more information, refer to the "Distributed Transaction Processing: The XA Specification".

According to the X/OPEN XA Specification Standard :

The Resource Manager detected a violation of the integrity of its resources.

In the xa_commit context, the Resource Manager did not commit the work done on behalf of the transaction branch. Upon return, the Resource Manager has rolled back the branch's work and has released all held resources. This value can be returned only if TMONEPHASE is set in flags.

In the xa_end context, the Resource Manager has dissociated the transaction branch from the thread of control and has marked rollback-only the work performed on behalf of *xid.

In the xa_prepare context, the Resource Manager did not prepare to commit the work done on behalf of the transaction branch. Upon return, the Resource Manager has rolled back the branch's work and has released all held resources.

In the xa_rollback context, the Resource Manager has rolled back the transaction branch's work and has released all held resources. These values are typically returned when the branch was already marked rollback-only.

In the xa_start context, the Resource Manager has not associated the transaction branch with the thread of control and has marked *xid rollback-only.

Also refer to the Resource Manager guide for more details.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-32003 is the Informix representation of XA_RBINTEGRITY from the X/Open XA Specification — per the official guidance, the Resource Manager detected a violation of the integrity of its resources.

  1. xa_commit/xa_prepare: the Resource Manager didn't commit/prepare the branch due to a detected resource-integrity violation, per the official guidance.
  2. xa_end: the Resource Manager dissociated the branch and marked it rollback-only, per the official guidance.
  3. xa_rollback: the Resource Manager rolled back the branch's work, per the official guidance.
Solutions / Resolution
  1. Investigate the Resource Manager's resource integrity (e.g. constraint violations, corrupted state) around the time of the error, per the official guidance's implication.
  2. Retry the global transaction once the underlying integrity issue is resolved.
Examples
N/A

No specific triggering statement is documented — this is a Resource-Manager-side XA return code.

Diagnostic Checks
  1. Check the Resource Manager's own integrity/consistency checks around the time of the rollback.
Related Errors / Related Topics
  • -32002 — "The rollback was caused by a deadlock was detected." Same XA rollback-reason family (XA_RBDEADLOCK).
  • -32004 — "The Resource Manager rolled back the transaction branch for a reason not on the XA rollback errors." Same family (XA_RBOTHER).

An XA transaction branch was rolled back due to a resource-integrity violation (XA_RBINTEGRITY) — investigate the Resource Manager's resource state and retry.