Skip to Content

Problems archiving historical data from SAP Business One for SQL in the data archiving option

Dear Our database is 355 GB in size. ERP system performance is low, which is why we need to run SAP business one data archiving option for SQL Server (archive historical data). At the moment of starting the process, it shows us a message that says: "Other users are currently connected to the database". I have validated no users from SAP, SQL, service connected. When we consult our SAP partner B1, he indicates that this option: Data Archiving, does not work (SQL Server / Hana), the truth is that it is hard for me to believe that there is an option which cannot be used. I will be grateful if you can give me the green light in this regard.

Regards

Wilton

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on 4 days ago

    Dear

    it works in Both version SAP B1 for SQL and SAP B1 for HANA. I did it once it will archive certain objects but impact on DB size will not be high so as a work around i went for log shrink log files in SQL regularly and it made high impact on DB size.

    You can try data archiving in SAP on test may be for you it will be helpful to do it disconnect all users and stop the integration service, event sender service, restart other services so existing connections will broke then try. Usually user connection error is sometimes users are disconnected but connection is still there so to kill the connection restart services and stop services which are connecting indirectly.

    If you have any add on please make sure its also disconnected

    Add a comment
    10|10000 characters needed characters exceeded

    • Estimado Abdul

      Thank you very much for your answer, I see the light at the end of the tunnel for my problem. All my colleagues told me that this option does not work, so I started writing. I will perform the test in two weeks, I will tell you the result.

      Regards

      Wilton

  • Posted on Sep 10 at 04:24 AM

    Thanks for replying Johan It is SAP Business One 9.3 (9.30.220) PL 12 Database age is 5 years, transaction amount is high (sales order amount per day is approximately 1000)

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on 5 days ago

    Hello Wilton,

    This SAP Note can help:

    2544671 - Troubleshooting Large Database Size

    Hope it helps,

    Jesper

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Jesper

      Review, of the suggestions, two we apply:

      1224089 - How to Shrink Database in Microsoft SQL Server

      2078341 - How to Maintain Database and Log File Settings for SAP Business One

      But it doesn't solve the problem for me, that's why we thought about filing, but I can't figure out how to do it.

      Thank you very much for answering

      Wilton

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.