Export HANA Database

[Former Member]

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

[lbreddemann]

no information on SAP HANA revision, no information from the indexserver trace files or about the failing object "OFLT"... we really can't tell what's going on here, without some more info.

[jgleichmann]

1. Open a new thread and give more information about your environment
2. check filesystem free space and look into the indexserver trace files
3. Activate a trace, reproduce the issue and afterwards deactivate the trace:

#activate trace
ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'system') SET ('trace', 'importexport') = 'debug' with reconfigure;

#deactivate trace
ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'system') UNSET ('trace', 'importexport') with reconfigure;

[former_member507914]

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

Thanks and Regards,

Aditya

[former_member507914]

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

copy of I
SBOCOMMON
SDRQ

D
$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: I

SDRQ

[former_member507914]

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

Thanks and Regards,

Aditya Asati

[former_member421694]

Hi Exports ,

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

Best Regards,

[former_member450712]

Sir did you got any solution for this problem ?. im also facing same error

[former_member421694]

Dear Hameem ,

Please try export from other Client ??

Best Regards,

Homsi

[jgleichmann]

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

[former_member349215]

Hi Dimitris,

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

Pascale

[lbreddemann]

The fact that you also have a similar problem doesn't help to analyse it. Can you provide more detail info?

[Former Member]

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

-- Steven D.

[former_member480482]

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