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.
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
Unknown said: 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
I'm very familiar with that error as I've been working on getting all of our reports v12-compatible. Under v11, this syntax was correct for that function, e.g.:
outer apply [FT_GET_ADDRESS] (GETDATE(), null, null, o.customer_no) b
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
From: Renu Singh <bounce-renusingh8802@tessituranetwork.com> Sent: 3/12/2014 7:34:13 PM
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!
Unknown said: Does anyone where can we see this function is being called from and fix the problem.
I see that I misread before my reply above, sadly. A hazard on busy days. When I want to find strings in sprocs, though, I usually use:
SELECT distinct object_name(id)
FROM syscomments
WHERE text LIKE '%FT_GET_ADDRESS]%'
order by object_name(id)
Hi Chris,
Thanks for your help. I did the same thing before I saw this message. This was the fix(Adding fifth parameter in ft_get_address) and it works fine now.
If I would have seen this before I would have saved a lot of time. But neverthelless thank you so much and I will reach out to this forum next time I need help.