JDE job is failing: unable to submit job. Check that the query on table F986111 is for the correct schema.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The JDE job is failing with the error message below.

 

2022-02-14 09:30:51             pool-1-thread-4: JDEUbeJob: Entry runJob

2022-02-14 09:30:51             Mon Feb 14 09:30:51 EST 2022

2022-02-14 09:30:51             In JDE Job

2022-02-14 09:30:51             pool-1-thread-4: JDEUbeJob: Setting agent level jobServerCom

2022-02-14 09:30:51             Using agent level login JDE - (CONN.JDEDWARDSAGENT.JDEDWARDSCONNECTION.JDEBTA)

2022-02-14 09:30:51             Using login: JDE

2022-02-14 09:30:51             pool-1-thread-4: JDEUbeJob: Entry doRunUbe

2022-02-14 09:30:51             pool-1-thread-4: JDEUbeJob: jdePrintImmediate

2022-02-14 09:30:51             pool-1-thread-4: JDEUbeJob: JDE printer

2022-02-14 09:30:51             pool-1-thread-4: JDEUbeJob: get max runid

2022-02-14 09:30:51             pool-1-thread-4: JDEdwardsAgentImpl: Entry getMaxRunid

2022-02-14 09:30:51             pool-1-thread-4: JDEdwardsAgentImpl: SQL:select CAST(jcjobnbr AS VARCHAR(25)) as runID from UC4.SVM910.F986111 where upper(rtrim(jcexehost)) =?

2022-02-14 09:30:51             pool-1-thread-4: JDEdwardsAgentImpl: Get connection

2022-02-14 09:30:51             pool-1-thread-4: JDEdwardsAgentImpl: getConnection: CONN.JDEDWARDSAGENT.JDEBTA

2022-02-14 09:30:51             pool-1-thread-4: JDEdwardsAgentImpl: getConnection: from pool 0 CONN.JDEDWARDSAGENT.JDEBTA [email protected]

2022-02-14 09:30:51             pool-1-thread-4: JDEdwardsAgentImpl: Define SQL

2022-02-14 09:30:51             pool-1-thread-4: JDEdwardsAgentImpl: DB retries:3600 retry sleep:30

2022-02-14 09:30:51             pool-1-thread-4: JDEdwardsAgentImpl: Execute SQL:select CAST(jcjobnbr AS VARCHAR(25)) as runID from UC4.SVM910.F986111 where upper(rtrim(jcexehost)) =?

2022-02-14 09:30:51             pool-1-thread-4: DBCall: runSqlQuery: select CAST(jcjobnbr AS VARCHAR(25)) as runID from UC4.SVM910.F986111 where upper(rtrim(jcexehost)) =? [PRODAPP1.BROADCOM.COM]

2022-02-14 09:30:51             pool-1-thread-4: DBCall: runSqlQuery: rows 0 retry: false elapsed ms 15 select CAST(jcjobnbr AS VARCHAR(25)) as runID from UC4.SVM910.F986111 where upper(rtrim(jcexehost)) =? [PRODAPP1.BROADCOM.COM]

2022-02-14 09:30:51             pool-1-thread-4: JDEdwardsAgentImpl: Exit getMaxRunid 1

2022-02-14 09:30:51             pool-1-thread-4: JDEdwardsAgentImpl: getMappedName (entry)

2022-02-14 09:30:51             pool-1-thread-4: JDEdwardsAgentImpl: Map:[F0094:, F986111:, F986167:, F986110:, F9860:, F983051:, F986130:]

2022-02-14 09:30:51             pool-1-thread-4: JDEdwardsAgentImpl: prefix:

2022-02-14 09:30:51             pool-1-thread-4: JDEdwardsAgentImpl: Mapped table:F986111

2022-02-14 09:30:51             pool-1-thread-4: JDEdwardsAgentImpl: getMappedName (exit)

2022-02-14 09:30:51             Unable to submit job. Check that the query on table F986111 is for the correct schema. Check that the server name (prodapp1.broadcom.com) is correctly defined in the Agent panel.

 

 

Environment

Release : 12.3

Component : RA JD EDWARDS

Cause

Environmental/Configuration issue

Resolution

Troubleshooting steps:

-Make sure that the synonym of the table F986111 has been created for the user used in JDE Agent

-Make sure that the table F986111 exists in the target database in the path. Ex. UC4.SVM910.F986111

-Make sure that the target DB server name  used in the JDE Agent configuration and the server name used by the table match. For example, if the JDE Agent is configured to use the target DB with fully qualified domain name(FQDN) then the database table also needs to have the FQDN.