CA Service Management

  • 1.  Problem with WebServices and KT

    Posted Jan 19, 2017 02:46 AM

    HI,

     

    I'm trying to use the webservices to do a query of KT with webservices, I'm using "Search" method, but when I want to sort by another field different to "Relevant" I get the following error "AHD03203:Wrong number of values from db" and in the stdlog "Could not create list using KD_list_web_HITS in factory KD:FAC:NC:ATTR:OB:MTH:".

     

    For the test, I'm using the App SoapUi, and how example this is the parameters:

     

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://www.ca.com/UnicenterServicePlus/ServiceDesk">
    <soapenv:Header/>
    <soapenv:Body>
    <ser:search>
    <sid>97288201</sid>
    <problem>problemas</problem>
    <resultSize>10</resultSize>
    <properties>TITLE,DOC_TYPE_ID,HITS</properties>
    <sortBy>HITS</sortBy>
    <descending>1</descending>
    <relatedCategories>1</relatedCategories>
    <searchType>1</searchType>
    <matchType>0</matchType>
    <searchField>15</searchField>
    <categoryPath></categoryPath>
    <whereClause></whereClause>
    <maxDocIDs>10</maxDocIDs>
    </ser:search>
    </soapenv:Body>
    </soapenv:Envelope>

     

    What is the problem??

     

    Regards.



  • 2.  Re: Problem with WebServices and KT

    Posted Jan 19, 2017 05:48 AM

    Hi Andres,

     

    What is the SDM version and patch level you are testing this on?

     

    Kind Regards,

    Brian



  • 3.  Re: Problem with WebServices and KT

    Posted Jan 19, 2017 05:54 AM

    Hi, I test in 12.6 (CUM#2) and 14.1 (CUM#3)

     

    Regards



  • 4.  Re: Problem with WebServices and KT

    Broadcom Employee
    Posted Jan 19, 2017 09:42 AM

    I would recommend raising a support case for this,  the problem seems to be just with the 

    <sortBy>HITS</sortBy>  

     

    RELEVANCE is the only item that seems to work there...

     

    _R



  • 5.  Re: Problem with WebServices and KT

    Broadcom Employee
    Posted Jan 19, 2017 11:55 AM

    Andres, try use "HITS DESC" instead of "HITS" in <sortBy>. Thanks _Chi



  • 6.  Re: Problem with WebServices and KT

    Broadcom Employee
    Posted Jan 19, 2017 12:44 PM

    Please ignore this update...we tried it with HITS_DESC and HITS DESC, none of them worked...please open a Support case so we can

    investigate. Sorry for the confusion. Thanks _Chi



  • 7.  Re: Problem with WebServices and KT

    Broadcom Employee
    Posted Oct 17, 2017 10:49 AM

    I have successfully tested on 14.1.04.01 using "faq" web services call with HITS as the sortBy value.