Support Thread for the TND 500, TND 700 or future Rand McNally products. (part two)

Discussion in 'Trucking Electronics, Gadgets and Software Forum' started by Mark Kling, Jul 7, 2014.

Thread Status:
Not open for further replies.
  1. msjs91011

    msjs91011 Light Load Member

    101
    12
    Aug 6, 2014
    0
    LOL IF I was closer to you, I probably would let you check it out.

    I'm checking out some of the data on the TNDT80 and I am wondering why the Routes table inside the /.Navi/RM/Data/qplanner.db file is exactly 1,220,661 rows long.
     
  2. Truckers Report Jobs

    Trucking Jobs in 30 seconds

    Every month 400 people find a job with the help of TruckersReport.

  3. Mark Kling

    Mark Kling Technology Contributor

    10,935
    4,216
    Sep 23, 2007
    Statesville, NC
    0
    and your wanting to know this is? The routes table is city to city.

    Thanks,
    Mark
     
  4. msjs91011

    msjs91011 Light Load Member

    101
    12
    Aug 6, 2014
    0
    Whenever the tablet (the tndt80) is rebooted, and I start up the Truck GPS app, it takes 2-3 minutes to become functional and it often pops up a warning that it's taking a long time to start and asks me if I want to keep waiting for it to start or if I want to close the app. Last time I had that issue it was because I had an extremely bloated db table in Truck.db it had something like 12 million lines with 8 million of them being duplicates. So that's why I wanted to know.
     
  5. Mark Kling

    Mark Kling Technology Contributor

    10,935
    4,216
    Sep 23, 2007
    Statesville, NC
    0
    The qplanner.db is in the RM/Data folder which is pushed by Rand to the units. This table will almost never change since it is fixed city to city locations. The only way this will be corrupted if it is in a read condition and somehow the entire Tablet crashes. Very rare case as build in read conditions are protected by other modules in the software to prevent this, such as timing the read's.

    The truck.db is in the RM/User folder which is a user defined file. This file does get written to a lot as it records mileage and fuel for the user. Safeguards have been put in place to protect the Read/Write when we found that the 730 crashing was corrupting this file.

    Most times now when the 730 crashes I remove all the user files and run the unit. 9/10 times it is the truck.db that was corrupted.

    The Tablet issue with the Truck GPS stopping was with the RM Services app. That was fixed back in March of this year. The Android handles error handling a little better than the TND's.

    Since you know the "workings" of the tablet,... on the 80, copy all the .navi/User and the .navi/RM/user files. In the RM/User folder, copy only the .db's, not the sub folders.

    If you think your .navi/RM/User/Truck.db is corrupted, then just rename it and see how the tablet reacts. But be aware that now you have two mileage/fuel logs.

    Thanks,
    Mark
     
    msjs91011 Thanks this.
  6. Corporal_Clegg

    Corporal_Clegg Road Train Member

    1,239
    605
    Oct 9, 2010
    Raleigh,NC
    0
    lol, now i feel foolish :)
    Yes, I was taping the screen. A long press did the trick!!!!! WOW
    You are The man!!!!!
     
    tow614 Thanks this.
  7. Mark Kling

    Mark Kling Technology Contributor

    10,935
    4,216
    Sep 23, 2007
    Statesville, NC
    0
    images.jpg
     
    msjs91011, Corporal_Clegg and tow614 Thank this.
  8. msjs91011

    msjs91011 Light Load Member

    101
    12
    Aug 6, 2014
    0
    OK all that has been copied. I'm on my way to work now, gotta make a run to Indy area so I'll post back tonight. There's one of those ghost turns on us 30 westbound, gonna see if it's gone or not with this device.
     
  9. dca

    dca Road Train Member

    6,834
    11,427
    May 31, 2011
    Earth
    0
  10. Mark Kling

    Mark Kling Technology Contributor

    10,935
    4,216
    Sep 23, 2007
    Statesville, NC
    0
    Probably will be since you don't have the maps in testing.

    Thanks
    Mark
     
  11. Mark Kling

    Mark Kling Technology Contributor

    10,935
    4,216
    Sep 23, 2007
    Statesville, NC
    0
    @buddyd157

    what is the word on your 510?

    Thanks,
    Mark
     
  • Truckers Report Jobs

    Trucking Jobs in 30 seconds

    Every month 400 people find a job with the help of TruckersReport.

  • Thread Status:
    Not open for further replies.