IBM Support

UDA-SQL-0227 when running a report

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"}}]

Document Information

Modified date:
15 June 2018

UID

swg21343357