Question

4
Replies
39
Views
HectorSMG Member since 2017 40 posts
INFORMATICA EL CORTE INGLES SA
Posted: September 25, 2020
Last activity: September 25, 2020

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:

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

 

Pega Platform 8.3.1
Share this page LinkedIn