Skip to Content

Import of hana dump is failing for Hierarchical views


When importing hana dump using "IMPORT "SOURCE"."*" AS BINARY from '/tmp/testexp' with REPLACE SCHEMA "SOURCE" TO "TARGET" THREADS 10;" command, its failing with error message "could not execute 'IMPORT "SOURCE"."*" AS BINARY from '/tmp' with RENAME SCHEMA "SOURCE" TO "TARGET"' in 40.779 seconds . SAP DBTech JDBC: [2048]: column store error: table import failed: [30111] Import failed (could not execute create statement);object=TARGET:USERS_SECOND_MANAGER_CYCLE_HVIEWen,column store error: logical index creation error: [6929] exception 75000002: Error in hierarchy definition. Error during parse of SQL query: sql syntax error: incorrect syntax near """: line 1 col 97 (at pos 97) ;object=TARGET:USERS_SECOND_MANAGER_CYCLE_HVIEWen at /sapmnt/ld7272/a/HDB/jenkins_prod/workspace/HANA__FA_CO_LIN64GCC48HAPPY_rel_fa~hana1sp12/s/ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/"

It seems, during import, it could not read the create view script for hierarichal view. When verified in the exported file, The line and col number of error points to a new line character in actual script.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 15, 2017 at 05:59 AM

    This issue looks to be deeper investigation of support. For further checking, please provide below information for us in a support incident:

    1. Please make a catalog export of the views that cannot be imported including dependencies (SAP Note#1710712 - How to export and import Hana Models for support purposes)

    2. Please collect a full-system-info-dump (KBA 1732157) and make sure that it includes the date range of system refresh.

    Add comment
    10|10000 characters needed characters exceeded