Re: ATG 2006.3 with MySQL 5.x on Linux

As a temporary workaround, I updated das_ddl.sql as follows:

----
create table if_integ_data (
        item_id varchar(40)     not null,
--      descriptor      nvarchar(255)   not null,
        descriptor      varchar(255)    not null,
--      repository      nvarchar(255)   not null,
        repository      varchar(255)    not null,
        state   integer not null,
        last_import     datetime        null,
        version integer not null
,constraint if_int_data_p primary key (item_id,descriptor,repository));

commit;

----

This reduces the overall key length (varchar is 1 byte, nvarchar is 2) so that it fits into mysql's limit of 1000 bytes per key.  I opened a support ticket with ATG about this and will hopefully hear back soon.