TDP 6.2 - Select to File limited to 2,048 records

Hello,

Running TDP 6.2. One of our automations, a Database Activity began to limit a Select to File (Excel file) result to 2,048 records. The configuration is set to unlimited. When we run the query on its own, same result when we try to manually export to Excel. Unclear what caused this to begin; however, any ideas on how to resolve?

I did not find any topics through my search, so I created this new item.

Cheers,

Mike

I'm guessing here
(only because of lack of details
(e.g. which automation task you're using, which version of Excel, what means being used to Export, etc.)
)
that something has happened on the Excel side of things... did MS Office get updated on the desktops? Using a different connector (or DBAs making a config change) that limits the number of records that can be retrieved by the user?

If you have a prior version of TDP (like 6.1), is it also producing the same effect?

BTW, it's not a bad idea to keep the old Toad version around (at least for a little while... e.g. for testing, etc.) when you install a newer version. Old and new versions can be installed side by side.

1 Like