RE: [sqr-users] need assistance with error: Cannot open the printerfile

["Knapp, Richard" <KnappR@umsystem.edu>]

My guess would be that the OS is printing the contents of the file then
deleting it.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu
-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
fschiff@metlife.com
Sent: Wednesday, January 19, 2005 8:56 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] need assistance with error: Cannot open the printer
file

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

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