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