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
11 replies
Subscribers
4 subscribers
Views
7070 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
Getting Error Intermittently while retrieving data from DB
Omkar K
over 8 years ago
Hello, Has anyone faced following error? Any inputs to deal with this error?
I am getting this error whenever I am trying to access any reports with queryEntity rule in it's definition:
[Appian Timer - 2] DEBUG org.hibernate.util.JDBCExceptionReporter - could not execute query [select count(*) as y0_ from site this_ inner join site_page p2_ on this_.id=p2_.site_id left outer join site_rm rolemapent5_ on this_.id=rolemapent5_.site_id left outer join rm_entry rolemap1_ on rolemapent5_.rm_entry_id=rolemap1_.id where p2_.visibility=?]
com.microsoft.sqlserver.jdbc.SQLServerException: The data types ntext and nvarchar(max) are incompatible in the equal to operator.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515...
OriginalPostID-236017
Discussion posts and replies are publicly visible
Parents
0
Sally Mason
Appian Employee
over 8 years ago
From what I can see above, this looks like its
forum.appian.com/.../kb-1122.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Sally Mason
Appian Employee
over 8 years ago
From what I can see above, this looks like its
forum.appian.com/.../kb-1122.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data