Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Mark Olive (MARKO929)
Cahaba Gba
US
MARKO929 Member since 2011 11 posts
Posted: Nov 14, 2016
Last activity: Nov 18, 2016
Posted: 14 Nov 2016 11:19 EST
Last activity: 18 Nov 2016 23:29 EST
Closed

PEGA pr_read_from_stream Function Error

I have noticed in our log file an error that references a PEGA function. Looking in the posts, it looks like this may be related to the UDF's being corrupted. Is this the case here and how would I go about correcting this. Below is the log file entry:

Show More

I have noticed in our log file an error that references a PEGA function. Looking in the posts, it looks like this may be related to the UDF's being corrupted. Is this the case here and how would I go about correcting this. Below is the log file entry:

[10/27/16 7:17:12:206 CDT] 0000001f SystemOut     O 2016-10-27 07:17:12,200 [   WebContainer : 36] ( rd.queryexec.SqlQueryExecutor) ERROR pegacahaba.bcbsal.org|bc450intraltm.bcbsal.org - An error occured on
executing the query for the report definition - There was a problem getting a list: code: -4304 SQLState: 42724 Message: DB2 SQL Error: SQLCODE=-4304, SQLSTATE=42724, SQLERRMC=PROD.PR_READ_FROM_STRE;SQL16011
6015347200;/home/db2inst1/sqllib/functi, DRIVER=4.19.26
com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: -4304 SQLState: 42724 Message: DB2 SQL Error: SQLCODE=-4304, SQLSTATE=42724, SQLERRMC=PROD.PR_READ_FROM_STRE;SQL16
0116015347200;/home/db2inst1/sqllib/functi, DRIVER=4.19.26
From: (H2767CA1A17D84FFF59B5DD9B179367C2:bc450intraltm.bcbsal.org)
        SQL: SELECT DISTINCT PROD.pr_read_from_stream('.pyMessageKey', "PC0".pzInsKey, "PC0".pzPVStream) AS "pyMessageKey" , "PC0".PXTIMECREATED AS "pxTimeCreated" , "PC0".PYPERFORMER AS "pyPerformer" , "PC0
".PXHISTORYFORREFERENCE AS "pxHistoryForReference" , PROD.pr_read_from_stream('.pxAddedByID', "PC0".pzInsKey, "PC0".pzPVStream) AS "pxAddedByID" FROM PROD.pr_history "PC0" WHERE  (  (  PROD.pr_read_from_stre
am('.pyMessageKey', "PC0".pzInsKey, "PC0".pzPVStream) LIKE ?   OR  PROD.pr_read_from_stream('.pyMessageKey', "PC0".pzInsKey, "PC0".pzPVStream) LIKE ?   OR  PROD.pr_read_from_stream('.pyMessageKey', "PC0".pzI
nsKey, "PC0".pzPVStream) LIKE ?   )  AND "PC0".PXHISTORYFORREFERENCE = ?  )  AND  "PC0".pxObjClass LIKE ?   ORDER BY 2 DESC
        SQL Inserts: <%StatusChanged%>  <%ItemCreated%> <%ItemReopened%>        <CGBA-CLAIMS-CATS-WORK ASSIGNA-1037737> <History-CGBA-Claims-CATS-Work%>

