Question

Export To Excel - Couldn't Download Network Issue

Forum|Forum|1 year ago
December 6, 2024
9 replies
0 views

I can't find my exact issue, so I'm starting a new thread.

I created two interfaces - one that shows a single survey and its answers in a grid and the user can download the data to Excel. That works fine. Then I made a copy of the interface and instead of filtering on a survey the grid displays ALL surveys and answers. However, when you try to export to Excel, I get the error "Couldn't Download - Network Issue". The number of records is LESS THAN 20 and so it's not a size issue.

This happens in the DEV environment. I haven't tried it in the TEST environment because I'm not ready to push my code yet.

Any thoughts why?

venkatrea696188

The number of records is LESS THAN 20 and so it's not a size issue.

Any luck in tomcat logs??And not just the number that decides size ,It might be case where it took more time for query to get the data

jonathana5776Author

Yes, thank you for the suggestion. The tomcat-stdOut.log file proved to show the issue. It was a comma inside the bracket for my call to a field in my record type

2024-12-09 13:42:57,126 [http-nio-8080-exec-4868] ERROR com.appiancorp.dataexport.DataExportStreamingOutput - Writing SmartServiceException to Excel Workbook
com.appiancorp.suiteapi.process.exceptions.SmartServiceException: Expression evaluation error: Expression evaluation error : Unmatched open bracket [

venkatrea696188

Good, Is it working now or still failing to export??

karumurua531442

Hi [mention:9bebc0ce13784f108354fe929595bb94:e9ed411860ed4f2ba0265705b8793d05] Could you check the logs? could you please try downloading 2-3 rows and see if the same error appears?

A

ankitab535847

Hi [mention:9bebc0ce13784f108354fe929595bb94:e9ed411860ed4f2ba0265705b8793d05]

Can you share the code?

stefanhelzle0001

Brainy

We need to have a look at your code first. Could it be that this interface has a rule input for filtering and you did not pass any value in your second instance?