Skip to Content
-1

Export HANA Database

Jun 22, 2017 at 03:32 PM

353

avatar image
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

10 |10000 characters needed characters left characters exceeded

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.

0

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

Thanks and Regards,

Aditya

0

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

0

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

Thanks and Regards,

Aditya Asati

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Pascale Khayeri Mwavaga Oct 19, 2017 at 07:48 AM
0

Hi Dimitris,

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

Pascale

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
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.

Share
10 |10000 characters needed characters left characters exceeded