Known issues

Workaround: If SMS' has URLs with Personalization Fields, create the SMS using Quick Builder.

Execute the following query on Platform database.

select * from usm_role_role_map where role_id = (select ID from usm_role where name='Deliver_admin' and application=101 and partition_id=<>)

Specify actual partition id in above query, default for partition1, partition id =1, it varies for multiple partitions.

If above result in more than one row, contact HCL support to help in executing the following delete query. Delete one of the duplicate record of "Deliver_admin" role by running below query.

delete from usm_role_role_map where role_id = (select ID from usm_role where name='Deliver_admin' and application=101 and partition_id=<>) and parent_role_id=<partition_id>

For example , for partition id =1

delete from usm_role_role_map where role_id = (select ID from usm_role where name='Deliver_admin' and application=101 and partition_id=1) and parent_role_id=1

An error occurred in executing ace_op_systab_<DB_TYPE>.sql from <DELIVER_HOME>\ddl\unicode folder. Due to this Email Responses are not processed in Journey - for Deliver - journey integration.

Workaround: Before running ace_op_systab_<DB_TYPE>.sql from <DELIVER_HOME>\ddl\unicode folder , replace *;-- * to / for CREATE OR REPLACE TRIGGER UCC_INS_Response and then execute the script.

For example:

CREATE OR REPLACE TRIGGER UCC_INS_Response
BEFORE INSERT ON UCC_Response
FOR EACH ROW WHEN (new.ResponseID IS NULL)
BEGIN
SELECT UCC_SEQ_Response.nextval INTO :new.ResponseID FROM dual;
END;
*;-- *

should be replaced with

CREATE OR REPLACE TRIGGER UCC_INS_Response
BEFORE INSERT ON UCC_Response
FOR EACH ROW WHEN (new.ResponseID IS NULL)
BEGIN
SELECT UCC_SEQ_Response.nextval INTO :new.ResponseID FROM dual;
END;
/