Sterling OMS Overriding customer_overrides.properties

By | 07/07/2018

Sterling OMS Overriding customer_overrides.properties

Sterling OMS Overriding customer_overrides.properties

Sterling OMS Overriding customer_overrides.properties

In this post we are going to learn about basic concepts of Sterling OMS properties. As part of Sterling install folder you can see folder with name properties.  This folder has lot of files related to properties. Few important files to discuss

S.No Files under properties folder Used Build or Run Time Remarks
1 sandbox.cfg Build Time Contains key,value parameters which is
Used to create properties file.
Stores all the information given during
Installation like DB URL, DB user name, Password
Install location details
Example : DB_PORT=1521
2 servers.properties Run Time This is important file which holds all the location reference for properties file available. During server startup below value passed to locate server properties file.
-DvendorFile=/servers.propertiesSample Data in file
yfs=E:/OMS/properties/yfs.properties
customer_overrides=
E:/OMS/properties/customer_overrides.properties
3 yfs.properties Run Time This file contains default configuration related to below area. Do not modify any value in this file. You should use customer_overrides.properties file to override

  • Agent
  • API security
  • CDT
  • Database
  • Exception management
  • Implementation
  • Internal
  • InteropHttpServlet
  • JMS
  • Online help (for SSCAP)
  • Prints
  • Security
  • Service Definition Framework (SDF)
  • Rich Client Platform (RCP)
  • System management
  • User interface
4 yfs.properties.in Build Time This is temp file used for creating yfs.properties file
5 APPDynamicclasspath.cfg Run Time Holds class path which used during APP server startup
6 APPDynamicclasspath.cfg.in Build Time This is temp file used for creating APPDynamicclasspath.cfg
Using sandbox.cfg values
7 AGENTDynamicclasspath.cfg Run Time Holds class path which used during AGENT server startup
8 AGENTDynamicclasspath.cfg.in Build Time This is temp file used for creating AGENTDynamicclasspath.cfg using sandbox.cfg values
9 customer_overrides.properties Run Time Manually created by user under <Install Dir>/properties. Used for override any existing or adding new properties

How to modify database related properties in sandbox.cfg?

  1. From <Install Directory>/properties folder take a copy of sandbox.cfg as sandbox.cfg.original
  2. Search for following values in sandbox.cfg
    • NO_DBVERIFY=false
    • REINIT_DB=true
  1. First make change in sandbox.cfg file
    • NO_DBVERIFY=false (DDL scripts created automatically)
    • REINIT_DB=false (Database update will not happen automatically; Have to run the DDL script manually)
  1. Go to <Install Directory>/bin in command prompt
  2. Run <Install Directory>/bin/setupfiles.cmd files
  3. All places will get referenced with new change

How to add new 3rdparty jar file into OMS ?

  • Go to <Install Directory>/bin in command prompt
  • Run <Install Directory>/bin/install3rdParty.cmd weblogic 12.3 -j C:\weblogic\12\wlfullclient.jar -targetJVM AGENT
    • weblogic – vendorname
    • 12.3 – version number
    • C:\weblogic\12\wlfullclient.jar – path of the jar file (Can take multiple jars)
    • -targetJVM AGENT – Defines which classpath files should be updated

What happens when install3rdParty cmd run ?

  • Jar files get copied under location <OMS Install Dir>/jar/weblogic/12.3 (If folder not there gets created)
  • <OMS Install Dir>\properties\AGENTDynamicclasspath.cfg.in files gets below entry

VENDOR_JAR=&INSTALL_DIR;\jar\weblogic\12\wlfullclient.jar

  • <OMS Install Dir>\properties\AGENTDynamicclasspath.cfg files gets below entry

VENDOR_JAR=E:/OMS\jar\weblogic\12\wlfullclient.jar

How to override property in yfs.properties ?

yfs.properties file has property with name yfs.jms.session.disable.pooling

Lets see how this property been defined in yfs.properties file (property group, modifiable, possible values, default)

if you like to override this property you need to make entry into customer_overrides.properties file in below format.

Format : prefix_name.property_name=property_value

