Support Article
Function builder not working in Report Definitions
SA-31948
Summary
Calculation (function) builder is not displaying the options to select the function in the Customer Service framework application. The same works fine in activities.
Error Messages
Exception in logs:
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)
at com.pegarules.generated.activity.ra_action_pzgetaliasfunctions_790cff505d4b37121da6d46cfdf5de2b.step10_circum0_Rule_Alias_Function(ra_action_pzgetaliasfunctions_790cff505d4b37121da6d46cfdf5de2b.java:1116)
at com.pegarules.generated.activity.ra_action_pzgetaliasfunctions_790cff505d4b37121da6d46cfdf5de2b.perform(ra_action_pzgetaliasfunctions_790cff505d4b37121da6d46cfdf5de2b.java:283)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3527)
at com.pegarules.generated.activity.ra_action_acdatasource_driver_f898b7b150b34d46ee8de29454c768b4.step1_circum0(ra_action_acdatasource_driver_f898b7b150b34d46ee8de29454c768b4.java:280)
at com.pegarules.generated.activity.ra_action_acdatasource_driver_f898b7b150b34d46ee8de29454c768b4.perform(ra_action_acdatasource_driver_f898b7b150b34d46ee8de29454c768b4.java:69)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3527)
at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646)
at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:467)
at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.runActivities(HttpAPI.java:3166)
at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:390)
at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
Steps to Reproduce
1. Log into designer studio with Out-of-the-box (OOTB) login CASysAdmin/install.
2. Open any report definition and click on function builder and type any function name. Observe that no results are displayed.
Root Cause
A defect in Pegasystems’ code or rules
Issue was not replicable when checked with OOTB login administartor@pega.com/install.
At CS framwork level code in CSTextInput was breaking. On debuging the issue further found it was found that "Rule Cache Managment" was disabled.
Upon enabling cache the issue was fixed. But if the server is re-started this option is getting disabled again.
Issue was related to BIX code when running the extract from an agent via activity pxExtractDataWithArgs.
Resolution
Apply HFix-31206.
Published January 10, 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.