Tools 8.54 Fin 9.2 Fluid - MSS Statement Could Not Be Prepared (Doc ID 2103251.1)

Last updated on JUNE 13, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.

Symptoms

On : 8.54 version, Mobile Application Platform

Tools 8.54 Fin 9.2 Fluid - MSS Statement could not be prepared

On DEMO system (Tools 8.54.15, Fin 9.2 Image 14, MSS 2014)


PSAPPSRV.3752 (162) 1-151 16.12.08 0.005000 SQL error. Function: SQLExec
  Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000)

  Statement: SELECT SUM(COUNT(DISTINCT EOAWPARENT_THREAD)) FROM PS_HMAP_SUMMDTL_VW WHERE EOAWPRCS_ID IN ('GLJOURNALAPPROVAL', 'PURCHASEORDER', 'REQUISITION') AND OPRID = :1 AND EOAWSTEP_STATUS IN ('P', 'H') GROUP BY EOAWPRCS_ID

  Original Statement: SELECT SUM(COUNT(DISTINCT EOAWPARENT_THREAD)) FROM PS_HMAP_SUMMDTL_VW WHERE EOAWPRCS_ID IN ('GLJournalApproval', 'PurchaseOrder', 'Requisition') AND OPRID = :1 AND EOAWSTEP_STATUS IN ('P', 'H') GROUP BY EOAWPRCS_ID
PSAPPSRV.3752 (162) 1-152 16.12.08 0.001000 PCodeWTL(3/3): OnErrorEvent() -->HMAP_APPROVAL.Document.Data.GroupListDataDocument.OnExecute Name:fetchApprovalTileCountOnly PCPC:6767 Statement:90 Called from:HMAP_APPROVAL.Document.Data.GroupListDataDocument.OnExecute Name:ConstructDocument Statement:14 Called from:HMAP_APPROVAL.ApprovalService.OnExecute Name:LocalDataLoad Statement:67 Called from:HMAP_APPROVAL.ApprovalService.OnExecute Name:FatchDataByAJAX Statement:222 Called from:HMAP_APPROVAL.ApprovalRequestController.OnExecute Name:PerformAJAXRequest Statement:31 Called from:HMAP_APPROVAL.ApprovalRequestController.OnExecute Name:OnAJAXEvent_GetGroupList Statement:83

ERROR
-----------------------
SQLSTATE 37000




STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1) Login as VP1
2) Click on Fluid Home

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use fluid.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms