Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Clear package error!!

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 Member
replied

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

Regards

     Roberto

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question