After upgrading from Tessitura 11 to 12.1 one of our reports is not functioning. I have narrowed it down to a sql table that is returning a null value, for T_PMAP.gl_hold_no but can view the table and have verify that values do exist. Does anyone have an idea what might be wrong with the sql statement below?
SELECT T_PERF.perf_code,T_PERF.perf_dt,
T_PMAP.gl_hold_no,T_TRANSACTION.trn_amt,T_BATCH.post_no
FROM T_TRANSACTION
LEFT OUTER JOIN T_FEE ON T_TRANSACTION.fee_no = T_FEE.fee_noLEFT OUTER JOIN T_FUND ON T_TRANSACTION.fund_no = T_FUND.fund_noLEFT OUTER JOIN T_PMAP ON T_TRANSACTION.pmap_no = T_PMAP.pmap_no
JOIN T_CAMPAIGN ON T_TRANSACTION.campaign_no = T_CAMPAIGN.campaign_noLEFT OUTER JOIN T_BATCH ON T_TRANSACTION.batch_no = T_BATCH.batch_noLEFT OUTER JOIN TR_BATCH_TYPE ON T_BATCH.batch_type = TR_BATCH_TYPE.idLEFT OUTER JOIN T_PERF ON T_TRANSACTION.perf_no = T_PERF.perf_no
WHERE T_TRANSACTION.perf_no>0 AND T_BATCH.post_no = 2382
Unknown said: After upgrading from Tessitura 11 to 12.1 one of our reports is not functioning. I have narrowed it down to a sql table that is returning a null value, for T_PMAP.gl_hold_no but can view the table and have verify that values do exist. Does anyone have an idea what might be wrong with the sql statement below?
Please see a very illustrative post from Paul Kappell below:
http://www.tessituranetwork.com/Community/forums/p/11218/34669.aspx#34669
Thank you I will check this out.