AWI - SAP/SQL/PS Job Update changing the Job content

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Updating SAP, SQL, and PeopleSoft JOBS objects in AWI 12.3.2 is not working as expected, listing steps in incorrect order and saving incorrectly.

The Lines format is truncated, and the lines are in reverse order or upside down (the first line becomes the second line, and the end of the statement is missing) from what they should be.
Therefore, the Job is not working anymore at all.

How to reproduce (SAP):

• Create or import a SAP JOBS with the content below in the Process part :
  R3_ACTIVATE_REPORT REPORT=ZTEST_012556
  R3_GET_JOB_SPOOL PAGES=2,FILE=(REPORT,REP)
• Save the JOB
• From the "Form" view in the process Tab, change the "Pages" value (e.g 4)
• Save the JOB
• Go back in the process Tab (edition mode) : the content is upside down and some content has been removed :
  R3_GET_JOB_SPOOL FILE=(REPORT,PAGES=4          [LINE TRUNCATED]
  R3_ACTIVATE_REPORT REPORT=ZTEST_012556       [FIRST LINE BECOMES SECOND LINE]

How to reproduce with SQL JOBS:

• Create or import a SQL JOBS object with the content below in the Process part :
  select * from oh;
  SQL_GET_JOBS;
• Save the JOB
• Go to the "Form" view in the process Tab
• Notice on the right-hand side that it now shows the select statement on top and the SQL_GET_JOBS below
• Making a change and saving now will keep the job like this.

Environment

Release : 12.3

Component : AUTOMIC WEB INTERFACE

Cause

Bug detected on AWI 12.3.2

Related to the "Form" feature used in both SAP/SQL/PS Jobs.

Resolution

Workaround:

Keep or downgrade the AWI to 12.3.1

 

Solution:

Update to a fix version listed below or a newer version if available.

Fix version:

Component(s): AWI

Automic Web Interface v12.3.2 HF3 - Available

Automic Web Interface v12.3.3 - Available

WARNING: If you want to keep your Automation Engine at v12.3.2, you can decided to only upgrade your AWI to V12.3.2 HF3 to solve this issue. If you keep AE v12.3.2 and upgrade AWI to v12.3.3 you will run into a compatibility issue.

Upgrading both AE and AWI to v12.3.3 does not lead to this compatibility issue.