Errors bringing custom output set into Wordfly

Nathanael Pearson $organization over 5 years ago

Hello all,

I hope you're doing well and staying safe in these strange times.

We're working on creating some custom fields for an Output Set to use with Wordfly. However, it gives us this error message in Wordfly:

It seems to be having trouble accessing the 'fields' within the Output set, and is thus getting cranky. The SQL view that I created as copy-pasted from Tessitura themselves (found here), and everything else appears to be working- the set works with lists within Tessitura, but Wordfly doesn't like it.

Melissa Scott $organization over 5 years ago

In TR_QUERY_ELEMENT is the check box for Single Row checked on that field? If it isn't, Wordfly will throw an error.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Nathanael Pearson $organization over 5 years ago in reply to Melissa Scott

They are checked off for the two custom elements. I went through the setup provided on the website- as far as I can tell all t's are crossed and i's dotted. I've put in support tickets with Wordfly and Tessitura, but no success yet.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Sheela Sur-Luk $organization over 5 years ago

I haven't seen this specific error before, but I have run into problems with output sets and WordFly getting along when control groups are in play. If anything in your list or output set references something that is control grouped outside of whatever group(s) your Tess Wordfly user is in, it might not work correctly.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Nathanael Pearson $organization over 5 years ago in reply to Sheela Sur-Luk

All our elements use the same control group.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Former Member $organization over 5 years ago

I've had this issue when permissions weren't properly granted to the view. Have you checked in SSMS that impusers and tessitura_app have got the correct permissions on the view? Thanks

Kerry
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Nathanael Pearson $organization over 5 years ago in reply to Former Member

The view setup query did include the impuser / tessitura_app permissions:
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel