Troubleshooting
Problem
execute function task or admin (defragment table name) returns -674 error
-674 Routine
Symptom
One of the following error(s) will be returned running the SQL statement
EXECUTE FUNCTION admin(“defragment”,“table name");
674: Routine (admin) can not be resolved.
OR
EXECUTE FUNCTION task(“defragment”,“table name");
674: Routine (task) can not be resolved.
Cause
The SQL statement is being run from the wrong database
Resolving The Problem
Run these API statements from the sysadmin database
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF025","label":"Platform Independent"},{"code":"PF008","label":"DYNIX\/ptx"},{"code":"PF010","label":"HP-UX"},{"code":"PF015","label":"IRIX"},{"code":"PF016","label":"Linux"},{"code":"PF022","label":"OS X"},{"code":"PF026","label":"Reliant UNIX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.5;11.7;11.70;12.1","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21631891