Error: ORA-00904 on run report definition
Hi,
With Pega 8.3.1 on premise installation on Oracle, when I run a report definition on Work- class it appears the following error:
An error occured on executing the query for the report definition - There was a problem getting a list: code: 904 SQLState: 42000 Message: ORA-00904: "PEGADATA"."PR_READ_FROM_STREAM": invalid identifier DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-00904: "PEGADATA"."PR_READ_FROM_STREAM": invalid identifier | SQL Code: 904 | SQL State: 42000
In log file we can find the query:
Hi,
With Pega 8.3.1 on premise installation on Oracle, when I run a report definition on Work- class it appears the following error:
An error occured on executing the query for the report definition - There was a problem getting a list: code: 904 SQLState: 42000 Message: ORA-00904: "PEGADATA"."PR_READ_FROM_STREAM": invalid identifier DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-00904: "PEGADATA"."PR_READ_FROM_STREAM": invalid identifier | SQL Code: 904 | SQL State: 42000
In log file we can find the query:
SELECT "PC0"."PYID" AS "pyID" , pegadata.pr_read_from_stream('.CandidateData.CURP', "PC0".pzInsKey, "PC0".pzPVStream) AS "CandidateData.CURP" , pegadata.pr_read_from_stream('.CandidateData.Name', "PC0".pzInsKey, "PC0".pzPVStream) AS "CandidateData.Name" , pegadata.pr_read_from_stream('.CandidateData.PaternalLastName', "PC0".pzInsKey, "PC0".pzPVStream) AS "CandidateData.PaternalLastName" , pegadata.pr_read_from_stream('.CandidateData.MaternalLastName', "PC0".pzInsKey, "PC0".pzPVStream) AS "CandidateData.MaternalLastName" , pegadata.pr_read_from_stream('.CandidateData.RFC', "PC0".pzInsKey, "PC0".pzPVStream) AS "CandidateData.RFC" , pegadata.pr_read_from_stream('.CandidateData.IMSS', "PC0".pzInsKey, "PC0".pzPVStream) AS "CandidateData.IMSS" , pegadata.pr_read_from_stream('.CandidateData.Figure', "PC0".pzInsKey, "PC0".pzPVStream) AS "CandidateData.Figure" , pegadata.pr_read_from_stream('.CandidateData.PlaceAssignment', "PC0".pzInsKey, "PC0".pzPVStream) AS "CandidateData.PlaceAssignment" , pegadata.pr_read_from_stream('.CandidateData.Email', "PC0".pzInsKey, "PC0".pzPVStream) AS "CandidateData.Email" , "PC0"."PYSTATUSWORK" AS "pyStatusWork" , "PC0"."PZINSKEY" AS "pzInsKey" FROM PEGADATA.pc_PPAL_RRHH_OnBoarding_Work "PC0" WHERE ( "PC0"."PXAPPLICATION" = ? AND pegadata.pr_read_from_stream('.CandidateData.Figure', "PC0".pzInsKey, "PC0".pzPVStream) IS NOT NULL ) AND "PC0"."PXOBJCLASS" LIKE ?
Thoughts??
Thanks very much
Capgemini
ES
It is a custom report definition. I attach an screenshot. You should know that this report works fine in another Pega 8.3.1 instance. Where it doesn't work is in the on-premise Pega 8.3.1 instance of the customer.
Thanks,
Capgemini
ES
Yes, I have a Pega 8.3.1 installation in an Amazon Machine with tomcat and postgre where it works fine.
The customer has an on premise installation of same Pega 8.3.1 on Weblogic and Oracle and here it doesn't work.
Thanks,