Hi,
Our conservatory came across an old report that they'd like to run again. The only problem is the report comes up blank when you run it. I've done some basic troubleshooting and found that it's joining a local table lt_class_sched to t_perf and tr_season
just for clarity:
into #temp
from lt_class_sched a
join t_perf b on
a.inv_no = b.perf_no
join tr_season c on
b.season = c.id
where b.season = @season
and
b.perf_code = @perf_code
I've done some investigation and found the report is blank because there is no corresponding inv_no in the lt_class_sched. The perf_no does exist in t_perf however.
My question is, how do I find what populates LT_CLASS_SCHED?
I've checked dependencies for the table in SQL and LT_CLASS_SCHED shows no dependencies, though a number of things depend on it.
Any ideas/suggestions are greatly appreciated.
Thanks
Nick, did you ever find that script?
Nick, did you ever find that script?From: Nick Torres <bounce-nicktorres3067@tessituranetwork.com>Sent: 3/18/2016 11:42:38 AMHi, Our conservatory came across an old report that they'd like to run again. The only problem is the report comes up blank when you run it. I've done some basic troubleshooting and found that it's joining a local table lt_class_sched to t_perf and tr_season just for clarity: into #temp from lt_class_sched a join t_perf b on a.inv_no = b.perf_no join tr_season c on b.season = c.id where b.season = @season and b.perf_code = @perf_code I've done some investigation and found the report is blank because there is no corresponding inv_no in the lt_class_sched. The perf_no does exist in t_perf however. My question is, how do I find what populates LT_CLASS_SCHED? I've checked dependencies for the table in SQL and LT_CLASS_SCHED shows no dependencies, though a number of things depend on it. Any ideas/suggestions are greatly appreciated. ThanksThis 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!
From: Nick Torres <bounce-nicktorres3067@tessituranetwork.com>Sent: 3/18/2016 11:42:38 AM
No worries. Is this a case where you guys migrated to RAMP recently, and a lot of the custom code you inherited is pre-RAMP?
If you're trying to figure out where that table was being updated, here are a few places you'd want to check:
The Agent Jobs you likely also don't have access to if you don't have access to create SPs, so ask for that as well. There is a non-zero chance, however, that whatever agent job might have being doing the work was lost during your upgrade.
Another, worse case scenario is that the updating script was cleverly attached to a trigger on a Tessitura table. In that case it has almost certainly been blown away during a Tessitura upgrade, and is likely lost forever.
One thing I did shortly after taking my current job was to Script To > CREATE every single custom element I could find in the database (and a few other tables designed to be customized, such as LP_CUSTOMER_RANK) so that I could keep them as files under source control.