JD Edwards

From Objectif Client Inc
(Redirected from JdEdwards)
Jump to navigation Jump to search

Deployment Server

Prerequisites

  1. Remove/Disable Ipv6
  2. Use 7-Zip to decompress zip file (Not windows)
  3. Use a short path like c:\jdedep\disk to decompress installation file
  4. Stop firewall
  5. Stop antivirus (windows defender)


Oracle Client 32 bit

From Oracle Edelivery

  1. Search Oracle Database Client 12.1.0.2.0
  2. Select palteform Microsoft Windows x64 (64Bits)
  3. Accept terms
  4. Download windows (32-bit) version V47124-01.zip file


Local Database

From Oracle Edelivery

  1. Download
  2. Run Install ServerManager
  3. Reboot


Deployment Server Installation

From Oracle Edelivery

  1. Rename import and export program (impdp.exe, expdp.exe)
    1. cd <32-bit_db_client_install_dir>\bin (D:\app\E1Local\product\12.1.0\client_1\BIN)
    2. Rename impdp.exe impdp.exe.bak
    3. Rename expdp.exe expdp.exe.bak
    4. Check the PATH Oracle32 must be in first position
  2. Install Deployment Server
    1. Copy tnsnames.ora from\\<deployment server name>\<release>\client to <32-bit Oracle Client Install Dir>\network\admin
    2. Install under d: drive


Create and Deploy Installation Plan

  1. Create Installation plan
    1. System Administration Tools -> System Installation Tools -> Typical Installation Plan
  2. Deploy Installation plan
    1. System Administration Tools -> System Installation Tools -> Installation WorkBench


Security

  1. Create System User
    1. Connect in DV920 (not JDEPLAN)
    2. System Administration Tools -> System Administration Tools -> Security Maintenance -> User Security
    3. Exit Row -> Form -> Add System User
    4. Click + Add System user: JDE Data Source: DEFAULT
  2. Create a User (copy of JDE)
    1. System Administration Tools -> System Administration Tools -> User Management -> User Profiles
    2. Select JDE And click on copy
  3. Change User password
    1. System Administration Tools -> System Administration Tools -> Security Maintenance -> Administrative Password Revision
    2. Select User id and enter password
  4. Warning
    1. If have added a user with the "User Security" (P98OWSEC) program before adding the system user with the "Add System User" (P980001) program, the system add an invalid record to the F98OWPU table.
    2. You have to delete records from F98OWPU and F98WSEC manually with a SQL Query tool.


Change Log Directory

1 Change Deployment Server Log Directory C:\Windows\jde.ini

[DEBUG]
...
;DebugFile=c:\jdedebug.log
DebugFile=D:\JDEdwards\E920_1\logs\DebugFile\jdedebug.log
;JobFile=c:\jde.log
JobFile=D:\JDEdwards\E920_1\logs\JobFile\jde.log

2 Change Deployment server JAS Log Directory D:\JDEdwards\E920_1\system\Classes\jdelog.properties

[E1LOG]
#FILE=\\jderoot.log
FILE=D:\JDEdwards\E920_1\logs\jderoot\jderoot.log
...
[LOG1]
#FILE=\\jas.log
FILE=D:\JDEdwards\E920_1\logs\Jas\jas.log
...
#[LOG2]
#FILE=\\jasdebug.log
#FILE=D:\JDEdwards\E920_1\logs\JasDebug\jasdebug.log

3 Change Enterprise Server Log Directory D:\JDEdwardsPPack\E920_1\system\bin32\jde.ini

[DEBUG]
...
;DebugFile=D:\JDEdwardsPPack\E920_1\log\jdedebug.log
DebugFile=D:\JDEdwardsPPack\E920_1\logs\DebugFile\jdedebug.log
;JobFile=D:\JDEdwardsPPack\E920_1\log\jde.log
JobFile=D:\JDEdwardsPPack\E920_1\logs\JobFile\jde.log
;JDETSFile=D:\JDEdwardsPPack\E920_1\log\JDETS.log
JDETSFile=D:\JDEdwardsPPack\E920_1\logs\JDETSFile\JDETS.log


Change JDENET Port

Change JAS Deployment JDENET Port D:\JDEdwards\E920_1\system\JAS\webclient.ear\webclient.war\WEB-INF\classes\jas.ini