Caused by SQL Problems.
Problem #1, SQLState 42724, Error code -4304: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-4304, SQLSTATE=42724, SQLERRMC=PROD.PR_READ_FROM_STRE;SQL160116015347200;/home/db2inst1/sqlli
b/functi, DRIVER=4.19.26
        at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:167)
        at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6298)
        at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6022)
        at com.pega.pegarules.data.internal.rd.queryexec.SqlQueryExecutor.executeQuery(SqlQueryExecutor.java:68)
        at com.pega.pegarules.data.internal.rd.queryexec.SqlQueryExecutor.executeQuery(SqlQueryExecutor.java:43)
        at com.pega.pegarules.data.internal.rd.SqlReportExecutor.executeQuery(SqlReportExecutor.java:279)
        at com.pega.pegarules.data.internal.rd.SqlReportExecutor.executeMainReport(SqlReportExecutor.java:126)
        at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:89)
        at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:56)
        at com.pega.pegarules.data.internal.PRDataProviderImpl.executeReport(PRDataProviderImpl.java:1240)
        at com.pega.pegarules.session.internal.mgmt.Executable.executeReport(Executable.java:10566)
        at com.pegarules.generated.definition.ra_action_pygetstatuschanges_3c96bdd51590968ea636f436fe12ec69.perform(ra_action_pygetstatuschanges_3c96bdd51590968ea636f436fe12ec69.java:50)
        at com.pega.pegarules.session.internal.mgmt.Executable.doAction(Executable.java:3086)
        at com.pegarules.generated.activity.ra_action_pxretrievereportdata_f4e4aa367a33b0ea2d8ac061a41e5f7f.step26_circum0(ra_action_pxretrievereportdata_f4e4aa367a33b0ea2d8ac061a41e5f7f.java:2848)
        at com.pegarules.generated.activity.ra_action_pxretrievereportdata_f4e4aa367a33b0ea2d8ac061a41e5f7f.perform(ra_action_pxretrievereportdata_f4e4aa367a33b0ea2d8ac061a41e5f7f.java:560)
        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3275)
        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10265)
        at com.pegarules.generated.activity.ra_action_pzfetchcasestatusupdate_1ce563401ceec1502eabee2a4f4f5b0a.step5_circum0(ra_action_pzfetchcasestatusupdate_1ce563401ceec1502eabee2a4f4f5b0a.java:467)
        at com.pegarules.generated.activity.ra_action_pzfetchcasestatusupdate_1ce563401ceec1502eabee2a4f4f5b0a.perform(ra_action_pzfetchcasestatusupdate_1ce563401ceec1502eabee2a4f4f5b0a.java:126)
        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3275)
        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10265)
        at com.pegarules.generated.activity.ra_action_pzfetchsubcaseattachments_0f20e0b65ef8a8bbdcf5cc295a6d541f.step11_circum0(ra_action_pzfetchsubcaseattachments_0f20e0b65ef8a8bbdcf5cc295a6d541f.java:1118)
        at com.pegarules.generated.activity.ra_action_pzfetchsubcaseattachments_0f20e0b65ef8a8bbdcf5cc295a6d541f.perform(ra_action_pzfetchsubcaseattachments_0f20e0b65ef8a8bbdcf5cc295a6d541f.java:269)
        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3275)
        at com.pegarules.generated.callActivity_071001_KhcknoEKbSvWlpqH0tlTMw.callActivity07_10_01(callActivity_071001_KhcknoEKbSvWlpqH0tlTMw.java:122)
        at com.pegarules.generated.callActivity_071001_KhcknoEKbSvWlpqH0tlTMw.invoke(callActivity_071001_KhcknoEKbSvWlpqH0tlTMw.java:82)
        at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:133)
        at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:110)
        at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:8633)
        at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflection(LibrarySupport.java:181)
        at com.pegarules.generated.pega_rules_utilities.callActivity(pega_rules_utilities.java:1479)
        at com.pegarules.generated.flowaction.ra_action_pycasenarrativecontent_96e7bf07a136a2db764714320034c54e.RunFlowActionActivity_circum0(ra_action_pycasenarrativecontent_96e7bf07a136a2db764714320034c54e
.java:332)
        at com.pegarules.generated.flowaction.ra_action_pycasenarrativecontent_96e7bf07a136a2db764714320034c54e.perform(ra_action_pycasenarrativecontent_96e7bf07a136a2db764714320034c54e.java:72)
        at com.pega.pegarules.session.internal.mgmt.Executable.doAction(Executable.java:3086)
        at com.pegarules.generated.activity.ra_action_pzlocalactionrender_0f51b3928fdbb3fcaf1e246bc2010d4d.step3_circum0(ra_action_pzlocalactionrender_0f51b3928fdbb3fcaf1e246bc2010d4d.java:302)
        at com.pegarules.generated.activity.ra_action_pzlocalactionrender_0f51b3928fdbb3fcaf1e246bc2010d4d.perform(ra_action_pzlocalactionrender_0f51b3928fdbb3fcaf1e246bc2010d4d.java:106)
        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3275)
        at com.pegarules.generated.html_section.ra_stream_pzlocalactionimpl_1621eb36fb5e4f47c490b16044ffb853.execute(ra_stream_pzlocalactionimpl_1621eb36fb5e4f47c490b16044ffb853.java:143)
        at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:3802)
        at com.pega.pegarules.session.internal.mgmt.autostreams.AutoStreamRuleRuntime.getSectionStream(AutoStreamRuleRuntime.java:149)
        at com.pegarules.generated.html_section.ra_stream_pxlocalaction_ecfb7c5c5ba1a32105dc9ef4233433cb.includeSectionBody_1(ra_stream_pxlocalaction_ecfb7c5c5ba1a32105dc9ef4233433cb.java:223)
        at com.pegarules.generated.html_section.ra_stream_pxlocalaction_ecfb7c5c5ba1a32105dc9ef4233433cb.pzLayoutBodyWrapper_1(ra_stream_pxlocalaction_ecfb7c5c5ba1a32105dc9ef4233433cb.java:213)
        at com.pegarules.generated.html_section.ra_stream_pxlocalaction_ecfb7c5c5ba1a32105dc9ef4233433cb.pzLayout_1(ra_stream_pxlocalaction_ecfb7c5c5ba1a32105dc9ef4233433cb.java:228)
        at com.pegarules.generated.html_section.ra_stream_pxlocalaction_ecfb7c5c5ba1a32105dc9ef4233433cb.pzSectionBody_1(ra_stream_pxlocalaction_ecfb7c5c5ba1a32105dc9ef4233433cb.java:205)
        at com.pegarules.generated.html_section.ra_stream_pxlocalaction_ecfb7c5c5ba1a32105dc9ef4233433cb.execute(ra_stream_pxlocalaction_ecfb7c5c5ba1a32105dc9ef4233433cb.java:100)
        at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:3802)
        at com.pega.pegarules.session.internal.mgmt.autostreams.AutoStreamRuleRuntime.getSectionStream(AutoStreamRuleRuntime.java:149)
        at com.pegarules.generated.html_section.ra_stream_pycasenarrativewrapper_943de67c506f4321fb49fdca12569af9.includeSectionBody_1(ra_stream_pycasenarrativewrapper_943de67c506f4321fb49fdca12569af9.java:2
24)
        at com.pegarules.generated.html_section.ra_stream_pycasenarrativewrapper_943de67c506f4321fb49fdca12569af9.pzLayoutBodyWrapper_1(ra_stream_pycasenarrativewrapper_943de67c506f4321fb49fdca12569af9.java:
214)
        at com.pegarules.generated.html_section.ra_stream_pycasenarrativewrapper_943de67c506f4321fb49fdca12569af9.pzLayout_1(ra_stream_pycasenarrativewrapper_943de67c506f4321fb49fdca12569af9.java:229)
        at com.pegarules.generated.html_section.ra_stream_pycasenarrativewrapper_943de67c506f4321fb49fdca12569af9.pzSectionBody_1(ra_stream_pycasenarrativewrapper_943de67c506f4321fb49fdca12569af9.java:206)
        at com.pegarules.generated.html_section.ra_stream_pycasenarrativewrapper_943de67c506f4321fb49fdca12569af9.execute(ra_stream_pycasenarrativewrapper_943de67c506f4321fb49fdca12569af9.java:100)
        at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:3802)
        at com.pega.pegarules.session.internal.mgmt.autostreams.AutoStreamRuleRuntime.getSectionStream(AutoStreamRuleRuntime.java:149)
        at com.pegarules.generated.html_section.ra_stream_pycaseauditinner_488aa8994ea09da2734d2e3313c4d1cb.includeSectionBody_2(ra_stream_pycaseauditinner_488aa8994ea09da2734d2e3313c4d1cb.java:246)
        at com.pegarules.generated.html_section.ra_stream_pycaseauditinner_488aa8994ea09da2734d2e3313c4d1cb.pzLayoutBodyWrapper_2(ra_stream_pycaseauditinner_488aa8994ea09da2734d2e3313c4d1cb.java:235)
        at com.pegarules.generated.html_section.ra_stream_pycaseauditinner_488aa8994ea09da2734d2e3313c4d1cb.pzLayout_2(ra_stream_pycaseauditinner_488aa8994ea09da2734d2e3313c4d1cb.java:280)
        at com.pegarules.generated.html_section.ra_stream_pycaseauditinner_488aa8994ea09da2734d2e3313c4d1cb.pzSectionBody_1(ra_stream_pycaseauditinner_488aa8994ea09da2734d2e3313c4d1cb.java:215)
        at com.pegarules.generated.html_section.ra_stream_pycaseauditinner_488aa8994ea09da2734d2e3313c4d1cb.execute(ra_stream_pycaseauditinner_488aa8994ea09da2734d2e3313c4d1cb.java:100)
        at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:3802)
        at com.pega.pegarules.session.internal.mgmt.autostreams.AutoStreamRuleRuntime.getSectionStream(AutoStreamRuleRuntime.java:149)
        at com.pegarules.generated.html_section.ra_stream_pycaseaudit_47c856d8fb8ae0e657891b2486c6b456.includeSectionBody_1(ra_stream_pycaseaudit_47c856d8fb8ae0e657891b2486c6b456.java:269)
        at com.pegarules.generated.html_section.ra_stream_pycaseaudit_47c856d8fb8ae0e657891b2486c6b456.pzLayoutBodyWrapper_1(ra_stream_pycaseaudit_47c856d8fb8ae0e657891b2486c6b456.java:259)
        at com.pegarules.generated.html_section.ra_stream_pycaseaudit_47c856d8fb8ae0e657891b2486c6b456.pzLayout_1(ra_stream_pycaseaudit_47c856d8fb8ae0e657891b2486c6b456.java:274)
        at com.pegarules.generated.html_section.ra_stream_pycaseaudit_47c856d8fb8ae0e657891b2486c6b456.pzSectionBody_1(ra_stream_pycaseaudit_47c856d8fb8ae0e657891b2486c6b456.java:212)
        at com.pegarules.generated.html_section.ra_stream_pycaseaudit_47c856d8fb8ae0e657891b2486c6b456.execute(ra_stream_pycaseaudit_47c856d8fb8ae0e657891b2486c6b456.java:100)
        at com.pega.pegarules.session.internal.mgmt.StreamBuilderTools.appendStreamKeepProperties(StreamBuilderTools.java:719)
        at com.pega.pegarules.session.internal.mgmt.autostreams.IncludeStreamRuntime.getStream(IncludeStreamRuntime.java:332)
        at com.pega.pegarules.session.internal.mgmt.autostreams.IncludeStreamRuntime.emitIncludeStreamReference(IncludeStreamRuntime.java:252)
        at com.pega.pegarules.session.internal.mgmt.autostreams.AutoStreamRuntimeImpl.emitIncludeStreamReference(AutoStreamRuntimeImpl.java:329)
        at com.pegarules.generated.html_section.ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.pyCaseAudit_1(ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.java:326)
        at com.pegarules.generated.html_section.ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.simpleLayoutCell_3(ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.java:337)
        at com.pegarules.generated.html_section.ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.simpleLayout_3(ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.java:360)
        at com.pegarules.generated.html_section.ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.pzLayoutBodyWrapper_3(ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.java:319)
        at com.pegarules.generated.html_section.ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.pzLayout_3(ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.java:365)
        at com.pegarules.generated.html_section.ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.layoutGroupCell_3(ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.java:532)
        at com.pegarules.generated.html_section.ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.layoutGroup_1(ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.java:552)
        at com.pegarules.generated.html_section.ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.pzLayoutBodyWrapper_4(ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.java:313)
        at com.pegarules.generated.html_section.ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.pzLayout_4(ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.java:557)
        at com.pegarules.generated.html_section.ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.pzSectionBody_1(ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.java:217)
        at com.pegarules.generated.html_section.ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.execute(ra_stream_pycasecontent_00c1b28c7b1ec241c5d6df8e5341d9e6.java:100)
        at com.pega.pegarules.session.internal.mgmt.StreamBuilderTools.appendStreamKeepProperties(StreamBuilderTools.java:719)
        at com.pega.pegarules.session.internal.mgmt.autostreams.IncludeStreamRuntime.getStream(IncludeStreamRuntime.java:332)
        at com.pega.pegarules.session.internal.mgmt.autostreams.IncludeStreamRuntime.emitIncludeStreamReference(IncludeStreamRuntime.java:252)
        at com.pega.pegarules.session.internal.mgmt.autostreams.AutoStreamRuntimeImpl.emitIncludeStreamReference(AutoStreamRuntimeImpl.java:329)
        at com.pegarules.generated.html_section.ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.pyCaseContent_1(ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.java:294)
        at com.pegarules.generated.html_section.ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.simpleLayoutCell_5(ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.java:453)
        at com.pegarules.generated.html_section.ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.simpleLayout_3(ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.java:466)
        at com.pegarules.generated.html_section.ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.pzLayoutBodyWrapper_3(ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.java:287)
        at com.pegarules.generated.html_section.ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.pzLayout_3(ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.java:471)
        at com.pegarules.generated.html_section.ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.simpleLayoutCell_6(ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.java:488)
        at com.pegarules.generated.html_section.ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.simpleLayout_5(ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.java:511)
        at com.pegarules.generated.html_section.ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.pzLayoutBodyWrapper_5(ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.java:243)
        at com.pegarules.generated.html_section.ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.pzLayout_5(ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.java:517)
        at com.pegarules.generated.html_section.ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.pzSectionBody_1(ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.java:214)
        at com.pegarules.generated.html_section.ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.execute(ra_stream_pycasebody_5b6c18d265092e0afd615f0cdf98d029.java:100)
        at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:3802)
        at com.pega.pegarules.session.internal.mgmt.autostreams.AutoStreamRuleRuntime.getSectionStream(AutoStreamRuleRuntime.java:149)
        at com.pegarules.generated.html_section.ra_stream_pycasecontainer_b1d5d36bafd5ba8d60d127080e4f0db3.includeSectionBody_4(ra_stream_pycasecontainer_b1d5d36bafd5ba8d60d127080e4f0db3.java:229)
        at com.pegarules.generated.html_section.ra_stream_pycasecontainer_b1d5d36bafd5ba8d60d127080e4f0db3.pzLayoutBodyWrapper_4(ra_stream_pycasecontainer_b1d5d36bafd5ba8d60d127080e4f0db3.java:219)
        at com.pegarules.generated.html_section.ra_stream_pycasecontainer_b1d5d36bafd5ba8d60d127080e4f0db3.pzLayout_4(ra_stream_pycasecontainer_b1d5d36bafd5ba8d60d127080e4f0db3.java:234)

        at com.pegarules.generated.html_section.ra_stream_pycasecontainer_b1d5d36bafd5ba8d60d127080e4f0db3.pzSectionBody_1(ra_stream_pycasecontainer_b1d5d36bafd5ba8d60d127080e4f0db3.java:211)
        at com.pegarules.generated.html_section.ra_stream_pycasecontainer_b1d5d36bafd5ba8d60d127080e4f0db3.execute(ra_stream_pycasecontainer_b1d5d36bafd5ba8d60d127080e4f0db3.java:100)
        at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:3802)
        at com.pega.pegarules.session.internal.mgmt.autostreams.AutoStreamRuleRuntime.getSectionStream(AutoStreamRuleRuntime.java:149)
        at com.pegarules.generated.html_section.ra_stream_pycasecontainerwithwarning_9876d59aa660ff084a81919dfb9803db.includeSectionBody_1(ra_stream_pycasecontainerwithwarning_9876d59aa660ff084a81919dfb9803d
b.java:225)
        at com.pegarules.generated.html_section.ra_stream_pycasecontainerwithwarning_9876d59aa660ff084a81919dfb9803db.pzLayoutBodyWrapper_1(ra_stream_pycasecontainerwithwarning_9876d59aa660ff084a81919dfb9803
db.java:215)
        at com.pegarules.generated.html_section.ra_stream_pycasecontainerwithwarning_9876d59aa660ff084a81919dfb9803db.pzLayout_1(ra_stream_pycasecontainerwithwarning_9876d59aa660ff084a81919dfb9803db.java:230
)
        at com.pegarules.generated.html_section.ra_stream_pycasecontainerwithwarning_9876d59aa660ff084a81919dfb9803db.pzSectionBody_1(ra_stream_pycasecontainerwithwarning_9876d59aa660ff084a81919dfb9803db.jav
a:207)
        at com.pegarules.generated.html_section.ra_stream_pycasecontainerwithwarning_9876d59aa660ff084a81919dfb9803db.execute(ra_stream_pycasecontainerwithwarning_9876d59aa660ff084a81919dfb9803db.java:100)
        at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:3802)
        at com.pega.pegarules.session.internal.mgmt.autostreams.AutoStreamRuleRuntime.getSectionStream(AutoStreamRuleRuntime.java:149)
        at com.pegarules.generated.html_harness.ra_stream_perform_7f1b69f0d6034b1c55fc3543ea77a0d5.includeSectionBody_1(ra_stream_perform_7f1b69f0d6034b1c55fc3543ea77a0d5.java:2940)
        at com.pegarules.generated.html_harness.ra_stream_perform_7f1b69f0d6034b1c55fc3543ea77a0d5.generatePegaHarnessDiv_6(ra_stream_perform_7f1b69f0d6034b1c55fc3543ea77a0d5.java:1774)
        at com.pegarules.generated.html_harness.ra_stream_perform_7f1b69f0d6034b1c55fc3543ea77a0d5.execute(ra_stream_perform_7f1b69f0d6034b1c55fc3543ea77a0d5.java:628)
        at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:3802)
        at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:3631)
        at com.pegarules.generated.activity.ra_action_show_harness_51d643dbef299ca26b77b38f884dd904.step6_circum0(ra_action_show_harness_51d643dbef299ca26b77b38f884dd904.java:684)
        at com.pegarules.generated.activity.ra_action_show_harness_51d643dbef299ca26b77b38f884dd904.perform(ra_action_show_harness_51d643dbef299ca26b77b38f884dd904.java:155)
        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3275)
        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10265)
        at com.pegarules.generated.activity.ra_action_displayharness_1d414472711606645476be6f8133a69a.step2_circum0(ra_action_displayharness_1d414472711606645476be6f8133a69a.java:336)
        at com.pegarules.generated.activity.ra_action_displayharness_1d414472711606645476be6f8133a69a.perform(ra_action_displayharness_1d414472711606645476be6f8133a69a.java:86)
        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3275)
        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10265)
        at com.pegarules.generated.activity.ra_action_perform_b0b86ee90d82814cd7e3e5124876b4e1.step16_circum0(ra_action_perform_b0b86ee90d82814cd7e3e5124876b4e1.java:1211)
        at com.pegarules.generated.activity.ra_action_perform_b0b86ee90d82814cd7e3e5124876b4e1.perform(ra_action_perform_b0b86ee90d82814cd7e3e5124876b4e1.java:352)
        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3275)
        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10265)
        at com.pegarules.generated.activity.ra_action_add_22ead3aca7888244c63f977745b75d30.step8_circum0(ra_action_add_22ead3aca7888244c63f977745b75d30.java:827)
        at com.pegarules.generated.activity.ra_action_add_22ead3aca7888244c63f977745b75d30.perform(ra_action_add_22ead3aca7888244c63f977745b75d30.java:194)
        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3275)
        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10265)
        at com.pegarules.generated.activity.ra_action_new_3d31304eb44f626163208c2e91b71ea0.step12_circum0(ra_action_new_3d31304eb44f626163208c2e91b71ea0.java:941)
        at com.pegarules.generated.activity.ra_action_new_3d31304eb44f626163208c2e91b71ea0.perform(ra_action_new_3d31304eb44f626163208c2e91b71ea0.java:282)
        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3275)
        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10265)
        at com.pegarules.generated.activity.ra_action_newfromflow_838fac44620b779a8daabe24d278fa22.step5_circum0(ra_action_newfromflow_838fac44620b779a8daabe24d278fa22.java:481)
        at com.pegarules.generated.activity.ra_action_newfromflow_838fac44620b779a8daabe24d278fa22.perform(ra_action_newfromflow_838fac44620b779a8daabe24d278fa22.java:144)
        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3275)
        at com.pegarules.generated.activity.ra_action_douiaction_cb321072ef69483913544df13aa40663.step20_circum0(ra_action_douiaction_cb321072ef69483913544df13aa40663.java:2037)
        at com.pegarules.generated.activity.ra_action_douiaction_cb321072ef69483913544df13aa40663.perform(ra_action_douiaction_cb321072ef69483913544df13aa40663.java:387)
        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3275)
        at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:640)
        at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:433)
        at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.runActivities(HttpAPI.java:3427)
        at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:402)
        at sun.reflect.GeneratedMethodAccessor61.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1203)
        at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:930)
        at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:815)
        at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:348)
        at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.invoke(HttpAPI.java:789)
        at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:312)
        at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:263)
        at com.pega.pegarules.session.internal.engineinterface.etier.ejb.EngineBean.invokeEngine(EngineBean.java:225)

        at sun.reflect.GeneratedMethodAccessor50.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:419)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:460)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingException(PRBootstrap.java:482)
        at com.pega.pegarules.internal.etier.ejb.EngineBeanBoot.invokeEngine(EngineBeanBoot.java:168)
        at com.pega.pegarules.internal.etier.interfaces.EJSLocalStatelessEngineBMT_f2439d86.invokeEngine(Unknown Source)
        at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngineInner(JNDIEnvironment.java:278)
        at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngine(JNDIEnvironment.java:223)
        at com.pega.pegarules.web.impl.WebStandardImpl.makeEtierRequest(WebStandardImpl.java:485)
        at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:290)
        at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:419)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:460)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:509)
        at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:118)
        at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doGet(WebStandardBoot.java:89)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:718)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
        at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1694)
        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:970)
        at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:508)
        at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)
        at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3994)
        at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:276)
        at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:945)
        at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)
        at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:191)
        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)
        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:516)
        at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:307)
        at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:84)
        at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1820)
        at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
        at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
        at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
        at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
        at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
        at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
        at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
        at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1662)
