Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

ALTERYX GALLERY Work Flow FAILS - Error running PreSQL

srikant96
9 - Comet

No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command. (Tool Id: 3)

 

Works perfect in the desktop wondering if this DSN in Gallery is an issue ?

4 REPLIES 4
TrevorS
Alteryx Alumni (Retired)

Hello @srikant96 ,


Can you please include a screenshot of the error message you are getting?

Thanks!

TrevorS

Community Moderator
srikant96
9 - Comet
ACTIVE WAREHOUSE, DATABASE, SCHEMA was missing and hence it failed .Desktop worked fine because , these things were built in differently
srikant96
9 - Comet

use warehouse xxx;
use database.schema;

 

Adding these helped solve the issues I was facing 

 

Thank You 

Devon
6 - Meteoroid

I got some help internally for this one but wanted to post the solution that worked for us. We ended up needing to add the USE WAREHOUSE XXX to the "Pre SQL Statement"

 

Edit: Update image