[JDENET]
# Enterprise Server JDENET port 
;serviceNameConnect=6016
serviceNameConnect=6017


Change Server Security

1 Change Deployment Server Security C:\Windows\jde.ini

[DSPWD]
JDE=MyPassword
...
[SECURITY]
;SecurityServer=
SecurityServer=vmentsvr

2 Change Enterprise Server Security D:\JDEdwardsPPack\E920_1\system\bin32\jde.ini

[DB SYSTEM SETTINGS]
...
Default User=JDE
;Default Pwd=JDE
Default Pwd=MyPassword

[SECURITY]
...
;SecurityServer=
SecurityServer=vmentsvr
ServerPswdFile=true
User=JDE
;Password=JDE
Password=MyPassword

[WORKFLOW]
;WRIPassword=JDE
WRIPassword=MyPassword

3 Change JAS Deployment Server Security D:\JDEdwards\E920_1\system\JAS\webclient.ear\webclient.war\WEB-INF\classes\jas.ini

[SECURITY]
DataSource=System - 920
;SecurityServer=
SecurityServer=vmentsvr

4 Change Jdbj Deployment Server Security D:\JDEdwards\E920_1\system\JAS\webclient.ear\webclient.war\WEB-INF\classes\jdbj.ini

[JDBj-BOOTSTRAP SESSION]
user=JDE
;password=
password=Mypassword
environment=JDEPLAN
role=*ALL

5 Restart Service Windows JDE E920 B9 Network


Change Compile parameters

1 Change Deployment Compilator parameters C:\Windows\jde.ini

;STDLIBDIR=$(COMP)\VC98\lib
TPLNAME=EXEFORM2
ERRNAME=CGERR
TARGET=OPTIMIZE
;INCLUDES=$(COMP)\VC98\include;$(SYSTEM)\include;$(SYSTEM)\cg;$(APP)\include;$(SYSTEM)\includev
;LIBS=$(COMP)\VC98\lib;$(SYSTEM)\lib32;$(APP)\lib32;$(SYSTEM)\libv32
;MAKEDIR=$(COMP)\VC98\bin;$(COMP)\Common\MSDev98\Bin

INCLUDES=C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\include;C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\atlmfc\include;C:\Program Files (x86)\Windows Kits\8.1\Include\um;C:\Program Files (x86)\Windows Kits\8.1\Include\shared;$(SYSTEM)\INCLUDE;$(SYSTEM)\INCLUDEV;$(SYSTEM)\CG;$(APP)\INCLUDE
LIBS=C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\lib;C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\atlmfc\lib;C:\Program Files (x86)\Windows Kits\8.1\Lib\winv6.3\um\x86;$(SYSTEM)\LIB32;$(SYSTEM)\LIBV32;$(APP)\LIB32
MAKEDIR=C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\Tools;C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\bin;C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE;C:\Program Files (x86)\Windows Kits\8.1\bin\x86
STDLIBDIR=C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\lib;C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\atlmfc\lib;C:\Program Files (x86)\Windows Kits\8.1\Lib\winv6.3\um\x86
CLASSPATH=C:\JDEdwards\E920_1\system\Classes\xalan.jar;C:\JDEdwards\E920_1\system\Classes\xerces.jar;C:\JDEdwards\E920_1\system\Classes\kernel.jar;C:\JDEdwards\E920_1\system\Classes\XTS.jar;C:\JDEdwards\E920_1\system\Classes\log4j.jar;C:\JDEdwards\E920_1\system\Classes

;USER=JDE
VisualStudioVersion=2013
SimultaneousBuild=4


Manage Media Queue

  1. In order to shutdown the deployment server
  2. Copy directory Deployment Server Directory D:\JDEdwards\E920_1\mediaobj to Enterprise Server D:\E920\mediaobj
  3. Create directory on Enterprise Server D:\E920\PrintQueue
  4. Copy Deployment server D:\JDEdwards\E920_1\SolutionExplorer into Enterprise server D:\E920\SolutionExplorer
  5. Create a share on the enterprise server E920 on D:\JDEdwards\E920_1
  6. System Administration Tools -> System Administration Tools -> Media Object Queues


Manage Local Database E1Local

  1. Change the database to activate archive log (not mandatory but better to recuperate from a crash)
  • ShutDown database, restart in mount mode, change mode, open database
  • D:\oracle\E1Local\BIN\sqlplus.exe /nolog
