Skip to Content

Import of hana dump is failing for Hierarchical views

Nov 10, 2017 at 09:56 AM


avatar image
Former Member


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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Hakan Haslaman
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.

10 |10000 characters needed characters left characters exceeded