XXX50 p_priv_06 (Custom Cash 09) returns no data
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description:
Our Circulation department reported that they got no data when running the DUP50 Custom Cash 09 Report. They get the message, "No rows selected." [ <Jerry Specht > ]
Resolution:
The p_priv_06 (customized p_cash_09) job transfers records with particular z31_transfer_date's and z31_recall_transfer_date's (-- placed there by a preceding p_cash_09 run). The runs today didn't have anything to process since there were no records with the date specified Transaction Date (To) ("2012-09-12").
We did the following SQL to see what cash records there are for what dates in Sept. We see that there are *no* records with dates for 2012-09-12. The only dates we see in Sept are:
20120906 (14 z31_recall_transfer_date's and 27 z31_transfer_date's)
xxx50@ALEPH21> select z31_recall_transfer_date, count(*) from z31 where z31_recall_transfer_date like '201209%' group by z31_recall_transfer_date;
**** Hit return to continue ****
Z31_RECALL_TRANSFER_DATE COUNT(*)
------------------------ ----------
20120906 14
xxx50@ALEPH21> select z31_transfer_date, count(*) from z31 where z31_transfer_date like '201209%' group by z31_transfer_date;
**** Hit return to continue ****
Z31_TRANSFER_DATE COUNT(*)
----------------- ----------
20120906 27
When there's a delay between the running of p_cash_09 and p_priv_06, you need to specify the date of the p_cash_09 run as the Transaction Date (To) in submitting p_priv_06. In this case that's "20120906".
- Article last edited: 12-Mar-2016