• Replies 6 replies
  • Subscribers 336 subscribers
  • Views 104 views
  • Users 0 members are here
Related

Constituency end date and name

David Geoffrey Hall
$organization

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

Parents
  • $organization

    Geoffrey

     

    Have found the issue – I left out a column name – start_dt

     

    Use this in data_from

     

    (select a.customer_no, c.description, a.constituency, a.end_dt, a.start_dt from LVXS_CONST_CUST_EXPIRED a join vrs_constituency c on a.constituency = c.id)

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Geoffrey Hall
    Sent: Wednesday, 13 March 2013 4:34 PM
    To: Sandra Ashby
    Subject: Re: [Tessitura Technical Forum] Constituency end date and name

     

    Hi Beth,

    Good pick up! I've now granted the correct permissions for the view but am still getting the same error.

    Very curious indeed. I'll keep digging.

    dgh

    From: Beth Gilliland <bounce-bethgilliland6030@tessituranetwork.com>
    Sent: 3/12/2013 11:26:31 PM

    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




    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!

Reply
  • $organization

    Geoffrey

     

    Have found the issue – I left out a column name – start_dt

     

    Use this in data_from

     

    (select a.customer_no, c.description, a.constituency, a.end_dt, a.start_dt from LVXS_CONST_CUST_EXPIRED a join vrs_constituency c on a.constituency = c.id)

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Geoffrey Hall
    Sent: Wednesday, 13 March 2013 4:34 PM
    To: Sandra Ashby
    Subject: Re: [Tessitura Technical Forum] Constituency end date and name

     

    Hi Beth,

    Good pick up! I've now granted the correct permissions for the view but am still getting the same error.

    Very curious indeed. I'll keep digging.

    dgh

    From: Beth Gilliland <bounce-bethgilliland6030@tessituranetwork.com>
    Sent: 3/12/2013 11:26:31 PM

    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




    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!

Children