Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!

Alteryx Server Discussions

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

Sharepoint Input. Runs on local, fails on server

BonusCup
9 - Comet

Hi,

 

I originally posted this on the Designer board but since I'm having issues on the Server side, thought I should move it here.

 

I'm using SharePoint Input v2.3.0 and created a simple WF that successfully runs on my local Designer.  For automation purposes, I'm using the 'App Sign In (Use Service Principal)' option.

 

When I saved the WF to the Gallery and ran it I received the below error:
 <class 'ValueError'>: Required fields cannot be empty. (ToolId: 1)

 

When I pull in the same WF from the Gallery and run it in Designer on the Server, I receive this error:

Error: SharePoint Input (1): Provided Azure application does not have required permissions for scheduling. Either disable 'use service principal' or provide an Azure app with required permissions and login again.

 

Has anyone ran into this and how did you resolve?  TIA

2 REPLIES 2
BonusCup
9 - Comet

@gabrielvilella, thanks for all the links.  After going through the documentation again I was able to get everything resolved.  I failed to set up DCM on both my local and server side.  

 

There seems to be a lot of references to “Service Principal” which took some time with trial and errors. 

 

While setting up new credentials, there are three different options for ‘Sharepoint Input Service Principal’.  The first and third ask for the same inputs while the second one asks for the ThumbPrint and Private key. 

 

BonusCup_0-1679318798799.png

 

 

BonusCup_1-1679318798808.png

 

  

BonusCup_2-1679318798816.png

 

While setting up the Data Source there are also two ‘Service principal’ options.  The first one listed the credentials I had created and the other one did not.

BonusCup_3-1679318798830.png

 

 

BonusCup_4-1679318798839.png

 

BonusCup_5-1679318798848.png