• Replies 3 replies
  • Subscribers 358 subscribers
  • Views 24 views
  • Users 0 members are here
Related

MP_Review_Customizations SP not showing all SP's

Former Member
Former Member $organization

Hi,

I noticed that when MP_Review_Customizations runs (either manually in SMS or via the report)  its missing some of our custom procedures.  For example I know for a fact that a few of our Report SP's with a prefix of "LRP" are not showing up as output.

I took a look at the SP, and as far as I can tell it should be picking up any and every SP that starts with an "L"...

(OBJECT_NAME(id) like 'L%'

Yet its not picking some of our LRP_ procedures up.

Anyone have any ideas?

Porter Venn (San Francisco Opera)



[edited by: Porter Venn at 5:17 PM (GMT -6) on 23 Mar 2012]
  • $organization

    Porter

    If this report is not working properly I would submit a TASK ticket to report the problem. 

    Anna

  • $organization

    That procedure is not meant to display all custom procedures, only those that have key terms like xref, n1n2, name2, street1, T_ADDRESS, T_EADDRESS, T_PHONE and T_CUST_ACTIVITY%CATEGORY somewhere in the text.  Right above the code you quote is:

    WHERE [text] LIKE @cur_like

    @cur_like is a variable that represents the search term looked for in that iteration of the loop.

    If you know that the procedure(s) missing from the report contain references to these columns or tables, then I'll repeat Anna's suggestion to open a help ticket so we may investigate further.  Including a copy of a sample proc that you think should have been included would be helpful.  

     

  • Former Member
    Former Member $organization

    Ah ok, that makes sense,  I miss understood that part.

     

    Thanks Brian!

     

    Porter

     

     

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Brian Pedaci
    Sent: Wednesday, March 28, 2012 11:15 AM
    To: Porter Venn
    Subject: Re: [Tessitura Next Generation Forum] MP_Review_Customizations SP not showing all SP's

     

    That procedure is not meant to display all custom procedures, only those that have key terms like xref, n1n2, name2, street1, T_ADDRESS, T_EADDRESS, T_PHONE and T_CUST_ACTIVITY%CATEGORY somewhere in the text.  Right above the code you quote is:

    WHERE [text] LIKE @cur_like

    @cur_like is a variable that represents the search term looked for in that iteration of the loop.

    If you know that the procedure(s) missing from the report contain references to these columns or tables, then I'll repeat Anna's suggestion to open a help ticket so we may investigate further.  Including a copy of a sample proc that you think should have been included would be helpful.  

     

    From: Porter Venn <bounce-portervenn1941@tessituranetwork.com>
    Sent: 3/23/2012 5:17:08 PM

    Hi,

    I noticed that when MP_Review_Customizations runs (either manually in SMS or via the report)  its missing some of our custom procedures.  For example I know for a fact that a few of our Report SP's with a prefix of "LRP" are not showing up as output.

    I took a look at the SP, and as far as I can tell it should be picking up any and every SP that starts with an "L"...

    (OBJECT_NAME(id) like 'L%'

    Yet its not picking some of our LRP_ procedures up.

    Anyone have any ideas?

    Porter Venn (San Francisco Opera)




    You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!