OTM Version 6.2.* has a bug that causes tremendous increase in Bulkplan Runtime when Rate Offerings use ExternalDrive for Transittimes (Like PCMILER).
There is a patch available in metalink .
OTM Tips and Tricks, OTM Info, Sharing Knowledge, OTM FAQ
OTM Version 6.2.* has a bug that causes tremendous increase in Bulkplan Runtime when Rate Offerings use ExternalDrive for Transittimes (Like PCMILER).
There is a patch available in metalink .
We had a requirement once to map the shipments out of OTM, but on a different system
Below is how I did it.. It might be of help..
Retrieve Shipment Stop Related Lat/Lan from OTM
SELECT SS.STOP_NUM,LAT,LON FROM SHIPMENT_STOP SS,
LOCATION LC WHERE SHIPMENT_GID='XXX.1002413'
AND SS.LOCATION_GID=LC.LOCATION_GID ORDER BY SS.STOP_NUM
Here’s the Javascript for rendering the Map
<script type="text/javascript" src="http://dev.virtualearth.net/mapcontrol/mapcontrol.ashx?v=6.2"></script>
<script type="text/javascript">
var map = null;
function RenderMap()
{
map = new VEMap('MapDiv');
map.SetDashboardSize(VEDashboardSize.Normal);
map.LoadMap(new VELatLong(39.828180,-98.57955),4,'r',false,VEMapMode.Mode2D);
var RouteLayer= new VEShapeLayer();
var shipment1 = new VEShape(VEShapeType.Polyline, new VELatLong(41.8672,-103.6575 ),
[
new VELatLong(41.8672,-103.6575 ),
new VELatLong(42.8419,-106.2818 )
]);
var shipment2 = new VEShape(VEShapeType.Polyline,
[
new VELatLong(33.776864,-84.437599),
new VELatLong(36.223227,-86.977615)
]);
shipment1.HideIcon();
shipment1.SetLineColor(new VEColor(0,225,0,1));
shipment1.SetLineWidth(3);
shipment2.HideIcon();
shipment2.SetLineColor(new VEColor(225,0,0,1));
shipment2.SetLineWidth(3);
RouteLayer.AddShape(shipment1);
RouteLayer.AddShape(shipment2);
map.AddShapeLayer(RouteLayer);
}
</script>
If we have a multi stop shipment and each stop has refnums or remarks or involved parties, and when you try to unassign the orders related to one of the stops in between, otm throws error . This will be fixed in Otm 6.2.7
** Update, there was data consistency issues after the fix in 6.2.7 (Patch is available), Ask oracle for a Patch
Workaround -
1. Manually delete the refnums and other stop level data from shipment before unassigning orders related to the stop
2.change the process to populate the stop level remarks before Tendering the shipment
Here’s how Dynamic Pooling works in OTM.
Scenario
A Region serviced by Multiple Pools
With out Dynamic Pool Option (Default), OTM would select one of Pool A or Pool B in Selection Order and Try to Build a Shipment From the Pool.
OTM Would not evaluate all the Pool Options .
To handle these scnearios, we can use Dynamic Pool where OTM would evaluate all the matched Pools for a Region
To enable Dynamic Pool , set parameters as below
Login to OTM using DBA.Admin
Search for Primary_JTS in Data sources
Edit the Pool section of the Source
You can change the Maximum Capacity as required.
Note ** : Before changing this value, make sure you have enough capacity and processes limits on Oracle DB
At one of client implementation, users had a large number of updates to rate factors every week and have a large number of rate factor sources
Here’s a a simple way to update rate factors. Comment in this post if you need a copy of this ..
When you have a huge list of tasks running on the default queues, you might have some backlog / performance problems. In the example below, we have Allocations running on shipments and is backlog on the default AgentPlanning queue. It will cause other tasks triggered on queue in backlog and has to wait..
to eliminate these issues, you can create custom queues and reassign the topic workflows to the custom Queue
Here are the property settings to redirect the topic group to custom Queue
Also remember to set the threads for the new queue
When OTM sends any outbound communication, it includes the Source System URL. Sometimes this is long and clumsy depending on the installation. (Network and Internal DNS)
In order to change the URL and add a Logical System ID (Like ABC_OTMPROD) , make below changes in glog.properties (custom Section)
!remove glog.integration.senderSystemId = $glog.webserver.URL$
glog.integration.senderSystemId=ABC_OTMPROD
Before:
After
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)
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
.