RA JDE jobs fail with: errorCode 942 SQLState 42000 ORA-00942: table or view does not exist

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

All RA JDE jobs fail with the following error:

pool-1-thread-2: DBCall: isConnectError errorCode 942 SQLState 42000 ORA-00942: table or view does not exist

 

Environment

Release : 2.1.1

Component : RA JD EDWARDS

Cause

Configuration.

Resolution

The RunNumber SQL statement does not take the prefix defined on the JDE agent in client 0 in account:

select CAST(jcjobnbr AS VARCHAR(25)) as runID from F986111 where upper(rtrim(jcexehost))=?

The SQL statement should be:

select CAST(jcjobnbr AS VARCHAR(25)) as runID from JDV920.F986111 where upper(rtrim(jcexehost))=?

Click on the SQL statement tab and add the prefix to the SQL statement.