After upgrading the JDE solution from Applciations Manager V8.0 to V9.0 JDE jobs abort.

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

After upgrading the JDE solution from Applciations Manager V8.0 to V9.0 JDE jobs abort.

Environment

Release: AAMORS99000-9.0-Automic Applications Manager-Oracle - RMS
Component:

Resolution

Symptoms

After upgrading the JDE solution from Applciations Manager V8.0 to V9.0 JDE jobs abort.

---

Cause

The JDE database uses NCHAR datatype for some columns. The older jdbc driver for AM implicitly converted these to char/varchar2. The latest jdbc driver does not.

---

Resolution

To fix this, explicitly convert NCHAR columns using TO_CHAR in the awserver_sqlusr.dat.

 

 

 

For example:

 

7015 JDE_CHK_STATUS2 SELECT 10000 0 OBD_CLS_COM_SUB_CONT NULL FETCH_ROW

 

arg_1,arg_2,arg_3,arg_4,arg_5 #result #

 

select to_char(decode(substr(to_char(jcjobsts),1,1),'D',32,'E',102,-1))||' '||

 

decode(substr(to_char(jcjobsts),1,1),'D','J-Done',

 

'E','J-Error',

 

'H','J-Hold',

 

'P','J-Processing',

 

'S','J-InQueue',

 

'W','J-Waiting','N/A')

  

||' '||to_char(jcjobnbr)

 

||' '||to_char(jcfndfuf2)

 

||' '||to_char(jcprocessid)

 

||' '||to_char(jcexehost) result

 

 

from {arg_1}

 

where to_char(jcfndfuf2) like substr(:arg_2||'_'||:arg_3,1,17)||'%'

 

and jcjobnbr > to_number(:arg_4)

 

and jcjobnbr <= to_number(:arg_5)

 

and not exists

 

(select 1 from so_job_queue

 

where to_char(jcjobnbr) = so_ref1)

 

order by jcsbmdate desc, jcsbmtime desc