Skip to Content

SFLIGHT import in HANA Express 2.0 causes Error: cannot load table due to old persistence format

Hi SAP Community,

I'm trying to import the SFLIGHT tables into HANA Express 2.0 as described in Blog

https://blogs.sap.com/2013/05/16/howto-import-sflight-sample-data-into-hana-from-a-local-computer/#

I have downloaded the "sflights Database for HANA.zip" file from github, but I will allways get this Error if I try to import in HANA Studio:

SAP DBTech JDBC: [2048]: column store error: table import failed: [10000053] Cannot load table SYSTEMDB::SFLIGHT:SAIRPORTen during recovery due to old persistence format from before SP9;object=SYSTEMDB::SFLIGHT:SAIRPORTen,location=hxehost:39001

I have searched for a newer version of the SFLIGHT tables working with HANA Express 2.0, but I haven't found any one in the web.

It would be very helpfull if someone could publish the correct files for downloading it from everybody how needs this.

Thanks a lot!

Regards

Andreas

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 07, 2017 at 05:58 AM

    Can you try it with the file available with following link: Sflight.zip

    This version can be imported into an HXE 2.0 installation.

    If you still get errors, please show the steps you are doing for the import.

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 09, 2017 at 10:36 PM

    SP9 is way too old. You need to download some HANA 2.0 version data for SFlight.

    Add comment
    10|10000 characters needed characters exceeded