The UTF-8 Migration Pack is failing when the target database has hyphen in its name: 'Incorrect syntax near '-'

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The UTF-8 Migration Pack is failing when the target database has hyphen in its name(Ex. TARGET-DB). The SCRI object PCK.AUTOMIC_UTF-8.MIG-STEP02.CHECK.TABLESPACE.DST fails with the error message below.

U02012033 Query could not be executed: 'Incorrect syntax near '-'. (Client: '0010', Object: Ah_idnr='10116008'/Otyp='SCRI'/Name='PCK.AUTOMIC_UTF-8.MIG-STEP02.CHECK.TABLESPACE.DST', Line: '0002, Variable: '')'

 

Environment

UTF8 Migration Pack 1.0.8 and lower

Cause

Product defect

Resolution

This is defect that is planned to be fixed in a future release of the Migration workflow.

 

Workaround:

-Add the lines below within the Process tab of the  workflow PCK.AUTOMIC_UTF-8-MIG.START

1)

Lines to be added:
:    rset &sourcedb# = '[&sourcedb#]'
:    rset &sourcedb_mq# =  '[&sourcedb_mq#]'

2) 

Line to be added:

:    rset &sourcedb# = '[&sourcedb#]'

 

3) 

Line to be added:

:    rset &sourcedb_mq# =  'UC4_SOURCE.[&sourcedb_mq#]'


Then, execute the migration workflow.

Additional Information

The internal defect id is DE178415.