Informix Error -26977: Sharded queries are not supported within an XA environment.
Cause and resolution
Sharded queries are not supported within an XA environment.
Sharded queries are not supported within an XA environment.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26977 fires when a sharded query is run inside an XA (distributed transaction) environment — per the official guidance.
- The sharded query ran within an XA environment, per the official guidance — the direct, only cause; not supported.
Solutions / Resolution
- Don't run sharded queries within an XA transaction, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a sharded query inside an XA transaction.
Diagnostic Checks
- Check whether the sharded query runs inside an XA-coordinated transaction, and restructure to avoid combining the two.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -26977 in this set yet.
A sharded query was run within an XA environment, which isn't supported — avoid combining sharded queries with XA transactions.