connect / as sysdba
archive log list
shutdown
startup mount
alter system set log_archive_dest_1='LOCATION=d:/oracle/E1Local/RDBMS/arch' scope = both;
alter database archivelog;
alter database open;
  1. Limit the numbers of archived Log
  • Run Rman, change configuration, remove archived log
  • D:\oracle\E1Local\BIN\rman.exe target=/
configure archivelog deletion policy to backed up 1 times to disk;
configure channel device type disk format 'D:/oracle/backup/E1Local/database/ora_T%t_S%s_P%p' maxpiecesize 2 G ;
backup database plus archivelog;
delete archivelog until time 'SYSDATE-1';


Jdeveloper

From Oracle Edelivery

  1. Install 32bits jdk 1.7 to directory D:\Java32\jdk1.7.0_80
  2. Download Jdeveloper Studio Edition 12.1.3.0.0 Generic (Size: 1.8GB) (not windows 64 and not Linux 64)
    1. jdev_suite_121300.jar
  3. Install Jdeveloper
    1. D:\Java32\jdk1.7.0_80\bin\java.exe -jar jdev_suite_121300.jar
    2. Installation location: D:\Jdev1213\Oracle_Home
    3. Update jde.ini
[MTR VALIDATION]
BusobjInMB=350
CDiskInMB=200
DeployDiskInMB=5000
NMakeVersion=6.00.8168.0
MDACVersion=2.60.6526.2
LiteRecords=12
JDeveloperVersion=12.1.3
JDeveloperInstallPath=D:\Jdev1213\Oracle_Home
WebSphereVersion=6.1
BuildForJAXWSWLS=1
BuildForJAXWSWAS=0
  1. Run P9603
  2. In Own
    1. Test a Build
      1. Check Out
        1. JP000006
        2. J0000120
        3. J0000130
        4. J0100010
        5. J0000010
        6. J0900010
      2. Go to design JP000006
      3. Invoke jdeveloper
      4. "confirm Import preferences" No
      5. Initialise E1 Workspaces
      6. Expend JP000006 until to see BusinessUnitManager.java
      7. Right click and Rebuild
    2. Validate Check In
      1. Select JP000006
      2. Check in


ServerManager

From Oracle Edelivery

  1. Install Weblogic
  2. Install ServerManager
  3. Upload jdbc drivers et software into ServerManager
  4. Install Agent Management on Enterprise and Deployment
  5. Record Existing Deployment server
  6. Record Existing Enterprise Server
  7. Distribute Software and Jdbc drivers
  8. Record Enterprise Weblogic Html Enterprise Server
  9. Record Html servers and other type of server
  10. Create group web_admins
  11. Assign permission viewGroupMembers and webProductInstance
  12. Grant web-admin to JDE
  13. Validate that all machine /instance declared can be ping from all servers Entreprise and Deployment
  14. Read Doc BSSV: Getting Started with setting up and running E1 Business Services with WebLogic Server (WLS) (Doc ID 2167546.2)
  15. Read Doc BSSV: How To Deploy Business Service Package (Doc ID 1313435.1)


Bssv Server

  • E1 Client jde.ini JAX-WS JDeveloper 12c
[MTR VALIDATION]
BusobjInMB=350
CDiskInMB=200
DeployDiskInMB=5000
NMakeVersion=6.00.8168.0
MDACVersion=2.60.6526.2
LiteRecords=12
JDeveloperVersion=12.1.3
JDeveloperInstallPath=D:\JDEV1213\Oracle_Home (Right before "jdeveloper" FOLDER)
MigrateOAStoWls=0
WeblogicHomepath=
BuildForJAXWSWLS=1
BuildForJAXWSWAS=0
WebSphereInstallPath=
  • E1 Deployment misc folder
C:\JDEdwards\E920_1\MISC\ojdbc7.jar
                         sqljdbc4.jar
  • or E1 Client misc folder
C:\E920_1\MISC\ojdbc7.jar
               sqljdbc4.jar
  • jdeinterop.ini in ini\sbf folder 'D:\JDEdwards\E920_1\DV920\ini\sbf' or 'D:\E920_1\DV920\ini\sbf'
