Re: [sqr-users] PDF Files created by SQR

[Eric Dimick Eastman <erice@ontko.com>]

Penny and others in this thread,

Your problems sound similar to one I had quite a while ago.  They are 
tricky to debug because the symptom only happens occasionally.  If I recall 
correctly, the problem was that our automatic processing of the PDF started 
before SQR was completely done generating the file.

If you are running the SQR with the "-printer:pd" the final rendering of 
the PDF file seems to happen asynchronously.  Try running the SQR with the 
"-nolis" option and then explicitly calling sqrp to generate the PDF file.

Hope this helps,
Eric

Penny J. Heeren wrote:

> We are creating several PDF files from various SQR programs with the
> following code section:
> 
>   declare-report report7          ! Image file report .pdf format
>     printer-type=pd
>     layout=layout7
>   end-declare
> 
> This file is then picked up by another process, and emailed to a
> recipient. Occasionally, the file received by the user is unable to be
> opened by Adobe Reader, with an error "Unable to open file, file has
> been corrupted". If we rerun the SQR program to generate the file again,
> the emailed file works this time. Since my manager has handled this in
> the past and not gotten me involved, I haven't had a chance to look at
> the file before it gets rewritten to see if it's corrupted on our server
> before it goes out in the email or if it's corrupted by the email/by
> sending the email/by receiving the email. I've made sure he knows that I
> want to see the file before it's replaced the next time this happens, as
> it's entirely possible this isn't an SQR issue, but an email issue...
> however, he wanted me to ask for feedback from the user group in case
> someone else has encountered this.
> 
> Additionally, if the recipient has a Yahoo mail account, that software
> treats the attached file as part of the body and displays the binary
> data in the body of the file. I'm 99.9% certain that has nothing to do
> with SQR nor the content of the file, but the way the file is attached.
> It's been a problem for some other email programs, but, for example,
> works fine consistently on Hotmail. The program that actually identifies
> that there is a file to be emailed and generates the email is a custom
> application built by a coworker using ASP running on Windows 2000, and
> interfaces with Microsoft Exchange to create the email from data stored
> in a flat text file that contains sender, recipient, subject, body, and
> if there is an attachment, the file path for the attachment file.
> 
> SQR version is 8.0, running on RedHat Advanced Server Linux box.
> 
> Has anyone else had issues like this or any ideas of a better way to do
> this? 
> 
> Penny Heeren
> DBA/Programmer Analyst
> Newton Manufacturing Co
> e-mail: pheeren@newtonmfg.com
> phone: 641-791-4242
> 
> _______________________________________________
> 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