"AHD03203:Wrong number of values from db" error message when do a search() knowledge search web service call

Products

• CA Service Desk Manager
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager - Mobile Application
• CA Service Desk Manager - Xtraction

Issue/Introduction

The web service API search() call to search knowledge documents returns error "AHD03203:Wrong number of values from db". Expected result is a list of knowledge documents to be fetched. 

This tech doc explains why the above error message generated and what one can do to have it corrected. 

Environment

Release : 17.+

Component : Svc Desk Web Services

Resolution

The reason is multiple sort fields are not supported. The default is BU_RESULT, meaning that the FAQ() rating sorts it. When ID is used as a secondary sort, it always sorts the results. A value of HITS in "sortBy" is also supported. HITS Identifies the number of times that the document has been viewed.

Additional Information

techdocs