ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
CA Automic V12 - Alternative MS SQL DB Schema cannot handle databases with '.' in the name
book
Article ID: 104950
calendar_today
Updated On:
Products
CA Automic Workload Automation - Automation Engine
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