Support Article
Running non-visual Segment with Rank cause ORA-00913
SA-20332
Summary
When attempting to run a non-visual Segmentation with ranking enabled, the execution fails with "ORA-00913: too many values".
Error Messages
2016-02-02 15:29:50,315 [ PegaRULES-Batch-4] [ STANDARD] [ ] [ PegaMarketing:07.13] (l.access.ConnectionManagerImpl) ERROR - Not returning connection 5 for database "externalmktdata" to the pool as it previously encountered the following error User ID: System Last SQL: INSERT INTO MKTSEGCAMERASEGMENT (CustomerID) SELECT DISTINCT "PARENTPC0".L1 AS "CustomerID" , "PARENTPC0".L2 AS "pzRank" FROM ( SELECT DISTINCT "PC0".CUSTOMERID AS "L1" , ROW_NUMBER() OVER (ORDER BY "PC0".CLV_VALUE DESC NULLS LAST) AS "L2" FROM PEGAMARKETING713_EXTERNAL.MKT_CUSTOMER "PC0" ) "PARENTPC0" WHERE "PARENTPC0".L2 <= ? java.sql.SQLSyntaxErrorException: ORA-00913: too many values
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
Steps to Reproduce
Steps they take to create the segment are as follows:
1) Audiences > Create
2) Give it name and created new segment
3) ‘Add Criteria’ which prompt to a new screen
4) Switch to build segment in Non Visual way
5) Select to rank it based on one attribute from the base class .a_property without adding any condition
Root Cause
A defect in Pegasystems’ code or rules.
Resolution
Install HFix-25985.
Tags:
Published February 28, 2016 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.