Troubleshooting
Problem
Running a Query Studio or Report Studio report returns an error message
Symptom
UDA-SQL-0227 Equivalence types are incompatible.
Cause
Incompatible datatypes involved in a join relationship, defined in either the model or within the report. (For example, a field of type character joined to a field of type float)
Resolving The Problem
Verify the data types being joined on each end, as well as their compatibility. If there is a difference in datatype, utilize a cast function to make them compatible.
[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cognos Connection","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2;10.1.1;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21343357