JD Edwards: Difference between revisions

Revision as of 02:40, 1 July 2017

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)
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
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

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

Security

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
Create a User (copy of JDE)
1. System Administration Tools -> System Administration Tools -> User Management -> User Profiles
2. Select JDE And click on copy
Change User password
1. System Administration Tools -> System Administration Tools -> Security Maintenance -> Administrative Password Revision
2. Select User id and enter password
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 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 Restart Service Windows JDE E920 B9 Network

Manage Local Database E1Local

Change the database to activate archive log (not mandatory but better to recuperate from a crash)
1. ShutDown database, restart in mount mode, change mode, open database
  1. to be documentated
Limit the numbers of archived Log
1. Excecute Rman, change configuration, remove archived log
  1. rman target=/
  2. configure archivelog deletion policy to backep up 1 times to disk;
  3. configure channel device type disk format 'f:/backup/E1Local/database/ora_T%t_S%s_P%p' maxpiecesize 2 G ;
  4. backup database plus archivelog;
  5. 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)
1. jdev_suite_121300.jar
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

Run P9603
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

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:
1. E1Local: E1Local Database Engine
2. oradata: E1Local Database File
3. middleware:
  1. 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

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_1

Path:

/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)
1. Setup Queue name ObjectManagement
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

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>

Revision as of 02:39, 1 July 2017 (view source) Nicolas (talk \| contribs) (→‎Setup Change) ← Older edit		Revision as of 02:40, 1 July 2017 (view source) Nicolas (talk \| contribs) (→‎Deployment Server) Newer edit →
Line 131:		Line 131:

	<div class="toccolours mw-collapsible mw-collapsed">		<div class="toccolours mw-collapsible mw-collapsed">


	=== Change Server Security ===		=== Change Server Security ===

JD Edwards: Difference between revisions

Revision as of 02:40, 1 July 2017

Deployment Server

Prerequisites

Oracle Client 32 bit

Local Database

Deployment Server Installation

Create and Deploy Installation Plan

Security

Change Log Directory

Change Server Security

Manage Local Database E1Local

Jdeveloper

ServerManager

Bssv Server

Structure

Enterprise Server

Manage JDE920 Database

Linux Notes

Oracle Setup

After Install

Create Table

Error

ELFCLASS64

Enterprise Install

Error

Cheat Sheet

Start-Stop

Windows Setup

Prerequisites

Cheat Sheet

Start-Stop

Ports

OMW Object Manager Workbench

Jdeveloper

Web Logic Setup

Reset Password

FireFox Issue

Client Installation

Issues

Symptoms:1

Cause:1

Solution: 1

Bssv

Test

WebLogic Jax-ws

WebLogic Jax-Rpc (old)

Navigation menu

Search