[Web Previewer] ORA-00932: inconsistent datatypes: expected - got CLOB

Forge Component
Published on 2018-11-19 by Rui Mendes
18 votes
Published on 2018-11-19 by Rui Mendes


I have the net error when I use Web Previewer.

Someone can help me?

It seems that the filename and filetype attributes in the database have a 5000 char length. This will create a CLOB attribute.

In the GetFileCache aggregate both those attributes are being used in the Filter tab which will translate to a WHERE clause. In Oracle this is not allowed, hence the error.

So while we wait for a fix on the authors part and since you've already published the component you can't shorten those attributes length:

- Duplicate those attributes with length lesser than 2000 chars, while deleting the original ones. This will create further complications when the component is upgraded.

- Understand what that action does and try to get the data any other way that won't need those two attributes in the WHERE clause.