Support Article

"Geofence Details" report definition is not working

SA-29175

Summary



"Geofence Details" report definition is throwing the error as below, if the user defined functions are not installed.


Error Messages



Error:** An error occured on executing the query for the report definition - There was a problem getting a list: code: 0 SQLState: 42883 Message: ERROR: function pegarules.pr_read_decimal_from_stream(unknown, character varying, bytea) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 5161 DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: function pegarules.pr_read_decimal_from_stream(unknown, character varying, bytea) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 5161 | SQL Code: 0 | SQL State: 42883


Steps to Reproduce



1. Run Report Definition Geofence Details of Class Rule-PegaMKT-Geofence in RuleSet PegaNBAMC-EventSimulator:07-21-01


Root Cause



This report definition is using un-optimized properties. Issue encountered when UDFs are not installed in the instance.

Resolution



HFix-30019

 

Published October 14, 2016 - Updated October 23, 2016


100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.