X Mobile Tracing

This KnowledgeBase article reviews how to configure a logging ("scratch") table in the SQL Database to log significant X Mobile communication information for problem solving purposes.  Note that some knowledge with SQL Management Studio is required.

Configuring the X Mobile Tracing File

  1. Run SQL Statement below:
  2. Rename existing GPS.ASP page in X Internet directory to GPS.ASP.ORIGINAL as backup in case logging will be disabled in the future.

  3. Create new file called GPS.ASP in X Internet directory and paste the following code into document.  Please note that if X Internet is run on a separate server than X Dispatch the IP address of the “Data Source” must be updated in the line connection string to the proper location:
  4. After saving the new GPS page, navigate to GPS.ASP on the X Internet website and add the "test=1" parameter to the URL.  Example: http://127.0.0.1/GPS.ASP?test=1 (if on internet server and are hosting site with default path.)  If the GPS.ASP page is working properly, the correct response for "test=1" is “525252”. 

  5. The new scratch table can now be queried in the cxtData database to view X Mobile posts to GPS.ASP.  Additionally, the phone number of the driver making the post, submission time of post, and the X Internet processing time can all be viewed.  Please note that only the most current 5,000 posts are retained to prevent the scratch table from taking up an excessive amount of SQL database space.