Oninit
Talk to an expert →

Informix Error -29013: AS resource not available. Reason,Type, Name,PrdID,RDB: Reason,ResourceType,ResourceName,ProductID,RDBname.

Cause and resolution

AS resource not available. Reason,Type, Name,PrdID,RDB: Reason,ResourceType,ResourceName,ProductID,RDBname.

The resource is not available at the remote RDB. The current SQL statement is terminated.

Reason, ResourceType, ResourceName, ProductID, and RDBname are returned as a token in SQLERRM.

Verify the identity of the resource that was not available. Ensure that the application server has the needed resource.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-29013 fires when a resource needed at the remote RDB isn't available — per the official guidance, the current SQL statement is terminated. The reason, resource type, resource name, product ID, and RDB name are returned as tokens in SQLERRM.

  1. The named resource being unavailable at the remote RDB, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Verify the identity of the unavailable resource, per the official guidance, using the tokens returned in SQLERRM.
  2. Ensure the application server has the needed resource, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond an unavailable AS resource.

Diagnostic Checks
  1. Extract the resource details from SQLERRM, and confirm the application server has that resource available.
Related Errors / Related Topics
  • -29014 — "Hard AS resource not available. Reason,Type, Name,PrdID,RDB: Reason,ResourceType,ResourceName,ProductID,RDBname." A related resource-unavailability error, severe enough to disconnect the application entirely.

A resource needed at the remote RDB wasn't available — verify its identity via SQLERRM and confirm the application server has it.