Hello,
I'm extending the SalesInvoiceDP with a new table for the SalesInvoice report. This table has to be a regular table because the SalesInvoiceDP extends SrsReportDataProviderPreProcess.
I have set the table as regular, I've added createdBy and createdTransactionId to both yes/true and in my process report method eventhandler, I use table.setConnection(this.parmUserConnection()) and everything is working correctly where my data self deletes once I close the report properly.
My problem is if I don't close the report properly (letting the tab time out or just closing the tab instead of the report) my data doesn't get deleted and it stays in the table. When I try to run the report again I get this error message "Cannot execute the required database operation. Cannot attach to connection since the buffer is in use. Use another buffer or clear the buffer by assigning NULL."
I as a dev can manually delete everything in my table through the table browser and everything works again, but this will eventually go out to customers who can't.
This will eventually go out to customers who have multiple users running this report at the same time and I am worried using a delete_from at the beginning of processReport() will cause issues for anyone is running the report at the same time.
The original tables for the SalesInvoice Report don't have this problem, I'm not able to view them in the table browser and they always self delete even if I close the report improperly. Is there a setting that I'm missing for my table or code so that my table does this as well?
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156