Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Circumstance Definition fails with Expression Builder

SA-16740

Summary



When using Expression Builder to construct an expression in Circumstance Definition, the rule fails to save with an error. The expression is associated to a DateTime property and the expression is defined as  "@(Pega-RULES:DateTime).getCurrentTimeOfDayStamp()". The expression is valid, but failed to save. If however, using a timestamp literal value as "20151111T000000.000 GMT", the Circumstance Definition was could be save successfully. 


Error Messages



General Error: ** Save failed: cannot parse date/time "@(Pega-RULES:DateTime).getCurrentTimeOfDayStamp()" in property pxCreateDateTime: code: <none> SQLState: <none> Message: <none>
-------------------------------
2015-09-24 14:20:17,083 [ WebContainer : 13] [ Developer] [ my_app:01.02.49] ( WBSave._baseclass.Action) ERROR a_host|aa.bbb.cc.dd [email protected] - Error in commit()
com.pega.pegarules.pub.database.BadTableMappingException: Database-General cannot parse date/time " @(Pega-RULES:DateTime).getCurrentTimeOfDayStamp()" in property pxCreateDateTime

2015-09-24 14:19:09,177 [ WebContainer : 13] [ Developer] [ my_app:01.02.49] ( WBSave._baseclass.Action) ERROR a_host|aa.bbb.cc.dd [email protected] - Error in commit()
com.pega.pegarules.pub.database.BadTableMappingException: Database-General cannot parse date/time "@(Pega-RULES:DateTime).GetDate("20150902T000000.000 GMT")" in property pxCreateDateTime
From: (HDB0E11DA4200974A9EEDEF2B6A8C15F0:aa.bbb.cc.dd)
at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.setStmtInsert(PageDatabaseMapperImpl.java:1863)
at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.fillInInternalSaveStatementFromPageWithoutStream(PageDatabaseMapperImpl.java:1424)
at com.pega.pegarules.data.internal.access.Saver.saveInstanceWithNoDeletedColumnOnlyIfNew(Saver.java:1167)
at com.pega.pegarules.data.internal.access.Saver.saveInstance(Saver.java:821)
at com.pega.pegarules.data.internal.access.DatabaseImpl.performOps(DatabaseImpl.java:2944)
at com.pega.pegarules.data.internal.access.DatabaseImpl.attemptToProcessUpdates(DatabaseImpl.java:2342)
at com.pega.pegarules.data.internal.access.DatabaseImpl.processUpdates(DatabaseImpl.java:2195)
at com.pega.pegarules.data.internal.access.DatabaseImpl.commit(DatabaseImpl.java:1947)
at com.pegarules.generated.activity.ra_action_wbsave_e1de2ab303dbe44804268c36510f62be.step5_circum0(ra_action_wbsave_e1de2ab303dbe44804268c36510f62be.java:934)
at com.pegarules.generated.activity.ra_action_wbsave_e1de2ab303dbe44804268c36510f62be.perform(ra_action_wbsave_e1de2ab303dbe44804268c36510f62be.java:143)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3020)
at com.pegarules.generated.activity.ra_action_wbsave_bff60bdf3e0b59adcfb1038a07e19748.step2_circum0(ra_action_wbsave_bff60bdf3e0b59adcfb1038a07e19748.java:270)
at com.pegarules.generated.activity.ra_action_wbsave_bff60bdf3e0b59adcfb1038a07e19748.perform(ra_action_wbsave_bff60bdf3e0b59adcfb1038a07e19748.java:90)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3020)


Steps to Reproduce



1) Create a DateTime property
2) Create a Circumstance Template linked to the DateTime property
3) Create a Circumstance Definition rule and use the Expression Builder to include the below statement:
@(Pega-RULES:DateTime).getCurrentTimeOfDayStamp() 
4) Attempt to save the Circumstance Definition rule.


Root Cause



This issue was determined to be a product enhancement request. 
 

Resolution



An enhancement request FDBK-13353 has been created for consideration by Pega Product Management. The Product Management team will evaluate this item during the normal maintenance level or product planning cycles and make an appropriate decision.
 

 

Suggest Edit

Published January 31, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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

Pega Community 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
Contact us