Target release
Epic
Document statusDRAFT
Document owner

Mike Stephenson

Designer
Developers
QA

Current Status & Notes

Last Update: 6/15/2014

    1. Identified approx. 1400 vehicles with potential issues relative to EODR
    2. Need to troubleshoot, categorizing into buckets for review
    3. Certain trucks will need software update, wiring inspection or wires connected (JBUS, Ignition)
    4. Several initiatives focused on EODR data, need to get to the bottom of the issues
      1. Need to get 5.20 to these units (6/15 Updated 7471 to 5.20.02 or higher.)
    5. Correlation reports to make sure inventory feed is working correctly
      1. Fetah has done majority of the work
      2. Does GetAll… call include inventory information, software version information
        1. XPe truck
        2. DTCore
      3. Currently software version not included, trying to get it in FW3.34
    6. Suggested to Ken we wait running report until we have at least 2 weeks of history compiled
      1. Start date 4/28/2014, that’s when half of fleet was deployed.
      2. 6/15/2014 – ran a new report and now down to approx. 1000 trucks
    7. Report to Ken who will check to see if we can correlate to oem/make/model

 

Goals

  • Need to get units updated to 5.20 as there were code changes that may help with EODR
  • Ran a query that showed potential issues; once we have units updated we will run the query again and see what has been resolved

Background


Attachment: EODR Examples.xlsx

 

-----Original Message-----
From: Ken Crane [mailto:kcrane@usxpress.com]
Sent: Tuesday, February 25, 2014 7:26 AM
To: Mike Stephenson; Jan DeHoop
Cc: Ken Crane
Subject: EODR Data Issues
Importance: High

 

Guys,

We have an internal initiative going that is using quite a few of the data elements of the EODR data. As part of the analysis, it has been noticed we have quite a few reporting anomalies. Attached is a spreadsheet that shows how these breakdown. I have asked for some recent examples for you to research with but I wanted to start the dialogue on these and what we could do to determine possible root cause and options to correct. Please let me know a good time to discuss.

 

Thanks!

 

Ken Crane | US Xpress, Inc.

4080 Jenkins Road | Chattanooga, TN 37421 Director, IT Operations

Office: 423 510 3365 | Fax: 423 510 3299 kcrane@usxpress.com | www.usxpress.com

 

 

 

Requirements

#TitleUser StoryImportanceNotes
1TPC UpdateNext step is to get units updated to 5.20Must Have
  • The hope is that once the known issues with JBUS connectivity are addressed the list of approx. 1400 units with issues will decrease
2Wiring IssuesSome tractors identified as having wiring issuesMust Have
  • Some of these units have already been identified as most likely having wiring issues. Based on the fact that we are getting no JBUS at any time
3    

User interaction and design

DECLARE @EODRRecords table

       (

       date                 datetime,

       truckPCID            int,

       systemMask           int,

       jbusParamsAudit      int

       )

 

INSERT INTO @EODRRecords(date, truckPCID, systemMask, jbusParamsAudit)

       SELECT

                     date,

                     truckPCID,

                     systemMask,

                     jbusParamsAudit

              FROM  dbo.DTECH_Rollup WITH (NOLOCK)

              WHERE (version >= 17) AND ([date] >= '2/1/2014' )

 

DECLARE @trucksWithProblems table

       (

       truckPCID                         int,

       serialNumber                      int,

       truckPCType                       int,

       [version]                         varchar(15),

       days                              int,

       daysWithAProblem                  int,

       daysWithAProblemPercent           int,

       J1939Days                         int,

       J1708Days                         int,

       noBusDays                         int,

       MOVING_WITHOUT_JBUS_DAYS          int,

       MISSING_HOS_JBUS_PARAMS_DAYS      int,

       BAD_IGNITION_DAYS                 int,

       RPM                               int,

       RoadSpeed                         int,

       Odometer                          int,

       Fuel                              int

       )

 

INSERT INTO @trucksWithProblems(truckPCID, daysWithAProblem, MOVING_WITHOUT_JBUS_DAYS, MISSING_HOS_JBUS_PARAMS_DAYS, BAD_IGNITION_DAYS, RPM, RoadSpeed, Odometer, Fuel, J1708Days, J1939Days, noBusDays)

       SELECT truckPCID,

                     COUNT(truckPCID),

                     SUM(CASE WHEN (systemMask & 0x020000) > 0 THEN 1 ELSE 0 END),

                     SUM(CASE WHEN (systemMask & 0x100000) > 0 THEN 1 ELSE 0 END),

                     SUM(CASE WHEN (systemMask & 0x000080) > 0 THEN 1 ELSE 0 END),

 

                     SUM(CASE WHEN (jbusParamsAudit & 0x002000) > 0 THEN 1 ELSE 0 END),

                     SUM(CASE WHEN (jbusParamsAudit & 0x000008) > 0 THEN 1 ELSE 0 END),

                     SUM(CASE WHEN (jbusParamsAudit & 0x008000) > 0 THEN 1 ELSE 0 END),

                     SUM(CASE WHEN (jbusParamsAudit & 0x020000) > 0 THEN 1 ELSE 0 END),

 

                     SUM(CASE WHEN ((jbusParamsAudit & 0x400000) > 0) THEN 1 ELSE 0 END), -- J1708

                     SUM(CASE WHEN ((jbusParamsAudit & 0x200000) > 0) THEN 1 ELSE 0 END), -- J1939

                     SUM(CASE WHEN (((jbusParamsAudit & 0x400000) = 0) AND ((jbusParamsAudit & 0x200000) = 0)) THEN 1 ELSE 0 END) -- NONE

              FROM  @EODRRecords

              WHERE ((systemMask & 0x020000) > 0) OR ((systemMask & 0x100000) > 0)

              GROUP BY truckPCID

 

DECLARE @daysPerTruck table

       (

       truckPCID int,

       days      int

       )

 

INSERT INTO @daysPerTruck(truckPCID, days)

       SELECT truckPCID, COUNT(truckPCID)

              FROM  @EODRRecords

              GROUP BY truckPCID

 

UPDATE l SET

              l.[version] = v.[version],

              l.serialNumber = v.truckPCSerialNumber,

              l.truckPCType = v.unitType

       FROM @trucksWithProblems AS l

       INNER JOIN dbo.DTECH_Vehicle AS v

       ON (v.truckPCID = l.truckPCID)

 

UPDATE l SET

              l.days = d.days

       FROM @trucksWithProblems AS l

       INNER JOIN @daysPerTruck AS d

       ON (d.truckPCID = l.truckPCID)

 

UPDATE @trucksWithProblems SET daysWithAProblemPercent = CAST((((CAST(daysWithAProblem AS float) / CAST(days AS float)) * 100) + .5) AS int)

 

SELECT * FROM @trucksWithProblems

       ORDER BY daysWithAProblemPercent DESC, days DESC

USXJBusProblems_JMD_03182014_WIP.xlsx

Questions

Below is a list of questions to be addressed as a result of this requirements document:

AudienceQuestionOutcome
 Does the COM5 Patch / TruckPC Core 5.20 update resolve the issues we identified from the first query?

Not Doing

  •