Support Article
Function builder issue in Report Definitions
SA-31950
Summary
Calculation (function) builder is not displaying the options to select the function in the Customer Service application.
The same works fine in activities.
Error Messages
Exception Trace com.pega.pegarules.pub.PRRuntimeException: Section 'CSTextInput' execution error. : Caught db exception while looking up pyLocalizedValue in Rule-Obj-FieldValue PRRuntimeException
Java Stack Trace
at com.pegarules.generated.html_property.ra_stream_cstextinput_4d6ef5367765a8946c554a6e8574314f.execute(ra_stream_cstextinput_4d6ef5367765a8946c554a6e8574314f.java:111)
at com.pega.pegarules.session.internal.mgmt.MessageEvaluator.getFormattedProperty(MessageEvaluator.java:1007)
at com.pega.pegarules.session.internal.mgmt.MessageEvaluator.getFormattedString(MessageEvaluator.java:954)
at com.pega.pegarules.session.internal.mgmt.MessageEvaluator.getRuleObjMessage(MessageEvaluator.java:735)
at com.pega.pegarules.session.internal.mgmt.MessageEvaluator.getRuleMessage(MessageEvaluator.java:364)
at com.pega.pegarules.session.internal.mgmt.MessageEvaluator.getRuleMessage(MessageEvaluator.java:1070)
at com.pega.pegarules.data.internal.dictionary.PropertyInfoImpl.lookForLocalizedMessage(PropertyInfoImpl.java:1255)
at com.pega.pegarules.data.internal.dictionary.PropertyInfoImpl.getLocalizedText(PropertyInfoImpl.java:1206)
at com.pega.pegarules.data.internal.dictionary.DictionaryImpl.getLocalizedText(DictionaryImpl.java:415)
at com.pega.pegarules.session.internal.mgmt.Executable.getLocalizedTextForString(Executable.java:7485)
at com.pega.pegarules.session.internal.mgmt.Executable.getLocalizedTextForString(Executable.java:7431)
at com.pega.pegarules.session.internal.mgmt.Executable.getLocalizedTextForString(Executable.java:7426)
at com.pega.pegarules.session.internal.mgmt.Executable.getLocalizedTextForString(Executable.java:7411)
Steps to Reproduce
1. Log into the environment shared with CASysAdmin/install.
2. Open a Report Definition and click on function builder of a column.
Root Cause
A defect in Pegasystems’ code or rules.
On debug the issue is with the Rule Cache management disabled. It is highly recommended that rule cache management should always be enabled.
Resolution
Perform the following local-change:
Enable the rule cache by logging into System Management Application (SMA).
Navigate to Advanced > Rule Cache Management > Enable Cache for enabling the cache.
Published January 11, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.