Problem of install AFL on HANA ver45

[former_member223311]

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.

[former_member300783 · Accepted solution]

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

[former_member223311 · Accepted solution]

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

[Former Member · Accepted solution]

You can found "SAP HANA Unified Installer of SP05" in Installation DVD SPS05

DVD_ROOT\DATA_UNITS\HANA_IM_LINUX__X86_64\

Regards,

Artem

[Former Member]

Hallo,

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

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

[former_member131867]

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

[michael_gerstmayer]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Vjola,

Please paste the contents of the log file:  /var/tmp/hanaconfig/2013.04.05T15.46.24/hanaconfig.log

Especially the last 50 or so lines.

Srikar

[Former Member]

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

[former_member223311]

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