DataDeploy creates table-views without PATH column

philipp

Hi,

We installed TeamSite 5.5.2 +..+ DataDeploy 5.6 on a new Solaris Server, copied all configuration files, backingstore etc.

We synced the database with

iwsyncdb.ipl -initial

The tables were created properly (create table IWT_123456789012 (PATH VARCHAR(255) NOT NULL, IW_STATE VARCHAR(30), META_0_...) ).

The table-views were create without having a PATH column ( create view IWV_123456789012 as select iw_state, meta_0_...).

Does anyone have an idea why the PATH column is left out and how to fix it?

(DataDeploy Admin Guide says that DD5.6 excludes columns with the types CLOB, BLOB, TEXT and IMAGE from the CREATE AS SELECT ... query, but this is actually not the case here)

Thanks in advance.

Migrateduser

Thats actually a bug which has been fixed in DD5.6SP1, please upgrade to DD5.6 SP1.