Closed
I'm getting An error occured on executing the report definition -(RD name:pyCompletedAssignmentsDefinition)
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 ?
***Edited by Moderator Marissa to update Platform Capability tags****
To see attachments, please log in.
Posted: 3 years ago
PEGA
Pegasystems Inc.
FR
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.
Posted: 3 years ago
Virtusa
Virtusa
LK
here is the alert message
Show More
here is the alert message
|
| Close |
Show Less
Posted: 3 years ago
Pegasystems Inc.
US
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".
Posted: 3 years ago
Virtusa
Virtusa
LK
We are not customized pyCompletedAssignmentDefinition report definition. i have identified (pylabel,pzinskey,pyPerformer,pyAssignedTo,pxTimeCreated,pxObjClass) property has no issue, Other all the properties has similar error. after that I try to exposed one property only(pyFlowName) .
Posted: 3 years ago
Blue Rose
Blue Rose
NL
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.
Posted: 3 years ago
Pegasystems Inc.
US
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.