Support Article

Reports not working after upgrade to 7.2.2 - string is not date

SA-33227

Summary



After upgrade to Pega 7.2.2, seeing same issue as when upgraded to 7.2.1.

Exception running reports string is not a date. (String is a time stamp)
Got HFix-30969 for 7.2.1, but now on 7.2.2 issue is reappearing.


Error Messages



2017-01-23 10:07:59,977 [ttp-bio-8180-exec-71] [ STANDARD] [Adjustments:10.03.01] ( internal.mgmt.Executable) ERROR xx.xxxx.com|ip.port-- Exception
com.pega.pegarules.pub.clipboard.InvalidValueException: String was not a date "01/01/2017 12:00 AM"
at com.pega.pegarules.pub.util.PRDateFormat.parseAsDate(PRDateFormat.java:1472)
at com.pega.pegarules.pub.util.PRDateFormat.parseAsDate(PRDateFormat.java:1451)
at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.setStmtInsert(PageDatabaseMapperImpl.java:1997)
at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.fillInStatementFromValList(PageDatabaseMapperImpl.java:1158)
at com.pega.pegarules.data.internal.access.ListSpec.list(ListSpec.java:339)
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:114)
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:66)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2954)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2934)
at com.pegarules.generated.activity.ra_action_getcontent_b0237cd8c4caef20383730671162b795.step1_circum0(ra_action_getcontent_b0237cd8c4caef20383730671162b795.java:208)
at com.pegarules.generated.activity.ra_action_getcontent_b0237cd8c4caef20383730671162b795.perform(ra_action_getcontent_b0237cd8c4caef20383730671162b795.java:70)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3553)
at com.pegarules.generated.callContentActivity_071017_YrFL8WJ7Pj9jQsip_Ux7Aw.callContentActivity07_10_17(callContentActivity_071017_YrFL8WJ7Pj9jQsip_Ux7Aw.java:111)
at com.pegarules.generated.callContentActivity_071017_YrFL8WJ7Pj9jQsip_Ux7Aw.invoke(callContentActivity_071017_YrFL8WJ7Pj9jQsip_Ux7Aw.java:69)
at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:221)
at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:119)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:9105)
at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflectionWithException(LibrarySupport.java:275)
at com.pegarules.generated.activity.ra_action_process_1b2d70f7a93069d9c69dabcdadceff66.step33_circum0(ra_action_process_1b2d70f7a93069d9c69dabcdadceff66.java:2283)
at com.pegarules.generated.activity.ra_action_process_1b2d70f7a93069d9c69dabcdadceff66.perform(ra_action_process_1b2d70f7a93069d9c69dabcdadceff66.java:544)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3553)
at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646)
at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:465)
at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.runActivities(HttpAPI.java:3203)
at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:391)
at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)


Steps to Reproduce



Run a list view with date criteria.


Root Cause



PageDatabaseMapper is using parseDate() API parse dates/datetime values in strings format .

Resolution



Modified PageDatabaseMapperImpl to use parseDateTime() API to parse datetime string formats.

Provided HFix-31876

Published February 2, 2017 - Updated February 3, 2017

Have a question? Get answers now.

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