Skip to Content
0
Mar 06, 2017 at 09:49 PM

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

844 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