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

Document ID : KB000090584
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
After upgrading the JDE solution from Applciations Manager V8.0 to V9.0 JDE jobs abort.
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