NAB Excel Downloads intermittently failing

[Player1st]

We are having issues with one of our apps that is intermittently failing to generate non-legacy Excel downloads using NAB. It will be working fine for a while and without any other changes occurring, it will suddenly start going into what looks like a spin loop waiting for a response when you hit the download button. This has happened on multiple versions over both our Test and Live systems. It will act this way for more than an hour and then it will inexplicably start working again. I have run the logged SQL query in ACS and don't see any issues with the data that is returned and the query reports a SQLSTATE of 00000.

As part of this process, it usually pops open a window asking if you want to download the current page, all pages, etc. It fails before it gets to that point and that window never pops up. I have examined the issue in the browser debugger and it fails due to a type error trying to get the length of a null value. I have attached the log that shows the javascript error.

My attempts at generating a reliable display of the bug in a minimal example have failed. I'm really at a loss here.

[Johnny Major]

Are you experiencing this with a specific grid widget or are all you grid widgets that allow for excel download experiencing this?

Thanks

[Player1st]

Are you experiencing this with a specific grid widget or are all you grid widgets that allow for excel download experiencing this?

Thanks

I have only noticed this on a specific grid widget but we don't have many to compare against yet.

[Johnny Major]

Is this a Grid widget or an Edit Grid widget? Is the widget paging or infinite scroll? Trying to determine the configuration so I can attempt to replicate this. Also what version of Valence 6.0 are you running?

Thanks

[Player1st]

Is this a Grid widget or an Edit Grid widget? Is the widget paging or infinite scroll? Trying to determine the configuration so I can attempt to replicate this. Also what version of Valence 6.0 are you running?

Thanks

It's a non-editable Grid widget with paging set at 250. It has been occurring on versions 6.0.20210818.1 and 6.0.20211007.0. I don't have any other versions to try it with.

[Player1st]

Some extra information that may be useful.

It occurred to me this morning that I exported the savf from version 6.0.20211007.0 and imported it to 6.0.20210818.1 so the issue may still be with something from the new version.

We are also using a GROUP BY in the grid on a column that is custom formatted. We do the GROUP BY on the data in the field but the custom formatting is a combination of 6 different columns in the data source.

Is it possible that certain special characters might interfere with Excel generation? One of these extra fields is a description that can contain things like *, -, commas, #, etc.

[Johnny Major]

We found that the issue was because the data config "Allow copy of row data" was checked on the grid widget

For the time being, we needed to uncheck that for the download to work and this will be fixed in the next Valence 6.0 update