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

 Hemanth Garlapati (HemanthG)
Paypal

Paypal
IN
HemanthG Member since 2014 2 posts
Paypal
Posted: Mar 24, 2016
Last activity: Mar 28, 2016
Posted: 24 Mar 2016 7:57 EDT
Last activity: 28 Mar 2016 2:41 EDT
Closed

caught DatabaseException while trying to save conclusion Property !pyStartIndex

Hi all,

We are getting this exception from checkforWarnings activity of Rule-Declare-Pages. This is happening when we try to save any data page. This is happening after we cleared db cache and performed a restart. Can anyone please give us a clue as to why we are seeing this?

Caused by: com.pega.pegarules.pub.runtime.IndeterminateConditionalException: ** ** No code generated for expression (5) - caught DatabaseException while trying to save conclusion Property!PYSTARTINDEX: Exception saving ClipboardPage instance via e-tier bean: code: <none> SQLState: EJB Exception: : java.lang.RuntimeException: Problem during method invocation (saveInOwnTransaction)  Message: at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:271)

        at com.pega.pegarules.priv.FUAUtil.activityPreTranIndeterminateConditionalCheck(FUAUtil.java:442)

        at com.pegarules.generated.activity.ra_action_pxretrievereportdata_ea2365ec0714372ba5ea7e36c543cc9a.step25_circum0(ra_action_pxretrievereportdata_ea2365ec0714372ba5ea7e36c543cc9a.java:3167)

        at com.pegarules.generated.activity.ra_action_pxretrievereportdata_ea2365ec0714372ba5ea7e36c543cc9a.perform(ra_action_pxretrievereportdata_ea2365ec0714372ba5ea7e36c543cc9a.java:524)

        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)

        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)

Show More

Hi all,

We are getting this exception from checkforWarnings activity of Rule-Declare-Pages. This is happening when we try to save any data page. This is happening after we cleared db cache and performed a restart. Can anyone please give us a clue as to why we are seeing this?

