SQL object script has fatal errors

book

Article ID: 197505

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation CA Automic Operations Manager CA Automic Oracle

Issue/Introduction

Error Behavior:  SQL statement completely changes before and after the saving.

Steps to reproduce the issue :

1. Create a object for JOB SQL

2 .Write the below SQL in pre-process:

SQL_SET_STATEMENT_TERMINATOR [email protected];
select * from dual;

3.Then save the Object.

4.Now when the object is opened again, you will see the below statement (which cannot be executed by SQL Agent)

select * from dual;
SQL_SET_STATEMENT_TERMINATOR [email protected];

Cause

Bug

Environment

Release : 12.3.1 and 12.3.2

Component : AUTOMATION ENGINE

Resolution

Resolution: Upgrade to the below  fixed version to resolve the issue.

Version: Automic Web Interface 12.3.3