• State Not Answered
  • Replies 10 replies
  • Subscribers 11 subscribers
  • Views 3706 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

Hello, We are getting intermittent issue when trying to search in lis

umeshkumarn0148
Certified Senior Developer
Hello,

We are getting intermittent issue when trying to search in list view of records with error message An error occurred while retrieving the data for “SCA Request For SCA Members”. (APNX-1-4205-003). I know it happens because of timeout but It's tough time to figure out what is causing timeout.What can be done to improve performance in record search for list view. There is no issue in going to summary view and display of records in list view but it happens only when searching record intermittently.

OriginalPostID-220970

OriginalPostID-220970

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer
    It's throwing error for whatever is being typed in search box but after 2 or 5 attempts it does show searched records.
    I am using 7.10 version of Appian and using Entity Backed Record. There are only 2000 rows which are returned in view and executing query in db by filter is very fast.

    Also checked server log is throwing below error:
    16:38:16,018 INFO [stdout] (ajp-/10.229.85.22:8009-13) 2016-06-29 16:38:16,018 [ajp-/10.229.85.22:8009-13] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01013: user requested cancel of current operation
    16:38:16,041 INFO [stdout] (ajp-/10.229.85.22:8009-13)
    16:38:16,052 INFO [stdout] (ajp-/10.229.85.22:8009-13) 2016-06-29 16:38:16,052 [ajp-/10.229.85.22:8009-13] ERROR com.appiancorp.rest.record.data.RecordItemListViewProvider - com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: An error occurred while retrieving the data for ?SCA Request For SCA Members?. (APNX-1-4205-003)
Reply
  • 0
    Certified Senior Developer
    It's throwing error for whatever is being typed in search box but after 2 or 5 attempts it does show searched records.
    I am using 7.10 version of Appian and using Entity Backed Record. There are only 2000 rows which are returned in view and executing query in db by filter is very fast.

    Also checked server log is throwing below error:
    16:38:16,018 INFO [stdout] (ajp-/10.229.85.22:8009-13) 2016-06-29 16:38:16,018 [ajp-/10.229.85.22:8009-13] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01013: user requested cancel of current operation
    16:38:16,041 INFO [stdout] (ajp-/10.229.85.22:8009-13)
    16:38:16,052 INFO [stdout] (ajp-/10.229.85.22:8009-13) 2016-06-29 16:38:16,052 [ajp-/10.229.85.22:8009-13] ERROR com.appiancorp.rest.record.data.RecordItemListViewProvider - com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: An error occurred while retrieving the data for ?SCA Request For SCA Members?. (APNX-1-4205-003)
Children
No Data

© 2024 Appian. All rights reserved.