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 24, 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.