Oninit
Talk to an expert →

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

Cause and resolution

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

The resource is not available at the remote RDB. The application is disconnected from the application server.

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 resource needed. Rerun the application.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-29014 fires when a resource needed at the remote RDB isn't available, severely enough that the application is disconnected from the application server — per the official guidance. 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, severely enough to disconnect, 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.
  3. Rerun the application, per the official guidance.
Examples
N/A

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

Diagnostic Checks
  1. Extract the resource details from SQLERRM, confirm the application server has that resource, and rerun the application.
Related Errors / Related Topics
  • -29013 — "AS resource not available. Reason,Type, Name,PrdID,RDB: Reason,ResourceType,ResourceName,ProductID,RDBname." A related, less severe resource- unavailability error that terminates only the current statement rather than disconnecting.

A resource needed at the remote RDB was unavailable and the application was disconnected — verify the resource via SQLERRM, ensure it's available, and rerun.