Automate

Hi,

I try to run a scheduled query but I get an error message: The current user is not authorized to view this data
Does anyone have the solution to this problem?
I do have a Query license.

Regards, Tom

------------------------------
Tom Schurink |
Signify Netherlands B.V. |
------------------------------

Hi Tom,

Can you run the query interactively, i.e. do you have access to the table data?    If so, are you using the same SAP credentials when you schedule to run the query?  

If not, you may need access, as sometimes scheduled queries are using service accounts.

If permissions are not an issue,  I would suggest opening a support ticket.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Hi Sigrid,

Yes I have access to the table data and yes I'm using the same SAP credentials.
I have created a support ticket for CTAC, thanks.

Regards,
Tom

------------------------------
Tom Schurink |
Signify Netherlands B.V. |
------------------------------

Original Message:
Sent: 12-09-2020 08:44
From: sigrid kok
Subject: Query error message

Hi Tom,

Can you run the query interactively, i.e. do you have access to the table data?    If so, are you using the same SAP credentials when you schedule to run the query?

If not, you may need access, as sometimes scheduled queries are using service accounts.

If permissions are not an issue,  I would suggest opening a support ticket.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Hi Sigrid,

We finally managed to run the queries, the problem was the SAP user authorizations.

Regards,

Tom

------------------------------
Tom Schurink |
Signify Netherlands B.V. |
------------------------------

Original Message:
Sent: 12-09-2020 08:53
From: Tom Schurink
Subject: Query error message

Hi Sigrid,

Yes I have access to the table data and yes I'm using the same SAP credentials.
I have created a support ticket for CTAC, thanks.

Regards,
Tom

------------------------------
Tom Schurink |
Signify Netherlands B.V. |
------------------------------


Original Message:
Sent: 12-09-2020 08:44
From: sigrid kok
Subject: Query error message

Hi Tom,

Can you run the query interactively, i.e. do you have access to the table data?    If so, are you using the same SAP credentials when you schedule to run the query?

If not, you may need access, as sometimes scheduled queries are using service accounts.

If permissions are not an issue,  I would suggest opening a support ticket.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA

Glad it's working, Tom!  Thanks for letting us know!

Happy holidays!

Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Original Message:
Sent: 12-21-2020 07:44
From: Tom Schurink
Subject: Query error message

Hi Sigrid,

We finally managed to run the queries, the problem was the SAP user authorizations.

Regards,

Tom

------------------------------
Tom Schurink |
Signify Netherlands B.V. |
------------------------------


Original Message:
Sent: 12-09-2020 08:53
From: Tom Schurink
Subject: Query error message

Hi Sigrid,

Yes I have access to the table data and yes I'm using the same SAP credentials.
I have created a support ticket for CTAC, thanks.

Regards,
Tom

------------------------------
Tom Schurink |
Signify Netherlands B.V. |


Original Message:
Sent: 12-09-2020 08:44
From: sigrid kok
Subject: Query error message

Hi Tom,

Can you run the query interactively, i.e. do you have access to the table data?    If so, are you using the same SAP credentials when you schedule to run the query?

If not, you may need access, as sometimes scheduled queries are using service accounts.

If permissions are not an issue,  I would suggest opening a support ticket.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA