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]
Resolving The Problem
It is recommended that the Initiate schema be installed in a user schema that contains on tables used by IBM Initiate software. Other tables that are not used by IBM Initiate software should not be in the same user schema. If possible, relocate these tables not related to the IBM Initiate product to another database user. If the IBM Initiate database tables must be relocated to another user, please create a customer service request for further assistance.
Historical Number
1036
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21471581