So I've just heard from a user that her output set is displaying blank phones for everyone, both phone1 and phone2. We tried it against multiple lists, all lists of people we're sure have phone numbers, and it's still coming up blank on everyone. I checked tr_query element and it's set up the default way for both phone1 and 2. We haven't modified LP_GET_PHONES in years. I definitely know we've been able to get phones from an output set before. We don't have any special logic for any particular called_from. I've run a number of reports that use ap_get_phones and they're all still displaying the phone numbers. I'm stumped. Any suggestions on where else to look?
Amanda it might be worth opening a TASK Ticket for this so someone can look over your setup.
In the meantime it might be worth having a little look at your LP_GET_PHONES as it hasn’t been changed in ages, there may be something in there that deals with when it’s called from rp_run_query that is no longer appropriate and hence returning no phone values.
Cheers
Sandra
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Amanda FreemanSent: Thursday, 11 August 2011 8:47 AMTo: Sandra AshbySubject: RE: [Tessitura Technical Forum] Out Put Set Phones Blank
Thanks, yes. I ran a trace and realized from that it's rp_run_query. I didn't see anything red-flaggy in the trace, but I could be missing it.
The output set actually is old; it's one we've used before successfully. I tried creating a new one too, same problem. I executed ap_get_phones for random customers in the list for their primary addresses and @called_from='rp_run_query' and when I do that, the phones show up.
I tried every output set we have that has phone elements in it and they all do the same thing, but other reports that use ap_get_phones are totally showing the phone info.
From: Andrea Crain <bounce-andreacrain8512@tessituranetwork.com>Sent: 8/10/2011 3:59:54 PM
Did you do a trace in Profiler while running the output set? What did it show you?
Also, did you try running an older output set that had phones as one of the elements that have been used successfully to check that the older output set still works?
Edited to add, It looks like it's RP_RUN_QUERY when I do a trace, not ap_list_report:
execute dbo.RP_RUN_QUERY @query_no = 2636, @list_no = 261, @mail_dt = null, @mail_type = null, @label_no = null, @signor = null, @eaddress_type = null, @eaddress_purpose = null, @eaddress_market_ind_no = null, @memb_org_no = null
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!