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
I suggest to check the tomcat std-out log file for details.
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