ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Error: "Invalid number of rows(0) affected by the operation. Expecting (1)" When consuming SDM REST API

book

Article ID: 212507

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager CA Service Desk Manager

Issue/Introduction

Error: "Invalid number of rows(0) affected by the operation. Expecting (1)" when trying to change status through REST

Cause

ID being used in the URL is not correct

Environment

Release : 17.2

Component : REST API

Resolution

The id 7076291 (Ticket ID, ref_num) being used is incorrect. In this field, the internal ID must be used, not the ref_num, which is the external ID. To get the correct id you can run:

select id from call_req where ref_num='<external ID>';

Additional Information

REST HTTP Methods

Attachments