Job Launch Error

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Why Job, A_AP_SFTP_WCASH_SGD_QUICK_M, going to LAUNCH ERROR status? Errors observed are :

10:40:44.482 MSM0: .AxRmiServer$1: null ErrorMsg: AwE-5102 Agent error (6/3/21 10:40 AM) 
Details: ORA-20154: Password must at least one alpha character and one number
ORA-06512: at "APPWORX.SO_USER_TABLE_TRIG", line 35
ORA-04088: error during execution of trigger 'APPWORX.SO_USER_TABLE_TRIG'
ORA-06512: at "APPWORX.AWAPI2", line 4346
ORA-06512: at "APPWORX.AWOP_API", line 732
ORA-06512: at "APPWORX.AWOP_API", line 1843

Environment

Release : 9.3

Component : APPLICATIONS MANAGER

Cause

Job Log showing

Line 180490: 15:12:37.365 rfp0: .StartDateTester: add 194487248.01 A_AP_SFTP_WCASH_SGD_QUICK_M A_AP_SFTP_WCASH_SGD_QUICK_M 2021-06-07 15:09:00.0 QUEUED 1
Line 180490: 15:12:37.365 rfp0: .StartDateTester: add 194487248.01 A_AP_SFTP_WCASH_SGD_QUICK_M A_AP_SFTP_WCASH_SGD_QUICK_M 2021-06-07 15:09:00.0 QUEUED 1 

So if the jobid 194487248 in the server log file there are:

Line 184589: 15:12:37.499 SJ1: .ResolveSubvars: resolving sub var:#WC_AP_SGQUICKREMOTE for jobid 194487248.01
Line 185351: Details: Error evaluating subvar #WC_AP_SGQUICKREMOTE for job: 194487248.01
Line 185392: Error evaluating subvar #WC_AP_SGQUICKREMOTE for job: 194487248.01

Resolution

Following suggestions will fix the problem:

1) Remove subvar from the job, save the job.

2) once done, resubmit the job.