Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    cir-30: TMPTABLE ... table or view does not exist

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Problem Symptoms:
    p_cir_30, being run from the job_list, gets the following error:

    xxx50.TMPTABLE
    *
    ERROR at line 9:
    ORA-00942: table or view does not exist

    Cause:
    Error in the parameter list of the p_cir_30 submission.

    Resolution:
    Submit the job via the GUI Services and examine the (by definition, correct) parameters as seen in the $alephe_scratch job log.

    Correct the parameters in the job_list entry.

    Additional Information

    Depending on the "Group Results by" value specified in the submission $aleph_proc/p_cir_30 invokes one of the following $alephm_root/sql_stat/ procs:

    cir_stat_07_stat_bor_param.sql:
    cir_stat_08_stat_date_param.sql:
    cir_stat_09_stat_itm_param.sql:
    cir_stat_10_stat_mat_param.sql:

    Each of these sql's does:

    /* Ensure our temporary table does not already exist */
    drop table &&1..TMPTABLE;
    ...
    create table &&1..TMPTABLE
    ...
    select
    &&1..TMPTABLE.SUBLIBRARY,
    <etc.>

    Thus, it would seem that the message could occur in the select if the create fails for some reason.

    Category: Circulation (500)


    • Article last edited: 12/15/2014
    //doorbell.io feedback widged