The pdm_settenant command is failing to complete.

Document ID:  TEC1697948
Last Modified Date:  06/08/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details


  • CA Service Desk Manager


  • CA Service Desk Manager:Release:14.1
  • CA Service Desk Manager:Release:12.9 CA SDM
  • CA Service Desk Manager:Release:17.0



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.9 SDM 14.1 SDM 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:


Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255


Not what you were looking for?

Search Again >

Product Information

Support by Product >


Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required


We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{}} will be helping you today.

    View Profile

  • Transfered to {{}}

    {{}} joined the conversation

    {{}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1]}} has ended.
    Thank you for your interest in CA.

    Rate Your Chat Experience.


agent is typing