G-Log Properties

Note: This post applies to OTM version 6.x and below.

The G-Log Properties file on the OTM App and Web servers holds the configuration that controls interactions between the App, Web, and Database tiers. It also contains configurable application settings such as the number of results to display on search screens. Always take a backup of the current file before making any changes — the file is read during application reboot and any corruption will cause application issues.

To view current properties from the application:

http://otm-server:7777/GC3/glog.webserver.properties.PropertiesServlet

Log in to the OTM application, navigate to the URL above (replacing otm-server with your server hostname), and click the List button to see all current properties.

To modify the properties file:

On the app and web server, switch to the base OTM directory ($OTM_HOME) and locate the file at:

$OTM_HOME/glog/config

Take a backup of the current file, apply your changes, and repeat on both the app and web servers. Restart the application for new settings to take effect.

Sample properties file with key settings:

#####################################################################
# G-Log Properties File for Both Web and App Server
# This property file holds the configurable settings for the
# G-Log Web and App Servers (running on the same box). These
# settings will override any settings in glog.webserver.properties,
# glog.appserver.properties, glog.common.properties, and
# glog.base.properties. These properties are initially set
# by the install scripts, but can be modified to work with
# your specific server. All G-Log property changes should be
# made to this file, rather than the webserver, appserver,
# common, or base property files.
#####################################################################
# !!!!!!!!!!!!!!!!!!!!!!!!!!! IMPORTANT !!!!!!!!!!!!!!!!!!!!!!!!!!!!
#-------------------------------------------------------------------
# Place all thread settings changes in the Custom Thread Properties
# section at the end of this file.
#-------------------------------------------------------------------
# Place all other changes, new properties, and custom properties in
# the Custom Properties section near the end of this file.
#-------------------------------------------------------------------
# These sections will be used by future installers during upgrades.
# Properties that are outside this section will not be migrated.
#####################################################################
#--------------------------------------------------------------------
# Base Install Settings
#--------------------------------------------------------------------
# GC3 version
glog.software.version=Otmv634
glog.software.patch.version=OTMv6.3.4
glog.software.installtype=WebAppServer
glog.software.instancetype=OTM
# installation paths
gc3.dir=/home/oracle/otm
gc3.config.dir=$gc3.dir$/glog/config
temp.dir=$gc3.dir$/temp
# application server URL and port
appserver=OTM-SERVER
appserver.port=7001
# application server type
glog.app.server.name=weblogic
appserver.protocol=t3://
# web server URL and port
webserver=OTM-SERVER
webserver.port=7777
# web URL prefix - should be blank unless web server is behind a reverse-proxy server
glog.webserver.urlprefix=

# web server URL (may differ from server name)
glog.webserver.URL=http://OTM-SERVER:7777$glog.webserver.urlprefix$
## this should only be uncommented if running In-Memory Logistics Command Center
#glog.includes.lc2=true
# db server URL and information
dbserver=127.0.0.1
glog.database.sid=otmdb
glog.database.connectstring=otmdb
glog.database.port=1521
glog.database.schema=glogowner
# LCC Controller only
#lc2.otm.database.server=lccdb.company.com
#lc2.otm.database.port=1521
#lc2.otm.database.service=lccdb
#lc2.otm.database.schema=lc2dba
#lc2.otm.database.password={e
#lc2.otm.database.commonPassword={e
# the following should only be used as directed by OTM Support:
#otm.db.url=
!includeIfSet $otm.db.url$,glog.rac.properties