Example : yfs.yfs.jms.session.disable.pooling=N

Here prefix_name (first yfs) is derived from <Install dir>\properties\servers.properties file (Inside this file search for yfs=)

How to override property using customer_overrides.properties ?

Make below entry into customer_overrides.properties

Sample Java Code for reading value from properties file

Export Jar and Add part of OMS (One time activity)

How to write java program : Read this blog

  • Export project and create SterlingCustom94.jar file under C:\deploy\SterlingCustom94.jar
  • Run below command from OMS bin folder (One time Activity)

install3rdParty.cmd customjar 1 -j C:\deploy\SterlingCustom94.jar -targetJVM EVERY

  • Jar file automatically copied into <Install Directory>\jar\customjar\1\SterlingCustom94.jar
  • Below lines get added in 3 files (APPDynamicclasspath.cfg, AGENTDynamicclasspath.cfg, and dynamicclasspath.cfg files)
  • VENDOR_JAR=<OMS Install Directoty>\jar\customjar\1\SterlingCustom94.jar
  • Next time you can export the custom jar directly into <Install Directory>\jar\customjar\1 from Eclipse
  • Perform Build and deploy

OMS Build & Deployment

  • Go to bin folder
  • Run command : deployer.cmd -t resourcejar
  • Run command : buildear.cmd -Dappserver=weblogic -Dwarfiles=smcfs -Dearfile=smcfs.ear -Dnowebservice=true -Ddevmode=true -Dnodocear=true -Dwls-10=true create-ear
  • Ear file gets created under <Install Directory>\external_deployments\smcfs.ear
  • Create new folder deploy and C:\
  • Run command : del C:\deploy\smcfs.ear (Clean up any existing file)
  • Run command : copy <Install Directory>\external_deployments\smcfs.ear C:\deploy\smcfs.ear
  • Deploy manually using weblogic console from folder C:\deploy\smcfs.ear

Create New Service in OMS

  • Go to Application Manager — General — Service
  • Create new service with name “ReadProperties” and service group name as “Custom”
  • Select Option as “In a Synchronous Mode”
  • Add API from components tab and connect the start and end
  • Select Extended API radio button
  • API Name : ReadProperties
  • Class Name : com.oms94.util.PropertiesReaderDemo
  • Medthod Name : readProperties
  • Save

Test the program using API Tester

How to use API tester ?

Input to API Tester : <Hello />

API Tester Result : 

<Hello Option1=”E:/OMS/SearchIndex Option2=”Y Option3=”E:/OMS/SearchIndex Option4=”ActiveKite Option5=”Active Kite Test/>

If you have any question or suggestion please email to : support@activekite.com

Questions from this topic

  1. OMS System allows to override only existing property values ? Answer : No. In this above example we had added new property yfs.forum.name
  2. Can we change the property value run time ? Answer : Yes if MODIFIABLE_AT_RUNTIME value is Y
  3. Does property  can be managed using database ? Answer : Yes if DATABASE_SUPPORT value is Y
  4. How to enable database property management ? Answer : sandbox.cfg file DATABASE_PROPERTY_MANAGEMENT=true
  5. Which database table holds the property name and value ? Answer : PLT_PROPERTY
  6. How to add or modify entry into database table ? Answer : manageProperty API or manageProperties command line script
  7. If property name available in database and file system which one value gets selected ? Answer : file system has priority over database

Hope this helps !!! Cheers. Happy Learning

Test your knowledge using our quiz page : install3rdparty.cmd

Register with us to get more updates

IBM OMS Sterling Interview Questions

6 thoughts on “Sterling OMS Overriding customer_overrides.properties

    1. admin Post author

      Thanks lot Mayank Gaur for your nice words !!! Helps us to keep motivated. Thanks once again

      Reply
    1. admin Post author

      Thanks lot for nice feedback. Helps us to keep motivated

      Reply
  1. ramakrishna.bogati

    Hi Where can I get completer onDemand video tutorials on Sterling OMS/WMS

    Reply
    1. admin Post author

      Ramakrishna,
      Currently we don’t have onDemand video tutorials. We will work in this and keep you posted. Thank you.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *