HDB Table example doesn't work

[iliyan-velichkov]

HDB Table example doesn't work

File: MyProducts5.hdbtable

table.schemaName = "APP_SCHEMA";
table.tableType = COLUMNSTORE;
table.columns = [    
    {
        name = "Col1";
        sqlType = VARCHAR;
        nullable = false;
        length = 20;
        comment = "dummy comment";
    },
    {
        name = "Col2";
        sqlType = INTEGER;
        nullable = false;
    },
    {
        name = "Col3";
        sqlType = NVARCHAR;
        nullable = true;
        length = 20;
    },
    {
        name = "Col4";
        sqlType = DECIMAL;
        nullable = false;
        precision = 2;
        scale = 2;
    }];
table.indexes =  [
    {
        name = "MyProducts5_MYINDEX1";
        unique = true;
        order = DSC;
        indexColumns = ["Col2"];
    },
    {
        name = "MyProducts5_MYINDEX2";
        unique = true;
        order = DSC;
        indexColumns = ["Col1", "Col4"];
    }];
table.primaryKey.pkcolumns = ["Col1"];

Results in:

2024-05-20 12:38:39.284 [ERROR] [schedulerFactoryBean_Worker-1] c.c.k.e.h.s.HDBTablesSynchronizer - hdbtable: HDBTable [id=7, tableType=COLUMNSTORE, columns=[HDBTableColumn [id=25, getName()=Col1, getType()=VARCHAR, getLength()=20, isNullable()=false, isPrimaryKey()=true, getDefaultValue()=null, getPrecision()=null, getScale()=null, isUnique()=false, isDefaultValueDateTimeFunction()=false, getComment()=dummy comment, getAlias()=null, isFuzzySearchIndex()=false, getStatement()=null, isCalculatedColumn()=false], HDBTableColumn [id=26, getName()=Col2, getType()=INTEGER, getLength()=null, isNullable()=false, isPrimaryKey()=false, getDefaultValue()=null, getPrecision()=null, getScale()=null, isUnique()=false, isDefaultValueDateTimeFunction()=false, getComment()=null, getAlias()=null, isFuzzySearchIndex()=false, getStatement()=null, isCalculatedColumn()=false], HDBTableColumn [id=27, getName()=Col3, getType()=NVARCHAR, getLength()=20, isNullable()=true, isPrimaryKey()=false, getDefaultValue()=null, getPrecision()=null, getScale()=null, isUnique()=false, isDefaultValueDateTimeFunction()=false, getComment()=null, getAlias()=null, isFuzzySearchIndex()=false, getStatement()=null, isCalculatedColumn()=false], HDBTableColumn [id=28, getName()=Col4, getType()=DECIMAL, getLength()=null, isNullable()=false, isPrimaryKey()=false, getDefaultValue()=null, getPrecision()=2, getScale()=2, isUnique()=false, isDefaultValueDateTimeFunction()=false, getComment()=null, getAlias()=null, isFuzzySearchIndex()=false, getStatement()=null, isCalculatedColumn()=false]], indexes=[], constraints=TableConstraints [id=7, primaryKey=TableConstraintPrimaryKey [id=7, name=PK_test-project2::MyProducts5, modifiers=null, columns=[Ljava.lang.String;@539f8e06, constraints.table=test-project2::MyProducts5], foreignKeys=[], uniqueIndexes=[TableConstraintUnique [id=9, indexType=null, order=DESC, name=MyProducts5_MYINDEX1, modifiers=null, columns=[Ljava.lang.String;@6da48477, constraints.table=test-project2::MyProducts5], TableConstraintUnique [id=null, indexType=null, order=DESC, name=MyProducts5_MYINDEX2, modifiers=null, columns=[Ljava.lang.String;@61514b36, constraints.table=test-project2::MyProducts5]], checks=[], table=test-project2::MyProducts5], isPublic=null, loggingType=null, temporary=null, hdbdd=null, location=/test-project2/MyProducts5.hdbtable, name=test-project2::MyProducts5, type=hdbtable, description=null, key=hdbtable:/test-project2/MyProducts5.hdbtable:test-project2::MyProducts5, dependencies=null, lifecycle=null, phase=null, error=null, createdBy=SYSTEM, createdAt=Mon May 20 12:38:28 EEST 2024, updatedBy=SYSTEM, updatedAt=Mon May 20 12:38:28 EEST 2024]
2024-05-20 12:38:39.284 [ERROR] [schedulerFactoryBean_Worker-1] c.c.k.e.h.s.HDBTablesSynchronizer - content: table.schemaName = "APP_SCHEMA";
table.tableType = COLUMNSTORE;
table.columns = [    
    {
        name = "Col1";
        sqlType = VARCHAR;
        nullable = false;
        length = 20;
        comment = "dummy comment";
    },
    {
        name = "Col2";
        sqlType = INTEGER;
        nullable = false;
    },
    {
        name = "Col3";
        sqlType = NVARCHAR;
        nullable = true;
        length = 20;
    },
    {
        name = "Col4";
        sqlType = DECIMAL;
        nullable = false;
        precision = 2;
        scale = 2;
    }];
table.indexes =  [
    {
        name = "MyProducts5_MYINDEX1";
        unique = true;
        order = DSC;
        indexColumns = ["Col2"];
    },
    {
        name = "MyProducts5_MYINDEX2";
        unique = true;
        order = DSC;
        indexColumns = ["Col1", "Col4"];
    }];
table.primaryKey.pkcolumns = ["Col1"];
2024-05-20 12:38:39.285 [ERROR] [schedulerFactoryBean_Worker-1] o.e.d.c.i.s.SynchronizationProcessor - could not execute statement [Unique index or primary key violation: "PUBLIC.UK_2MAP4E125OKBPI5F14SJWYQAG_INDEX_4 ON PUBLIC.KRONOS_TABLE_UNIQUES(CONSTRAINTS_ID NULLS FIRST) VALUES ( /* 9 */ CAST(7 AS BIGINT) )"; SQL statement:
insert into KRONOS_TABLE_UNIQUES (CONSTRAINT_COLUMNS,CONSTRAINTS_ID,UNIQUE_INDEXTYPE,CONSTRAINT_MODIFIERS,CONSTRAINT_NAME,UNIQUE_ORDER,UNIQUE_ID) values (?,?,?,?,?,?,default) [23505-224]] [insert into KRONOS_TABLE_UNIQUES (CONSTRAINT_COLUMNS,CONSTRAINTS_ID,UNIQUE_INDEXTYPE,CONSTRAINT_MODIFIERS,CONSTRAINT_NAME,UNIQUE_ORDER,UNIQUE_ID) values (?,?,?,?,?,?,default)]; SQL [insert into KRONOS_TABLE_UNIQUES (CONSTRAINT_COLUMNS,CONSTRAINTS_ID,UNIQUE_INDEXTYPE,CONSTRAINT_MODIFIERS,CONSTRAINT_NAME,UNIQUE_ORDER,UNIQUE_ID) values (?,?,?,?,?,?,default)]; constraint ["PUBLIC.UK_2MAP4E125OKBPI5F14SJWYQAG_INDEX_4 ON PUBLIC.KRONOS_TABLE_UNIQUES(CONSTRAINTS_ID NULLS FIRST) VALUES ( /* 9 */ CAST(7 AS BIGINT) )"; SQL statement:
insert into KRONOS_TABLE_UNIQUES (CONSTRAINT_COLUMNS,CONSTRAINTS_ID,UNIQUE_INDEXTYPE,CONSTRAINT_MODIFIERS,CONSTRAINT_NAME,UNIQUE_ORDER,UNIQUE_ID) values (?,?,?,?,?,?,default) [23505-224]]
2024-05-20 12:38:39.358 [ERROR] [schedulerFactoryBean_Worker-1] o.e.d.c.i.s.SynchronizationProcessor - Error occured during synchronization: [could not execute statement [Unique index or primary key violation: "PUBLIC.UK_2MAP4E125OKBPI5F14SJWYQAG_INDEX_4 ON PUBLIC.KRONOS_TABLE_UNIQUES(CONSTRAINTS_ID NULLS FIRST) VALUES ( /* 9 */ CAST(7 AS BIGINT) )"; SQL statement:
insert into KRONOS_TABLE_UNIQUES (CONSTRAINT_COLUMNS,CONSTRAINTS_ID,UNIQUE_INDEXTYPE,CONSTRAINT_MODIFIERS,CONSTRAINT_NAME,UNIQUE_ORDER,UNIQUE_ID) values (?,?,?,?,?,?,default) [23505-224]] [insert into KRONOS_TABLE_UNIQUES (CONSTRAINT_COLUMNS,CONSTRAINTS_ID,UNIQUE_INDEXTYPE,CONSTRAINT_MODIFIERS,CONSTRAINT_NAME,UNIQUE_ORDER,UNIQUE_ID) values (?,?,?,?,?,?,default)]; SQL [insert into KRONOS_TABLE_UNIQUES (CONSTRAINT_COLUMNS,CONSTRAINTS_ID,UNIQUE_INDEXTYPE,CONSTRAINT_MODIFIERS,CONSTRAINT_NAME,UNIQUE_ORDER,UNIQUE_ID) values (?,?,?,?,?,?,default)]; constraint ["PUBLIC.UK_2MAP4E125OKBPI5F14SJWYQAG_INDEX_4 ON PUBLIC.KRONOS_TABLE_UNIQUES(CONSTRAINTS_ID NULLS FIRST) VALUES ( /* 9 */ CAST(7 AS BIGINT) )"; SQL statement:
insert into KRONOS_TABLE_UNIQUES (CONSTRAINT_COLUMNS,CONSTRAINTS_ID,UNIQUE_INDEXTYPE,CONSTRAINT_MODIFIERS,CONSTRAINT_NAME,UNIQUE_ORDER,UNIQUE_ID) values (?,?,?,?,?,?,default) [23505-224]]]