Skip to Content
author's profile photo Former Member
Former Member

BI4.7 SP1 patch 1 update Error:database is locked

Hi,

We are facing this issue when updating BI from 4.0 SP5 to 4.1 SP7 Patch 1 on Windows 2008 R2 SP 1 OS.

11:56:24.530 Adding property: wdeploy.script-4.0-core$tomcatasinstance. Value: localhost

11:56:24.530 Adding property: wdeploy.script-4.0-core$tomcatasservicename. Value: BOEXI40Tomcat

11:56:24.624 Error: Error in SqliteTable::ExecQuery():

11:56:24.624 Error: Statement: RELEASE UpdateDUProperties

11:56:24.624 Error: Error: database is locked

11:56:24.764 UI thread has terminated properly

11:56:24.920 SqliteManifest's sqlite db is successfully closed at C:\Program Files (x86)\SAP BusinessObjects\InstallData\WorkingManifest.sqlite

11:56:24.920 Closed manifest C:\Program Files (x86)\SAP BusinessObjects\InstallData\WorkingManifest.sqlite

11:56:24.920 Error: Exception thrown while accessing manifest (caught ManifestAccessException) :

11:56:24.936 Error: Statement: RELEASE UpdateDUProperties

11:56:24.936 Error: Error: database is locked

11:56:24.936 Error: Note that even though the program has terminated abnormally, the manifest should not be left in a corrupt state.

11:56:24.936 Error: Internal error detected. Program will exit.

11:56:34.967 Exiting Windows wmain function

Any suggestions are really appreciated.

And also we are planning to update to SP7 Patch 4. Is that going to cause any issue?

Regards,

Michael

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jun 13, 2016 at 06:42 PM

    Can you restart your Database and try again ?

    -Yogesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Everyone,

      I found the solution here: https://scn.sap.com/thread/2099484

      You cannot do a repair once you get this issue, it will try to make you continue from the same spot it stopped but it won't work.

      You need to open the "InstallManifest.SQLite" file that is located inside the InstallData folder under SAP BusinessObjects folder.

      Once you open browse this database, go to "DUTransaction" table and search for any zero (0) value under "committed" column and change it to 1.

      save the database and then try to install again.

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.