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];
Bug
Release : 12.3.1 and 12.3.2
Component : AUTOMATION ENGINE
Resolution: Upgrade to the below fixed version to resolve the issue.
Version: Automic Web Interface 12.3.3