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.