Export of Datatype Data throwing an error

General
, , , ,
1

Hi,

When we try to Export Data of a Datatype it is failing and it throws an error. below is the screen shot of the error.

Error that shows on the screen.jpg
Error that shows on the screen.jpg773×257 17.5 KB
We have recently upgraded this environment to Pega 8.5.5

Below is the exception that we can see in the logs and it is not giving much information to identity the issue.

com.pega.pegarules.pub.PRRuntimeException: An error occurred while exporting the data.com.pega.pegarules.pub.PRRuntimeException: PRRuntimeException 
	at com.pega.pegarules.exec.internal.util.importexport.DataExportHelper.exportData(DataExportHelper.java:210) ~[prprivate-exec.jar:?] 
	at com.pega.pegarules.exec.internal.util.importexport.DataImportUtilsImpl.exportData(DataImportUtilsImpl.java:560) ~[prprivate-exec.jar:?] 
	at com.pegarules.generated.activity.ra_action_pxexportdatausingrdpage_3e851e282c860d477eed8a02c63096a0.step3_circum0(ra_action_pxexportdatausingrdpage_3e851e282c860d477eed8a02c63096a0.java:306) ~[?:?] 
	at com.pegarules.generated.activity.ra_action_pxexportdatausingrdpage_3e851e282c860d477eed8a02c63096a0.perform(ra_action_pxexportdatausingrdpage_3e851e282c860d477eed8a02c63096a0.java:117) ~[?:?] 
	at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2837) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:11478) ~[prprivate-session.jar:?] 
	at com.pegarules.generated.activity.ra_action_pzexportdatausingresultset_26b9581acfe5616383d5d8e924618413.step1_circum0(ra_action_pzexportdatausingresultset_26b9581acfe5616383d5d8e924618413.java:177) ~[?:?] 
	at com.pegarules.generated.activity.ra_action_pzexportdatausingresultset_26b9581acfe5616383d5d8e924618413.perform(ra_action_pzexportdatausingresultset_26b9581acfe5616383d5d8e924618413.java:76) ~[?:?] 
	at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2837) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:11478) ~[prprivate-session.jar:?] 
	at com.pegarules.generated.activity.ra_action_pxdownloaddatarecordsascsv_96fe6ad6209de363e0d7609ecdc92760.step7_circum0(ra_action_pxdownloaddatarecordsascsv_96fe6ad6209de363e0d7609ecdc92760.java:842) ~[?:?] 
	at com.pegarules.generated.activity.ra_action_pxdownloaddatarecordsascsv_96fe6ad6209de363e0d7609ecdc92760.perform(ra_action_pxdownloaddatarecordsascsv_96fe6ad6209de363e0d7609ecdc92760.java:189) ~[?:?] 
	at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2837) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:653) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:520) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.runActivities(HttpAPI.java:4378) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:445) ~[prenginext.jar:?] 
	at sun.reflect.GeneratedMethodAccessor231.invoke(Unknown Source) ~[?:?] 
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_322] 
	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_322] 
	at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1399) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1131) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:985) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:368) ~[prenginext.jar:?] 
	at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.invoke(HttpAPI.java:936) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:338) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:282) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:259) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngineInner(JNDIEnvironment.java:281) ~[prpublic.jar:?] 
	at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngine(JNDIEnvironment.java:226) ~[prpublic.jar:?] 
	at com.pega.pegarules.web.impl.WebStandardImpl.makeEtierRequest(WebStandardImpl.java:779) ~[prwebj2ee.jar:?] 
	at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:428) ~[prwebj2ee.jar:?] 
	at sun.reflect.GeneratedMethodAccessor224.invoke(Unknown Source) ~[?:?] 
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_322] 
	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_322] 
	at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:388) ~[prbootstrap-8.5.5-782.jar:8.5.5-782] 
	at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:430) ~[prbootstrap-8.5.5-782.jar:8.5.5-782] 
	at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:225) ~[prbootstrap-api-8.5.5-782.jar:8.5.5-782] 
	at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:274) ~[prbootstrap-api-8.5.5-782.jar:8.5.5-782] 
	at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:146) ~[prbootstrap-api-8.5.5-782.jar:8.5.5-782] 
	at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doGet(WebStandardBoot.java:107) ~[prbootstrap-api-8.5.5-782.jar:8.5.5-782] 
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:655) ~[servlet-api.jar:4.0.FR] 
	at com.pega.pegarules.internal.web.servlet.WebStandardBoot.service(WebStandardBoot.java:172) ~[prbootstrap-api-8.5.5-782.jar:8.5.5-782] 
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) ~[servlet-api.jar:4.0.FR] 
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[catalina.jar:9.0.58] 
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.58] 
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-websocket.jar:9.0.58] 
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[catalina.jar:9.0.58] 
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[catalina.jar:9.0.58] 
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) ~[catalina.jar:9.0.58] 
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) ~[catalina.jar:9.0.58] 
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) ~[catalina.jar:9.0.58] 
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) ~[catalina.jar:9.0.58] 
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[catalina.jar:9.0.58] 
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) ~[catalina.jar:9.0.58] 
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) ~[catalina.jar:9.0.58] 
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) ~[catalina.jar:9.0.58] 
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) ~[tomcat-coyote.jar:9.0.58] 
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) ~[tomcat-coyote.jar:9.0.58] 
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) ~[tomcat-coyote.jar:9.0.58] 
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1735) ~[tomcat-coyote.jar:9.0.58] 
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-coyote.jar:9.0.58] 
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-util.jar:9.0.58] 
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-util.jar:9.0.58] 
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-util.jar:9.0.58] 
	at java.lang.Thread.run(Thread.java:750) [?:1.8.0_322] 
2

@MaruthiNaiduK Are you facing this issue even for OOTB data types after upgrade?

Can you confirm that you are on Oracle?

If so, I believe I’ve identified this to be a known bug BUG-679515 which is fixed in Patch 8.5.6.

The issue relates to issues w.r.t Oracle DB in Native SQL API’s. This was traced to previous work done around retry handling for Oracle queries where there were issues identifying the correct column types; that previous work has been reverted to resolve this null pointer exception causing the ‘There has been an issue’ error.

If you wish to have more detailed bug analysis, you will need to log a support ticket. Could you enable the following loggers to ‘All’ to obtain more debug?

  • com.pega.pegarules.exec.internal.util.importexport.DataImportHelper
  • com.pega.pegarules.exec.internal.util.importexport.DataExportHelper
  • com.pega.pegarules.exec.internal.util.importexport.DataImportUtilsCommon

Alternatively, if you can replicate on a Dev environment:

  1. Pega 8.5.6 looks to be set to be released on March 25th.

Are you able to wait until that release in order to confirm the issue is resolved?

  1. If you wish to test my analysis, there is a hotfix you could request via the My Support Portal (‘Request existing hotfix’:

HFIX-81791 for Pega 8.5.5).

3

@MarijeSchillern ,

Thank you for your explanation. yes, you are right this issue is happening on the environment where we have Oracle as Database.

I will request for the HF that you have mentioned and will verify the issue after installing it.

Thanks and Regards,

Maruthi Naidu Kurupati.

4

@MarijeSchillern

Hi Marije,

While I was requesting for the HF The description of it says as “The CDH Data flow batch runs for DF_ProcessEmails are failing.” Wondering it you have given correct HF ID or not.

Could you please confirm.

Thanks and Regards,

Maruthi Naidu Kurupati.

5

@MarijeSchillern

Hi Marije,

The HF that you have suggested fixed our problem. Thank you for your help.

Thanks and Regards,

Maruthi Naidu Kurupati.