Clear package error!!
We are using BPC 7.5 M with SQL Server 2008 single server configuration, we are trying to clear some old/historical data and getting error "ExecuteNonQuery requires an open and available Connection. The connection's current state is closed." on load step of clear package.
Is it related to amount of data we are trying to clear?
Thanks & Regards,
Roberto Vidotti replied
probably you are deleting a big amount of records so you have to split your clear in sevral executions or using ClearFromFact, see please 1664093 - BPC: ERROR: "ExecuteNonQuery requires an open and available Connection. The connection's current state is closed." .
Another possibility is to build a Delete query in SSMS on the fact tables.
Remember that ClearFromFact and delete SQL delete physically the records from DB so you can't goback, that's why if you do this it's better to do a backup of the DB before or a snapshot.
If you use a delete SQL query after you need a modify application to rebuild the OLAP.