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 'f:/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
Linux Notes
[Jd Edwards Linux Enterprise]
Oracle Setup
- To enable remote connections for your Oracle database
Edit the init.ora file, and set the remote condition by adding this line:
REMOTE_LOGIN_PASSWORDFILE=SHARED
After Install
Create Table
- with OMW crete the following table
F989999 : Java Persistent Objects in Central Objects - PY910 F986020 : Business Service Temporary Artifacts F686030 : Business Service Temporary Published Methods
Error
ELFCLASS64
libclntsh.so.11.1: wrong ELF Class: ELFCLASS64: No such file or directory
- Create directory lib32 inside ORACLE_HOME (/u1/app/oracle/product/11.2.0/db_home)
- Download Oracle Client 32bit Linux
- Copy libclntsh.so.11.1 and libnnz11.so into lib32
- Validate the path of jde910 (echo $PATH)
Enterprise Install
Name:JDE_PPack910_Home_1Path:
/u01/jdedwardsppack/e910_1
Error
Linux 6 (oracle) ..jre/lib/i386/xawt/libmawt.so: libXext.so.6: cannot open shared object file: No such file or directory -> Install LibXext-1.3.2-2.1.el6.i686 yum install
..jre/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory -> Install LibXtst-1.2.2-2.1.el6.i686 yum install
Cheat Sheet
Start-Stop
- Start Listner: under oracle profile:
lsnrctl start
- Start Dabase: under oracle profile:
sqlplus /nolog SQL> connect sys/admin as sysdba; SQL> startup;
- Start Oracle Enterprise Manager
emctl start dbconsole
- Start Jde: under jde910
RunOneWorld
or
/u01/jdedwardsppack/e910_1/system/bin32/RunOneWorld.sh
- Start Weblogic under oracle profile
/u01/app/oracle/Middleware/Weblogic/user_projects/domains/base_domain/startWebLogic.sh
- Start Node Manager
/u01/app/oracle/Middleware/Weblogic/user_projects/domains/base_domain/bin/startNodeManager.sh
or
/u01/app/weblogic/wlserver_10.3/server/bin/startNodeManager.sh
- Start Managed WebLogic Server
/u01/app/oracle/Middleware/Weblogic/user_projects/domains/base_domain/bin/startManagedWebLogic.sh Jde-PS
- Start Agent
/u01/app/agent_1/SCFHA/bin/startAgent
Windows Setup
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
Cheat Sheet
Start-Stop
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
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
OMW Object Manager Workbench
- Error on the right panel: Page can't be displayed
- 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
- 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.
Jdeveloper
D 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.
Web Logic Setup
Reset Password
FireFox Issue
- 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
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>