403141: Forbidden when assigning a new owner to a datasource in 2022.1

Describe the bug
The code works in 2021.4.3

Versions
Details of your environment, including:

Tableau Server version - 2022.1.2
Python version - 3.8.5
TSC library version - 0.19

To Reproduce
Trying to assign a new owner to a datasource. Logged as a server administrator.

tableau_server_address = "https://mytableau"

tableau_auth = TSC.TableauAuth('userx', 'mypass', site_id='')
server = TSC.Server(tableau_server_address, use_server_version=True)
server.auth.sign_in(tableau_auth) 

datasource = server.datasources.get_by_id (ds_luid)
datasource.owner_id = new_owner_luid
updated_datasource = server.datasources.update(datasource)

Results

  File "fix_users.py", line 264, in <module>
    updated_datasource = server.datasources.update(datasource)
  File "/usr/local/lib/python3.8/site-packages/tableauserverclient/server/endpoint/endpoint.py", line 186, in wrapper
    return func(self, *args, **kwargs)
  File "/usr/local/lib/python3.8/site-packages/tableauserverclient/server/endpoint/datasources_endpoint.py", line 184, in update
    server_response = self.put_request(url, update_req)
  File "/usr/local/lib/python3.8/site-packages/tableauserverclient/server/endpoint/endpoint.py", line 133, in put_request
    return self._make_request(
  File "/usr/local/lib/python3.8/site-packages/tableauserverclient/server/endpoint/endpoint.py", line 66, in _make_request
    self._check_status(server_response)
  File "/usr/local/lib/python3.8/site-packages/tableauserverclient/server/endpoint/endpoint.py", line 82, in _check_status
    raise ServerResponseError.from_response(server_response.content, self.parent_srv.namespace)
tableauserverclient.server.endpoint.exceptions.ServerResponseError:

        403141: Forbidden
                'userx' isn't authorized to update the datasource 'xyz'.

Here's the code that works - same credentials, same ds and user luid, but going directly against the rest api using requests.

import boto3
import requests
from xml.etree import ElementTree
import urllib
import html
import json

uname = tableau_api_user_name
pw = tableau_api_user_pwd
tableau_server =  tableau_server_url
api_version = tableau_server_api_version

base_url = 'https://{}/api/{}'.format (tableau_server, api_version)

headers = {'content-type': 'text/xml'}

signin_data='<tsRequest><credentials name="{}" password="{}" ><site contentUrl="" /></credentials></tsRequest>'.format (uname, pw)

url = '{}/auth/signin'.format (base_url)

r = requests.post(url, data=signin_data, headers=headers)

if r.status_code!=200:

    raise Exception('Tableau server {} signin unsuccessful'.format (tableau_server))

root = ElementTree.fromstring(r.content)

token = root.find('.//t:credentials', namespaces={'t': "http://tableau.com/api"}).attrib['token']
headers = {'X-Tableau-Auth': token}
site_id = root.find('.//t:site', namespaces={'t': "http://tableau.com/api"}).attrib['id']
content_url = root.find('.//t:site', namespaces={'t': "http://tableau.com/api"}).attrib['contentUrl']
if not content_url or content_url=='':
    content_url='Default'

datasource_id = ds_luid
new_owner_id = new_owner_luid
url = '{}/sites/{}/datasources/{}'.format (base_url, site_id, datasource_id)
request_data = """<tsRequest>
                   <datasource>
                      <owner id="{}"/>
                   </datasource>
                 </tsRequest>""".format (new_owner_id)

r = requests.put(url, data=request_data, headers=headers)

if r.status_code!=200:
    raise Exception('Tableau server {}, data source {} owner reassignment request unsuccessful'.format (tableau_server, datasource_id))

root = ElementTree.fromstring(r.content)

result = root.find('.//t:owner', namespaces={'t': "http://tableau.com/api"}).attrib['id']
print (result)

@ashterenberg-paramount

Thanks @ashterenberg-paramount - I think have an idea of what's happening. Could you tell me what the value of
tableau_server_api_version is in your program?

I’ll save you some precious time.
In versions of the rest api lower than 3.15 you need to pass the project id of the datasource id along with the new owner id in the put call updating the datasource.
This was confirmed (reluctantly) by Tableau support via a support case.
They promised to update the documentation but no idea when it will happen.

I’ll save you some precious time. In versions of the rest api lower than 3.15 you need to pass the project id of the datasource id along with the new owner id in the put call updating the datasource. This was confirmed (reluctantly) by Tableau support via a support case. They promised to update the documentation but no idea when it will happen. Alex Shterenberg VP Of Business Intelligence ***@***.******@***.***> 323-956-4154 (direct) | 310-486-0244 (mobile) From: Jac ***@***.***> Sent: Thursday, September 1, 2022 5:19 PM To: tableau/server-client-python ***@***.***> Cc: Shterenberg, Alex - Paramount ***@***.***>; Mention ***@***.***> Subject: Re: [tableau/server-client-python] 403141: Forbidden when assigning a new owner to a datasource in 2022.1 (Issue #1072) <External Email> Thanks @ashterenberg-paramount<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_ashterenberg-2Dparamount&d=DwMCaQ&c=jGUuvAdBXp_VqQ6t0yah2g&r=cpWxI1-x9mzsHEN54_mqiS_l8lIGte4wqQRNjh8LLiw&m=8JY6hrFJj44lQT-TwPcQgyTZfCeALImyLyOXXPDEl7PkzEiZ-V6pyisvJHavffjM&s=Xy1HVbpoAEa6YAt0qkD5BdbUP29VIZsVtE2mMDP1spo&e=> - I think have an idea of what's happening. Could you tell me what the value of tableau_server_api_version is in your program? — Reply to this email directly, view it on GitHub<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_tableau_server-2Dclient-2Dpython_issues_1072-23issuecomment-2D1234934142&d=DwMCaQ&c=jGUuvAdBXp_VqQ6t0yah2g&r=cpWxI1-x9mzsHEN54_mqiS_l8lIGte4wqQRNjh8LLiw&m=8JY6hrFJj44lQT-TwPcQgyTZfCeALImyLyOXXPDEl7PkzEiZ-V6pyisvJHavffjM&s=49OGwQhdoljv0BdAA3K9ug5EirIp3UO2PzaJw40s-uk&e=>, or unsubscribe<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_AVKI5MPIJKFKN4BNBQ6MQWDV4FBWNANCNFSM54JM2BHA&d=DwMCaQ&c=jGUuvAdBXp_VqQ6t0yah2g&r=cpWxI1-x9mzsHEN54_mqiS_l8lIGte4wqQRNjh8LLiw&m=8JY6hrFJj44lQT-TwPcQgyTZfCeALImyLyOXXPDEl7PkzEiZ-V6pyisvJHavffjM&s=2e51N6FdkcPdPT2hmdQUHMvm0k1YEUT9dv2Iy12KwQk&e=>. You are receiving this because you were mentioned.Message ID: ***@***.******@***.***>>

Have tried both 3.16 and 3.17 API versions and the exact same issue.

Update datasources_endpoint.py

Fix bug in update-datasources before 3.15 (#1203)

Push code for 0.25 with custom views (#1206)

Push code for 0.25 with custom views (tableau#1206)

Navigation Menu

Repository navigation

403141: Forbidden when assigning a new owner to a datasource in 2022.1 #1072

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

403141: Forbidden when assigning a new owner to a datasource in 2022.1 #1072

Description

Activity

ashterenberg-paramount commented on Jul 22, 2022

jacalata commented on Sep 2, 2022

ashterenberg-paramount commented on Sep 2, 2022

ashterenberg-paramount commented on Oct 11, 2022

mustiem commented on Feb 24, 2023

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions