The UTF-8 DB Migration Action Pack is failing: SET options have incorrect settings: 'CONCAT_NULL_YIELDS

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The UTF-8 DB Migration Action Pack PCK.AUTOMIC_UTF-8.MIG.SQLI.STEP04.CREATE.TABLE.NOILM is failing with the error messag ebelow.

U00020274 Wrong SQL statement in 'PCK.AUTOMIC_UTF-8.MIG.SQLI.STEP04.CREATE.TABLE.NOILM'. DB error: 'U00003754 Database-error in SQLI-variable: 

'U00003590 UCUDB - DB error: 'SQLExecDirect', 'ERROR ', '42000', 'SELECT failed because the following SET options have incorrect settings: 'CONCAT_NULL_YIELDS'  

Environment

Product: CA Automic Workload Automation - Automation Engine v24.x

Database: MSSQL server

Cause

The DSN ODBC of the source database does not have the "Use Ansi nulls, paddings and warnings" checked.

Resolution

Please check the "Use Ansi nulls, paddings and warnings".