Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
10 replies
Subscribers
10 subscribers
Views
3917 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
Hello, We are getting intermittent issue when trying to search in lis
umeshkumarn0148
Certified Senior Developer
over 8 years ago
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
umeshkumarn0148
Certified Senior Developer
over 8 years ago
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)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
umeshkumarn0148
Certified Senior Developer
over 8 years ago
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)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data