I'm running Toad Data Point 5.0, and I'm encountering an error where I can't export a data set that is 5,240 rows to Excel. I've encountered this same issue several times, and I typically experience the issue somewhere in the 4,000-5,000 range of rows. Anything beneath that is fine. I'm also not the only person at my organization to encounter this problem.
When I experience this error when copying and pasting data into Excel, I find that nothing actually copies into my clipboard. I am prompted to ask whether I want to include headers or not when copying the data.
When I try to export the data to Excel, I receive the following error upon completion of the export: "Export is cancelled - Object reference not set to an instance of an object. Export is cancelled." Then, I see an export summary of the results stating that only 2,048 rows exported, and that the export was status is "Cancelled." However, I do see that the export actually occurred, and that 2,048 rows are found in the output file.
As I mentioned, I have encountered this issue with several different data sets. I have tried to export to my desktop, to a location in My Documents and to other places, and I experience this same issue in each case. I'm also not the only person at my organization who experienced the issue. Importantly, I started to encounter it when I was given a Windows 10 laptop with Toad 5.0 installed. Prior to that, I had a different version of Windows and an older version of Toad, and I never encountered this issue.
We're at a loss as to how to handle this. Does anybody know what might be going on and how to troubleshoot it?