The GSO Solution for submitting jobs to JD Edwards uses the 2 methods JD Edwards allows for ‘batch’ scheduling.

Document ID : KB000088434
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
The GSO Solution for submitting jobs to JD Edwards uses the 2 methods JD Edwards allows for ‘batch’ scheduling.
Resolution:
When submitting jobs using ‘runubexml’ from Automic, a JD Edwards jobid is returned by the process, so Automic can track and manage the submitted job. When customers are submitting jobs using the JD Edwards ‘runube’ command, a jobid is not returned from JD Edwards and the solution has to query the F986110 table. The solution selects the max JD Edwards jobid from the F986110 table and look for jobs greater than that JD Edwards jobid returned and then the solution uses the jobs and prompts to locate the submitted jobs and it’s corresponding JD Edwards jobid. This has always been a limitation when using JD Edwards tool set version 9.1.4 and lower.

JD Edwards tool set 9.1.5 has a change to the jcfndfuf2 column in the F986110 table.

This is what was stored in the column prior to version JD Edwards tool set version 9.1.5.
<report>_<version>_<number>_PDF
  R03B221_ZJDE0001_402_PDF
This has the problem of truncating the version when the JD Edwards jobid number gets too big.
Example:
R0006P_XJDE0001_100000001_PDF
R0006P_XJDE000_1000000001_PDF <-the version> is truncated and match is not found to extract the JD Edwards jobid
So when a search is performed for the combination of ‘report’ and ‘version’, no rows are returned because the field (version) is truncated.

Tool set 9.1.5 fixes the truncation of the version in the jcfndfuf2 column.
Now it just stores the report and the version in this new column and does not truncate any values
<report>_<version>
R03B221_ZJDE0001

This makes looking up the JD Edwards number in the F986110 table easier/better because they do not need to truncate the version now.

*** Customers must send us the exec/jde* scripts for Automic to review
*** Customers must send the data/awserver_sqlusr.dat for Automic to review