Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
7 subscribers
Views
2232 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
We've upgraded our Appian Dev/Tst environments from 7.3 to 16.1. Our databa
Todd Tran
Certified Associate Developer
over 10 years ago
We've upgraded our Appian Dev/Tst environments from 7.3 to 16.1. Our databases are on SQLServer 2012. We noticed in the application-server.log that the following errors are reoccurring every 15 mins. Does anyone have any idea or information on this? Thanks.
--------------------------------------
2016-03-15 15:00:37,055 [Appian Timer - 1] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 402, SQLState: S0001
2016-03-15 15:00:37,056 [Appian Timer - 1] ERROR org.hibernate.util.JDBCExceptionReporter - The data types ntext and nvarchar(max) are incompatible in the equal to operator.
2016-03-15 15:00:52,071 [Appian Timer - 1] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 402, SQLState: S0001
2016-03-15 15:00:52,071 [Appian Timer - 1] ERROR org.hibernate.util.JDBCExceptionReporter - The data types ntext and nvarchar(max) are incompatible in the equal to operator.
OriginalPostID-200849
OriginalPostID-200849
Discussion posts and replies are publicly visible
0
abhi.jana
Appian Employee
over 10 years ago
Did you update your JDBC driver? 4.2 is the supported version for Appian 16.1 while 7.3 supports 4.0
forum.appian.com/.../System_Requirements.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
vishnuv
A Score Level 1
over 10 years ago
It looks like you got the wrong driver..
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Todd Tran
Certified Associate Developer
over 10 years ago
We installed SQL Server JDBC Driver 4.2, updated module.xml and redeployed Appian but it did not fix the errors
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
jaredw
over 9 years ago
I'm having a similar issue. I installed the SQL Server JDBC Driver 4.2, and updated module.xml but the error is still in the logs for me as well. Was a solution found for this issue?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
abhi.jana
Appian Employee
over 9 years ago
This KB article should help -
forum.appian.com/.../kb-1122.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel