14 Replies Latest reply: Jun 26, 2013 10:30 AM by Andy Chen RSS

Problem of install AFL on HANA ver45

Jiawei Huang
Currently Being Moderated

hello everyone,

 

I'm starting to investigate BFL, I have download the BFL guide from HANA appliance.

According to the guide, the prerequisite of using BFL is install AFL first.

The installation of AFL is included in HANA unified installer.

So I downloaded the "HANA unified installer" , unfortunately, SMP doesn't provide the SP05 unified installer, only SP04 & SP03 unified install available.

never mind, I started to install the AFL with SP04 version and followed the installer guide.

 

following is what the unified installer guide says:

  

  1.   Connect to the system with an X server client to enable GUI system access.

  

2.     Open a root shell and go to the directory where you mounted the SAP HANA DVD, by entering a command like the following:

 

          cd <HANA_DVD>/DATA_UNITS/HANA_IM_LINUX__X86_64

  

 

3.      Call the script in GUI mode to perform the rename:

 

          ./hanaconfig.sh --gui

  

 

but when i execute ./hanaconfig.sh --gui , the error shows "Error while checking for existence of HANA system. Please specify the SID of the current HANA installation on the command line."

I have tried a lot to add SID in the command everywhere, but the error still exists.

anybody can help?

 

