Dynamic Subvars With Comments

Document ID : KB000090320
Last Modified Date : 14/04/2018
Show Technical Document Details
Dynamic Subvars With Comments
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.


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

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.