Question about SAP APO connection

Anonymous
2022-06-27T08:02:29.397+00:00

Hi team,

I'm facing permission issue when connecting SAP APO system using synapse data copy tool. It would be appreciated if you can help to identify the problem here.

I created linked service with SAP BW Open Hub, and tried to connect to our APO test environment.
Although I can connect and see table list, it failed to preview data with below error.

SapRfcClient operation '/SAPDS/RFC_READ_TABLE2' failed. Error message:
'このアクティビティを実行する権限がありません' このアクティビティを実行する権限がありません
Activity ID: 95cfed0c-26cd-4a14-af10-542280721035

215269-image.png
('このアクティビティを実行する権限がありません' means "You do not have permission to perform this activity")
Does this mean this user account doesn't have enough permission?
Let me know if you need further detail.

Regards,
Yuhei

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,191 questions
0 comments No comments
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,602 Reputation points Microsoft Employee
    2022-06-27T22:11:51.58+00:00

    Hello @Anonymous ,

    Thanks for the question and using MS Q&A platform.

    From my understanding you were able to view the table list but when you try to preview the data you are receiving the above error. Please correct if my understanding is incorrect.

    Seems like this issue is from SAP side and not ADF. Below are few issues discussed in SAP knowledge base articles related to similar issues.

    Please refer to above SAP knowledge base articles and see if that helps. And if the solutions discussed in them are not helpful to resolve the issue, then we recommend reaching out in SAP community forum or filing a support ticket with SAP for further analysis.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2022-06-28T09:17:50.893+00:00

    Hi @KranthiPakala-MSFT ,

    Our SAP team added correct role to my account and now I can successfully extract data from APO.
    Thank you for your help!

    Regards,
    Yuhei

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.