Skip to Content
avatar image
-1
Former Member

Export HANA Database

Hello everybody,

I try to export a Database from SAP HANA using the command

EXPORT "Database"."*" AS BINARY INTO '/hana/shared/backup_service/backups/Database' WITH REPLACE THREADS 10

from SAP HANA Studio.

After a while I get this error:

Could not execute 'EXPORT "Database"."*" AS BINARY INTO '/hana/shared/backup_service/backups/Database' WITH REPLACE ...' in 13:20.258 minutes . 
SAP DBTech JDBC: [2048]: column store error: table export failed:  [29002] Unknown persistence layer error;/hana/shared/backup_service/backups/Database/index/Database/OF/OFLT,object=Database:OFLTen,location=linux-ifp8:30003 

Have the same process more than one times and still get the same error.

Can someone please advice a workaround in order this database is exported successfully?

Kind regards,

Dimitris Theotokatos

Add comment
10|10000 characters needed characters exceeded

  • I am facing the same issue has anyone find the solution?

    Thanks and Regards,

    Aditya

  • i a m getting below error information in indexserver.trc file

    copy of ISBOCOMMONSDRQD$container$ to <Path>/index/SBOCOMMON/SD/SDRQ/$container$ failed with rc = 29002 [5504]{207173}[164/28612547] 2018-05-08 12:03:05.644893 e ImportExport ImportExport.cpp(09935) : Could not export data, indexId: SBOCOMMON:SDRQ (t 21670) [5504]{207173}[164/28612547] 2018-05-08 12:03:05.644906 e ImportExport ImportExport.cpp(06225) : Export binary data failed for column table: SBOCOMMON:SDRQ (t 21670), at: ISDRQ

  • Does anyone has the solution of the same? I am still not able to export DB using Export.

    Thanks and Regards,

    Aditya Asati

  • Get RSS Feed

4 Answers

  • Oct 19, 2017 at 07:48 AM

    Hi Dimitris,

    I'm also having the same error. Did you manage to get a solution for it?

    Pascale

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 08, 2017 at 11:14 PM
    -1

    I have similar situation but no answer to what is wrong, how to fix or workaround.

    -- Steven D.

    Add comment
    10|10000 characters needed characters exceeded

  • -1

    Hola, deben revisar que la carpeta y subcarpeta cuente con los permisos de Lectura y Escritura.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 26 at 09:59 AM
    -2

    Hi Exports ,

    Please can any one help me , i have the same issue ?

    Best Regards,

    Add comment
    10|10000 characters needed characters exceeded

    • just check out if you are facing a known issue:

      2657444 - Indexserver Crash After LobExportConsumer::consumeLob When Running out of Space on Export Target While Creating Binary Export Including LOBs

      Due to a programming error in SAP HANA, running out of space on the export target while creating a binary export including LOBs can lead to a crash.

      Another one is regarding older revisions (SPS10/11) and the binary format. Just try to use csv format as workaround or update to one of the latest revisions.

      Regards,

      Jens