Informix Error -25745: UUID already exists for <servername>. </servername>
Cause and resolution
UUID already exists for <servername>. </servername>
You issued a CREATE UUID <servername> for a database server that already is associated with a UUID. That is, <servername> is included in the sysservers table of the syscdr database. </servername></servername>
If the database server <servername> has a new UUID because it was reinitialized, use ALTER SERVERUUID <servername> to update the UUID in the sysservers table. </servername></servername>
If the database server <servername> no longer exists, you can use DROP SERVERUUID to remove the entry from the sysservers table. It is not necessary to remove a nonexistent database server from sysservers. Leaving the entry in the sysservers table does not cause problems. </servername>
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-25745 fires when CREATE UUID <servername> targets a server already associated with a
UUID in syscdr:sysservers — per the official guidance.
CREATE UUIDtargeting a server already registered insyscdr:sysservers, per the official guidance — the direct, only cause.
Solutions / Resolution
- If the server was reinitialized and now has a new UUID, use
ALTER SERVERUUID <servername>to update the entry instead, per the official guidance. - If the server no longer exists, use
DROP SERVERUUID, per the official guidance — though leaving a nonexistent server's entry insysserverscauses no problems, so this isn't strictly necessary.
Examples
N/A
No specific triggering statement is documented beyond creating a UUID for an already-registered server.
Diagnostic Checks
- Check
syscdr:sysserversfor an existing entry for the server, and useALTER SERVERUUIDinstead ofCREATE UUIDif one exists.
Related Errors / Related Topics
- -25701 — "The specified servername
is not in SYSSERVERS." The mirror-image error, for ALTER SERVERUUIDon a server with no existing entry. - -25746 — "UUID does not exist for
." The mirror-image error, on altering/dropping a UUID that doesn't exist. - -25747 — "Do not have permissions to execute the drop serveruuid statement." A related ServerUUID error, on privilege rather than an existing UUID.
CREATE UUID targeted a server that already has a syscdr:sysservers entry — use ALTER SERVERUUID to update it instead.