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
