Informix Error -25728: Type <data_type_name> is not the same in the local and remote </data_type_name> database.
Cause and resolution
Type <data_type_name> is not the same in the local and remote </data_type_name> database.
The attributes of the user-defined data type <data_type_name> are different on the local and remote databases. A UDT used in a distributed query must have the same attributes in all databases accessed by the query. </data_type_name>
Examine the definition of the <data_type_name> UDT in both your local and remote databases. Modify one or both of the UDTs so that they are the same. </data_type_name>
You can use the oncheck utility to check for compatible data types between servers. For example:
oncheck -cvt db1@server1 db2@server2.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-25728 fires when a user-defined data type's attributes differ between the local and remote databases in a distributed query — per the official guidance, a UDT used in a distributed query must have identical attributes everywhere the query accesses.
- A UDT with differing attributes between the local and remote databases, per the official guidance — the direct, only cause.
Solutions / Resolution
- Examine the UDT's definition in both the local and remote databases, and modify one or both so they match, per the official guidance.
- Use
oncheck -cvtto check for compatible data types between servers, per the official guidance.
Examples
Checking type compatibility between servers
$ oncheck -cvt db1@server1 db2@server2
Diagnostic Checks
- Compare the UDT's definition on both databases, using
oncheck -cvt, and reconcile any differences.
Related Errors / Related Topics
- -25736 — "The extended type <data_type_name> has not been defined in the local database." A related distributed-query UDT error, on the type being entirely undefined locally rather than defined with different attributes.
A UDT's attributes differed between the local and remote database in a distributed
query — reconcile the definitions, checking with oncheck -cvt.