Issues with publishing a workflow to my server

[AdmusNets]

Hi guys

I am having a confusing issue. I have a connection to a database called CDP. In CDP I usually fetch data from this table: ref_01_nordic_ci_transactional_overview.fact_rep_acq_trx_agg_day_w_gl_test

The owner of the DB informed me that they are migrating the data from the ref_01. To this à rep_acq_trx_agg_day_w_gl_caps

When testing the connection in my Alteryx from my remote machine: I can pull data and push data, however, whenever I try publishing my data I get this error with the new table:

I did not however receive this error with the first table.

Could you help me guide/assist me with what the issue is?

[fmvizcaino]

Hey @AdmusNets ,

Is this connection using windows authentication? It might be because the server user doesn`t have access to these views/tables.

Best,

Fernando Vizcaino

[AdmusNets]

Hi sir,

It should have a connection, because im already fetching data from the server and that works fine, its as soon as I switch from one table to another, I get that error code. Usually I took the needed data from the Transactional_overview, and afterwards the IT team migrated the data to the VNC table. Im being told that there are no difference in accesibility to the tables, and I can from my own desktop/remote machine access both tables, and fetch data. 

 

[fmvizcaino · Accepted solution]

Hi @AdmusNets ,

If everything else is working except this newly created table, I'd say it's likely an access issue.

I`m not super familiar with Hive, but I would try running a query to check the permissions of the table, just in case. I asked ChatGPT, and it is something like this. SHOW GRANT ON TABLE <database_name>.<table_name>;

A test you can do to guarantee nothing weird is going on is to access Alteryx Server remotely and run the workflow on the Designer Desktop inside the Server machine (using the same user credential that is responsible for running all alteryx server workflows). If the user can`t see the table from the server machine, you have a good argument for them.

Best,

Fernando Vizcaino

[AdmusNets]

Hi sir,

You were completely right, the only issues was 1 additional access to the server -,-...