[SERVER]
glossaryTextServer=VMENT921SVR:6017  Where VMENT921SVR is the E1 Server and 6017 is the E1 port (as stated in the E1 Client jde.ini [JDENET] section)

codePage=1252

[JDENET]
serviceNameListen=6667
serviceNameConnect=6017              E1 port as is stated in the [JDENET] of E1 Client jde.ini
enterpriseServerTimeout=90000
maxPoolSize=30
maxKernelRanges=1
.....
#==========================================================
# Define the features for inbound Business Function call
#==========================================================
[INTEROP]
enterpriseServer=VMENT921SVR          Where VMENT921SVR is the E1 Server
port=6017
manual_timeout=30000000
Repository=c:\connector\repository
....
#==========================================================
# Security Server. Security server port is in [JDENET]
#==========================================================
[SECURITY]
NumServers=1
SecurityServer=VMENT921SVR      Where VMENT921SVR is the E1 Security Server

#==========================================================
# OCMEnabled--It will enforce Connector to use OCM to find
# enterprise server or use setting in [Interop]section.
#==========================================================
[OCM]
OCMEnabled=true

[TRANSACTIONS]
ReapInterval=5
MaxAge=10

[WEB DEVELOPMENT]
WebDevelopment=TRUE            This must be set to 'true' 
  • P9603
  1. Select WLS (Weblogic Server)
  2. Select a Pathcode
  3. Jdeveloper Install Path should be automatically populated when clicking on it 'D:\Jdev1213\Oracle_Home'
  4. Click Close after Business Service Operation list appears
  • OMW
Add the JDeveloper install path in OMW:
- In OMW, add a Business Service object JPR01000 to a project.
- Highlight the object (JPR01000).
- Click on 'Start Design Tools' tab
- Click the 'JDeveloper Install Path' icon to enter the JDeveloper 12g install path.
- Import "No"
- Initialize EOne Workspace under Tools menu
- Expande until RI_AddressBookManager
- Close


Structure

  1. Java32 : Jdk1.7.0_80
  2. jde_home_1: server Manager directory
  3. jde_home_2: Agent directory for this deployment server
  4. JDEdwards : Jd Edwards install directory
  5. jdev123: JDeveloper Studio 12.3 (32Bits)
  6. oracle:
    1. E1Local: E1Local Database Engine
    2. oradata: E1Local Database File
    3. middleware:
      1. Oracle_Home: Weblogic directory

Enterprise Server

Manage JDE920 Database

  1. Open Ms sql Management Studio
  2. Right click on JDE920 database
  3. Click on properties
  4. Click on file
  5. Add another file as Rows Data unlimited

Cheat Sheet

Start-Stop WebLogic

On the Enterprise Server

  • Start WebLogic
C:\Oracle\Middleware\weblogic\domains\base_domain\startWebLogic.cmd
  • Start NodeManager
C:\Oracle\Middleware\weblogic\domains\base_domain\bin\startNodeManager.cmd

On the deployment server

  • Start WebLogic
C:\Oracle\Middleware\weblogic\domains\base_domain\startWebLogic.cmd
  • Start NodeManager
C:\Oracle\Middleware\weblogic\domains\base_domain\bin\startNodeManager.cmd


Re-Generate F98780R / F98780H

On the enterprise database server

  • Backup JDE920.SY920.F00942T
  • Remove the record corresponding at the environment
  • Or change the value of EMDBSRCFLG to 0


Major Table

  1. OMW
    1. JDE920.OL920.F9860 object Header
    2. JDE920.OL920.F9861 Object Path code

Ports


Error Handling

Cannot connet to E1Local

Symptome

  1. Object Dispear during checkout

Cause

  1. Unkwnoned

Resolution

  1. Copy tnsnames.ora
    1. From Database Installation D:\oracle\E1Local\NETWORK\ADMIN
    2. To oracle 32 Client : D:\app\E1Local\product\12.1.0\client_1\network\admin


OMW Object Manager Workbench

Symptome

  1. Error on the right panel: Page can't be displayed

Resolution

  1. Setup Media Object Queue (P98MOQUE)
    1. Setup Queue name ObjectManagement
  2. Change processing options under "process Tab"
    1. Media Object Queue Name for Web Page: ObjectManagement
    2. Html File Name in Queue or URL Address: object_management_workbench.htm

