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

 Maruthi Kurupati (MaruthiNaiduK)
Adqura

Adqura
IN
MaruthiNaiduK Member since 2015 5 posts
Adqura
Posted: Feb 24, 2022
Last activity: Feb 24, 2022
Posted: 24 Feb 2022 1:11 EST
Last activity: 24 Feb 2022 9:07 EST
Closed
Solved

Export of Datatype Data throwing an error

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 screenWe 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.

 

Show More

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 screenWe 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] 
Show Less
***Edited by Moderator: Pooja Gadige to add capability tag***
To see attachments, please log in.
Pega Platform 8.5.5
Dev/Designer Studio
Data Integration
Other Industry
Solutions Engineer

Posted: 2 years ago
Posted: 24 Feb 2022 7:16 EST
Marije Schillern (MarijeSchillern)
MOD
Senior Knowledge Management Specialist
Pegasystems Inc.
GB

@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?

2.  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).   

 

To see attachments, please log in.
Posted: 2 years ago
Posted: 24 Feb 2022 8:06 EST
Maruthi Kurupati (MaruthiNaiduK)
Adqura

Adqura
IN

@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. 

To see attachments, please log in.
Posted: 2 years ago
Posted: 24 Feb 2022 8:14 EST
Maruthi Kurupati (MaruthiNaiduK)
Adqura

Adqura
IN

@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. 

To see attachments, please log in.

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