Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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
    • Was this article helpful?