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

book

Article ID: 206176

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine 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

 

Cause

Configuration.

Environment

Release : 2.1.1

Component : RA JD EDWARDS

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.

Attachments