Please note: These WebEx forums have replaced the earlier site forums. All the previous threads and posts have been replicated here, and if you subscribed to the previous forums, please re-subscribe. Thank you.
« Back to Usage Reporting

SQL Exception when trying to fetch usage statistics

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
SQL Exception when trying to fetch usage statistics
Answer
4/19/10 4:36 PM
Hi!
 
Since around 12 hours ago, we have been getting 000003 SQL Exception when we have tried to fetch usage statistics. This does not seem like an error on our part, so are you having problems right now?
Edit: I forgot to mention that we are using the XML API version 5.3.
 
Regards
Ingemar
 
Flag

RE: SQL Exception when trying to fetch usage statistics
Answer
4/20/10 2:18 AM as a reply to Ingemar Nilsson.
Hi Ingemar,
 
If this is on your production site you need to call into support immediately.  At this time there have not been any reports into our support team from other API customers.  This could be an issue that is only affecting your site and support will be able to gather the information needed to troubleshoot the issue.  They can escalate to our data center if it is determined to be a server issue.  When calling for support please be sure to have the XML request and the XML response from WebEx.
 
 
Thank you,
-Kingsley Lewis
Flag

RE: SQL Exception when trying to fetch usage statistics
Answer
7/8/10 12:52 PM as a reply to Kingsley Lewis.
I am also facing the same issue while using the XML API. Please let me know the solution for this.
The response i am getting is :
<serv:message>
¿
<serv:header>
¿
<serv:response>
<serv:result>FAILURE</serv:result>
<serv:reason>SQL Exception</serv:reason>
<serv:gsbStatus>PRIMARY</serv:gsbStatus>
<serv:exceptionID>000003</serv:exceptionID>
</serv:response>
</serv:header>
¿
<serv:body>
<serv:bodyContent/>
</serv:body>
</serv:message>
 
I have also used the tool provided on your site for testing the XML API. above output is from that tool.
Request was:
 
<?xml version="1.0" encoding="UTF-8"?>
<serv:message xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <header>
           <securityContext>
       <webExID>xx</webExID>
       <password>xx</password>
       <siteID>xx.</siteID>
       <partnerID>xx</partnerID>
            <email>xx@xx.com</email>
       </securityContext>
    </header>

    <body>
    <bodyContent xsi:type="java:com.webex.service.binding.meeting.LstsummaryMeeting">
<listControl>
<startFrom>1</startFrom>
<maximumNum>10</maximumNum>
<listMethod>OR</listMethod>
</listControl><order>
<orderBy>HOSTWEBEXID</orderBy>
<orderAD>ASC</orderAD>
<orderBy>CONFNAME</orderBy>
<orderAD>ASC</orderAD>
<orderBy>STARTTIME</orderBy>
<orderAD>ASC</orderAD>
</order></bodyContent>
    </body>
</serv:message>
Flag

RE: SQL Exception when trying to fetch usage statistics
Answer
7/9/10 1:50 AM as a reply to Noah Curran.
Hi Noah,
 
Is this for your production site,  or the sandbox site?  SQL Exception is usually related to the siteID and partnerID being incorrect values.  If it' s a production site you can validate your siteID and partnerID from your WebEx account manager.  The correct siteID and partnerID for the sandbox site are below.
 
<siteID>243585</siteID>
<partnerID>g0webx!</partnerID>
 
Also, as I have above, if this is a production site that was previously working,  please call in to technical support.  Make sure you have available your XML request and response. This way we can quickly provide you with a solution, or indicate any known issues that could affect your production site.
 
Thank you
-Kingsley Lewis
Flag

Create a Cisco account today and gain access across all Cisco Collaboration Developer sites.

Sign Up Now!

 

Follow the WebEx Developer program on Twitter for the latest industry and WebEx Meetings related information.

Follow us