CA Automic V12 - Alternative MS SQL DB Schema cannot handle databases with '.' in the name

Article Id: 104950

Status: Published

Updated On: 14-08-2018 09:23

Products:

CA Automic Workload Automation - Automation Engine , AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction:

Integrating an Alternative MS SQL Server DB Schema for CA Automic V12.1 doesn’t work in case the database name contains a dot “.”

For example: Database is named Automic_12.1, which works in general.
When setting up a separate MQ database, the mqdb_ddl.sql fails with:

U00003590 UCUDB - DB error: 'SQLExecDirect', 'ERROR ', '42000', 'Incorrect syntax near '.1'.'

Cause:

The reason is that "mqdb_ddl.sql" cannot handle db names with '.'

Environment:

Release:
Component: AAUTEN

Resolution:

Workaround:
Please do not use dots in your database name

The bug was fixed in the following versions:

Component:
Automation Engine

Automation.Engine 12.2.0 - available for download
Automation.Engine 12.1.2 - available for download