Wednesday, November 9, 2011

JDE Service Pack upgrade for Unix Systems

One of the most common type of projects in JDE is SP upgrade of an instance. Deployment Servers being windows machines are the easiest ones to Upgrade. And if you are on XE or Erp8.0 You just need to get the latest ESUs from the Change assistant and get started. For SO upgrade backup the OneWorldClientInstall, System and SystemComp folders , execute the Setup.exe of the SP , check the ptf.log and voila your SP upgrade of the Dep Server is done.

The real test of skill lies in the upgrade of a unix ent server and this is what i will enlist step by step in this post.Lets start from the download.

1. Download the correct SP file from Update Center. I recommend using the latest Change Assistant to get these. Select Type-> EnterpriseOne Tools Release, Release -> either 8.9x or Xe as the case may be with you , Platform -> SUN (based upon the Ent server OS you have) and if you know the version same of the SP you are searching for , you can shorten the result by typing a wild card in the Name filed.

2. In the list of SP’s shown select the latest version that it shows. As a rule of thumb I typically wait for *.1.1 and higher versions to appear. For instance if i am about to do an SP24 upgrade I will today be downloading SP24.1.3. If you are adventurous please feel free to download *.0.0 (specially recommended for POC’s , believe me they give a stupendous learning experience).

3. After you have saved your downloaded Par file for the upgrade. Open it with Winzip oor Winrar or any other unzipper and extract the files.

4. The file contains a system.Z file for the ENT server. Now the next step is to send it over to the ENT server. There are multiple ways to achieve this. If you site allows WinSCP install. Just install it connect to your ENT server, create a temp file on the server and drag and drop this system.z from the local machine onto the dir you just created on the ENT server. To avoid unseen data loss try and configure winscp to transmit in binary mode. Now if winscp isnt possible and you dont have hummingbird as well just remember that everysite allows an FTP connection between the deployment server to the ent server. Make sure that ftp services are enabled on the DEP server IIS and sent it to the ENT server using ftp.

5. Now once the file has been sent over to the ENT server login to th eent server using telnet or PUTTY as might be the case for you using the same user id that runs the JDE services on the ENT server. Go into the temp dir that was created in the step above and execute a “chmod 777 system.Z” command.

6. Stop the JDE services.

7. Go to your /dir/jdedwardsoneworld/ver### dir and execute ” mv system system_bak_date” command. This will create a backup of the system dir. Now you are ready to replacs this old system with the new system.

8. Go to the temp dir that has system.Z and execute the command “zcat system.Z | (cd /dir/jdedwardsoneworld/ver###;tar xvf – )”. This will unzip the system.Z and create a system dir for you in the /dir/jdedwardsoneworld/ver### .

9. Go to /dir/jdedwardsoneworld/ver###/system and rename the RunOneWorld.sh and the EndOneWorld.sh by the following command cp RunOneWorld.sh RunOneWorld.sh_original_sp and cp EndOneWorld.sh EndOneWorld.sh_original_sp. This will preserve the original scripts that came with the SP.

10. Go to /dir/jdedwardsoneworld/ver###/system and copy the RunOneWorld.sh and the EndOneWorld.sh from the system_backup_date into this system dir.

11. Execute a chmod 555 for system/lib/* system/libv32/* and Run cat ptf.log, it should show the latest SP name.

12. Now its the time to give up all hope in life, give up on your weekend plans and question your decision of becoming a CNC and after you have done all that execute ./RunOneWorld.sh

13. If you see the One World Startup Complete message do a Joy Dance and execute a portest. If porttest comes out successful, you are ready for a full package build and take it from there.
The above 12 steps will only help if you are not changing the DB. Remember that if the SP upgrade also involves a DB upgrade you will need to do a variety of changes to the JDE.ini , the .profile etc for the change to take effect.

14. A lil prayer helps!

Let me know if this helps any one of you! Also please feel free to point out any points that I might have missed. Happy SP Upgrading

No comments:

Post a Comment