« Back to IP Phone Services Questions

RE: How to debug service

Combination View Flat View Tree View
Threads [ Previous | Next ]
How to debug service
sql service debug
Answer
11/13/12 7:18 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
Flag

Re: New Message from Cindy Brozyno in IP Phone Services (IPPS) - IP Phone S
Answer
11/13/12 7:25 PM as a reply to Cindy Brozyno.
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
Flag

RE: How to debug service
500 error message http connection
Answer
11/14/12 7:46 PM as a reply to Sascha Monteiro.
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?
Flag

RE: How to debug service
Answer
11/15/12 2:00 PM as a reply to Cindy Brozyno.
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
Flag