Support Article

Manually publishing FCM data fails with database error

SA-36416

Summary



When a user tries to publish data in FCMR through the FCMR landing page, a database error is thrown in the log. User tried multiple times for “Work”, “Administrative” and “Assignments” options. No error appears on screen, but the logs show errors and data is not published in FCMR.

Error Messages



Last SQL: SELECT "PARENTPC0".L1 AS "pyPublishType" , "PARENTPC0".L2 AS "pyRecordsSavedCount" , "PARENTPC0".L3 AS "pyTimeLeft" , "PARENTPC0".L4 AS "pxCreateDateTime" , "PARENTPC0".L5 AS "pyTotalRecords" , "PARENTPC0".L6 AS "pzInsKey" , "PARENTPC0".L7 AS "pyUserIdentifier" , "PARENTPC0".L8 AS "pyOperation" , "PARENTPC0".L9 AS "pyOperationStatus" , "PARENTPC0".L10 AS "pzRank" FROM ( SELECT "PC0".PYPUBLISHTYPE AS "L1" , "PC0".PYRECORDSSAVEDCOUNT AS "L2" , FCMR.pr_read_from_stream('.pyTimeLeft', "PC0".pzInsKey, "PC0".pzPVStream) AS "L3" , "PC0".PXCREATEDATETIME AS "L4" , "PC0".PYTOTALRECORDS AS "L5" , "PC0".PZINSKEY AS "L6" , "PC0".PYUSERIDENTIFIER AS "L7" , "PC0".PYOPERATION AS "L8" , "PC0".PYOPERATIONSTATUS AS "L9" , ROW_NUMBER() OVER (ORDER BY "PC0".PXCREATEDATETIME DESC NULLS LAST) AS "L10" FROM PEGADATA.PR_LOG_FCMR "PC0" WHERE ( "PC0".PYOPERATION <> ? AND "PC0".PYOPERATION <> ? AND ( "PC0".PYOPERATIONSTATUS <> ? OR "PC0".PYOPERATIONSTATUS IS NULL ) ) AND "PC0".pxObjClass = ? ) "PARENTPC0" WHERE "PARENTPC0".L10 <= ? ORDER BY 10 ASC
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=PR_READ_FROM_STREAM;FUNCTION, DRIVER=3.72.24

Steps to Reproduce



Go to the FCMR landing page and click the Publish button.

Root Cause



A defect in Pegasystems’ code or rules
Pega-provided User Defined Functions (UDFs) should not be needed, but because a column is not exposed initially, they are called.


Resolution



Perform the following local-change:
Expose the pyTimeLeft column in the PegaDATA.PR_LOG_FCMR table.


Published April 12, 2017 - Updated May 1, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.