java.sql.SQLException: ORA-20168: SubVars/EnvVars cannot start with a number "Sub Var "#1""

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

The following error is seen in Applications Manager

ErrorMsg: AwE-5102 Agent error
Details: APPWORX
java.sql.SQLException: ORA-20168: SubVars/EnvVars cannot start with a number "Sub Var "#1""

Environment

Release : 9.4.x

Cause

Applications Manager uses #1, #2, #3, .. , .. for passing Process Flow prompt to components as described in the documentation below:

Passing Values Through a Process Flow with Numeric Subvars

Due to this feature, User created subvars with names such as #1 or #2 is not allowed. Doing so will result in documented error.

By default, when creating a new Substitution Variable, Applications Manager will not allow a number character to be the first character of the Substitution Variable name.

Resolution

Locate object that is referencing #1, #2, .. , etc, and rename or delete the object name, or edit the configuration.