PS: only one HANA instance installed on this server.

  • Re: Problem of install AFL on HANA ver45
    Srikar Garisa
    Currently Being Moderated

    I worked for me. This is full command:

     

    ./hanaconfig.sh -interactive aflinstall --afl_sid HAN --afl_path /hanasoft/AFLHANA_45-10011498.SAR --afl_sidadm_pwd <password>

     

    let me know how it goes.

     

    Regards,
    Srikar

    • Re: Problem of install AFL on HANA ver45
      Jiawei Huang
      Currently Being Moderated

      Hi Srikar,

      Thanks for your reply. but it didn't work for me.

      here is the error log.

      Running HANA configuration tool...

      Work directory: /tmp/hanaconfig.0

      org.apache.commons.cli.UnrecognizedOptionException: Unrecognized option: -interactive

      Use --help for help.

      Full log written to /var/tmp/hanaconfig/2012.12.18T14.47.03/hanaconfig.log

      HANA configuration tool exited with an error.

       

      It seems hanaconfig doesn't accept the parameter interactive

       

      BR
      jiawei

  • Re: Problem of install AFL on HANA ver45
    Jimmy Shao
    Currently Being Moderated

    Hi JiaWei

    You can NOT install AFL package on the SPS04 Version.

    AFL is supported from SPS05 version.

    You only could install AFL Package on SPS05.

    Thanks a lot.

    Jimmy

    • Re: Problem of install AFL on HANA ver45
      Jiawei Huang
      Currently Being Moderated

      Hi Jimmy,

      That's the problem. According to the SP05 BFL guide, it says "

      To use the BFL functions, you must:

      ■ Install SAP HANA SPS05.

      ■ Install the Application Function Library (AFL), which includes BFL. For more information, see the section Installing Application Function Libraries (AFLs) on a SAP HANA System in the SAP HANA Installation Guide with Unified Installer.

      ".

      So I found the guide of "SAP HANA Installation Guide with SAP HANA Unified Installer" of SP05 .

      But SP05 unified installer is not available at SMP. only SP04 and SP03.

      That's ridicules.

       

      Yes, I have installed AFL successfully by AFL install package.

      But there is a little problem.

      After AFL installed, the _SYS_AFL schema cannot be seen in studio( studio is also ver45).

      But after create any object (es: table) under _SYS_AFL schema . the schema shows automatically.

       

      BR
      Jiawei

  • Re: Problem of install AFL on HANA ver45
    Vjola Dule
    Currently Being Moderated

    Hi,

     

    I have the same problem with the Installation of AFL.

    I run HANA SPS05 Rev 52.

     

    with the command:

     

    ./hanaconfig.sh --batch aflinstall --afl_sid HDB --afl_path /usr/local/AFL.SAR --alf_sidadm_pwd <password>

     

    i have the following error:

     

    Running HANA configuration tool...

    Work directory: /tmp/hanaconfig.3

    Can not detect on original HANA System

    Full log written to /var/tmp/hanaconfig/2013.04.05T15.46.24/hanaconfig.log

    HANA configuration tool exited with an error.

     

     

    can anybody help?

     

    Regards, Vjola

  • Re: Problem of install AFL on HANA ver45
    Vjola Dule
    Currently Being Moderated

    Hi,

     

    below is  log file:

     

    NFO 2013-04-05 15:46:28 HANA Config
    HANA system found! SID: HNA, InstanceNumber: 00, Hostname: srv

    INFO 2013-04-05 15:46:28 HANA Config
    Executing external process: /usr/sap/hostctrl/exe/sapcontrol -nr 00 -function ParameterValue DIR_INSTALL

    INFO 2013-04-05 15:46:29 HANA Config


    INFO 2013-04-05 15:46:29 HANA Config
    05.04.2013 15:46:28

    INFO 2013-04-05 15:46:29 HANA Config
    ParameterValue

    INFO 2013-04-05 15:46:29 HANA Config
    OK

    INFO 2013-04-05 15:46:29 HANA Config


    INFO 2013-04-05 15:46:29 HANA Config
    /usr/sap/HNA/SYS

    WARN 2013-04-05 15:46:29 HANA Config
    Cannot load landscapeVariables.properties for system with installation directory /usr/sap/HNA/SYS and hence cannot determine if installation is secondary. Probably the installation is incomplete. Treating it as secondary.

    java.io.FileNotFoundException: /usr/sap/HNA/lm_structure/landscapeVariables.properties (No such file or directory)
    at java.io.FileInputStream.open(Native Method)
    at java.io.FileInputStream.<init>(FileInputStream.java:106)
    at com.sap.lm.hana.config.common.utils.hana.LandscapeVariables.createLandscapeVariablesInputStream(LandscapeVariables.java:59)
    at com.sap.lm.hana.config.common.utils.hana.LandscapeVariables.ensurePropertiesAreLoaded(LandscapeVariables.java:47)
    at com.sap.lm.hana.config.common.utils.hana.LandscapeVariables.isInstallationSecondary(LandscapeVariables.java:64)
    at com.sap.lm.hana.config.common.utils.hana.HanaSystemDetector.isOriginal(HanaSystemDetector.java:151)
    at com.sap.lm.hana.config.common.utils.hana.HanaSystemDetector.detectOriginalHanaInstance(HanaSystemDetector.java:131)
    at com.sap.lm.hana.config.Application.ensureOriginalHanaExistence(Application.java:101)
    at com.sap.lm.hana.config.Application.startExecution(Application.java:91)
    at com.sap.lm.hana.config.Application.start(Application.java:70)
    at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
    at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
    at org.eclipse.equinox.launcher.Main.run(Main.java:1410)
    at org.eclipse.equinox.launcher.Main.main(Main.java:1386)
    ERROR 2013-04-05 15:46:29 HANA Config
    Can not detect an original HANA system

     

     

    Thank you for your response

     

    Regard,

    Vjola

    • Re: Problem of install AFL on HANA ver45
      Srikar Garisa
      Currently Being Moderated

      So do you see the directory /usr/sap/HNA/lm_structure/? If yes, what about the file landscapeVariables.properties?

       

      If the directory lm_structure is missing,  then initial Install of HANA SP05 is incomplete.

      Uninstall and resinstall the HANA software.

       

      Regards,

      Srikar

      • Re: Problem of install AFL on HANA ver45
        Vjola Dule
        Currently Being Moderated

        Hi Srikar,

         

        thank you for your response.

         

        the directory Im_structure is missing.

        do i have to install again the whole Databank in  SPS05 (rev. 46)  or just the latest Rev. 52?

         

        regards

        Vjola

        • Re: Problem of install AFL on HANA ver45
          Srikar Garisa
          Currently Being Moderated

          Hi Vjolo,

           

          Ideally I would reinstall the HANA database if lm_structure is missing.

          lm_structure should have been there with 46 itself.

          Install SPS05 again. Check if lm_structure exists and then apply 52.

           

          What's the role of this system? Sanbox, Dev ,QA or Production?

          I can understand if the system is already live for corresponding system role use, it's a pain to redo all this stuff. In that case i would recommend raise SAP message, may be they can take a look your system install integrity.

           

          Let us know how it goes.

           

          Regards,

          Srikar

  • Re: Problem of install AFL on HANA ver45
    Michael Gerstmayer
    Currently Being Moderated

    Hello,

     

    LM_STRUCTURE belongs to SUM functionality which has been added in SPS3. If your system was first setup without this components you can install them afterwards using the script attached to note:

    1793303 - Install and configure SUM for SAP HANA (non-distributed systems)

    Doing it this way the hostagent, LM_STRUCTURE and SUM are installed and configured automatically if missing. Of course you can do a fresh installation of SPS5 using the Unified Installer, but I'm sure the note provided will help in this case.

     

    Regarding AFL installation, the AFL revision needs to be identical to the HANA revision (at the moment). SMP only holds the latest main HANA SP0x software components installation files (of rev. 45 and 53). However, this should not be a problem as the revision of your appliance should be updated frequently.

     

    Best regards,

    Michael

  • Re: Problem of install AFL on HANA ver45
    Vjola Dule
    Currently Being Moderated

    Hallo,

     

    i have checked again for LM_STRUCTURE, but i found only  LM_STRUCTURE_CONTENT

    LM_STRUCTURE_CONTENT.PNG

    there is no lanscapeVariables.properties

     

    I will try firstwith the NOTE, if it doesn't work then reinstall the SPS5.

    I 'll let you know how it goes.

     

    This System ist just a Test System.

     

    Thank you and regards,

    Vjola

    • Re: Problem of install AFL on HANA ver45
      Andy Chen
      Currently Being Moderated

      Hi Vjolo,

       

      Have you solved this issue? And how?

       

      I personaly also meet this probelm right now.

       

      Exception while running hana config tool: Cannot read master host of HANA system XXX.

      ......

      Caused by: java.io.FileNotFoundException: /sapmnt/JH2/lm_structure/landscapeVariables.properties (No such file or directory)

      Thanks ahead.

       

      Best Regards,

      Andy Chen

Actions