Informix Error -25746: UUID does not exist for <servername>. </servername>
Cause and resolution
UUID does not exist for <servername>. </servername>
You cannot DROP SERVERUUID <servername> or ALTER SERVERUUID <servername> unless <servername> is associated with a UUID in the sysservers table of the syscdr database. </servername></servername></servername>
To find the names of database servers whose UUIDs exist, use the following query:
SELECT * FROM syscdr:sysservers.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-25746 fires when DROP SERVERUUID or ALTER SERVERUUID names a server with no UUID
entry in syscdr:sysservers — per the official guidance.
DROP/ALTER SERVERUUIDtargeting a server not associated with a UUID, per the official guidance — the direct, only cause.
Solutions / Resolution
- Query
syscdr:sysserversto find servers whose UUIDs actually exist, per the official guidance (SELECT * FROM syscdr:sysservers;), and target one of those.
Examples
Listing servers with registered UUIDs
SELECT * FROM syscdr:sysservers;
Diagnostic Checks
- Query
syscdr:sysserversto confirm whether the target server has a UUID entry before issuingDROP/ALTER SERVERUUID.
Related Errors / Related Topics
- -25745 — "UUID already exists for
." The mirror-image error, for CREATE UUIDon a server that already has one. - -25747 — "Do not have permissions to execute the drop serveruuid statement." A related ServerUUID error, on privilege rather than a missing entry.
DROP/ALTER SERVERUUID targeted a server with no UUID entry — query
syscdr:sysservers for a server that actually has one.