Forum Discussion

SELECTDBA's avatar
SELECTDBA
Icon for Advocate I rankAdvocate I
5 years ago
Solved

Dataset Refreshes Fail when Ownership Account is Disabled

Hello;   We've noticed that as Dataset owner's AD accounts are disabled the Dataset will fail to refresh.  Meaning lets say you deploy a Dataset, you are automatically set as the Owner, and if your...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    We do this proactively - we run scripts against our AD to identify workspace admins and dataset owners that are no longer valid and we alert the remaining admin(s) that they must add at least a second admin and/or fix the ownership.  Combination of Powershell and API calls.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

dataset ownership is not (directly) related to gateway connection refresh, But I can imagine that loss of that dataset owner will trigger the issues you described.

 

The remedy is quick - have someone else take ownership of the dataset either on the service UI or via API call.

SELECTDBA's avatar
SELECTDBA
Icon for Advocate I rankAdvocate I
5 years ago

Thanks for the response.  That's what we have been doing as far as taking over ownership, but thats time consuming, and sometimes days late after the account has been disabled.    

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    We do this proactively - we run scripts against our AD to identify workspace admins and dataset owners that are no longer valid and we alert the remaining admin(s) that they must add at least a second admin and/or fix the ownership.  Combination of Powershell and API calls.

    • SELECTDBA's avatar
      SELECTDBA
      Icon for Advocate I rankAdvocate I
      5 years ago

      Thanks for the suggestion.  That's a good idea and something we'll look to implement.  

    • VizKid's avatar
      VizKid
      Frequent Visitor
      1 year ago

      Do you have the sample Script?