Error loading on Server: The output connection "Output5" was not valid

Hi everyone.

I am stumped by this error. The workflow is simple with a simple macro in it. It works perfectly fine (if not a little slow) on my desktop. When I load it to server I get the "The output connection was not valid" and I can't figure it out since there is really no config for macro output so I dont get what this error could mean.

I tried deleting it and putting in a new macro output tool, but that didn't work. Not sure what else to do here, since it works fine on my laptop.

Does anyone have any pointers to solve this, as getting this process to work on Server is of critical need to one of my projects.

WF.png

macro.png

Output

Server

Batch Macro

Sharepoint

Accepted answers

danilang

Hi @DanielG

The crux of your issue is the ...ended by a downstream tool message. When run on your desktop, the final Browse tool is enough to have the macro complete. When run on Server, the app sees that the output will not be used anywhere, so stops it after one iteration. Browse tools are not a useful output when run the server. Add an output to either excel or .yxdb in your main workflow and the process will run 'til the end.

Dan

All comments

DanielG

And pay no attention to the sloppiness of my select tool before AND after the datetime tool... 😁😬

danilang

Hi @DanielG

Can you post a screenshot of all the errors that you see in the output log?

Dan

DanielG

@danilang thanks for responding. This is what I am seeing. "Upload error.png" is what I see on the Designer pop-up after loading it to server. "Error listing on Server.png" is what I see after reviewing the process on Server. "Run on server result.png" is what happens when I try to run it on Server. My sample test has 21 files with over a million total rows of data (across all files, not on each file). Process runs to completion on desktop in about 6-7 minutes. The process on server appears to only get the 21 file names from the initial SP tool run then the macro shuts the process down for unknown (to me) reason 😊

error listing on Server.png

run on server result.png

Upload error.png

danilang

Hi @DanielG

Dan

DanielG

@danilang -- thanks so much for the assist. I thought I was doing myself a favor by simplifying the workflow for testing purposes... Have a great weekend.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703