Issue
Issue No
Issue Name
Issue Description
I tried to figure out how they are doing this, but I cannot. Please look at the following HAWB#'s on production. The code next to it is the status/milestone each shipment went to that doesn't have an event date/time on the tracking note and on the milestone. We need to track this down and fix it. I tried duplicating the problem from the tracking page, the update milestone page and page 1. I couldn't get it to do it. Please see if you can track it down. 4520798 REF 4529037 RD1 4523647 CXL 4519400 REF 4526763 DEL 4518052 RAI 4514089 RAI 4526496 RAI 4519378 RAI 4523597 RAI 4524559 RAI 4526638 RAI 4517635 RAI
Response
Customer Can Review Response
Submitted by
ReAssign To
Aaron Biebuyck
Administrator
Brian Cronin
Carlo Toppi
Chuck Schubert
CSA Support (Internal)
Customer
Dave Fisher
David Wilken
Deepti Kulkarni
Don Mowat
Eva Wang
Ezra Lloyd
Gayatri Mehta
Guest
Jeanne Graziano
John Zhang
Julie Lopez
Lihua Li
Manisha Gohel
Monty Munro
Nathan Palmer
Nichole Baumgartner
Nick Schubert
Parvathy Viswamohan
Paul Go
Preeti Nevrekar
Ray Ciccone
Sam Kean
Shalu David
Shilpa Sahu
Steve Nielson
Sucharitha Koleti
Tressie Davis
Vidya Naga Kanchumarthy
Waiting for Release
William Avery
Worldtrak
Date Submitted
Priority
High
Highest
Hold for now
Low
Lowest
Normal
Expected Date
New Status
Branch - 02/18
Branch - 02/22
Branch - 04/12
Branch - 07/23_0922
Branch - 12/14
Branch - 12/14 - EFM
Branch - 12/14- EFW
Branch - 12/14-PEG3
Branch - 12/14-PEG4
Branch - 12/14-PEG5
Branch - 12/14-PEG6
Branch - 12/14-PEG6
Branch - 12/14-PEG7
Chuck BX
Closed
Completed
CSA Group Discussion
EDI Follow Up
Estimate
In progress
Installed
Merge to 79/162
Needs to be Merged
On Estes Test Box
On hold
Open
Priority
Questions
Ready For Install
Ready For Testing
Re-Merge
Re-Work
RTI - Estes Test Box
Version Control
Waiting for Full Rel
Waiting for Release
Waiting for ReleaseE
Waiting For ReleaseP
Waiting for Rel-EFM
Waiting on Feedback
Version
In Version
Orig Assigned To
Billable
Now Assigned To
Customer
A2 GLOBAL
AAB
AAFL
AARK
ABSOLUTE
ACE
ACES
ACI
ACT2
ACTUS
ADCOM
AES
AFCLOG
AFPLUS
AFU
AIR1
AIRCAREGO
AIRGRD
AIRLAND
AIRLAND EXPRESS
AJC
ALG
ALLENLUND
ALLSTATES
ALSLOG
ALTA AIR
ALTO
AM FREIGHT
AMR
AMS
ANDERSON CARGO
ARETE
ARK
ARTHRX
ASSURE
AVENUE
AVERITT
AXIS
AXISWW
BE LOGISTICS
BERING
BLK
BOXER FREIGHT
BRD
BRISK
BRONCO
BSTYET
BX SOL
CAMBRIDGE GRP
CARGO LOGI
CARGOT
CBC
CENTRAL
CHALLENGER
CHCOAK
CHURCH
CLEARL
CLT
CMSNET
COMLOG
CONEJO
CORE
CORTRANS
CRANE
CRATERSFR
CSA
CTFSHO
CTSLOG
CUSTOM
DDI
DEPLOG
DGFINC
DILIGENT
DLR CARGO
DLR MERCANTILE
DLS
DNCS
DOVE
DRIVEN
DSI
DTS
EA LOG
EASCO
EDGE
EFM
ELITEX
EPIC
ERHLOG
ESTES
EVENT
EXLINE
EXPEDITE RIGHT
EXPEDITORS
EXPEDITORT
EXSHOW
FALCON
FASTRANS
FHC
FIRSTAIR
FORBES
FRITZ
FTLOG
GDSI
GENESIS
GGL
GIBBY
GIOEXP
GLOBAL EVT
GLOCAR
GLTRAN
GNDAIR
GOLDEN
GREEN
GSL
GSLOG
GTUSA
GUARD
HAAS
HARRAH
HDLOG
HHXLOG
HORIZON
HOW
HWL
HWLCAN
ICAT
IFS
INSTIC
JETPRO
JETSTREAM
JKALOG
KANDL
KFS
KHA
KN
KNIGHT
LABS
LBRTY
LEGACY
LEI
LIGUSA
LION
LLINK
LMI EXPRESS
LOVE
LSS
LUCKY
LUI
LYNDEN
MAC CL
MACH1
MARIS
MAV
MCE
MERCURY
MERIT
MIDEXP
MIRAMAR
MKTPLC
MOREX
MULTI
NATIONS
NEW DIREX
NFO
NIND
NOBLE
NORTHSTAR
NOVA
NSWL
O2DLOG
OFFSHORE
OLD DOMINION
OLS
OMNI
OMNILAS
OMNIPD
OMNITR
ONESOURCE
OPTIMA
ORANGE
PCS
PEAK
PEGASUS
PEI
PERIMETER
PGL
PILOT
PIM
PLG
POWERFREIGHT
PRECISION AIR CARGO
PROLOG
PURPLE SH
QLOG
QUALITY
REVLOG
RMFL
RSE
SAEW
SANTAH
SAPWW
SATURN
SAY
SBA
SCL
SDS GLOBAL
SHOCKWAVE
SIGNATURE
SIXGLO
SKYG
SNAP
SOURCE
SPCFRT
STAND
STCLOG
SUPER
SYNERGY
TEAM
TECH
THEURG
TIC
TIME
TLM
TOTAL
TRANSM
TRANSPAK
TRANSX
TRI-STATE
TRIPR
TRL
TTS
TWL
UPS
VALUE OUTS
WATCH
WESPAC
WESTWARD GLOBAL
WORLDT
WWLOG
X-LINE
XPO
YELLOW
Priority
Customer Status
Closed
In Progress
Installed
On Hold
Open
Pending Release
Testing at Client Site
Testing at CSA
Status
Customer Product
AirTrak/2000
WorldTrak (SQL)
Web-Trak for WorldTrak
WMS-Trak
Pathfinder Interface
EDI
Billable
Next Action Date
(Send No Email On Action Date Change)
Customer Contact Information (When Applicable)
Customer Added
Name
Phone Number
Email Address
Issue Documents
Document Upload/Delete
Documents List Attached To This Issue
AnalyzeSql_1.txt
Analyze_1.PNG
Analyze_2.PNG
(Select File To Delete From List)
AnalyzeSql_1.txt
Analyze_1.PNG
Analyze_2.PNG
Response History
By
Date
Customer
Can View
Note Status?
Response
Assigned To
Priority
Status
Brian Cronin
10/24/2020 7:20:37 AM
NO
Normal (BLACK)
Open (BLUE)
Misc Info (BROWN)
Install Info (GREEN)
Important Info (PURPLE)
Critical (RED)
Installed on EFW DEV on 10/22
Nathan Palmer
High
Waiting for ReleaseE
Brian Cronin
10/10/2020 7:57:23 AM
NO
Normal (BLACK)
Open (BLUE)
Misc Info (BROWN)
Install Info (GREEN)
Important Info (PURPLE)
Critical (RED)
This is a duplicate ticket to another ticket that Ray is working on.
Brian Cronin
High
Ready For Install
Nathan Palmer
6/15/2020 7:33:54 PM
NO
Normal (BLACK)
Open (BLUE)
Misc Info (BROWN)
Install Info (GREEN)
Important Info (PURPLE)
Critical (RED)
Brian Cronin
High
Ready For Install
Brian Cronin
6/10/2020 12:10:33 PM
NO
Normal (BLACK)
Open (BLUE)
Misc Info (BROWN)
Install Info (GREEN)
Important Info (PURPLE)
Critical (RED)
Nathan Palmer
High
Branch - 12/14- EFW
Ray Ciccone
6/8/2020 5:00:42 PM
NO
Normal (BLACK)
Open (BLUE)
Misc Info (BROWN)
Install Info (GREEN)
Important Info (PURPLE)
Critical (RED)
Tested from the page-1 and the Tracking pages, entered a blank event date with an event time. Now does not enter '1900' date.
Brian Cronin
High
Ready For Testing
Nathan Palmer
6/5/2020 5:06:23 PM
NO
Normal (BLACK)
Open (BLUE)
Misc Info (BROWN)
Install Info (GREEN)
Important Info (PURPLE)
Critical (RED)
Ray Ciccone
High
Ready For Testing
Ray Ciccone
6/4/2020 6:07:57 PM
NO
Normal (BLACK)
Open (BLUE)
Misc Info (BROWN)
Install Info (GREEN)
Important Info (PURPLE)
Critical (RED)
Sorry 2 changesets:
Changeset 50381
Main/Operations/TrackingNotes.aspx.vb
Changeset 50380
Main/Operations/MTracking.aspx.vb
Main/Operations/MTracking1.aspx.vb
Main/Operations/ShipmentEdit.aspx.vb
This fixes the issue of an empty 'EventDate' but with an 'EventTime'; the current date plus entered time will be entered into the tbl_TrackingNotes.
Nathan Palmer
High
Merge to 79/162
Brian Cronin
1/28/2020 12:58:26 PM
NO
Normal (BLACK)
Open (BLUE)
Misc Info (BROWN)
Install Info (GREEN)
Important Info (PURPLE)
Critical (RED)
ok...no need to do this today, but if the event date is left blank on page 1 - and a time is entered in the event date, we need to assume that the date is today's date when writing the tracking note and updating the milestone.
You can do the same thing on the tracking page as well, so please check the logic there as well.
Ray Ciccone
High
In progress
Ray Ciccone
1/28/2020 12:09:53 PM
NO
Normal (BLACK)
Open (BLUE)
Misc Info (BROWN)
Install Info (GREEN)
Important Info (PURPLE)
Critical (RED)
I had taken a couple hours in troubleshooting this:
1 - logged into the Estes production and SQL server and found the data per the provided
2 -attached some findings:
AnalyzeSql_1.txt
Analyze_1.PNG
Analyze_2.PNG
3 - Tried to debug and force it with 12/14_EFW code.
4 - From TrackingNotes, the note 'Shipment Status changed to' is the particular note that has the blank EventDate. The user 'STredway' is the user where this occurs the most.
5 - The only way I can get it do to it (local debug on my machine) - is while e.g. Domestic/ShipmentEdit.aspx -> Enter '1/1/1900' in the EventDate field; or leave that blank and just enter the time. It will put in a tracking note with 1900 and when you come back to that shipment and display tracking notes - you will then see a blank event date. Now, it looks like other users are updating that Shipment (e.g. orderNo = 4005368).
6 - Also, there is an updateMilestone call when it updates the shipment. I traced that code and it's possible that it can slip in a 1900 datetime for the eventDate in that record as well.
Thanks,
Brian Cronin
High
Questions
Ray Ciccone
1/27/2020 5:40:50 PM
NO
Normal (BLACK)
Open (BLUE)
Misc Info (BROWN)
Install Info (GREEN)
Important Info (PURPLE)
Critical (RED)
Investigating
Ray Ciccone
High
In progress