[nQSError: 22024] A comparison is being carried out between non-compatible types BIT and VARCHAR. (H

Question

Hello All,

After migrate reports from OBIEE 11g to OBIEE 12c(12.2.2.1.4) Few reports are throwing error ([nQSError: 22024] A comparison is being carried out between non-compatible types BIT and VARCHAR. (HY000)) in OBIEE 12c.

Can anyone please help me how to resolve above issue in OBIEE 12c.

Thanks & Regards,

Subhankar Mahanti

[Deleted User] · Answer

+1'000'000

The harder enforcements were overdue. All the things there are now much more explicit and require things to be as they always should have been have - for many, many clients - lifted the lid on just how shoddy a lot of implementations have been over the years. I've spent months cleaning RPDs and catalogs of things that shouldn't exist.

@4146774 Solve the real issue. Compare things that are comparable. Use correct data types. it will save you a lot of pain.

Steve F-2 · Answer

12c (and onwards, including Oracle Analytics Server) has tighter type enforcement

You can relax the enforcement, but it better to identify the formula, filter, etc that is the root cause -- as mentioned by @Christian Berg

User_V7A4J · Answer

Thank you Christian for your reply.

Sorry for my mistake I was talking about OBIEE answers analysis object but the same analysis is working fine in OBIEE 11g version.

Thanks,

Subhankar