Question

7
Replies
2743
Views
GiriKonatham Member since 2008 15 posts
Kelly Services
Posted: 4 years ago
Last activity: 2 years 8 months ago
Closed
Solved

MSOParseExcelFile Cannot Parse A Date(dd-mmm-yyyy) Cell Data.

Hello All,

I got a requirement were client wants to upload a spread sheet which contains business data. So this spread sheet contains different verities of data (text, numbers, decimals, date, etc...).

So, the date cells in the spread sheet are in dd-mmm-yyyy format and client is very rigid on this format. Client doesn't want to change the format of that cell to text nor remove it.

So, in Pega, we have created a binary file (template) where all the pega properties are mapped.

And we user the MSOParseExcelFile OOTB activity to parse the same.

The problem we are facing here is MSOParseExcelFile OOTB activity is not able to parse the date cells out of the excel sheet. Pega is reading the date from the excel sheet as some junk value as per below error. Please find below the complete stack trace from log file FYR.

Request all to help me how can we achieve this:

Reading an excel sheet (only the second sheet) and map that data to the Pega clipboard directly.

2016-02-18 14:14:05,449 [p-bio-8443-exec-1051] [TABTHREAD1] [                    ] [       DPDA:01.01.01] (  internal.access.DatabaseImpl) ERROR bmsbiologics-1.pegacloud.com|165.89.84.89 dpdascientist - A commit cannot be performed because a deferred save of instance BMS-DPDA-WORK DPDA-64 failed

2016-02-18 14:14:05,449 [p-bio-8443-exec-1051] [TABTHREAD1] [                    ] [       DPDA:01.01.01] (  internal.access.DatabaseImpl) ERROR bmsbiologics-1.pegacloud.com|165.89.84.89 dpdascientist - The deferred save failed with the following exception

com.pega.pegarules.pub.database.BadInputException: Trying to save an invalid page: Trying to save an invalid page: page is not valid

.StudyInfo.InitialDate: 42374 is not a valid date value

From: (H57D204B3725DFF616C7E74D2A76406A1:165.89.84.89) 

at com.pega.pegarules.data.internal.access.Saver.validate(Saver.java:1325)

at com.pega.pegarules.data.internal.access.Saver.saveDeferred(Saver.java:327)

at com.pega.pegarules.data.internal.access.DatabaseImpl.saveDeferred(DatabaseImpl.java:4832)

at com.pega.pegarules.data.internal.access.DatabaseImpl.saveDeferred(DatabaseImpl.java:4816)

at com.pega.pegarules.data.internal.access.DatabaseImpl.saveDeferred(DatabaseImpl.java:4810)

at com.pegarules.generated.activity.ra_action_saveattachment_613d72462e140a21a2dcd20bd0fe791c.step4_circum0(ra_action_saveattachment_613d72462e140a21a2dcd20bd0fe791c.java:422)

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

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

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

at com.pegarules.generated.activity.ra_action_attachfile_c61fb0f1989f5cd69602bc73d33c43fd.step14_circum0(ra_action_attachfile_c61fb0f1989f5cd69602bc73d33c43fd.java:1322)

at com.pegarules.generated.activity.ra_action_attachfile_c61fb0f1989f5cd69602bc73d33c43fd.perform(ra_action_attachfile_c61fb0f1989f5cd69602bc73d33c43fd.java:288)

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

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

at com.pegarules.generated.activity.ra_action_saveattachment_390bc14473f4b75ddf95f91f85681add.step8_circum0(ra_action_saveattachment_390bc14473f4b75ddf95f91f85681add.java:699)

at com.pegarules.generated.activity.ra_action_saveattachment_390bc14473f4b75ddf95f91f85681add.perform(ra_action_saveattachment_390bc14473f4b75ddf95f91f85681add.java:198)

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

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

at com.pegarules.generated.activity.ra_action_saveallattachments_1139eaf5683425c836e33e925266f101.step8_circum0(ra_action_saveallattachments_1139eaf5683425c836e33e925266f101.java:831)

