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
3913 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
0
phanibabuk
over 8 years ago
Do you have access to logs.
If so, look into the "Caused By:" field to get more details of the error.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
phanibabuk
over 8 years ago
Or else look if there any rows with incorrect data in the database.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
harrys
over 8 years ago
Can you leverage facets to perform the search, or is the information you're looking for granular?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sonalk
over 8 years ago
Which version of Appian are you working on ? Also if you could post your code that will be useful for practitioners so as to debug the issue.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Navajith K
over 8 years ago
@Umesh, Is it throwing error for all the search key words? if its an entity backed record, could you plesae check how many rows are returned for this query in DB? Also please check the logs as suggested in the earlier comments.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
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
0
harrys
over 8 years ago
Per your output, it indeed looks like you're getting intermittent timeouts. These can be caused by a number of different factors, spanning the network, server architecture, Appian settings and coding patterns. Recommend you look at <your Appian instance>/suite/help/16.2/playbook/Database_Operations_with_Slow_Execution_Phases.html for ideas on causes and how to troubleshoot.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
umeshkumarn0148
Certified Senior Developer
over 8 years ago
I am using following code in title of list view
concat({rf!field1, "/", rf!field2,"/", rf!field3 ,"/", rf!field4}).
Also this issue is not reproducible in our development & test environment with same code.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
umeshkumarn0148
Certified Senior Developer
over 8 years ago
Just to Add we Blank Search field is left blank for that records then entire list view is displayed without any issue. Searching should perhaps display filtered list view without any issue but searching is only causing issue.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sonalk
over 8 years ago
Hi Umesh,
Please verify the output of the search query as it may be due to the large data that is causing the time out. You can modify the default settings and check if it works.
Link for the same is as shared below :
forum.appian.com/.../Post-Install_Configurations.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel