Clear package error!!

[Former Member]

Hello Experts,

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?

Please Advice.

Thanks & Regards,

Rohit

[former_member186498 · Accepted solution]

Hi Rohit,

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 c....

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.

Regards

     Roberto

[Former Member · Accepted solution]

Hi Roberto,

Thanks for your reply, Yes we are deleting big amount of data.

If we use "ClearfromFact" package then also do we need to do Modify Application from BPC Admin module or only running "ClearfromFact" package is enough to clear data from SQL and OLAP?

Thanks & Regards,

Rohit

[former_member186498 · Accepted solution]

Hi Rohit,

with clearfromfactTable you don't need a modify application, only if you delete this directly from SSMS because it's outside BPC.

But remember to do a backup before for safety.

Regards

     Roberto