Skip to Content

DTW error "Unable to access SBO-Common database " for sap hana

Hi.. Experts

I am working on SAP Hana Pl 04 64 bit, On which I got the error "Unable to access SBO-Common database " While using DTW.

also company databases are also not presents,For more details for more details find out attachment.

I have also check out all services & Restart them.

Please give me proper solution.



DTW_ HANA_ERR.jpg (77.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

8 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 15, 2014 at 05:55 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 10, 2014 at 04:12 PM

    Hi Amole,

    have you typed in the server box the full address and port number of HANA DB?

    Like this: 192.168.1.69:30015

    From your screenshot I cannot see it but a common problem is that you only type address without port number, on my systems if I don't put also the port number it doesn't connect.

    Regards,

    Fabrizio

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 12, 2014 at 05:57 AM

    Hi Amole,

    Have you installed HANA database client on this computer? 32-bit or 64-bit? same type as DTW and DI API? Same version as your HANA database? I remember PL04 requires Rev 69.

    And can you access the SLD: https://SERVER IP:40000/ControlCenter and see the company list?

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 14, 2014 at 01:09 AM

    Hi,

    Please check:


    1.Ensure you have the correct DB Type selected under the Login options.


    2.Verify that all connection information is correct (for example, the correct user name and password or the user has enough right to connect to the database server in case Windows Authentication is used).

    3. Check whether the database is running properly, make sure that the COMMON and company databases are not suspended or stopped.


    4. Ensure there is no DI API version mismatch.

    Thanks & Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 09, 2015 at 12:16 PM

    Hi,

    Go to the "Change Server" Button and log with the SYSTEM user,

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 29, 2016 at 06:01 PM

    Good day, although this question is old. Just I spend something similar in a SQL version 9.1 PL11 and SQL 2014. And all I did was set up the connection to SQL again, through the Change Server button


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 29, 2016 at 06:26 PM

    Hi,

    On SQLServer the connection detail are not so sensible as the Hana connection.

    Oh Hana you must inform the exactly server name (Hostname, IP ou FQDN). It depends of how the SLD has been configurated.

    Of course, the other hint given by other collegues are welcome, like the correct Hana clients and other else hints.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2016 at 04:56 PM

    Hi,

    I was dealing with the same issue for the longest time. This is what finally made it work for me:

    1. Click on "Change Server" and type <IP>:30015 as your "Database Server"

    2. On the same page, under "Login ID" and password, you actually need to specify the "SYSTEM" user

    3. Then the list of databases should populate in the Logon screen

    4. Select the database you wish to connect to, and under "User Code" and password, you type your actual SAP B1 HANA user/password account information.

    I didn't realize "Login ID" and "User Code" were different things, since the DTW tool pre-populates those both fields with the "User Code" account information, and pre-populates the Database Server information without the 30015 port number.

    Another tip, make sure the DI API architecture matches the DTW client, i.e, either both 32-bits or both 64-bits. It won't work if you mix them.

    Add a comment
    10|10000 characters needed characters exceeded

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.