Skip to end of metadata
Go to start of metadata

You use Database Studio as of Version 7.9.08 and one of the following symptoms has occurred:

  1. Database Studio does not start on Linux
  2. Database Studio is called and does not respond
  3. When launched, Database Studio reports the following error: JVM terminated. Exit code=-1
  4. Database Studio reports errors if the explorer view is activated
  5. After being launched, Database Studio reports the following error: Could not acces to user management
  6. Database Studio is used in a WTS environment and does not start up correctly
  7. Database Studio starts up with inexplicable errors

  8. Database Studio starts up with inexplicable errors and point 7 did not help

  9. Database Studio does not start and reports the error message The program can't start because MSVCR100.dll is missing...

Other Terms

dbstudio, dbstudio.ini

Reason and Prerequisites

  • Database Studio 64-bit was reinstalled.
  • An upgrade was executed for the Java runtime environment, uninstalling Java 64-bit.
  • Database Studio was called again and reacted unexpectedly
  • In Database Studio Version < 7.9.08.29, an attempt was made to use SAP JVM as the Java runtime environment.
  • Database Studio was closed while the explorer view was not in the foreground.
  • Database Studio was not shut down correctly.

Solution

  1. Database Studio does not start on Linux
    1. You might not have called Database Studio from the installation directory. Call Database Studio from the installation directory:
      - cd /sapdb/clients/DatabaseStudio
      - ./dbstudio
    2. In Database Studio 7.9.09.00, the delivered Java runtime environment (SAP JVM) is missing execution rights for programs in the “bin” directory. Change the file rights as follows:
      - cd /sapdb/clients/DatabaseStudio/sapjvm/sapjvm_8_jre/bin
      - chmod +x *

  2. Database Studio is called and does not respond
    It can be assumed that the installed Java runtime environment is not compatible with the Database Studio version. Even if Database Studio worked once on your computer without any problems, Database Studio might no longer be able to run due to an update of the Java runtime environment.
    Until now, in this context, it has turned out that the 64-bit Java runtime environment has been deinstalled inadvertently with the assumption that the 32-bit Java runtime environment would be sufficient for operations. However, this is not the case.
    If you work on a 64-bit Microsoft Windows or Linux computer, you must use Database Studio for a 64-bit architecture and thus the 64-bit Java runtime environment, too. If you work on a 32-bit Microsoft Windows or Linux computer, you must use Database Studio for a 32-bit architecture and thus the 32-bit Java runtime environment, too.
    How can you check which Java version is used by Database Studio?
    Switch to the directory in which Database Studio is called:
    On Microsoft Windows: cd C:\sapdb\clients\DatabaseStudio
    On Linux: cd /sapdb/clients/DatabaseStudio
    Check the Java version using the following command: java -version The 64-bit variant of Java can be recognized by the text 64-Bit Server:
    (In this example, the 64-bit Java Version 1.8 is used.)
    java version "1.8.0_60" Java(TM) SE Runtime Environment (build 1.8.0_60-b27) Java HotSpot(TM) 64-Bit Server VM (build 25.60-b23, mixed mode)
    Therefore, if you require 64-bit Java and the term 64-Bit does not appear in the version specifications, there is no 64-bit Java version on your computer. Install the 64-bit Java runtime environment from https://java.com/en/download/. On Microsoft Windows, you can check the correct installation of the 64-bit Java runtime environment with Control Panel -> Programs and Features, too.
    As of Database Studio 7.9.08.29, you can also use SAP's own Java runtime environment for Database Studio, which is available at http://sapjvm.wdf.sap.corp:1080/downloads. For more detailed information about the possibilities as to how Java can be used for Database Studio, see the following SAP Note: 1097311 - SAP MaxDB Database Studio Installation

  3. When launched, Database Studio reports the following error: "JVM terminated. Exit code=-1"
    In earlier versions of Database Studio (<7.9.08.29), the error message JVM terminated. Exit code=-1 can appear. As in case 2, this suggests an incompatible Java runtime environment. You should therefore proceed as described in point 2.

  4. Database Studio reports errors if the explorer view is activated
    After the launch of Database Studio and activation of the explorer view, the following error appears in the explorer view:
    java.lang.NoClassDefFoundError: com/sap/sdb/tools/ui/actions/IToggleLinkingAdapter
    This error occurs if Database Studio was last closed with the explorer view covered by the outline view because the outline tab was activated, for example. As a workaround, activate the explorer tab that contains the error in Database Studio. Close and restart Database Studio or use Database Studio Version 7.9.08.34 or above.

  5. After starting, Database Studio reports the error "Could not access to user management"
    Immediately after Database Studio starts up - before the password is requested - the following error message appears: Could not access to user management See Window-> Show View -> Event Log Viewer for more details
    This symptom is seen extremely rarely. This error can occur if Database Studio was not closed properly. In this case, it helps if you restart your computer in order to end any processes that have got stuck.  

  6. Database Studio is used in a WTS environment and does not start up correctly

    You work in a WTS environment and call Database Studio for the first time. Startup problems have been noticed in WTS environments, even though they are rare. Note that in WTS environments, the HOME directories might be located on other hosts. First, find out which directory is your HOME directory. The path to the user-specific Eclipse workspace might look like this, for example: \\TSHomeServer\TSHome$\<user>\sdb\DatabaseStudio The path to Eclipse Secure Storage might look like this: \\TSHomeServer\TSHome$\<user>\.eclipse\org.eclipse.equinox.security

    Caution: In more recent WTS environments, the HOME directory is: C:\users\<user>.
    You can find the Database Studio workspace folder in the file explorer by entering c:\users\<user>\sdb into the explorer input field. <user> is your operating system user. 

    In this case, proceed as follows:

    • Delete the content of the folder <HOME>/<user>/sdb/DatabaseStudio.
    • Restart Database Studio.

  7. Database Studio starts up with inexplicable errors 
    All other possible solutions have not been successful. Database Studio starts up with inexplicable errors. This case occurs extremely rarely. The Database Studio workspace might be damaged.
    In this case, proceed as follows:
    1. If you have landscape data that you do not want to lose, back this data up by backing up the following file: <HOME>/<user>/sdb/DatabaseStudio/.metadata

    2. Delete the content of the folder <HOME>/<user>/sdb/DatabaseStudio.

    3. If you backed up the file <HOME>/<user>/sdb/DatabaseStudio/.metadata, restore it.
    4. As of Database Studio Version 7.9.08.14, you can back up the landscape data using the "Export Landscape" function, too. Note that the logon data is not backed up with this.

  8. Database Studio starts up with inexplicable errors and point 7 did not help
    In this case the master password of Database Studio in the Eclipse Secure Storage has to be reset. Hereby all landscape data of Database Studio will get lost. 
    But you can import the landscape data of a previously executed export.     

    1. Reset the eclipse secure storage password of Database Studio as follows: 
      • Start Database Studio and ignore the error messages.
      • Open Window -> Preferences -> General -> Security -> Secure Storage -> Contents
      • Open on the left side of the Contents tab the entry [Default Secure Storage].
      • Choose the entry com.sap.sdb.tools.databasestudio, delete it with the Delete button and leave the dialog with OK.  
    2. Exit Database Studio.
    3. Delete the content of the folder <HOME>/<user>/sdb/DatabaseStudio.
    4. Start again Database Studio and enter a master password.
    5. If you have got a file with a previous backup of the landscape, you can now import the landscape data with the "Import Landscape" context menu function. 

  9. Database Studio does not start and reports the error message The program can't start because MSVCR100.dll is missing...
    You have installed Database Studio 7.9.09.00 or 7.9.09.01 in a Microsoft Windows system and the Microsoft runtime library MSVCR100.dll is not installed on your computer. The Microsoft runtime library MSVCR100.dll is required as of Java Version 7. Since Database Studio includes SAP's own SAP JVM in version 8 as of version 7.9.09.00 but not the runtime environment library MSVCR100.dll required by Microsoft, the error can occur if the runtime library MSVCR100.dll has not already been installed (f.e. in conjunction with other software).
    Solution:
    As of 7.9.09.02, the problem is rectified, since the missing Microsoft runtime environment library is installed with Database Studio. Until delivery of version 7.9.09.02, proceed as follows:

    1. On the download page http://sapjvm.wdf.sap.corp:1080/downloads, go to the SAP JVM release under "Downloads" and click the link Windwos  x86_64bit.
    2. Click on the package vcredist_64.msi and load it onto your computer.
    3. Install the package by double-clicking the downloaded file vcredist_64.msi. This makes MSVCR100.dll available at the path C:\Windows\System32

Further Information

SAP Note 2213168 Problems Starting Database Studio
SAP Note 1097311 Database Studio Installation
Database Studio 7.9 News

 

  • No labels