at com.pegarules.generated.activity.ra_action_saveallattachments_1139eaf5683425c836e33e925266f101.perform(ra_action_saveallattachments_1139eaf5683425c836e33e925266f101.java:196)

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

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

at com.pegarules.generated.activity.ra_action_uploadstudy_de60a1bb9dfc222f98e6ff3334a5b53a.step6_circum0(ra_action_uploadstudy_de60a1bb9dfc222f98e6ff3334a5b53a.java:571)

at com.pegarules.generated.activity.ra_action_uploadstudy_de60a1bb9dfc222f98e6ff3334a5b53a.perform(ra_action_uploadstudy_de60a1bb9dfc222f98e6ff3334a5b53a.java:171)

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

at com.pegarules.generated.flow.ra_action_enterstudydetails_19e0fbf9dfda84038da85fe5f5e6e8ab.RunTaskActivity(ra_action_enterstudydetails_19e0fbf9dfda84038da85fe5f5e6e8ab.java:4201)

at com.pegarules.generated.flow.ra_action_enterstudydetails_19e0fbf9dfda84038da85fe5f5e6e8ab.Task_Utility1_circum0(ra_action_enterstudydetails_19e0fbf9dfda84038da85fe5f5e6e8ab.java:2812)

at com.pegarules.generated.flow.ra_action_enterstudydetails_19e0fbf9dfda84038da85fe5f5e6e8ab.perform(ra_action_enterstudydetails_19e0fbf9dfda84038da85fe5f5e6e8ab.java:614)

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

at com.pegarules.generated.StartFlow_071001_pHqeTXSalkhabVGTYNWp6A.StartFlow07_10_01(StartFlow_071001_pHqeTXSalkhabVGTYNWp6A.java:167)

at com.pegarules.generated.StartFlow_071001_pHqeTXSalkhabVGTYNWp6A.invoke(StartFlow_071001_pHqeTXSalkhabVGTYNWp6A.java:76)

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:8786)

at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflection(LibrarySupport.java:181)

at com.pegarules.generated.pega_procom_flow.StartFlow(pega_procom_flow.java:605)

at com.pegarules.generated.activity.ra_action_completeassignment_7c229c203839163ba035bdb1bc564749.step24_circum0(ra_action_completeassignment_7c229c203839163ba035bdb1bc564749.java:2385)

at com.pegarules.generated.activity.ra_action_completeassignment_7c229c203839163ba035bdb1bc564749.perform(ra_action_completeassignment_7c229c203839163ba035bdb1bc564749.java:517)

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

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:8786)

at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflection(LibrarySupport.java:181)

at com.pegarules.generated.pega_rules_utilities.callActivity(pega_rules_utilities.java:1432)

at com.pegarules.generated.activity.ra_action_performflowaction_cc66ac9b214b3cec592f3634031988bc.step18_circum0(ra_action_performflowaction_cc66ac9b214b3cec592f3634031988bc.java:1754)

at com.pegarules.generated.activity.ra_action_performflowaction_cc66ac9b214b3cec592f3634031988bc.perform(ra_action_performflowaction_cc66ac9b214b3cec592f3634031988bc.java:382)

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

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

at com.pegarules.generated.activity.ra_action_finishassignment_d0045083e1b45f7e2330fe3464a87513.step10_circum0(ra_action_finishassignment_d0045083e1b45f7e2330fe3464a87513.java:1435)

at com.pegarules.generated.activity.ra_action_finishassignment_d0045083e1b45f7e2330fe3464a87513.perform(ra_action_finishassignment_d0045083e1b45f7e2330fe3464a87513.java:229)

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

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

at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:435)

at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.runActivities(HttpAPI.java:3252)

at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:384)

at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1188)

at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:926)

at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:811)

at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:330)

at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.invoke(HttpAPI.java:839)

at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:315)

at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:263)

at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:240)

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.GeneratedMethodAccessor82.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:338)

at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:379)

at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:216)

at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:265)

at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:118)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:724)

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Data Integration Low-Code App Development System Administration
Moderation Team has archived post
Share this page LinkedIn