[sqr-users] need assistance with error: Cannot open the printer file

[fschiff@metlife.com]

I have sqr reports which create many reports via a queue mechanism.

Stripped to essentials this is the outer loop:

begin-procedure outer
begin-select
job_id
company_id
file_name
gen_name

   do init-report       ! does new-report, etc.

        do report_section     ! actual selects and print statements

   do done-report ! cleanup including change value of job_status field in
table ic_report_job

from ic_report_job
where rpt_type='{rpt_type}'
  and job_step='Creating'
  and job_status = 'Active'
  and as_of = $actdate
end-select
end-procedure

I often get this error, after the outer loop has gone through many reports.

(SQR 6002) Cannot open the printer file: ABC_02331375.spf
(2): No such file or directory

There does not seem to be any reason for this and I can't track it down.
Any thoughts or a workaround to have it reset itself?



Fred Schiff
Information Systems Consultant
Broker Dealer IT
fschiff@metlife.com
732-734-2155
The information contained in this message may be CONFIDENTIAL and is for the
intended addressee only.  Any unauthorized use, dissemination of the
information, or copying of this message is prohibited.  If you are not the
intended addressee, please notify the sender immediately and delete this
message.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users