sgumucio Posted July 13, 2021 Share Posted July 13, 2021 I am trying to connect two UUIDs from the same database in a virtual data source via Jasper Reports Server. They join fine in the domain, but when I create the adhoc, it throws this error "TEIID30492 Non-comparable expression of type object cannot be used in comparison". I am working on JasperReports Server 7.8. Is there anyway I can solve this issue? Link to comment Share on other sites More sharing options...
yama818 Posted July 13, 2021 Share Posted July 13, 2021 If I were to investigate, I would first look at the SQL issued by the AdHoc View.https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v790/configuring-ad-hoc#Query_Settings--> Ad Hoc Query Settings > Configure View Query After that, check if this SQL is Teiid compliant.https://docs.jboss.org/teiid/7.7.0.Final/reference/en-US/html/index.html I hope this is helpful. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now