I am getting the below error. Can you guys please suggest what could be the reason for this?
Caused by: net.sf.hibernate.QueryException: unexpected token: with [select obj.id, obj.VersionId, obj.DeleteFl , obj.TskId, obj.TskWarnFl, obj.TskPriority, obj.StreamStage.StsName, obj.TskStatus, obj.ParentTask.TskId, obj.ParentTask.StreamStage.StsName, obj.TskCreatedDttm, obj.TskStartDttm, obj.TaskController.TcrName, obj.ProcessChainDfn.SpdnName from com.azure.spark.database.hibernate.mappings.reference.impl.TaskImpl obj with(NOLOCK) left join obj.StreamStage StreamStage with(NOLOCK) left join obj.ParentTask ParentTask with(NOLOCK) left join obj.ParentTask.StreamStage ParentTaskStreamStage with(NOLOCK) left join obj.TaskController TaskController with(NOLOCK) left join obj.ProcessChainDfn ProcessChainDfn with(NOLOCK) where true = true and obj.StreamStage.DeleteFl = false and ( obj.TskEndDttm is null or ( obj.TskEndDttm is not null and obj.TskEndDttm >= :MinDttm and obj.TskEndDttm <= :MaxDttm ) ) and obj.TaskArchive is null and obj.PartitionId in ( 1 ) order by obj.TskId desc] at net.sf.hibernate.hql.FromParser.token(FromParser.java:101) at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87) at net.sf.hibernate.hql.PreprocessingParser.token(PreprocessingParser.java:123) at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:29) at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149) at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138) at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:295) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1571) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1542) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39) at com.azure.spark.database.hibernate.util.HibernateUtil$10.doSessionWork(HibernateUtil.java:462) at com.azure.spark.database.hibernate.util.HibernateUtil.doSessionWork(HibernateUtil.java:84) ... 9 more
|