Article - CS121614
Creating an aggregate expression against a multi-value picklist in Integrity with MS SQL Database results in error: "Cannot perform an aggregate function on an expression containing an aggregate or a subquery."
Modified: 21-Mar-2018
Applies To
- PTC RV&S (formerly Integrity Lifecycle Manager) 2009 to 11.2
Description
- Generating distribution charts with aggregate expressions against item backed pick list (IBPL) fields throws an error
- When you perform a view issue on an item or run a chart with an aggregate expression you get following error message:
*** MKS124814: Cannot show view information: MKS131372: An unhandled database exception has occurred. Please contact your administrator.
The error supplied by the database is:
Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
The error supplied by the database is:
Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
- There is a DEBUG level error in the server.log:
DEBUG [mksis.IntegrityServer] DEBUG java.sql.SQLException: java.sql.SQLException: Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
...
This is a printer-friendly version of Article 121614 and may be out of date. For the latest version click CS121614