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
1568 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 8 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 8 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 8 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 8 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 7 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 7 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