Other

  1. Gray Object Button with Check Mark: Another project holds the token for this object.
  2. Colored Object Button (not gray): The project that contains the object holds the token for this object.
  3. Colored Object Button with Check Mark (not gray): The project that contains the object holds the token for the object, and the object is checked out.
  4. Gray Object Button: This object is not checked out and no project currently holds the object for the token.
  1. Non-Object Librarian Object buttons do not vary in appearance.
  1. Objects to be deleted are marked in bold in this window.

Symptome

  1. Object Dispear during checkout

Cause

  1. Unkwnoned

Resolution

  1. Update table OL920.F9861


Syumptome

  1. Cannot Check out object

Cause

  1. Technical issue during a Checkin or Checkout

Resolution=

  1. Remove object from F98780R and F98780H

Jdeveloper

  • JD Edwards EnterpriseOne Tools Release 9.1 Update 4 introduces JDeveloper 12c for developing JAX-WS business services.
  • With JDeveloper 12c, extensions and plugins are not loaded during JDeveloper startup.
  • Plugins and extensions are loaded in JDeveloper 12c only when you use a feature provided by the extension.
  • For loading EnterpriseOne development extensions on JDeveloper 12c, select the option Initialize E1 Workspace under the Tools menu after launching JDeveloper 12c from OMW.

Error Writing JDBJ.INI

  • Copy jdbj.ini inside each path code directory / ini/sbf/

WebLogic Reset Password

  • To b documented

FireFox Weblogic Security Access Issue

Symptome

  • The page cannot be accessed because of a security issue

Resolution

  1. Increase key strength of WLS certificates to 1024 bits:
  2. Open firefox browser and type ‘about:config’ in URL field
  3. Search for ‘security.ssl3.dhe_rsa_aes_128_sha’ and ‘security.ssl3.dhe_rsa_aes_256_sha’
  4. Double click (Toggle) on ‘security.ssl3.dhe_rsa_aes_128_sha’ and ‘security.ssl3.dhe_rsa_aes_256_sha’ so that their value gets changed to ‘false’
  5. Close the firefox and open new firefox window
  6. Access OEM Weblogic Admin Server Console

JD Edwards Fat Client Installation Issues

Symptoms:1

  • INFO: No installable E1 packages were found. Contact your system administrator.

Cause:1

  • The oraparam.ini file on Deployment Server had an incorrect entry for package_inf. folder path i.e.
[FileLocations]
PackageInfs=\package_inf
CurrentReleaseMasterPath=\\SERVER\E920

Solution: 1

  • To fix the issue, it was corrected to this :
[FileLocations]
PackageInfs=\\DEPLOYMENTSERVER\E920\package_inf
CurrentReleaseMasterPath=\\DEPLOYMENT\E920

Bssv

Test

WebLogic Jax-ws

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:orac="http://oracle.e1.bssv.JP010000/">
<soapenv:Header> 
   <wsse:Security xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" 
     xmlns="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" 
     xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" 
     soapenv:mustUnderstand="1">
     <wsse:UsernameToken xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" 
       xmlns="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
       <wsse:Username>JDE</wsse:Username>   
       <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">password</wsse:Password>  
     </wsse:UsernameToken>
   </wsse:Security>
 </soapenv:Header>
   <soapenv:Body>
      <orac:getAddressBook>
         <entity>
            <entityId>50</entityId>
         </entity>
      </orac:getAddressBook>
   </soapenv:Body>
</soapenv:Envelope>

WebLogic Jax-Rpc (old)

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:orac="http://oracle.e1.bssv.JP010000/" xmlns:java="java:oracle.e1.bssv.JP010000.valueobject" xmlns:java1="java:oracle.e1.bssv.util.J0100010.valueobject">
<soapenv:Header> 
   <wsse:Security xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" 
     xmlns="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" 
     xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" 
     soapenv:mustUnderstand="1">
     <wsse:UsernameToken xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" 
       xmlns="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
       <wsse:Username>JDE</wsse:Username>   
       <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">password</wsse:Password>  
     </wsse:UsernameToken>
   </wsse:Security>
 </soapenv:Header>
   <soapenv:Body>
      <orac:getAddressBookElement>
         <java:Entity>
            <java1:EntityId>1</java1:EntityId>
         </java:Entity>
      </orac:getAddressBookElement>
   </soapenv:Body>
</soapenv:Envelope>