The pdm_settenant command is failing to complete.

book

Article ID: 6920

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

The pdm_settenant command is failing to complete. When checking the stdlog the following error is logged:

ERROR set_tenant_mgr.c 307 received message got_row_and_tenant_id with error: AHD03200:Fetch is complete

Cause

By default the "fetch size" for pdm_settenant is set to 500.

In the example above the fetch size was set to a value greater than 500.

Environment

SDM 12.9SDM 14.1SDM 17

Resolution

In addition to the pdm_settenant command enter "-s fetch_size" to specify the fetch size for fetching data from a table specified in the configuration file.

The fetch size can be a value between 100 and 1000, however cannot be greater than 1000.

Additional Information

If the fetch size is over 1000, the settenant.xml file can be modified by adding in an additional Where clause to lower the fetch size below 1000.

See TEC1795197 below for instruction on how to add an additional where clause to set tenancy based on group:

https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec1795197.html