I just transitioned from storing data as .CSV files to storing and retrieving data from a SQL server.
I’m having issues now where periodically random columns from random rows will be null
Just to test, I created a service that pulls data out of SQL and writes it to a CSV file once every 5 seconds – then I had the dashboard load the CSV instead – I did not see any issues with null rows here.
Has anyone else seen this? I’m not even sure where to start troubleshooting; this issue occurs whether the collections are populated via scheduled endpoint or in UDTable endpoint
Any help would be appreciated, this is a huge pain for us – the dashboard works great for a few seconds, but then random object properties will show missing data and eventually entire tables will crash when trying to perform functions (splits, etc) on the null properties.
Thanks in advance!