search cancel

The pdm_settenant command is failing to complete.


Article ID: 6920


Updated On:


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


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


SDM 12.9SDM 14.1SDM 17


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.


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: