We got the below error message in the logs. Is it something related to site? But there is no impact or slowness from the application front end. Just out of curiosity would like to understand what does this message says?
Error : 932, Position : 368, Sql = select count(distinct this_.id) as y0_ from site this_ inner join site_page p1_ on this_.id=p1_.site_id left outer join site_page c2_ on p1_.id=c2_.parent_site_page_id left outer join site_page_input nori4_ on c2_.id=nori4_.site_page_id left outer join site_page_input ori3_ on p1_.id=ori3_.site_page_id where this_.is_system=:1 and (ori3_.default_value_expr<>:2 or nori4_.default_value_expr<>:3 ), OriginalSql = select count(distinct this_.id) as y0_ from site this_ inner join site_page p1_ on this_.id=p1_.site_id left outer join site_page c2_ on p1_.id=c2_.parent_site_page_id left outer join site_page_input nori4_ on c2_.id=nori4_.site_page_id left outer join site_page_input ori3_ on p1_.id=ori3_.site_page_id where this_.is_system=? and (ori3_.default_value_expr<>? or nori4_.default_value_expr<>?), Error Msg = ORA-00932: inconsistent datatypes: expected - got CLOB
Discussion posts and replies are publicly visible
Seems to be related with an Appian internal Oracle query when generating or loading the site.... open a support ticket....