• Replies 5 replies
  • Subscribers 338 subscribers
  • Views 53 views
  • Users 0 members are here
Related

Custom Report(Infomaker) issue

Renu Singh
$organization

HI,

I have been trying to fix a problem which is due to incompatibility between a customized report New contribution and ft_get_address sql function. This function has changed in v12 and has a new parameter @allow_multiple_contact_points. I have changed the report setup to accomodate the new parameter:  List Filter Acts Upon

But still I am getting error related to ft_get_address:

An insufficient number of arguments were supplied for the procedure or function ft_get_address

Does anyone where can we see this function is being called from and fix the problem.

Regards,

Renu.

 



[edited by: Renu Singh at 7:37 PM (GMT -6) on 12 Mar 2014]
Parents
  • $organization

    Hi all,

     

    Another option is a free product called SQL Search by Red Gate. It plugs into SSMS and essentially allows you to search all objects in a database for specific text. For example, you could use it to find all procedures that reference the ft_get_address function. Once you find it, there is an option to quickly jump to the object you want to work with.

     

    You can get it here: http://www.red-gate.com/products/sql-development/sql-search/.

     

    Thanks,

    David

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gawain Lavers
    Sent: Friday, March 14, 2014 1:16 PM
    To: David Frederick
    Subject: Re: [Tessitura Technical Forum] Custom Report(Infomaker) issue

     

    Hi Renu,

    I just hit that issue.  I'm pretty sure there are ways within T-SQL to discover dependencies, but I've never had much luck with them, so I created my on SP to methodically dig through objects in the database looking for any textual reference to the object I'm looking for.  I could post it here, perhaps, or maybe someone can post a way to use internal procedures.

    --Gawain

    From: Renu Singh <bounce-renusingh8802@tessituranetwork.com>
    Sent: 3/12/2014 7:34:13 PM

    HI,

    I have been trying to fix a problem which is due to incompatibility between a customized report New contribution and ft_get_address sql function. This function has changed in v12 and has a new parameter @allow_multiple_contact_points. I have changed the report setup to accomodate the new parameter:  List Filter Acts Upon

    But still I am getting error related to ft_get_address:

    An insufficient number of arguments were supplied for the procedure or function ft_get_address

    Does anyone where can we see this function is being called from and fix the problem.

    Regards,

    Renu.

     




    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

    Hi all,

     

    Another option is a free product called SQL Search by Red Gate. It plugs into SSMS and essentially allows you to search all objects in a database for specific text. For example, you could use it to find all procedures that reference the ft_get_address function. Once you find it, there is an option to quickly jump to the object you want to work with.

     

    You can get it here: http://www.red-gate.com/products/sql-development/sql-search/.

     

    Thanks,

    David

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gawain Lavers
    Sent: Friday, March 14, 2014 1:16 PM
    To: David Frederick
    Subject: Re: [Tessitura Technical Forum] Custom Report(Infomaker) issue

     

    Hi Renu,

    I just hit that issue.  I'm pretty sure there are ways within T-SQL to discover dependencies, but I've never had much luck with them, so I created my on SP to methodically dig through objects in the database looking for any textual reference to the object I'm looking for.  I could post it here, perhaps, or maybe someone can post a way to use internal procedures.

    --Gawain

    From: Renu Singh <bounce-renusingh8802@tessituranetwork.com>
    Sent: 3/12/2014 7:34:13 PM

    HI,

    I have been trying to fix a problem which is due to incompatibility between a customized report New contribution and ft_get_address sql function. This function has changed in v12 and has a new parameter @allow_multiple_contact_points. I have changed the report setup to accomodate the new parameter:  List Filter Acts Upon

    But still I am getting error related to ft_get_address:

    An insufficient number of arguments were supplied for the procedure or function ft_get_address

    Does anyone where can we see this function is being called from and fix the problem.

    Regards,

    Renu.

     




    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
No Data