Skip to Content
0
May 29, 2018 at 08:13 AM

HANA Stored procedure Merge Partition error

942 Views

Hi All ,

I have a strange error in my stored procedure when i try to do merge partition but the same error is not encounter when doing from hana studio sql console any help is really appreciated . Many thanks

From sql console

Statement 'alter table DMF.TEST2 merge partitions' successfully executed in 290 ms 952 µs (server processing time: 289 ms 473 µs) - Rows Affected: 0

From Stored procedure

line 22 col 1 (at pos 1560): [129] (range 3): transaction rolled back by an internal error: column store error: fail to alter partition: [2999] general error (no further information available);replayLog: Cannot create delta for table that is not yet visible in a separate transaction;Error when merging delta index of part. java.sql.SQLWarning: Not recommended feature: DDL statement is used in Dynamic SQL (current dynamic_sql_ddl_error_level = 1)

My syntax in stored procedure

exec 'alter table ' || :p_schema_name || '.TEST2 drop primary key'; --exec 'alter table ' || :p_schema_name || '.TEST2 merge partitions'; exec ( 'alter table ' || :p_schema_name || '.TEST2 merge partitions' );

Any thoughts ??, Thanks