Import table failed

[former_member1054930]

help me i already export this querry

EXPORT "SCHEMA_NAME"."*" AS BINARY INTO 'LOCATION' WITH REPLACE;

and i also execute this querry

IMPORT "SCHEMA_NAME"."*" AS BINARY FROM 'LOCATION'

WITH REPLACE THREADS 10 RENAME SCHEMA "SCHEMA_NAME" TO "SCHEMA_NAME_NEW";

and i got an eror

SAP DBTech JDBC: [2048]: column store error: table import failed: [30110] join depth exceeds its maximum:255: line 1058 col 8 (at pos 34053)

pls help me thanx

[simon25]

Hi Hadi,

What is your exact SPS revision of the HANA systems involved ?

Your symptom matches a known issue which was fixed way back on revision >= 122.00 (SPS12).

Review the workaround from SAP Note 2429351 - SAP HANA Studio Schema Import is failing with "SQL internal parse tree depth exceeds its maximum: join depth exceeds its maximum"

Kind Regards

Simon