PDF's created in SM report an error when opened or printed
Hint Ref: 021102170011
Hint Date: 17/02/2011
Hint Details:
If when opening or printing a PDF created in Space Manager or by a Job Runner process the PDF reader reports that "An error exists on this page. Acrobat may not display the page correctly. Please contact the person who created the PDF document to correct the problem." the following may help
Find any strings that are displayed on the page and cast them as characters. This does seem to apply to sub selects more than straight fields in the main select statement but it is worth trying all the items.
For example:
change (select first c.printnote from contract c join accountlink where accountlink.documentid=iqacdocument.documentid)
to cast((select first c.printnote from contract c join accountlink where accountlink.documentid=iqacdocument.documentid) as char(100))
(Please Note: This Procedure can be destructive and should only be used by Advanced Users. RADical Systems (UK) Limited or its Partners cannot be held responsible, in anyway, for any consequence of using this or any other Database Function, Procedure or SQL command. Responsibility resides solely with the user.
IT IS HIGHLY RECOMMENDED THAT A FULL AND VALID SPACE MANAGER DATABASE BACKUP IS TAKEN AND VERIFIED AS VALID BEFORE MAKING ANY CHANGES TO THE DATABASE.)