• State Not Answered
  • Replies 11 replies
  • Subscribers 4 subscribers
  • Views 7066 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

Getting Error Intermittently while retrieving data from DB

Omkar K
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

  • 0
    ...)
              at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
              at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
              at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
              at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
              at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
              at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
              at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
              at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
              at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
              at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
              at org.hi...
  • 0
    ...bernate.loader.Loader.doQuery(Loader.java:802)
              at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
              at org.hibernate.loader.Loader.doList(Loader.java:2533)
              at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
              at org.hibernate.loader.Loader.list(Loader.java:2271)
              ...
              at java.lang.reflect.Method.invoke(Method.java:497)
              at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
              at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
              at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
              at org.springframewor...
  • 0
    ... k.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
              at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
              at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
              at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
              at com.sun.proxy.$Proxy253.getSitesStats
              at com.appiancorp.common.monitoring.AggregatedDataTimer$4.run(AggregatedDataTimer.java:421)
              at com.appiancorp.security.auth.SpringSecurityContextHelper.runAsAdmin(SpringSecurityContextHelper...
  • 0
    ... .java:110)
              at com.appiancorp.common.monitoring.AggregatedDataTimer.timeout(AggregatedDataTimer.java:418)
              at com.appiancorp.common.timer.AppianTimerSystem.run(AppianTimerSystem.java:59)
  • 0
    Hi Sally, thanks for your response. But, if my error is related incompatible datatypes then it should not throw any error on the UI. However, I am getting one as could not execute query.

    I am also getting the KB-1122 but, as in the KB-1122, it is said that you can disregard the error, I am disregarding that. Please let me know if you need more information.
  • 0
    Appian Employee
    Would you be able to upload the log for further review?
  • 0
    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.
  • 0
    Hi Sally, Please find attached logs with debug mode on and let me know if you need more information.

    relevant_logs.txt

  • 0
    Appian Employee
    The way around this issue is to convert the actual type of the column in question, bearing in mind in Appian, there is no %LIKE% statement, only =

    Also see the discussion on social.msdn.microsoft.com/.../msg-402-level-16-state-1-line-15-the-data-types-ntext-and-ntext-are-incompatible-in-the-equal-to
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.