Monday, February 17, 2025

JDE Web Package Build

 

Application 9.2

Tools Release 9.2.5.x

Verify Tools Planner ESU, Tools ESU and Tools ASI is completed

Three new applications have been delivered, off of menu GH9083, for the web client:

  • P9601W - Package Assembly
  • P9621W - Package Definition
  • P9631W - Package Deployment


Configure Deployment Server INI

[INSTALL]

ClientType=deployment

[JDENET_KERNEL_DEF11]
KrnlName=PACKAGE BUILD KERNEL
dispatchDLLName=jdekrnl.dll
dispatchDLLFunction=_JDEK_DispatchPkgBuildMessage@28
MaxNumberOfProcesses=1
numberOfAutoStartProcesses=1

 

Also, make sure the following matches the content in the jde.ini on the Enterprise Server:

[SECURITY]
SecurityServer=xxxxxxx
User=JDE
Password=xxxxxxxx
DefaultEnvironment=DV920

[JDENET]
serviceNameListen=6017
serviceNameConnect=6017


Start and Stop Deployment Server service - JDE B9 Client Network

Set Service to Start Automatic 

Use Application P9601W to Package Assembly,followed by Define and deployment....

Friday, February 7, 2025

JDE Check-In Process Based on Tool Release

 



Tools Prior to 9.2.1


Specs - > From Dev Workstation to Central Objects (F987*) Table

Artifacts - > From Dev WorkStation source, include, java, res copied  to Deployment Server pathcode folder







Tools 9.2.1. to 9.2.4.x



Tools 9.2.1.x -> 
Specs -> From Dev Workstation to Central Objects (F987*) Table
Artifacts - > From Dev WorkStation source, include, java, res copied  to Deployment Server pathcode folder
Artifacts - > From Dev WorkStation source, include, java, res copied  to Repository F98780R and F98780H


Tools 9.2.3.x - >  
Specs -> From Dev Workstation to Central Objects (F987*) Table
Artifacts - > From Dev WorkStation source, include, java, res copied  to Deployment Server pathcode folder
Artifacts - > From Dev WorkStation source, include, java, res copied  to Repository F98780R and F98780R. 

NER and TER Artifacts not copied to Deployment Server and Repository. 

BSFN Artifacts continue copied to Deployment Server Pathcode folder
BSFN Artifacts are copied to Repository F98780R and F98780H
NER and TER Artifacts (.c and .h) are created at build time.



Tools 9.2.4.x -> 
Specs -> From Dev Workstation to Central Objects (F987*) Table
Artifacts - > From Dev WorkStation source, include, java, res copied  to Repository F98780R and F98780H. 

BSFN, NER and TER Artifacts not copied to Deployment Server.  

NER and TER Artifacts are not copied to Repository F98780R and F98780R. 
BSFN Artifacts are copied to Repository F98780R and F98780R. 
NER and TER Artifacts (.c and .h) are created at build time.






Tools 9.2.5.x or higher


E1Local Database is removed

Specs - Copied from the User Spec Tables (F98xxxUS) to the Central Objects (F987xxx) Check-in location tables.
Artifacts -> From Dev WorkStation source, include, java, res copied  to Repository F98780R and F98780H







Thursday, January 23, 2025

JDE Submitted Job Execution Performance


Jobs in JDE Need to be evaluate for performance. Below Query will give Minimum, Average and Maximum Runtime of Jobs 


 --- SQL Query to find Execution Time in Minute 

 SELECT JCJOBNBR,JCPID,JCVERS,JCSTDTIM,JCETDTIM,DATEDIFF(MINUTE,JCSTDTIM,JCETDTIM) AS EXECUTION_MINUTE INTO SVM920.F986114_EXECUTION FROM SVM920.F986114 WHERE JCENHV LIKE '%PD920%' AND JCJOBSTS='D' AND DATEDIFF(MINUTE,JCSTDTIM,JCETDTIM) >0 ORDER BY JCPID,JCVERS,EXECUTION_MINUTE DESC


 --Create Table based on above Select Query 

 SELECT JCJOBNBR,JCPID,JCVERS,JCSTDTIM,JCETDTIM,DATEDIFF(MINUTE,JCSTDTIM,JCETDTIM) AS EXECUTION_MINUTE FROM SVM920.F986114 WHERE JCENHV LIKE '%PD920%' AND JCJOBSTS='D' AND DATEDIFF(MINUTE,JCSTDTIM,JCETDTIM) >0 ORDER BY JCPID,JCVERS,EXECUTION_MINUTE DESC



 -- Finally Find Minimum, Average and Maximum Time for Job to complete 

 SELECT JCJOBNBR, JCPID, JCVERS, MIN(EXECUTION_MINUTE) AS MINIMUM,AVG(EXECUTION_MINUTE) AS AVERAGE,MAX(EXECUTION_MINUTE) AS MAXIMUM FROM SVM920.F986114_EXECUTION GROUP BY JCPID,JCVERS