Informix Error -32503: User tables should be closed to change session attribute.

Reasons / Common Causes

-32503 fires when a session attempts to change a session attribute (such as sensitivity level) while user tables or cursors remain open — per the official guidance.

1. Open tables or cursors remaining active when a session sensitivity-level change was attempted, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Close all open tables and relinquish all open cursors before changing session sensitivity levels, per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond open tables/cursors blocking a session-attribute change.

Diagnostic Checks

1. Check for open tables/cursors in the session, and close/free them before retrying the level change.

Related Errors / Related Topics

• -32500 — "User does not have discrete privilege to change session levels." A related session-level-change error, on a missing privilege rather than open tables/cursors.

Open tables or cursors blocked a session-attribute change — close them first.