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
7072 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
Omkar K
over 8 years ago
Hi Sally, thanks for your response. Since I don't have the loga, I will make sure and attached the logs to this post once this issue gets reproduced. The issue got resolved by reconfiguring the data source configuration and restarting the server.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Omkar K
over 8 years ago
Hi Sally, thanks for your response. Since I don't have the loga, I will make sure and attached the logs to this post once this issue gets reproduced. The issue got resolved by reconfiguring the data source configuration and restarting the server.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data