Caused by:
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-4304, SQLSTATE=42724, SQLERRMC=PROD.PR_READ_FROM_STRE;SQL160116015347200;/home/db2inst1/sqllib/functi, DRIVER=4.19.26
        at com.ibm.db2.jcc.am.kd.a(Unknown Source)
        at com.ibm.db2.jcc.am.kd.a(Unknown Source)
        at com.ibm.db2.jcc.am.kd.a(Unknown Source)
        at com.ibm.db2.jcc.am.ResultSet.completeSqlca(Unknown Source)
        at com.ibm.db2.jcc.am.ResultSet.earlyCloseComplete(Unknown Source)
        at com.ibm.db2.jcc.t4.bb.a(Unknown Source)
        at com.ibm.db2.jcc.t4.bb.n(Unknown Source)
        at com.ibm.db2.jcc.t4.bb.j(Unknown Source)
        at com.ibm.db2.jcc.t4.bb.d(Unknown Source)
        at com.ibm.db2.jcc.t4.p.c(Unknown Source)
        at com.ibm.db2.jcc.t4.vb.j(Unknown Source)
        at com.ibm.db2.jcc.am.fp.mb(Unknown Source)
        at com.ibm.db2.jcc.am.gp.b(Unknown Source)
        at com.ibm.db2.jcc.am.gp.nc(Unknown Source)
        at com.ibm.db2.jcc.am.gp.execute(Unknown Source)
 at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java:942)
        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:618)
        at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:990)
        at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6221)
        ... 200 more
 
 
***Updated by Moderator: Marissa to update categories***

 


Show Less
To see attachments, please log in.
Data Integration

Posted: 8 years ago
Posted: 15 Nov 2016 10:02 EST
Paul Gentile (PaulGentile_GCS)
PEGA
Principal Engineer, Technical Support, 1:1 Customer Engagement
Pegasystems Inc.
US

You could be right but I'm more inclined to think you might need to check your UDF configuration first. 

Have you made any environment changes recently (upgrades, etc.) or is this issue now appearing on a previously healthy instance?

Please refer to https://community.pega.com/support/support-articles/report-definition-error-after-migrating-database-new-server

 

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice