How to debug service

Version 1

    Subject: RE: How to debug service
    Replied by: Cindy Brozyno on 13-11-2012 02:14:28 PM
    Thanks for the suggestion, Sascha.  I did that, but I have no idea what I'm looking at. The only thing I was able to determine is that it takes longer on the 8941 phone than it does on the 7942.  I actually posted the wireshark pics under this post - Phone service - HTTP Connection failed error on 8941 phones - but as of yet have not received any feedback from anyone else on them.
    I appreciate the suggestion, though. 
    I tried again, and the exact error being recorded is HTTP Connection Failed.  I reviewed an older post which says suggests it's something in the script failing on the web server.  I know where it's failing, I just don't know why,.
    The user inputs a number, and clicks submit.  On the 7942 phone, it works fine.  on the 8941, I get the HTTP Connection failed. They hit exit, re-enter the number, hit submit again.  It works fine. 
    Ideas?
    This document was generated from CDN thread

    Created by: Cindy Brozyno on 13-11-2012 01:18:15 PM
    How do you debug a phone service?  My timeclock service utilizes query params & goes to SQL; on newer phones it seems to time out when it needs to return data from SQL. Would like to debug. Suggestions?
    Thanks.  Cindy

    Subject: Re: New Message from Cindy Brozyno in IP Phone Services (IPPS) - IP Phone S
    Replied by: Sascha Monteiro on 13-11-2012 01:25:48 PM
    you can start by running a wireshark trace on the server where your ipps is
    hosted,
    and analyse the http requests and response from/to the phone

    Subject: RE: How to debug service
    Replied by: Cindy Brozyno on 15-11-2012 08:00:16 AM
    I'm one step closer.  I ran SQL Profiler and did a trace of the service as I ran it.  On the 7942 phones, it ran fine.  On the 8941, I found the issue.  I'm just not sure how to solve it. 
    Below is the code that runs, then the SQL that goes through the trace.
    SERVICE PAGE CODE
    var input = Request.QueryString("input");
    var input2 = input * 1;      // I did this math to ensure that the data comes through as a number.  The datatype of the field is numeric(15,0).
    sql=("SELECT * FROM dbo.vw_User_PinList WHERE PERSON_ID =("+input2+") ");
    TRACE RESULTS ON 8941 PHONE
    SELECT * FROM dbo.vw_User_PinList WHERE PERSON_ID =(Nan)
    select * from SELECT * FROM dbo.vw_User_PinList WHERE PERSON_ID =(Nan)
    (At this point, the user receives HTTP Connection failed, they try again, and this is what goes through:
    SELECT * FROM dbo.vw_User_PinList WHERE PERSON_ID =(73220)
    ***********
    I then changed the SQL query from requesting Input2 to input, leaving it as a string, to see what it was submitting.
    Here's what I found:
    TRACE RESULTS
    SELECT * FROM dbo.vw_User_PinList WHERE PERSON_ID =(%2073220)
    select * from SELECT * FROM dbo.vw_User_PinList WHERE PERSON_ID =(%2073220)
    User gets - http connection failed - tries again.
    SELECT * FROM dbo.vw_User_PinList WHERE PERSON_ID =(73220)
    So it looks like there is a Space coming through with the number, only on the 8941 phones.
    I'm going to try and add a "trim" statement to see if that works. 
    Any other ideas out there?  all help is much appreciated.  Thank you.  Cindy