Hi Team,I am trying to use Export Data Store Entity to CSV smart service where DSE fetching data from view.
Failing Node Error:
Details: An error occurred while accessing the datastore entity: View1Contact a system administrator for additional data.
Could you provide any suggestions on how to resolve it?
Thanks in Advance
Discussion posts and replies are publicly visible
Yes. Provide more information.
- Error details from the tomcat-stdout log file
- Does that view work outside the export
Caused by: com.mysql.jdbc.exceptions.MySQLTimeoutException: Statement cancelled due to timeoutView is taking 32 secs to query from database.
Hi Vidyalakshmi ,
What's the records count of view?, if data is huge try considering batching. Query the data by batches and export, that will work.
Then you will have to speed up that view.
32 seconds
The time it is taking is because of the data size and the variety of data it is aggregating. So you can either increase the speed using indexing or you can reduce the column of data. In any of these cases, it should solve the problem.
In this scenario, you need to optimize your view and bring its performance down to max 10 sec more then 10 second will going to create this problem
Hi Vidyalakshmi You can use some index on the columns to increase the performance, Use explain statement and check which table scan is affecting your view, index columns on the particular table
Already replied to your spam on this thread.