I am getting below error in a node where export CSV "Export data store entity to csv" we are using to export from view.
I have checked the view performance ( which is good) and the table data its having only 3800 rows .
I am not able to find out the reason of failure as this error is not captured in the tomcat.stdout log.
Error accessing data store entity: OutputView. Please contact a system administrator for additional details. (APNX-1-4505-026)
Any pointer to check any other thing which I have not think of will be helpfull.
Discussion posts and replies are publicly visible
just not i observed that this node is fetching data from the Records in all the exprestion and entiry is configured in this node but in CDT is of record type which is making it slow I guess , any suggestion on this.
I suggest to check the tomcat std-out log file for details.
checked this error is not there in logs
Surprisingly to logs appeared in the log file
Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [OutputViewDT77240], query: [queryentity expression], order by: [[Sort[id asc]]], filters:[(reqId = TypedValue[it=1,v=4371])]) (APNX-1-4261-002)
Feels like a timeout issue ...
yes View has been optimised alsreayd its taking only 10 s now , i have removed all queries from this node other than one select query
only DS performance or secondary being different region causing this issue , i guess i will check DS logs
Appian uses a fixed timeout of 10 seconds.
10 s is too less , my view is taking average 12 s time , can we increase it?
Inorder to reduce the view execution time , You can try adding Indexes in the tables the view is calling .