Question
OCBC Bank
SG
Last activity: 28 Mar 2022 2:42 EDT
ERROR - An error occured on generating the query for the report definition
Hi Team,
we are using a Report definition, where in pxmonthnumber function used in the filter criteria of the RD.
This RD is invoked in queue-Processor through activity,
while running the queue processor, the following exception is coming and queue processor is not running and item send to BQ , however , if we run the RD alone, it is working fine.
any thoughts
ERROR - An error occured on generating the query for the report definition - Failed to generate com.pegarules.generated.alias_function.ra_stream_pxmonthnumber_121dc0195cd5b8b6ffd8617bb531d05f com.pega.pegarules.pub.PRRuntimeException: Failed to generate com.pegarules.generated.alias_function.ra_stream_pxmonthnumber_121dc0195cd5b8b6ffd8617bb531d05f
Eclatprime Digital Private Limited
IN
@SriniJajjaru if the RD is able to execute the function using your Operator and not with queue processor, then probably the queue processor is not able to access the function.
If you are using branch, pls test after merging the code to trunk and also check if queue process have access to the the function’s Ruleset.
OCBC Bank
SG
@PIYUSH SINHA , Thank you,
the code is not in branch, you might right, queue process is not able to access the function , let me check and update here
EIB
PL
@SriniJajjaru Check your data on the DB side and make sure that values are suitable for the pxMonthNumber function.