"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

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

This tech doc explains why you get this error and what you can do to have it corrected. 

Environment

Release : 17.3, 17.2, 17.3

Component : Svc Desk Web Services

Resolution

The reason is the sortBy field in the search() call uses other fields other than RELEVANCE. For example, HITS. Currently only RELEVANCE is supported in sortBy so to correct this issue you would need to modify your script to use RELEVANCE in sortBy.

Additional Information

There is some mistake in techdocs web site

https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/ca-service-management/17-3/reference/ca-service-desk-manager-reference-commands/technical-reference/web-services-knowledge-management.html

that describes other fields such as HITS can be used. Broadcom is in the process correcting this mistake.