In-DB "Datastream Out" not work on Server but in local Designer

[chvizda]

Hi all

I have an In-DB workflow which runs perfect on my Designer

But when I run it from the Gallery on our Server I get following error message:

Error SQLExecute: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;258 insufficient privilege: search table error: insufficient privilege: Not authorized (please check lines: 17) (Tool Id: 30)

Tool ID 30 is a Datastream Out tool.

All other In-DB tools before are running perfect, only this tool makes problems.

The Server runs on version 2020.2 and the designer on 2020.1.5.

Do you have there any ideas ?

Many thanks

Steffen

[RishiK]

@chvizda this is probably to do with the permissions that the user associated to your Server has on that table.  Can you check this?

Alternatively try to set the workflow up on Server to Run As a different user ie. the one that's used in Designer:

https://community.alteryx.com/t5/Alteryx-Server/Run-As-Settings/ta-p/17830

[hroderick-thr]

For quick proof of security problem, run the workflow on server as the service account using designer instead of gallery. For me it is easier to see details of the error and pass them on to dba as a security change request.