Unable to export data from an automated job using a PostgreSQL database,
Scenario : Trying to export 1 million rows using an automated job in Toad Data Point, it starts the process and exports 5000 rows then stops. Then Toad displays the following error : " Object SQL Query finished with error: Cannot access a closed file."
WORKAROUND
1. The information can be exported to Local Storage and then exported to a .csv file.
2. The information can be exported manually and it works too.
STATUS : Waiting for fix in future release of Toad Data Point