I'm getting an error executing the report definition in the pega 8.4.1(this is a 7.1.5 to 8.4.1 upgrade). Report definition name is pyCompletedAssignmentsDefinition. I have try to Exposed the property but issue is still existing.
Error Details -:
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 data.pr_read_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: 17 DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: function
how to sort this out ?
Hello,
Is it still the Out-Of-The-Box Report Definition or a custom version? If you run the standard version with a standard user are you still getting the same behaviour?
Maybe you can trace the execution and share the tracer XML for analysis.
You seem to have 2 separate errors here. Are you sure both are associated with the problem executing pyCompletedAssignmentDefinition?
Questions:
1) pyCompletedAssignmentDefinition is an OOTB report but it is available. Did you modify it at all? E.g., have you added any columns?
2) What property did you expose? The error message for pr_read_from_stream appears to be giving a property name of "unknown".
Hi AnuradhaW,
The DB function pr_read_from_stream will be used to fetch data from blob
pzPvstrpzPvstream
1.
Can you check the query formed in the tracer while running report and try to run the same query in DB with params.
2. Can you also try add another blob property instead of
pyFlowName
property and try running the report.
You need to check the upgrade logs to make sure there were no errors. How was the database migrated to 8.4.1? If this is a stock OOTB pyCompletedAssignmentsDefinition report all of the properties it is trying to access should have been exposed by default. If they are not (or the system thinks they are not) then something likely went wrong with either the upgrade or the DB migration.
About Pegasystems
Pegasystems is the leader in cloud software for customer engagement and operational excellence. If you’ve driven a car, used a credit card, called a company for service, opened an account, flown on a plane, submitted a claim, or performed countless other everyday tasks, chances are you’ve interacted with Pega. For the past 30 years, our technology – CRM, digital process automation, robotics, AI, and more – has empowered the world’s leading companies to achieve breakthrough results.
Hello,
Is it still the Out-Of-The-Box Report Definition or a custom version? If you run the standard version with a standard user are you still getting the same behaviour?
Maybe you can trace the execution and share the tracer XML for analysis.