JD Edwards
Deployment Server
Prerequisites
- Remove/Disable Ipv6
- Use 7-Zip to decompress zip file (Not windows)
- Use a short path like c:\jdedep\disk to decompress installation file
- Stop firewall
- Stop antivirus (windows defender)
Oracle Client 32 bit
From Oracle Edelivery
- Search Oracle Database Client 12.1.0.2.0
- Select palteform Microsoft Windows x64 (64Bits)
- Accept terms
- Download windows (32-bit) version V47124-01.zip file
Local Database
From Oracle Edelivery
- Download
- Run Install ServerManager
- Reboot
Deployment Server Installation
From Oracle Edelivery
- Rename import and export program (impdp.exe, expdp.exe)
- cd <32-bit_db_client_install_dir>\bin (D:\app\E1Local\product\12.1.0\client_1\BIN)
- Rename impdp.exe impdp.exe.bak
- Rename expdp.exe expdp.exe.bak
- Check the PATH Oracle32 must be in first position
- Install Deployment Server
- Copy tnsnames.ora from\\<deployment server name>\<release>\client to <32-bit Oracle Client Install Dir>\network\admin
- Install under d: drive
Create and Deploy Installation Plan
- Create Installation plan
- System Administration Tools -> System Installation Tools -> Typical Installation Plan
- Deploy Installation plan
- System Administration Tools -> System Installation Tools -> Installation WorkBench
Security
- Create System User
- Connect in DV920 (not JDEPLAN)
- System Administration Tools -> System Administration Tools -> Security Maintenance -> User Security
- Exit Row -> Form -> Add System User
- Click + Add System user: JDE Data Source: DEFAULT
- Create a User (copy of JDE)
- System Administration Tools -> System Administration Tools -> User Management -> User Profiles
- Select JDE And click on copy
- Change User password
- System Administration Tools -> System Administration Tools -> Security Maintenance -> Administrative Password Revision
- Select User id and enter password
- Warning
- 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.
- 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
- In order to shutdown the deployment server
- Copy directory Deployment Server Directory D:\JDEdwards\E920_1\mediaobj to Enterprise Server D:\E920\mediaobj
- Create directory on Enterprise Server D:\E920\PrintQueue
- Copy Deployment server D:\JDEdwards\E920_1\SolutionExplorer into Enterprise server D:\E920\SolutionExplorer
- Create a share on the enterprise server E920 on D:\JDEdwards\E920_1
- System Administration Tools -> System Administration Tools -> Media Object Queues
Manage Local Database E1Local
- 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;
- 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
- Install 32bits jdk 1.7 to directory D:\Java32\jdk1.7.0_80
- Download Jdeveloper Studio Edition 12.1.3.0.0 Generic (Size: 1.8GB) (not windows 64 and not Linux 64)
- jdev_suite_121300.jar
- Install Jdeveloper
- D:\Java32\jdk1.7.0_80\bin\java.exe -jar jdev_suite_121300.jar
- Installation location: D:\Jdev1213\Oracle_Home
- 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
- Run P9603
- In Own
- Test a Build
- Check Out
- JP000006
- J0000120
- J0000130
- J0100010
- J0000010
- J0900010
- Go to design JP000006
- Invoke jdeveloper
- "confirm Import preferences" No
- Initialise E1 Workspaces
- Expend JP000006 until to see BusinessUnitManager.java
- Right click and Rebuild
- Check Out
- Validate Check In
- Select JP000006
- Check in
- Test a Build
ServerManager
From Oracle Edelivery
- Install Weblogic
- Install ServerManager
- Upload jdbc drivers et software into ServerManager
- Install Agent Management on Enterprise and Deployment
- Record Existing Deployment server
- Record Existing Enterprise Server
- Distribute Software and Jdbc drivers
- Record Enterprise Weblogic Html Enterprise Server
- Record Html servers and other type of server
- Create group web_admins
- Assign permission viewGroupMembers and webProductInstance
- Grant web-admin to JDE
- Validate that all machine /instance declared can be ping from all servers Entreprise and Deployment
- Read Doc BSSV: Getting Started with setting up and running E1 Business Services with WebLogic Server (WLS) (Doc ID 2167546.2)
- 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
- Select WLS (Weblogic Server)
- Select a Pathcode
- Jdeveloper Install Path should be automatically populated when clicking on it 'D:\Jdev1213\Oracle_Home'
- 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
- Java32 : Jdk1.7.0_80
- jde_home_1: server Manager directory
- jde_home_2: Agent directory for this deployment server
- JDEdwards : Jd Edwards install directory
- jdev123: JDeveloper Studio 12.3 (32Bits)
- oracle:
- E1Local: E1Local Database Engine
- oradata: E1Local Database File
- middleware:
- Oracle_Home: Weblogic directory
Enterprise Server
Manage JDE920 Database
- Open Ms sql Management Studio
- Right click on JDE920 database
- Click on properties
- Click on file
- 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
- OMW
- JDE920.OL920.F9860 object Header
- JDE920.OL920.F9861 Object Path code
Ports
- Server Manager (on deployment server): [http://localhost:8999/manage] (jde_admin)
- Database Console (on Enterprise server): [https://localhost:1158/em/console]
- Oracle Database Port 1521
- Weblogic console (on Http Server): [http://localhost:7001] Secure [https://localhost:7002]
- Node Manager Port : 5556
Error Handling
Cannot connet to E1Local
Symptome
- Object Dispear during checkout
Cause
- Unkwnoned
Resolution
- Copy tnsnames.ora
- From Database Installation D:\oracle\E1Local\NETWORK\ADMIN
- To oracle 32 Client : D:\app\E1Local\product\12.1.0\client_1\network\admin
OMW Object Manager Workbench
Symptome
- Error on the right panel: Page can't be displayed
Resolution
- Setup Media Object Queue (P98MOQUE)
- Setup Queue name ObjectManagement
- Change processing options under "process Tab"
- Media Object Queue Name for Web Page: ObjectManagement
- Html File Name in Queue or URL Address: object_management_workbench.htm
Other
- Gray Object Button with Check Mark: Another project holds the token for this object.
- Colored Object Button (not gray): The project that contains the object holds the token for this object.
- 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.
- Gray Object Button: This object is not checked out and no project currently holds the object for the token.
- Non-Object Librarian Object buttons do not vary in appearance.
- Objects to be deleted are marked in bold in this window.
Symptome
- Object Dispear during checkout
Cause
- Unkwnoned
Resolution
- Update table OL920.F9861
Syumptome
- Cannot Check out object
Cause
- Technical issue during a Checkin or Checkout
Resolution=
- 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
- Increase key strength of WLS certificates to 1024 bits:
- Open firefox browser and type ‘about:config’ in URL field
- Search for ‘security.ssl3.dhe_rsa_aes_128_sha’ and ‘security.ssl3.dhe_rsa_aes_256_sha’
- 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’
- Close the firefox and open new firefox window
- 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>