Blogs

Check out the new content on the Cisco Developer Network reflecting the New & Enhanced features in Cisco Unified Communication Manager 9.1.

See the new 9.1 IP Phone Services Documentation ...Read More

 

The Unified Communications 9.0 Partner Bundle packages Cisco’s Collaboration application software for our Collaboration partner community to leverage for their internal lab or demonstration systems. The 9.0 version is now available for order. Learn More >> ...Read More

 

Developer Partners,

Cisco announces the availability of our 2012 Developer Partner presentations shared at CiscoLive London.

Please log into the Cisco Developer Network using your Partner UserID to download this content.

Access these presentations here: http://developer.cisco.com/web/cdc/devforumpreso PARTNER LOGIN REQUIRED
...Read More

 

Cisco Technology Developer Partners,

Cisco is proud to announce the availability of our Cisco Unified Communications System Release 8.6 Not-For-Resale software bundle on Cisco Marketplace (Partner Login Required).

To purchase the latest Unified Communications NFR Software bundle
- Navigate to Cisco Marketplace
- Login using your Cisco.com UserID ...Read More

 



REMINDER! CDN DEVELOPER TECHNICAL SESSION TRACK AT CISCO LIVE LONDON, JANUARY 31 through FEBRUARY 2, 2011
...Read More

 



Cisco Developer Network will be presenting a CDN Developer Track at Cisco Live! London the week of January 31, 2011.

We are presenting technical sessions which highlight Application Programming interfaces (APIs) and Software Developer Kits (SDKs) for Cisco technologies such as Unified Communications, IOS, and Access Routing Technologies ¿ including the new Cisco Cius ...Read More

 

Showing 6 results.
Items per Page 20
of 1

Forums

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
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

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

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?

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

Collateral


No files available