ORA-20997: trying to set so_module to null

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

An error message of "ORA-20997: trying to set so_module to null" can be see if the following is met:

1. A Job or component alias value contains substitution value, dynamic substitution value, or a value passed from a Process Flow such as {#1} or {#2}
2. The same Job or component is deactivated

When both of the above requirements are met, the Alias value resolves to a Null value. Applications Manager throws the ORA error because it is unable to set the Alias value to a Null value. Below is the full error message.

java.sql.SQLException: ORA-20999: Scheduling has encountered an exception - Scheduling will not continue until issue is resolved - 
[ORA-20001: Submit_chains so_sch_seq=40145-[ORA-20997: trying to set so_module to null
ORA-06512: at "APPWORX.SQLOPER_SOJOBQUEUE", line 431
ORA-04088: error during execution of trigger 'APPWORX.SQLOPER_SOJOBQUEUE']
ORA-06512: at "APPWORX.SQLOPER_SOJOBQUEUE", line 431
ORA-06512: at "APPWORX.SCHEDULING", line 808
ORA-06512: at "APPWORX.SCHEDULING", line 808
ORA-06512: at "APPWORX.SCHEDULING", line 840
ORA-06512: at "APPWORX.SCHEDULING", line 840
ORA-06512: at "APPWORX.SCHEDULING", line 840
ORA-06512: at "APPWO]
ORA-06512: at "APPWORX.AW_TIMEZONES", line 2453
ORA-06512: at "APPWORX.AW_TIMEZONES", line 2177
ORA-06512: at "APPWORX.AW5", line 2272
ORA-06512: at "APPWORX.AW5", line 2276
ORA-06512: at line 1

Environment

Component : APPLICATIONS MANAGER

Resolution

Can be resolved by one of the following:

1. Reactivate the Job or Component
2. Change the Job or Component alias value a static value