# db users and passwords
otm.db.user=glogdba
otm.db.password={eR0xPR0RCQQ==
glog.database.load.user=glogload
glog.database.load.password={eR0xPR0xPQUQ=
# oracle driver type should be "Oracle" for thin drivers or "weblogic" for oci drivers
glog.database.default.poolDriver=Oracle
# default password storage setting (Encrypt/Text) - Note, changing this option also requires db changes
glog.crypto.password.mode=Encrypt
# App-to-Web authentication
glog.signedServlet.password={eQ0hBTkdFTUU=
#--------------------------------------------------------------------
# Log Settings
#--------------------------------------------------------------------
# turn logging on or off
glog.log.on=false
# path to log file(s)
glog.log.dir=$gc3.dir$/logs
glog.log.file.defaultLog.filepath=$gc3.dir$/logs/glog.default.log
# maximum size of log files (bytes)
glog.log.maxsize=10000000
# maximum number of log backup files
glog.log.backups=10
#--------------------------------------------------------------------
# Web Server Settings
#--------------------------------------------------------------------
document.root=$gc3.dir$/web/htdocs
# maximum number of results returned by port/airport finder, optional
glog.webserver.portresults.count=100
# maximum number of results returned by giv, optional
glog.webserver.givresults.count=100
# webservices
appserver.port.webservice.weblogic=$appserver.port$
# OHS settings
ohs.config.dir=/home/oracle/Middleware/Oracle_WT1/instances/instance1/config/OHS/ohs1
ohs.diagnostics.dir=/home/oracle/Middleware/Oracle_WT1/instances/instance1/diagnostics/logs/OHS/ohs1
## Replicated Operational Database (ROD) - optional
#ods_feature=true
#glog.ods.dbserver=otmodsdb.company.com
#glog.database.ods.sid=otmodsdb
#glog.ods.connectstring=otmodsdb
#glog.ods.database.port=1521
#glog.database.ods.schema=glogowner
## Fusion Transportation Intelligence (FTI) - optional
#aa_webserver=http://otmfti.company.com:7001
#ALLOW_ADVANCED_ANALYTICS=true
#glog.fti.dbserver=otmftidb.company.com
#glog.fti.database.port=1521
#glog.fti.database.schema=hdowner
#glog.database.fti.sid=otmrod01
#glog.database.fti.user=hdowner
#glog.database.fti.password={e
#glog.fti.connectstring=jdbc:oracle:thin:@$glog.fti.dbserver$:$glog.fti.database.port$
#glog.security.userSession.enabled=true

## Oracle Data Integrator (ODI); for use with FTI - optional
#glog.odi.agent.server=otmodiagent.company.com
#glog.odi.agent.port=20910
#glog.odi.password={e
#glog.odi.work.repository.code=FTI_WORK
## Oracle MapViewer server
#glog.mapServer=mapviewer.company.com
#glog.map.service_name=elocation_mercator
#glog.map.basemap=elocation_mercator.world_map
## Oracle Spatial server
#OracleSpatial.host=spatial.company.com
#OracleSpatial.port=7777
#OracleSpatial.US_Canada.routeServlet=/routeserver/servlet/RouteServerServlet
#OracleSpatial.WesternEurope.routeServlet=/routeserver_eu/servlet/RouteServerServlet
#OracleSpatial.geocodeServlet=/geocoder/gcserver
## URLStreamHandler Class for Outbound HTTPS - uncomment for AIX or WebSphere
#glog.integration.https.urlStreamHandlerClass=com.ibm.net.ssl.www.protocol.https.Handler
## LCC Analytics
#lc2.obiee.analytics.server.protocol=http
#lc2.obiee.analytics.server.host=lccanalytics.company.com
#lc2.obiee.analytics.server.port=9704
#lc2.odi.agent.server=lccodi.company.com
#lc2.odi.agent.port=20910
#lc2.odi.password={e
#lc2.odi.work.repository.code=LC2_WORK
## LCC Pool Server SSO
#glog.security.sso=true
#glog.security.sso.appUidLocation=3
#--------------------------------------------------------------------
# App Server Settings
#--------------------------------------------------------------------
# scalability settings
glog.scalability.on=false
glog.log.ID.JMS.on=false
glog.log.ID.Scalability.on=false
glog.scalability.thisTarget=gc3-OTM-SERVER
glog.scalability.thisMachine=DEFAULT
glog.scalability.thisMachineURL=$appserver.protocol$$appserver$:$appserver.port$
glog.scalability.defaultServer=DEFAULT
glog.scalability.defaultMachineURL=$appserver.protocol$$appserver$:$appserver.port$
glog.scalability.defaultMachine=DEFAULT

# list of available app servers to poll for network topology - used only by web server. one per line.
!remove glog.scalability.topologyMachineURL
glog.scalability.topologyMachineURL=$appserver.protocol$$appserver$:$appserver.port$
#glog.scalability.topologyMachineURL=<additional app server>
# list of available web servers
!remove glog.scalability.web.topologyMachineURL
glog.scalability.web.topologyMachineURL=http://$webserver$:$webserver.port$
#glog.scalability.web.topologyMachineURL=<additional web server>
# mail settings
glog.mail.smtp.host=mail.company.com
glog.workflow.notify.defaultSmtphost=mail.company.com
glog.mail.images=$glog.webserver.URL$/images/mail
# settings for fixed property change log
glog.properties.log.file=$glog.log.dir$/properties.log
# mail settings for property change notifications (these properties are
# reserved and cannot be changed via the Property Set Manager
glog.properties.log.email.host=mail.company.com
glog.properties.log.email.from=OtmAdvisor@company.com
# workflow settings
glog.workflow.notify.advisor.name=G-Log Advisor
glog.workflow.notify.advisor.email=OtmAdvisor@company.com
glog.workflow.notify.advisor.fax=555-555-1212
## FaxMaker Settings - optional
#glog.workflow.notify.faxmaker.email=fax@company.com
## RightFax Settings - optional
#glog.fax.defaultHandler.routingMode=to
#glog.fax.defaultHandler.routingPicture=/name={lastName},{firstName}/fax={rawPhone}/
#glog.fax.email=fax@company.com
## external integration settings
#glog.integration.URLtoSendBills=http://<server_name>/servlets/<ClassNameOfServletThatReceivesFinancialRelatedXML>
#glog.integration.URLtoSendVouchers=http://<server_name>/servlets/<ClassNameOfServletThatReceivesFinancialRelatedXML>
## external SMC Rateware - optional
#glog.RatingEngine.Rateware.URL=rateware.company.com
#glog.RatingEngine.Rateware.Port=23700
## external SMC RateWare Version 1.2.325 (or later) or SMC Carrier Connect
#glog.RatingEngine.Rateware.NewAPI=true
## external SMC RatewareXL - optional
#glog.RatingEngine.RatewareXL.Username=
#glog.RatingEngine.RatewareXL.Password=
#glog.RatingEngine.RatewareXL.License=
## external PCMiler/PCMiler Streets - optional
#pcmiler.host=pcmiler.company.com
#pcmiler.port=8145
## external PCMiler Rail - optional
#pcmiler.rail.host=pcmiler-rail.company.com
#pcmiler.rail.port=2001
## external Rand McNally - optional
#intelliroute.host=127.0.0.1
#intelliroute.port=1998
#intelliroute.user=otm
#intelliroute.password=changeme
#intelliroute.location=company
## external MileMaker - optional
#milemaker.host=milemaker.company.com
#milemaker.port=1031
## external Kewill FlagShip - optional
#glog.RatingEngine.Kewill.URL=kewill.company.com
#glog.RatingEngine.Kewill.Port=1200
#glog.RatingEngine.Kewill.RefnumQual=KEWILL_CUST_NUM
#--------------------------------------------------------------------
# Transmission Error properties -- can help in debugging inbound
# transmission errors
#--------------------------------------------------------------------
# This property specifies if the response is a StackTrace or TransmissionAck
#glog.integration.servlet.TransmissionStageError.elementName = StackTrace
# This property indicates if the full Transmission is sent back
#glog.integration.servlet.TransmissionStageError.includeTransmissionText = false
# This controls how the elements are formatted [comment|CDATA|normal]
#glog.integration.schema.element.StackTrace = comment
#glog.integration.schema.element.TransmissionText = comment

# The following properties specify if an email should be sent and to whom
#glog.integration.servlet.TransmissionStageError.sendErrorEmail = false
#glog.integration.servlet.TransmissionStageError.errorEmailTo =
#glog.integration.servlet.TransmissionStageError.errorEmailFrom =
#glog.integration.servlet.TransmissionStageError.errorEmailSubject = Transmission XML Stage Error
#glog.integration.servlet.TransmissionStageError.errorEmailSmtpHost =
#--------------------------------------------------------------------
# Custom Properties - Beginning
#--------------------------------------------------------------------
# Place all changes, new properties, and custom properties here.
# This section will be used during GC3 Upgrades
#
# Note that Property Sets WEB_CUSTOM, APP_CUSTOM and APP_WORKFLOW_THREADING
# can be used to specify custom properties via the OTM Property Set Manager
# screen. Only changes to reserved properties must be entered here.
#--------------------------------------------------------------------
# This property should be uncommented and repeated for every e-mail
# requiring notification of property changes.
#glog.properties.log.email.recipients=recipient1@domain.com
#glog.properties.log.email.recipients=recipient2@domain.com
#--------------------------------------------------------------------
# Custom Properties - End
#--------------------------------------------------------------------
#--------------------------------------------------------------------
# Default EBS Properties
#--------------------------------------------------------------------
#!include ebs.properties
#--------------------------------------------------------------------
# Default E1 Integration Properties
#--------------------------------------------------------------------
#glog.integration.enableCaseChange=true
#glog.integration.printXmlDeclaration=true
#glog.workflow.topic.OrderLatestEstDeliveryDateSync.suppresslifetime=false
#--------------------------------------------------------------------
# Default Web Server Properties
#--------------------------------------------------------------------
# This directive allows for the use of Property Set WEB_CUSTOM to manage
# custom properties for the web-tier. This property set is stored in the
# OTM database and is accessible through the Property Set manager within OTM.
# Comment this out to disable this data-driven property set
!propertySet WEB_CUSTOM,sibling
!include glog.webserver.properties
#--------------------------------------------------------------------
# Default App Server Properties
#--------------------------------------------------------------------
# This directive allows for the use of Property Set APP_CUSTOM to manage
# custom properties for the application tier. This property set is stored in the
# OTM database and is accessible through the Property Set manager within OTM.
# Comment this out to disable this data-driven property set.
!propertySet APP_CUSTOM,sibling
!include glog.appserver.properties
#--------------------------------------------------------------------
# Turn off Workflow persistence
#--------------------------------------------------------------------
glog.workflow.persistent.reboot=false
!remove glog.workflow.persistent.classes
#--------------------------------------------------------------------
# Thread model (should only be set to 'on' for WebSphere installs)
#--------------------------------------------------------------------
glog.util.commonj.threadModel.appServer=off
#--------------------------------------------------------------------
# compensate for WebSphere issues
#--------------------------------------------------------------------
#glog.vpd.cacheMode.profileTagging=pool
#--------------------------------------------------------------------
# Custom Thread Properties - Beginning
#--------------------------------------------------------------------
# Place all thread changes and properties here.
# This section will be used during GC3 Upgrades
#--------------------------------------------------------------------
# This directive allows for the use of Property Set APP_WORKFLOW_THREADING to manage
# workflow groups and their thread counts. This property set is stored in the
# OTM database and is accessible through the Property Set manager within OTM.
# Comment this out to disable this data-driven property set.
!propertySet APP_WORKFLOW_THREADING,sibling
#--------------------------------------------------------------------
# Custom Thread Properties - End
#--------------------------------------------------------------------

Questions & Discussion

Have a question about this topic? Post it below using your GitHub account. Comments are visible to everyone and help other OTM consultants with the same question.

Backward Oracle DBA notes