Issue No
Issue Name
Issue Description	Please review and tell me what is causing this issue: "I am attempting to run the MONTH END report from the shipment extract for the month of July. However, every time I attempt to run the report, I receive a message stating “No Data Found”. This report works for every other month (March-June) but not July. Based on pervious discussions, we believe that the issue is related to bad data in the system on 7/06/23. This issue is providing a backlog of Financial Reporting for July so we’re escalating this to a High priority. " Bottom line, run that report from 07/06 to 07/06 - You always get 'no data found' returned immediately. Please find out why and let me know. Bill your time to project management. WTD-1424	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 EPL 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	World-Trak SQL monthly rental Web-Trak for World-Trak monthly rental LTL-Trak Account-Trak EDI
Billable		Next Action Date	(Send No Email On Action Date Change)
	Customer Contact Information (When Applicable)
Customer Added
Name
Phone Number
Email Address

Document Upload/Delete	Documents List Attached To This Issue
26484_OrderNo_100176695.png Assessorials_by_PODDate.xlsx (Select File To Delete From List)	26484_OrderNo_100176695.png Assessorials_by_PODDate.xlsx

Response History

By Date Customer Can View   Note Status? Response Assigned To Priority Status   Brian Cronin 4/12/2024 3:06:36 PM NO Normal (BLACK) Open (BLUE) Misc Info (BROWN) Install Info (GREEN) Important Info (PURPLE) Critical (RED) ok, thanks Dave. Waiting for Release Low Waiting for Full Rel David Wilken 4/12/2024 2:57:22 PM NO Normal (BLACK) Open (BLUE) Misc Info (BROWN) Install Info (GREEN) Important Info (PURPLE) Critical (RED) Brian - this issue isn't really Pilot-specific. It's a bug with charge code descriptions containing embedded apostrophes causing an SQL error to be thrown. I fixed it in the latest changeset. Brian Cronin Low Ready For Testing Nathan Palmer 10/11/2023 7:37:32 PM NO Normal (BLACK) Open (BLUE) Misc Info (BROWN) Install Info (GREEN) Important Info (PURPLE) Critical (RED) David Wilken Low Ready For Testing David Wilken 10/11/2023 2:11:32 PM NO Normal (BLACK) Open (BLUE) Misc Info (BROWN) Install Info (GREEN) Important Info (PURPLE) Critical (RED) Changeset 70133 AirTrak/VisibleFunctions.asmx.vb Nathan Palmer Low Merge to 79/162 Nick Schubert 10/10/2023 12:52:32 PM NO Normal (BLACK) Open (BLUE) Misc Info (BROWN) Install Info (GREEN) Important Info (PURPLE) Critical (RED) Dave - Low Priority. Need to make the change you suggested on the charge code description issue. I'm going to hold off on the ShipmentMilestone change for now. That appears to be a one-off issue. 1. 8/9/2023 3:18:54 PM - Allow apostrophes in the charge code description. David Wilken Low Questions Nick Schubert 10/10/2023 12:41:00 PM NO Normal (BLACK) Open (BLUE) Misc Info (BROWN) Install Info (GREEN) Important Info (PURPLE) Critical (RED) Disregard. I figured out the issue. Nick Schubert High Questions Nick Schubert 10/10/2023 12:31:54 PM NO Normal (BLACK) Open (BLUE) Misc Info (BROWN) Install Info (GREEN) Important Info (PURPLE) Critical (RED) Dave - Omni is having an issue with the Consignee Ref # field. Log into Omni Prod with my profile and run the Con Ref # saved layout. You will get another 'no data found' pop-up. Something is off with the consignee ref #. If you remove that data element the report runs fine. I have narrowed down the issue to shipments with a Ready Date Range of 09/25/2023 - 09/25/2023. Something with one of the Consignee Ref #'s in one of these shipments seems to be an issue but I haven't been able to track it down. David Wilken High Questions David Wilken 9/19/2023 1:46:27 PM NO Normal (BLACK) Open (BLUE) Misc Info (BROWN) Install Info (GREEN) Important Info (PURPLE) Critical (RED) Nick, Housebill 373164847 has two COB milestones (see 26484_OrderNo_100176695.png), this is causing the extract to error out. This issue is very similiar to 26551, where it was returning more than one station on a zip. The short-term fix would be to delete one of those entries from tbl_shipmentMilestones. The longer term fix is to add 'top 1' statements the milestone section of the extract query. Nick Schubert Highest In progress Nick Schubert 9/19/2023 9:43:59 AM NO Normal (BLACK) Open (BLUE) Misc Info (BROWN) Install Info (GREEN) Important Info (PURPLE) Critical (RED) Dave - There is another data issue, this time with milestones. On Pilot Prod, I have a global layout saved called 'WALMART MILESTONES'. If you try and run it with a ready date/range of 09/07/2023 - 09/07/2023 you always get no data found. This appears to be an issue with the Milestones Data Element # 183. If you remove that data element, you can run the report. However, if you keep # 183 checked AND check the 'Include Milestones on separate row in the spreadsheet.' checkbox, it will allow you to run the report. David Wilken Highest In progress David Wilken 8/9/2023 3:18:54 PM NO Normal (BLACK) Open (BLUE) Misc Info (BROWN) Install Info (GREEN) Important Info (PURPLE) Critical (RED) A couple of shipments have a charge description with an apostrophe in it (951 - ADD'L LINES OF ENTRY). I'm almost positive this is causing the sql to error out and return no data. I searched production and only found two shipments with a 951 charge code, both with a POD date of 7/6. The short term fix is to remove the apostrophe from the charge description on the affected shipments (call it ADDL LINES OF ENTRY). I updated the shipments in Prod, and successfully ran the Extract for 7/6. Long term is to fix the code to properly escape the embedded apostrophes in sql. Brian Cronin Highest In progress David Wilken 8/9/2023 1:43:52 PM NO Normal (BLACK) Open (BLUE) Misc Info (BROWN) Install Info (GREEN) Important Info (PURPLE) Critical (RED) I updated the charge descriptions on the 7/6 housebills, but still returns no data. Still investigating David Wilken Highest In progress David Wilken 8/9/2023 11:41:40 AM NO Normal (BLACK) Open (BLUE) Misc Info (BROWN) Install Info (GREEN) Important Info (PURPLE) Critical (RED) Brian - see the attached spreadsheet. These are assessorials per day for the first week of July. There are some charge codes with multiple descriptions that might be the issue. The charge codes with standard description (i.e. matching the cost/charge table) are yellow, and the non-standard description are orange. On 7/6, housebill 372061331 has an assessorial of '226 - HANDLING'. It should be '226 - IMPORT HANDLING FEE'. The extract tries to combine its results with the assessorials matching on code *and* description. I think the other cases with multiple descriptions work because it tries to match on the the first code/desc it finds (which is a standardized '001 - FREIGHT CHARGES') Brian Cronin Highest Questions Brian Cronin 8/9/2023 7:36:27 AM NO Normal (BLACK) Open (BLUE) Misc Info (BROWN) Install Info (GREEN) Important Info (PURPLE) Critical (RED) ok, that is good info. Please find out why it isn't running properly with that checkbox checked. It works for the other days, so there must be something wrong with at least one of the shipments on that day. David Wilken Highest Questions David Wilken 8/8/2023 4:23:07 PM NO Normal (BLACK) Open (BLUE) Misc Info (BROWN) Install Info (GREEN) Important Info (PURPLE) Critical (RED) To further clarify, the MONTH_END export has the option 'Only Include Accessorials that have been used on the transactions being pulled in the spreadsheet' turned on by default. Brian Cronin Highest Open David Wilken 8/8/2023 4:12:44 PM NO Normal (BLACK) Open (BLUE) Misc Info (BROWN) Install Info (GREEN) Important Info (PURPLE) Critical (RED) Brian - I do get data for POD date 7/6 - 7/6 when I uncheck the 'Only Include Accessorials that have been used on the transactions being pulled in the spreadsheet' option Brian Cronin Highest Open