Solved

Unable to Download CSV from DSE

Forum|Forum|2 years ago
January 9, 2024
9 replies
0 views

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: View1
Contact a system administrator for additional data.

Could you provide any suggestions on how to resolve it?

Thanks in Advance

[mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05]

Best answer by harshitb6843

32 seconds [emoticon:458682de9e4d4e7c94377c4fe2884528]

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.

stefanhelzle0001

Yes. Provide more information.

- Error details from the tomcat-stdout log file

- Does that view work outside the export

V

vidyalakshmim8485Author

Caused by: com.mysql.jdbc.exceptions.MySQLTimeoutException: Statement cancelled due to timeout
View is taking 32 secs to query from database.

niranjanreddym9323

Hi [mention:9e473a9548bb455ea80381f334f0ccb4:e9ed411860ed4f2ba0265705b8793d05] ,

What's the records count of view?, if data is huge try considering batching. Query the data by batches and export, that will work.

karumurua531442

Hi [mention:9e473a9548bb455ea80381f334f0ccb4:e9ed411860ed4f2ba0265705b8793d05] 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

tomd6974

[deleted]

harshitb6843

Already replied to your spam on this thread.

Sign up

Login with SSO

Login to the community

Login with SSO