Dynamic Subvars With Comments

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Dynamic Subvars With Comments

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Applicable toApplications Manager Versions:  v7.x, v8.0

Detailed Description and Symptoms

AwE-5001 Database Query Error Thrown by Dynamic Substitution Variables with comments

Error thrown:

ErrorMsg: AwE-5001 Database Query Error (9/30/10 7:13 PM)

Details: select so_full_pathname from appworx.so_print_log where so_jobid=47763.00 and so_full_pathname like '%rpbpell%.lis'-- note: the {jobid_47751} subvar needs to exist prior to running this subvar.

jdbc:oracle:thin:@172.31.11.18:1521:apwxdev:APPWORX

java.sql.SQLException: Non supported SQL92 token at position: 141: jobid_47751

Solution

You may run into this error if you upgraded from AppWorx 6.x and had substitution variables that had comments at the end of their sql statement.  This occurs because a difference in how Java handles special characters.  These comments (noted by the '-- <comment block>') must be removed for the subvar to process correctly.