pool-1-thread-2: DBCall: runSqlQuery: select CAST(jcjobnbr AS VARCHAR(25)) as runID from F986111 where upper(rtrim(jcexehost)) =? [JDEENTD1]

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Prefix is missing when running JDE job. For example:
pool-1-thread-2: DBCall: runSqlQuery: select CAST(jcjobnbr AS VARCHAR(25)) as runID from F986111 where upper(rtrim(jcexehost)) =? 

Resolution

1. Edit JDE agent in client 0000

2. Open JD Edwards tab

3. Under 'Table Prefix Mapping' click on the notepad icon under SQL (Jobtable cannot be changed)

4. The following window pops up. Click OK

5. Now the prefix is added via the SQL. Restart agent and the error should no longer occur