Dynamic Subvars With Comments

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