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

 Zeba Tanveer (ZebaT771)
Virtusa

Virtusa
IN
ZebaT771 Member since 2013 2 posts
Virtusa
Posted: Jan 24, 2017
Last activity: Jan 27, 2017
Posted: 24 Jan 2017 6:51 EST
Last activity: 27 Jan 2017 0:46 EST
Closed

Issue editing the data table instances

Hi,

We are getting Array index out of bound exception while trying to edit or delete some of the instances of a data table. Can anyone provide info on reason we are getting this error and the solution for this?

Thanks

***Moderator Edit: Vidyaranjan | Updated Categories***

To see attachments, please log in.
Low-Code App Development
Data Integration

  • Preethi Ageer Vijekanth Moorthy
Posted: 8 years ago
Posted: 24 Jan 2017 7:25 EST
Haritha Damarla (Haritha12)
PEGA
Technical Solutions Engineer
Pegasystems Inc.
IN

Hi,

We will not be able to delete rows from datatable having entries >1000 or 950+.
That is because of url length restriction (as we use 'get')

You should be able to edit them using the excel (import/export ). 

or try editing param.MaxRecords in ListEditorSettings, which was set to 1000 by default.
 

To see attachments, please log in.
Posted: 8 years ago
Posted: 25 Jan 2017 3:25 EST
Zeba Tanveer (ZebaT771)
Virtusa

Virtusa
IN

We have only 60 instances in the data table 

Here is the stack trace

Show More

We have only 60 instances in the data table 

Here is the stack trace

java.lang.ArrayIndexOutOfBoundsException: 0 
at com.pega.pegarules.data.internal.access.CompressImpl.isCompressed(CompressImpl.java:239)  
 at com.pega.pegarules.data.internal.clipboard.StorageStreamCommonImpl.inflateStream(StorageStreamCommonImpl.java:624)  
 at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.populatePageOrStringMapFromStreamColumn(PageDatabaseMapperImpl.java:2148)  
 at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.createPageFromResultSet(PageDatabaseMapperImpl.java:462)  
 at com.pega.pegarules.data.internal.access.Opener.getResultFromResultSet(Opener.java:884)  
 at com.pega.pegarules.data.internal.access.Opener.openData(Opener.java:702)  
 at com.pega.pegarules.data.internal.access.Opener.openData(Opener.java:406)  
 at com.pega.pegarules.data.internal.access.DatabaseImpl.open(DatabaseImpl.java:4597)  
 at com.pegarules.generated.activity.ra_action_review_ce0aac03c978919a7a5a8ce38101e1fc.step5_circum0(ra_action_review_ce0aac03c978919a7a5a8ce38101e1fc.java:710)  
 at com.pegarules.generated.activity.ra_action_review_ce0aac03c978919a7a5a8ce38101e1fc.perform(ra_action_review_ce0aac03c978919a7a5a8ce38101e1fc.java:146)  
 at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3098)  
 at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:617)  
 at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:601)  
 at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.runActivities(HttpAPI.java:2841)  
 at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:394)  
 at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source)  
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
 at java.lang.reflect.Method.invoke(Method.java:601)  
 at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1092)  
 at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:771)  
 at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:328)  
 at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.invoke(HttpAPI.java:722)  
 at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:312)  
 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:277)  
 at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngine(JNDIEnvironment.java:222)  
 at com.pega.pegarules.web.impl.WebStandardImpl.makeEtierRequest(WebStandardImpl.java:400)  
 at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:278)  
 at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)  
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
 at java.lang.reflect.Method.invoke(Method.java:601)  
 at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:349)  
 at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:390)  
 at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:439)  
 at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:118)  
 at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doGet(WebStandardBoot.java:89)  
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)  
 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.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.valves.RemoteIpValve.invoke(RemoteIpValve.java:680)  
 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:722)  

 


Show Less
To see attachments, please log in.
Posted: 8 years ago
Posted: 27 Jan 2017 0:46 EST
Zeba Tanveer (ZebaT771)
Virtusa

Virtusa
IN

Hi Mahesh,

Thanks for your inputs. I have checked this article but the issue is in all environments so we can't delete and re insert the records at the DB end since its already in prod. From the data table, the edit in excel is not working. So I am trying to fix that 1st. Any ideas regarding the issue with edit in excel option of data tables?..I tried the approach given in article(https://community.pega.com/support/support-articles/edit-excel-data-tables-not-working-0) but edit in excel still doesn't work

Thanks

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