Performance Tuning Options for OTM

 

Typeahead or Autocomplete option in OTM generates lot of sql queries on DB server.

For Example :  in Location Field , if you start typing the first 3 characters, OTM would return list of  matches.

 

What actually happens in the background is OTM generates a query something like this : “ Select location_Xid from location where location_xid like ‘ABC%’ “

Imagine lot of users on the screens trying to fill the fields and OTM generating lot of autocomplete queries wil add lot of queries and load on db server.

Depending on DB Server capacity and connection Pools, this may or may not be an issue..

 

Adjust these glog.properies to manage this option

 

glog.ui.autocomplete=false (To turn off autocomplete )

glog.ui.autocomplete.start=3  ( change this  to a higher value to see performance and adjust as needed)

Fixing Duplicate MAC Address error on VMWARE

Troubleshooting Error - “MAC Address --- of adapter Ethernet0 is within the reserved address range or Adapter Ethernet0 many not have network connectivity”

 

This error will appear when copy of a VM Image is running in parallel with the original VM and  you chose ‘I Moved it’ when prompted by VMware.

 

Solution

1. Shutdown the VM which has the error.

2. Go to the VM’s (The VM which is generating error) Folder and change the Folder Name .,. (change to any thing)

3. Launch the VMX File and VMware generates the same prompt,  choose “I Copied it”

This will fix the problem

.

Persisting Planning Parameter at shipment Level

 

with new 6.2 Release Oracle added functionality to store parameter used for building shipment at shipment Level. This  helps in using the parameter for various shipment actions with out relying on domain default parameter sets.

You can disable  this if you need to in Domain Settings

 

Showing Stop Activity on Shipment Map Page

To show stop activity on Shipment Map Window ,  make below changes in glog.properties file ( Change in Custom Section)

!remove glog.map.show_stop_activity=false

glog.map.show_stop_activity=true

Configuring Action Checks

If you need to validate some values when performing a user action, you can configure Action checks to do validation

 

for example,  When a User creates a Order Base , we can validate if the base id contains any invalid / unwanted chars

 

select Audit Action as “Add Order Base”

 

Create Allow Condition as below

 

you can set the cause and solution labels with required error message

 

Assign this Action check to user or role as required…

OTM External System Communication using Proxy

Some times there are external systems that can be reached by proxy only. Here’s how you can set the Proxy for http communication in glog.properties

 

 

You can also set proxy for ftp comunication using below parameters

glog.integration.ftp.proxyHost

glog.integration.ftp.proxyPort

Reformulating Regions and Cleaning up the Old Sets

 

There are some instances when you need to change region details and move the details between regions . If you do this thru UI , all the internal tables (Formulated Regions) gets adjusted automatically . How ever when you change or move the details via CSV uploads.. you have a bad region formulation.

You need to clean up HNAME_SET_MEMBER table  for the regions impacted. (delete all the records from that table)

Update Region table and set LOADED Flag as N for the regions impacted

and choose Formulate Regions from the UI

Setting up manual trigger for agents | Custom Action on Screen

We can use Actions to trigger an agent manually on selected Object.  Here’s how we can do it

Set Action Name as required . Set the Label  (in Public Domain using DBA.ADMIN) with Relevant Name. This is the name you are going to use when setting up the Action Link in Screenset

 

Select Required Definition, if you are running Action on shipment Objects and Trying to invoke Agent, select RUN_AGENT_SHIPMENT.  Agent ID Field shows list of Agents which can be invoked.

 

In Your custom screenset,  go to Actions tab and add action

Select “Add Actions” and choose the Action you created above..

Viewing Active ports on Linux / Ubuntu

To view all the active ports on Linux and view the current state -

If you have sudo Access you can provide p option

p option will only provide program name – this is not mandatory

netstat -ntulp

Without sudo or root access, you can run with out p option

netstat -ntul

Using DB.XML to retrieve nested table entries in OTM Data Export

You can export data out of OTM using DB.XML method. its cleaner than using CSV and you can also retrieve required child records along with parent.

For example : to retrieve Shipment and associated shipment_stop records , use below query in DB.XML Export option

Query :

select shipment.*,cursor(select * from shipment_stop where shipment_stop.shipment_gid=shipment.shipment_gid) as shipment_stop from shipment where shipment_gid  in (’ABC.1001’,’ABC.1002’)

Root: SHIPMENT