My Oracle Support Banner

Test Cases Not Listed Under The Project Due To Group By Exception (Doc ID 2177347.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle Application Testing Suite - Version 12.5.0.2 and later
Information in this document applies to any platform.

Symptoms

In OATS when trying to list the test cases under the project, none of the test cases are listed.
Getting Group By Clause exception

On Opening the Project we don’t see the test cases.

In The Logs  following error observed:

<<<Jul 8, 2016 10:12:17 AM SAST> <Notice> <LoggingService> <BEA-320400> <The log file /u01/app/orbit/oats12/oats/servers/AdminServer/logs/access.log will be rotated. Reopen the log file if tailing has stopped. This can happen on some platforms like Windows.>
<Jul 8, 2016 10:12:17 AM SAST> <Notice> <LoggingService> <BEA-320401> <The log file has been rotated to /u01/app/orbit/oats12/oats/servers/AdminServer/logs/access.log01196. Log messages will continue to be logged in /u01/app/orbit/oats12/oats/servers/AdminServer/logs/access.log.>
[EL Warning]: 2016-07-08 10:12:28.881--UnitOfWork(1411549882)--Thread(Thread[[ACTIVE] ExecuteThread: '13' for queue: 'weblogic.kernel.Default (self-tuning)',5,Pooled Threads])--Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00979: not a GROUP BY expression

Error Code: 979
Call: SELECT t0.ISSUESTATUSTYPEID, t2.ISSUEPRIORITYTYPEID FROM "TO_Issues" t3, "Type_Priority_Issue" t2, "Activity_Issue" t1, "Type_Status_Issue" t0 WHERE (((t1.issueId IN (?)) AND (t1.ISSUEACTIVITYID = (SELECT MAX(t4.ISSUEACTIVITYID) FROM "TO_Issues" t5, "Activity_Issue" t4 WHERE ((t5.ISSUEID = t3.ISSUEID) AND (t5.ISSUEID = t4.issueId))))) AND (((t0.ISSUESTATUSTYPEID = t1.STATUSID) AND (t2.ISSUEPRIORITYTYPEID = t1.PRIORITYID)) AND (t3.ISSUEID = t1.issueId))) GROUP BY t0.ISSUESTATUSTYPEID, t2.ISSUEPRIORITYTYPEID ORDER BY t3.ISSUEID ASC
bind => [1 parameter bound]

>>

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.