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?
Could the set up for the phone1 and phone2 output elements have been changed? Or is there an alternate custom version of these elements that may have been used for this output set?
When you execute an Output Set it generates the same address and phone information as a List or extraction when you use the standard elements for these. So it might be worth looking at the elements being used.
Cheers
S.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Amanda Freeman Sent: Friday, 8 October 2010 5:33 AM To: Sandra Ashby Subject: [Tessitura Technical Forum] Out Put Set Phones Blank
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!
The elements being used are definitely the standard elements, unedited. If I were trying to mimic what happens when we execute an output set using the phone_1 and phone_2 elements, should I use "AP_LIST_REPORT" and the "called from"? I just tried that and get phones returned in ssms...
Anybody have any other ideas why phones might be blank from output sets?
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
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.