Question
Tech Mahindra
AU
Last activity: 4 Apr 2018 0:50 EDT
PegaPDFSImplementation missing while trying to access Customer Service for Financial Services
Dear Team,
In one of our customer engagements, we had to install Customer Service for Financial Services after installing the Platform, Customer Service and FSIF. When I try accessing the CS for financial Services it gives an error mentioning PegaPDFSImplementation is missing. When I looked at the application stack, I could see that the CS for financial services is dependent on PegaPDFSImplementation application which is not present in the server.
What would be the remedial course of action so as to have this application in place?
Regards,
Subhajit
Accepted Solution
Pegasystems Inc.
US
Hi Subhajit,
For CSFS v7.31, you need to install Pega Foundation for Financial Services 7.32 (software distribution 115703_PFFS732 zip) and Product Designer for Financial Services 7.32 (PDFS_7.32 which is available under 115703_PFFS732\ResourceKit\PDFS_7.32).
Pega Foundation for Financial Services (PFFS) is previously called FSIF (Financial Services Industry Foundation).
If you already have PFFS 7.31 installed, then you need to upgrade it to PFFS 7.32.
Please let me know if you still have any issues after you upgrade to PFFS 7.32 and install PDFS_7.32.
Thanks,
Susan
Pegasystems Inc.
US
Hi,
Which version of CSFS your system has?
If you are using CSFS v7.31, it needs the platform Pega 7.31, CS 7.31, Foundation for FS 7.32 and Product Designer for FS v7.32.
PegaPDFSImplementation is "Product Designer for Financial Service" application.
Did you install Product Designer for FS v7.32?
Its software is under Foundation for FS 7.32 : ResourceKit\PDFS_07.32\rules\PegaPDFS_732.zip.
Please go ahead to install it.
In below CSFS installation guide, Prerequisites section, page #5, step 8 to install Product Designer for FS 7.32.
Thanks,
Susan
Tech Mahindra
AU
Hi Susan,
The Pega Platform is 7.3.1, The CS version is also 7.3.1, Pega FSIF is 7.2.1 and the CSFS version is also 7.3.1.
When I open the Application stack for the CSFS 7.31, it shows that it is dependent on CustomerService 7.1 and PDFSImplementation 7.2.1 applications. I guess the PDFSImplementation application is missing in the application stack.
Could you let me know if how to get the zip for the Product Designer?
Do we need to install the FSIF 7.3.2 version for resolving this issue?
Thanks and Regards,
Subhajit
Tech Mahindra
AU
Hi Susan,
We already have FSIF 7.3.1 installed. If we import the FSIF for 7.3.2, will it cause any problems or do we need to manually update all the application dependencies?
Please help.
Thanks and Regards,
Subhajit
Pegasystems Inc.
IN
Hi Subhajit,
For CSFS 7.31 FSIF 7.32 and Product Designer for FS v7.32 are the prerequisites along with CS 7.31 and pega 7.31.
As you have installed FSIF 7.31 at your end you need to upgrade it to FSIF 7.32.
Product Designer for Financial Services version 7.32 assets are located on the Pega Foundation for Financial Services distribution media, in the ResourceKit\PDFS_07.32 directory. Navigate to this directory to import the media.
Regards,
Nishitha
Accepted Solution
Pegasystems Inc.
US
Hi Subhajit,
For CSFS v7.31, you need to install Pega Foundation for Financial Services 7.32 (software distribution 115703_PFFS732 zip) and Product Designer for Financial Services 7.32 (PDFS_7.32 which is available under 115703_PFFS732\ResourceKit\PDFS_7.32).
Pega Foundation for Financial Services (PFFS) is previously called FSIF (Financial Services Industry Foundation).
If you already have PFFS 7.31 installed, then you need to upgrade it to PFFS 7.32.
Please let me know if you still have any issues after you upgrade to PFFS 7.32 and install PDFS_7.32.
Thanks,
Susan
Accenture
AU
Hi Pega Team,
We installed the missing component and verification is now in progress. In tomcat logfile, I see below error. It simply complains about the fact that function pegadata.pr_read_from_stream does not exist. I read a few articles and they suggest it could be due to the fact that we bypassed installing Java UDF.
In file setupDatabase.properties (bypass.udf.generation=true). We did this because our database is postgre RDS and we don't have access to underlying infrastructure to deploy the required libraries.
Could I confirm with you that this is ok and we can ignore this error in our log files? Is there a way to remove this error from tomcat logs? Thanks.
com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 0 SQLState: 42883 Message: ERROR: function pegadata.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: 8
DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: function pegadata.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: 8
| SQL Code: 0 | SQL State: 42883
Hi Pega Team,
We installed the missing component and verification is now in progress. In tomcat logfile, I see below error. It simply complains about the fact that function pegadata.pr_read_from_stream does not exist. I read a few articles and they suggest it could be due to the fact that we bypassed installing Java UDF.
In file setupDatabase.properties (bypass.udf.generation=true). We did this because our database is postgre RDS and we don't have access to underlying infrastructure to deploy the required libraries.
Could I confirm with you that this is ok and we can ignore this error in our log files? Is there a way to remove this error from tomcat logs? Thanks.
com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 0 SQLState: 42883 Message: ERROR: function pegadata.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: 8
DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: function pegadata.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: 8
| SQL Code: 0 | SQL State: 42883
at com.pega.pegarules.data.internal.access.ExceptionInformation.createAppropriateExceptionDueToDBFailure(ExceptionInformation.java:354) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:333) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.convertSqlExceptionToDatabaseException(Lister.java:577) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.listWithResultPresenter(Lister.java:260) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.queryexec.SqlQueryExecutor.executeQuery(SqlQueryExecutor.java:99) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.queryexec.SqlQueryExecutor.executeQuery(SqlQueryExecutor.java:50) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.SQLExecutorResultsCP.executeQuery(SQLExecutorResultsCP.java:110) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.executeMainReport(SqlReportExecutor.java:156) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:83) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:54) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.PRDataProviderImpl.executeReport(PRDataProviderImpl.java:1460) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.Executable.executeReport(Executable.java:11111) ~[prprivate.jar:?]
at com.pegarules.generated.definition.ra_action_getcustomerexpireddocuments_0d28d120db486f881d335484bfaf4e55.perform(ra_action_getcustomerexpireddocuments_0d28d120db486f881d335484bfaf4e55.java:52) ~[?:?]
at com.pega.pegarules.session.internal.mgmt.Executable.doAction(Executable.java:3402) ~[prprivate.jar:?]
at com.pegarules.generated.activity.ra_action_pxretrievereportdata_000526128e76e1ea70aeb8f9dbf10a07.step33_circum0(ra_action_pxretrievereportdata_000526128e76e1ea70aeb8f9dbf10a07.java:3622) ~[?:?]
at com.pegarules.generated.activity.ra_action_pxretrievereportdata_000526128e76e1ea70aeb8f9dbf10a07.perform(ra_action_pxretrievereportdata_000526128e76e1ea70aeb8f9dbf10a07.java:701) ~[?:?]
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3597) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10845) ~[prprivate.jar:?]
at com.pegarules.generated.activity.ra_action_pxcallretrievereportdata_bdad8aec32fa6f6b37675fbef2631bbd.step4_circum0(ra_action_pxcallretrievereportdata_bdad8aec32fa6f6b37675fbef2631bbd.java:374) ~[?:?]
at com.pegarules.generated.activity.ra_action_pxcallretrievereportdata_bdad8aec32fa6f6b37675fbef2631bbd.perform(ra_action_pxcallretrievereportdata_bdad8aec32fa6f6b37675fbef2631bbd.java:124) ~[?:?]
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3597) ~[prprivate.jar:?]
at com.pega.pegarules.exec.internal.declare.infengine.pages.DeclarativePageDirectoryImpl.runRule(DeclarativePageDirectoryImpl.java:1092) ~[prprivate.jar:?]
at com.pega.pegarules.exec.internal.declare.infengine.pages.DeclarativePageDirectoryImpl.runLoadActivity(DeclarativePageDirectoryImpl.java:446) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.base.handler.EditableDataPageHandler.loadDataPage(EditableDataPageHandler.java:129) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.base.handler.EditableDataPageHandler.findDataPage(EditableDataPageHandler.java:278) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.base.AbstractPageDirectory.findDataPageInCurrentDir(AbstractPageDirectory.java:941) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.base.AbstractPageDirectory.getDirectPage(AbstractPageDirectory.java:721) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.base.ThreadPageDir.getDirectPage(ThreadPageDir.java:471) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.base.ThreadPageDir.getPage(ThreadPageDir.java:429) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.getPage(PRThreadImpl.java:559) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.Executable.findPage(Executable.java:2168) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.Executable.findDataPage(Executable.java:11054) ~[prprivate.jar:?]
at com.pegarules.generated.activity.ra_action_createcustomerdocexpiryevents_ae11967781ffec4311ae7eca65d0a953.perform(ra_action_createcustomerdocexpiryevents_ae11967781ffec4311ae7eca65d0a953.java:177) ~[?:?]
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3597) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.runActivity(QueueProcessor.java:786) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:655) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:1055) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1327) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1075) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:957) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:761) ~[prprivate.jar:?]
at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:991) ~[prjsr166java6-3.0.jar:?]
at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:532) ~[prjsr166java6-3.0.jar:?]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_161]
Caused by: org.postgresql.util.PSQLException: ERROR: function pegadata.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: 8
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458) ~[postgresql-9.4.1211.jar:9.4.1211]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2158) ~[postgresql-9.4.1211.jar:9.4.1211]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:291) ~[postgresql-9.4.1211.jar:9.4.1211]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432) ~[postgresql-9.4.1211.jar:9.4.1211]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358) ~[postgresql-9.4.1211.jar:9.4.1211]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:171) ~[postgresql-9.4.1211.jar:9.4.1211]
at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:160) ~[postgresql-9.4.1211.jar:9.4.1211]
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197) ~[tomcat-dbcp.jar:8.5.28]
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197) ~[tomcat-dbcp.jar:8.5.28]
at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:504) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.listWithResultPresenter(Lister.java:238) ~[prprivate.jar:?]
... 40 more
2018-03-14 12:55:45,005 [ PegaRULES-Batch-4] [ STANDARD] [ ] [ PegaFSIF:07.21] ( rd.queryexec.SqlQueryExecutor) ERROR - Query: SELECT pegadata.pr_read_from_stream('.CD_CIFNBR', "PC0".pzInsKey, "PC0".pzPVStream) AS "CD_CIFNBR" , pegadata.pr_read_from_stream('.CD_DOCEXPIRYDATE', "PC0".pzInsKey, "PC0".pzPVStream) AS "CD_DOCEXPIRYDATE" , pegadata.pr_read_from_stream('.CD_DOCNAME', "PC0".pzInsKey, "PC0".pzPVStream) AS "CD_DOCNAME" , pegadata.pr_read_from_stream('.CD_DOCTYPE', "PC0".pzInsKey, "PC0".pzPVStream) AS "CD_DOCTYPE" , pegadata.pr_read_from_stream('.CD_ISSUEDCOUNTRY', "PC0".pzInsKey, "PC0".pzPVStream) AS "CD_ISSUEDCOUNTRY" , pegadata.pr_read_from_stream('.CD_ISSUEDSTATE', "PC0".pzInsKey, "PC0".pzPVStream) AS "CD_ISSUEDSTATE" FROM pegadata.pr_other "PC0" WHERE ( pegadata.pr_read_from_stream('.CD_DOCEXPIRYDATE', "PC0".pzInsKey, "PC0".pzPVStream) IS NOT NULL AND pegadata.pr_read_from_stream('.CD_DOCEXPIRYDATE', "PC0".pzInsKey, "PC0".pzPVStream) <= ? ) AND "PC0"."pxobjclass" = ?