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

CANNOT ACCESS SLD AFTER DATABASE MIGRATION FAIL

Hello Everybody, Hi Duncan (I hope you're there),

After a DB failed conversion from SQL to HANA i cannot access the SLD on the HANA machine anymore. I get the error message: "System error; check log for details".

On top of this, If I now try to install a new licence in the HANA studio for the HANA studio itself, i Get the following error:

"SAP DBTech JDBC: [436]: could not set system licence: 5503: nameserver failed top process the request; ltt exception: Failed to install a permanent licence".

Please advice on how to get out of this wihout re-installing any component.

Thanks a lot for the help.

Regards,

Luigi Silipo

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 23, 2015 at 05:27 PM

    Hi,

    Your problem's solution is available on SAP note 1944485 - Cannot import schema into SAP HANA if data staging is enabled.

    You need S user id and password for it.

    Best of luck.

    Regards,

    Chintan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 23, 2015 at 05:56 PM

    Hi Luigi,

    How many databases arr there ??

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 23, 2015 at 10:21 PM

    Hello There,

    I've completely removed SAP Business ONE server, HANA DB, HANA Studio and all related services. Now I re-install everything and looks good....until I find that It is setting the DAtabase Server on a non existent ip address: 192.168.249.1

    Do you know Why?

    This thing is driving me crazy.....looks very "unstable"!!!!!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 24, 2015 at 06:20 AM

    Hello,

    unfortunately my system is now in an unusable state.

    To make it quicker, does anybody know how to COMPLETELY remove al the Linux components of SAP HANA from a server?

    I want to DELETE ALL TRACES of my previous installation:

    1) Delete the DB

    2) Delete all the components (Tomcat, catalina, ecc. ecc.)

    3) Delete HANA studio and the DB client

    4) Delete SAP Business ONE server, server tools and the likes

    I really appreciate your help.

    Regards,

    Luigi

    Add a comment
    10|10000 characters needed characters exceeded


    • Hi Luigi,

      You could visit http://www.suse.com/slesb1hana download the latest ISO and reinstall Linux. This would remove all B1 and HANA components from the server. If that is too extreme you can take the steps shown below.

      1. Stop B1 components using /etc/init.d/sapb1servertools
      2. Uninstall B1 using the uninstall.bin program located in /opt/sap/SAPBusinessOne, or /usr/sap/SAPBusinessOne
        • The installer must be run in a graphical environment
      3. Confirm that all B1 RPM files have been removed using rpm -q -a | grep B1
        • If step 3 shows rpm files use rpm -q -a | grep B1 | xargs rpm -e to remove them
      4. Delete the B1 install directory, path given in step 2
      5. Confirm in the SLD that all related schemas are gone. If any are left behind delete them. When prompted do a cascading deleting
        1. You cannot delete the Common schema, used by analytics. You drop the common schema by deleting the common user. When deleting the user select cascading and the schema will be deleted too

      The five steps above remove all B1 components and there associated tables. If you should be able to reinstall now. If you would also like to remove HANA I will be provide the steps below.

      1. Navigate to the SA_HANA_DATABASE directory that was created when you executed sapcar -xvf <HANA install sar file> and call ./hdbuninst this will start the HANA uninstall process. You can use this process to remove HANA clients, HANA DB, and HANA studio
      2. Confirm that all the HANA directories are gone
      3. Delete the contents of /tmp

      You will have to run the uninstall program referenced in step 1 multiple times to remove all the installed HANA components.

      After the steps above are completed you can proceed with your installation.

      Best regards,

      Duncan

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.