IBM Support

Error Message:"org.hibernate.hql.ast.QuerySyntaxException: EntXtsk_id is not mapped" in Web Reports

Troubleshooting


Problem

If the Initiate database is installed in a database schema with many other tables, such as the Oracle system user, it is possible the following exception may be experienced with running web reports. org.hibernate.hql.ast.QuerySyntaxException: EntXtsk_id is not mapped [select count(task.memrecno), task.srcrecno from com.initiatesystems.reports.dao.AudHeadPO as audhead, EntXtsk_id as task, com.initiatesystems.reports.dao.MemHeadPO as memhead where (task.memrecno = memhead.memrecno) and (memhead.caudrecno = audhead.audrecno) and (memhead.memstat in (:memstats)) and (task.tsktypeno = 2) and (task.srcrecno in (:srcRecnos)) and (audhead.audctime >= :begin) and (audhead.audctime <= :end) group by task.srcrecno]

[{"Product":{"code":"SSLVY3","label":"Initiate Master Data Service"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

1036

Document Information

Modified date:
16 June 2018

UID

swg21471581

Page Feedback