SQL Exception when trying to fetch usage statistics

cdnadmin · ‎01-25-2014

This document was generated from CDN thread

Created by: Ingemar Nilsson on 19-04-2010 11:35:28 AM
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

Subject: RE: SQL Exception when trying to fetch usage statistics
Replied by: Kingsley Lewis on 19-04-2010 09:18:47 PM
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

Subject: RE: SQL Exception when trying to fetch usage statistics
Replied by: Noah Curran on 08-07-2010 07:52:42 AM
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>

Subject: RE: SQL Exception when trying to fetch usage statistics
Replied by: Kingsley Lewis on 08-07-2010 08:50:24 PM
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