Skip to Content
avatar image
Andreas Schaller

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

Mar 06, 2017 at 09:49 PM | 313 Views

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

SAP HANA studio
hana express 2.0 | old persistence format | sflight | sflight.zip | sflights.zip
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Florian Pfeffer
    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