Caused by: com.pega.pegarules.pub.runtime.IndeterminateConditionalException: ** ** No code generated for expression (5) - caught DatabaseException while trying to save conclusion Property!PYSTARTINDEX: Exception saving ClipboardPage instance via e-tier bean: code: <none> SQLState: EJB Exception: : java.lang.RuntimeException: Problem during method invocation (saveInOwnTransaction)  Message: at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:271)

        at com.pega.pegarules.priv.FUAUtil.activityPreTranIndeterminateConditionalCheck(FUAUtil.java:442)

        at com.pegarules.generated.activity.ra_action_pxretrievereportdata_ea2365ec0714372ba5ea7e36c543cc9a.step25_circum0(ra_action_pxretrievereportdata_ea2365ec0714372ba5ea7e36c543cc9a.java:3167)

        at com.pegarules.generated.activity.ra_action_pxretrievereportdata_ea2365ec0714372ba5ea7e36c543cc9a.perform(ra_action_pxretrievereportdata_ea2365ec0714372ba5ea7e36c543cc9a.java:524)

        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)

        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)

        at com.pegarules.generated.activity.ra_action_pxcallretrievereportdata_ac7c5191bd54e9e32ee884ac93fa0a8e.step4_circum0(ra_action_pxcallretrievereportdata_ac7c5191bd54e9e32ee884ac93fa0a8e.java:373)

        at com.pegarules.generated.activity.ra_action_pxcallretrievereportdata_ac7c5191bd54e9e32ee884ac93fa0a8e.perform(ra_action_pxcallretrievereportdata_ac7c5191bd54e9e32ee884ac93fa0a8e.java:123)

        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)

        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)

        at com.pegarules.generated.activity.ra_action_checkforwarnings_5574e4810e7778b3024e815763345ed5.step5_circum0(ra_action_checkforwarnings_5574e4810e7778b3024e815763345ed5.java:527)

        at com.pegarules.generated.activity.ra_action_checkforwarnings_5574e4810e7778b3024e815763345ed5.perform(ra_action_checkforwarnings_5574e4810e7778b3024e815763345ed5.java:120)

        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)

        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)

        at com.pegarules.generated.activity.ra_action_standardvalidate_7fef3e27af128b6cbe6c28ac874f0677.step14_circum0(ra_action_standardvalidate_7fef3e27af128b6cbe6c28ac874f0677.java:1351)

        at com.pegarules.generated.activity.ra_action_standardvalidate_7fef3e27af128b6cbe6c28ac874f0677.perform(ra_action_standardvalidate_7fef3e27af128b6cbe6c28ac874f0677.java:310)

        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)

        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)

        at com.pegarules.generated.activity.ra_action_savesetup_4eb219ec0c4871c82bdecff81e70846c.step10_circum0(ra_action_savesetup_4eb219ec0c4871c82bdecff81e70846c.java:931)

        at com.pegarules.generated.activity.ra_action_savesetup_4eb219ec0c4871c82bdecff81e70846c.perform(ra_action_savesetup_4eb219ec0c4871c82bdecff81e70846c.java:222)

        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)

        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)

        at com.pegarules.generated.activity.ra_action_save_8a9389718ecc3a03d944e63fa1749839.step6_circum0(ra_action_save_8a9389718ecc3a03d944e63fa1749839.java:1105)

        at com.pegarules.generated.activity.ra_action_save_8a9389718ecc3a03d944e63fa1749839.perform(ra_action_save_8a9389718ecc3a03d944e63fa1749839.java:154)

        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)

        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)

        at com.pegarules.generated.activity.ra_action_wbsave_e5084315e488b7e6a97b8fcc7c0c5bf9.step4_circum0(ra_action_wbsave_e5084315e488b7e6a97b8fcc7c0c5bf9.java:679)

        at com.pegarules.generated.activity.ra_action_wbsave_e5084315e488b7e6a97b8fcc7c0c5bf9.perform(ra_action_wbsave_e5084315e488b7e6a97b8fcc7c0c5bf9.java:123)

        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)

        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)

        at com.pegarules.generated.activity.ra_action_wbsave_b30c51565c6494e204fb3b073f4a29d2.step4_circum0(ra_action_wbsave_b30c51565c6494e204fb3b073f4a29d2.java:386)

        at com.pegarules.generated.activity.ra_action_wbsave_b30c51565c6494e204fb3b073f4a29d2.perform(ra_action_wbsave_b30c51565c6494e204fb3b073f4a29d2.java:122)

        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)

        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)

        at com.pegarules.generated.activity.ra_action_rmactionsave_16cfff2a41335510d8b2f9f7f80c171c.step4_circum0(ra_action_rmactionsave_16cfff2a41335510d8b2f9f7f80c171c.java:374)

        at com.pegarules.generated.activity.ra_action_rmactionsave_16cfff2a41335510d8b2f9f7f80c171c.perform(ra_action_rmactionsave_16cfff2a41335510d8b2f9f7f80c171c.java:120)

        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)

        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)

        at com.pegarules.generated.activity.ra_action_processrmaction_b2414ca9344c4ec0701560598b5b5aeb.step6_circum0(ra_action_processrmaction_b2414ca9344c4ec0701560598b5b5aeb.java:838)

        at com.pegarules.generated.activity.ra_action_processrmaction_b2414ca9344c4ec0701560598b5b5aeb.perform(ra_action_processrmaction_b2414ca9344c4ec0701560598b5b5aeb.java:157)

        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)

        at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)

        at com.pegarules.generated.activity.ra_action_pzruleformtoolbaraction_92e3dff3a770b8ae9e3f0d83f3cb2fbf.step4_circum0(ra_action_pzruleformtoolbaraction_92e3dff3a770b8ae9e3f0d83f3cb2fbf.java:416)

        at com.pegarules.generated.activity.ra_action_pzruleformtoolbaraction_92e3dff3a770b8ae9e3f0d83f3cb2fbf.perform(ra_action_pzruleformtoolbaraction_92e3dff3a770b8ae9e3f0d83f3cb2fbf.java:121)

        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)

        at com.pegarules.generated.activity.ra_action_pzrunactionwrapper_056ec03796d8a13802f156886066036d.step1_circum0(ra_action_pzrunactionwrapper_056ec03796d8a13802f156886066036d.java:318)

        at com.pegarules.generated.activity.ra_action_pzrunactionwrapper_056ec03796d8a13802f156886066036d.perform(ra_action_pzrunactionwrapper_056ec03796d8a13802f156886066036d.java:69)

        at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)

        at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646)

        ... 56 more


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

Posted: 8 years ago
Posted: 28 Mar 2016 1:10 EDT
Hemanth Garlapati (HemanthG)
Paypal

Paypal
IN

Hi Rajiv,

Thanks for the reply. Yes, this property exists in pega ruleset. After doing the resolution steps mentioned in below article for pxRetrieveReportData , these errors were resolved at the node level.

https://community.pega.com/support/support-articles/indeterminateconditionalexception-trying-save-flow-rules


We may have repeat it in all the other 10 nodes that use the same datasource for pega db, would be great if you can point to the root cause, so we can understand and avoid this in future.

To see attachments, please log in.
Posted: 8 years ago
Posted: 28 Mar 2016 2:41 EDT
Rajiv Nistala (nistr) Senior Manager - Engineering
Pegasystems
IN

I am not sure about the root cause. Looks like the assembly didn't happen correctly because the memory or DB cache didn't have the right data. It is difficult to trace back why this might have happened.

To see attachments, please log in.

Related content:

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