Skip to Content

Error while import schema in HANA DB

Hi...

I am trying to perform an export-import of a HANA DB user instance at schema level including all objects (in my case tables and synonyms) and data.

Export and Import works very well except importing a schema which contains a synonym referred to other existing schema .

Here is a test case

- Schema A with a Table and Schema B to contain a synonym for schema A's table.

- Exported both schemas to CSV which is done successfully and everything looked ok in export location.

- Imported Schema A and then Schema B with the following command.

Command:

IMPORT "<bkup_schema>"."*" FROM '<bkp_location>' WITH RENAME SCHEMA <bkup_schema> TO <brand_new_schema>;

The schema A (with table) imported fine. Schema B (with synonym) gives the below error :

"SAP DBTech JDBC: [2048]: column store error: table import failed: [2003] An index already exists with the same name "


When trying to use "REPLACE" clause in the command the error changes as below:

SAP DBTech JDBC: [2048]: column store error: table import failed: [30117] Binary import failed (cannot execute drop statement)

Has anybody faced this type of error before??

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Jun 10, 2014 at 07:51 PM

    Hi,

    I got the same message...

    Could you resolve this error?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 29, 2014 at 11:52 AM

    Hello,

    i have the same problem:

    "SAP DBTech JDBC: [2048]: column store error: table import failed: [2003] An index already exists with the same name". while restoring schema with rename.

    Mr Krishna,

    how can i check the case You mentioned?

    Regards,

    Cezary Mikuć

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2014 at 04:13 PM

    Folks, I am running into the same issue. What I figure out was the following:

    1) I turn off the autocommit

    2) I run the import for the first time

    import "<SCHEMA_NAME>"."*" as binary from '<location>' with replace;
    rollback;
    

    3) I get the error as described

    SAP DBTech JDBC: [2048]: column store error: table import failed:  [30117] Binary import failed (cannot execute drop statement) 
    

    4) I run this import once again and commit and surprisingly the error is gone and the import is successful.

    import "<SCHEMA_NAME>"."*" as binary from '<location>' with replace;
    commit;
    
    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2014 at 05:54 PM

    Hi Raval,

    Before Importing U have to clear sys_repo system In content using SQL command

    Regards,

    V@li

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 27, 2014 at 02:30 PM

    Hi, Upgrade to review HANA 74.3 or higher, in this review many errors related to export and import database schemas are resolved. Regards,

    Add comment
    10|10000 characters needed characters exceeded