UVMS upgrade from 7.01.01 to 7.01.11 generates ERROR X0Y32 already exists

Products

• CA Automic Dollar Universe

Issue/Introduction

When upgrading UVMS from  v7.01.01 to v7.01.11, the error message below shows up. However, the upgrade remains successful despite of the message. 

----------------------------------------------------------------------------------------------------------------------------------------------------------

ALTER TABLE UNI_UV_NODES_INFO ADD COLUMN IS_MS_FEATURE_ACTIVATED SMALLINT DEFAULT 0 NOT NULL;

ERROR X0Y32: Column 'IS_MS_FEATURE_ACTIVATED' already exists in Table/View '"SA"."UNI_UV_NODES_INFO"'.

ij> ALTER TABLE UNI_UV_NODES_INFO ADD COLUMN REGISTER_DATE varchar(255);

ERROR X0Y32: Column 'REGISTER_DATE' already exists in Table/View '"SA"."UNI_UV_NODES_INFO"'.

ij> ALTER TABLE UNI_UV_NODES_INFO ADD COLUMN UNREGISTER_DATE varchar(255);

ERROR X0Y32: Column 'UNREGISTER_DATE' already exists in Table/View '"SA"."UNI_UV_NODES_INFO"'.

ij> /*==============================================================*/

/* Table: UNI_TELEMETRY_NODE                                    */

/*==============================================================*/

create table UNI_TELEMETRY_NODE (

    ID                        bigint              not null,

    NODE_ID                   bigint              not null,

    REFERENCE_DATE            numeric(8)          not null,

    WS_MULTISTEP_COUNT        bigint              not null,

    CREATION_TIMESTAMP        TIMESTAMP                   ,

    UPDATE_TIMESTAMP          TIMESTAMP                   ,

    constraint PK_UNI_TELEMETRY_NODE primary key (ID),

    constraint UNIQUE_TELEMETRY_NODE unique (NODE_ID, REFERENCE_DATE)

);

ERROR X0Y32: Table/View 'UNI_TELEMETRY_NODE' already exists in Schema 'SA'.

ij> alter table UNI_TELEMETRY_NODE

    add constraint FK_TELEMETRY_NODE_NODE foreign key (NODE_ID)

        references UNI_UV_NODES (ID);

ERROR X0Y32: Constraint 'FK_TELEMETRY_NODE_NODE' already exists in Schema 'SA'.

ij>  => Upgrading derby DB to v7 ...

 

 ----------------------------------------------------------------------------------------------------------------------------------------------------------

Environment

Product: Univiewer Manager Server v7.01.01 

Cause

DE177245

Resolution

Please ignore the error message since the UVMS upgrade is still successful.

Fix version:
Univiewer Management Server v7.01.21 - Planned release May 2026

 

Additional Information

Public title: Added Extra condition

Public Description: Added extra condition to prevent those warnings