cannot import sflight.zip

[Former Member]

Hi,

i'm following the dev guide wanting to do the excercise on top of sample database SFLIGHT.

However, after executing exactly every step mentioned in the dev guide, SFLIGHT still cannot being imported (no error msg, but no data or model imported).

With the advice of Rajarshi, i have sychronized the version of HANA DB, Clinet and Studio all to version 15, and configured host file, still cannot import the data successfully.

one line added to host file:

10.60.71.205    CNDT***.DHCP.PVGL.***.CORP    HA9

below is my exercise environment:

1. I downloaded the sflight.zip file and unzipped it. Then I placed the index folder in /home in the linux server.

    The folder structure is like /home/index/sflight/sa/….

2. Below screen describes the steps I made and the inputs I placed, is there anything wrong?

[Former Member · Accepted solution]

Make sure you adjust your path to just: /home/SFLIGHT

[Former Member · Accepted solution]

tried, but still failed, pls refer to details in my reply above.

[rajarshi_muhuri · Accepted solution]

if you unzip the sflight.zip ... in the /home directory .. the folder structure should be

/home/index/sflight/(SA , SB, ..... ST)

and the export location is just /home ...

(which does just seem the first option that you had tried .... not sure why it fails for you !!!! )

[Former Member · Accepted solution]

quite strange my case is, thanks for all the hints and i will play it more with it and i will let everyone know if i get over it

[Former Member · Accepted solution]

Wow...i caught the bug!

Somehow after the unzip, the folder name changed to lowercase characters which is unrecognizable for HANA studio. Change them to uppercase, then it's done!

[Former Member · Accepted solution]

If you have noticed in my original post i put /home/SFLIGHT in capital letters, for Linux/Unix are case sensitive when it comes to names of folders & files and not the Hana studio.

[rajarshi_muhuri]

I am little concerned about the ALIAS HA9 , HA9 is the sid of the HANA system , my guess is that the alias would be cndt5080***** . So can you ping from your local machine to the HANA machine

i.e open command promt and write ping HA9 , if you get a reply , then your entry is correct in the host file .  else change the alias in the hostfile as

10.60.71.205    CNDT***.DHCP.PVGL.***.CORP      CNDT***

alternatively , you can ask the person with access to the HANA systems linux OS to write

$ hostname -i ( gives the IP)

and

$ hostname -f  (gives the full qualified host name )

$ hostname ( alias)

[Former Member]

Hi Rajarshi,

ping HA9 succeed.

the $hostname in Linux shows: CNDT***,  but ping CNDT** didn't succeed

Could it be the import folder path?  Is /home/index correct?

And i assume after importing succeeds, there should be a schema named SFLIGHT, right? if i don't see this schema, it means the import failed

[rajarshi_muhuri]

hey buddy Hao   ....

i think the import path is just /home for you .... .. now i am sure your troubles are over ...

Also there is an Efashion tutorial ( HANA developer pocketbook) .. .. I would advice you to try that before doing the SFLIGHT example .

and yes after the import you will see like this ....

[Former Member]

Rajarshi, thanks for your contiguous focus on my issue, and the developer pocketbook looks palatable!

For sflight.zip, I just gave a exciting try with the path /home, still not work

i placed three folders under /home

1.  /home/index/sflight/sa/….

2.  /home/sflight/index/sflight/sa/….

3.  /home/sflight/sa/….

Then i tried the path:

1. /home

2. /home/index

3. /home/sflight

but neither works...