Informix Error -9252: Xadatasource type datasource_type_name not found.
Cause and resolution
Xadatasource type datasource_type_name not found.
The datasource_type_name you are trying to drop with DROP XADATASOURCE TYPE datasource_type_name statement does not exist. Use the correct datasource_type_name.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-9252 fires when a DROP XADATASOURCE TYPE statement names a type that doesn't exist — per the official guidance.
- A misspelled or nonexistent xadatasource type name in a DROP XADATASOURCE TYPE statement, per the official guidance — the direct, only cause.
Solutions / Resolution
- Use the correct
datasource_type_name, per the official guidance.
Examples
Dropping a nonexistent type
DROP XADATASOURCE TYPE xads_typo; -- -9252 if no such type exists
Diagnostic Checks
- Check the system catalog for the actual xadatasource type name, and correct the DROP statement.
Related Errors / Related Topics
- -9250 — "Xadatasource type datasource_type_name already exists in database." The inverse case — creating a type name that already exists.
- -9253 — "Xadatasource datasource_name not found." The same class of not-found error, for xadatasource instances rather than types.
The named xadatasource type doesn't exist — check the system catalog and correct the name.