Constituency end date and name

Thanks Beth for that … that’ll teach me to copy and paste!

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Beth Gilliland
Sent: Wednesday, 13 March 2013 3:41 PM
To: Sandra Ashby
Subject: Re: [Tessitura Technical Forum] Constituency end date and name

Actually, now that I look at the Cookbook more closely, it looks like there is a typo at the end of the SQL to create the view. On page 13 it says:

GRANT REFERENCES, SELECT on [LVS_CONT_RECENT_DT] to impusers
GO

When it should actually say:

GRANT REFERENCES, SELECT on [LVXS_CONST_CUST_EXPIRED] to impusers
GO

It's granting permissions to a different view - possible one you don't even have! Hopefully that can get changed in the documentation... :)

Beth

Hi there,

I am using the Output Set Builder Cookbook for V11 (July 2012) and trying to get the Constituency end date and name output set working.

When I try and run the view SQL (LVXS_CONST_CUST_EXPIRED), I get an error that the view doesn't currently exist. I modified the code from ALTER VIEW to CREATE VIEW and ran it successfully. Now, when I try and use execute the output set I get the following error:

Invalid column name 'start_dt'
execute dbo.RP_RUN_QUERY;1 @query_no = 28, @list_no = 0

Any ideas why this isn't working?

Thanks,

David Geoffrey Hall

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Thanks Beth for that … that’ll teach me to copy and paste!

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Beth Gilliland
Sent: Wednesday, 13 March 2013 3:41 PM
To: Sandra Ashby
Subject: Re: [Tessitura Technical Forum] Constituency end date and name

Actually, now that I look at the Cookbook more closely, it looks like there is a typo at the end of the SQL to create the view. On page 13 it says:

GRANT REFERENCES, SELECT on [LVS_CONT_RECENT_DT] to impusers
GO

When it should actually say:

GRANT REFERENCES, SELECT on [LVXS_CONST_CUST_EXPIRED] to impusers
GO

It's granting permissions to a different view - possible one you don't even have! Hopefully that can get changed in the documentation... :)

Beth

Hi there,

I am using the Output Set Builder Cookbook for V11 (July 2012) and trying to get the Constituency end date and name output set working.

When I try and run the view SQL (LVXS_CONST_CUST_EXPIRED), I get an error that the view doesn't currently exist. I modified the code from ALTER VIEW to CREATE VIEW and ran it successfully. Now, when I try and use execute the output set I get the following error:

Invalid column name 'start_dt'
execute dbo.RP_RUN_QUERY;1 @query_no = 28, @list_no = 0

Any ideas why this isn't working?

Thanks,

David Geoffrey Hall

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!