The following errors are seen in the server log repeatedly, after 12 hours of starting the application server, while using SQL Server or Oracle as the Appian datasource:
[Appian Timer - 1] ERROR org.hibernate.util.JDBCExceptionReporter - The data types ntext and nvarchar(max) are incompatible in the equal to operator."
[Appian Timer - 1] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00932: inconsistent datatypes: expected - got CLOB
This is an issue when using Sites with SQL Server or Oracle databases. The query that throws the error is invoked to populate sites.csv. This error appears only after 12 hours since the data-metrics logs are written every 12 hours.
This issue has been reported to the Appian product team. The reference number for this issue is AN-69032.
The error can be safely disregarded since it doesn’t have any impact except an empty sites.csv log.
To avoid the logs from getting populated with these error messages and to prevent the increase in disk usage, perform the following steps:
This article applies to Appian 16.1 and later using SQL Server or Oracle databases.
Last Reviewed: July 2017
© 2020 Appian. All rights reserved.