Print PDF or RTF letter works localhost but not on VPS

[Hansolo]

Have a letter to print in PDF based on data in the .dbf. All works fine published to localhoast. Code for sending to PDF basically comes from help file.

<%a5

if eval_valid("Id")
    if Id[1] = ""
        goto IdNotSpecified
    end if
    dim filter as c
    dim order as c
    filter = Id.dump()
    filter = *for_each(x,"Id = " + val(x),filter)
    filter = strtran(alltrim(filter), crlf()," .or. ")
    order = ""
	pSet.JpegQuality="High"
    dim filename as c
    filename = session.session_folder + chr(92) + "templetter.pdf"
    filename = letter.saveas("individual_ltr@[PathAlias.ADB_Path]\supplementaldata.dbf","PDF",filter,order,filename,.f., pSet)
    if file.exists(filename)
        response.redirect(session.session_url + "templetter.pdf?" + time("hms3"))
        end
    end if
else
    IdNotSpecified:
end if
%>

Published all files (including data files) so the letter is there on the VPS.

The error I get is below. It is not the error that is trapped by the code but seems to indicate a path problem.

500 Internal Server Error
"Script Error
Error:
Amyuni Low Level Print:
Layout name: individual_ltr@[PathAlias.ADB_Path]\...mentaldata.dbf
Layout type: letter
Letter not found: 'individual_ltr@[PathAlias.ADB_Path]\supplementaldata.ddd'."

My Alias is defined as

[PathAlias.ADB_Path] = c:\A5V9\data\FitSup

in the setting for publishing to the VPS. It is correct in terms of the absolute path to the data files. I have verified that they are there and they are the ones I published. Have done it several times.

I thought this might just be a case of not having Acrobat on the VPS but even if I try to print an RTF or CSV, I get the same error.

Any ideas would be appreciated.

[Steve Wood]

Re: Print PDF or RTF letter works localhost but not on VPS

This part is wrong:

\supplementaldata.dbf",

should be : \supplementaldata.ddd",

[Hansolo]

Re: Print PDF or RTF letter works localhost but not on VPS

Thanks. Tried that. Error is about the same:

500 Internal Server Error
"Script Error
Error:
Amyuni Low Level Print:
Layout name: 'individual_ltr@[PathAlias.ADB_Path]\supplementaldata.ddd
Layout type: letter
Letter not found: 'individual_ltr@[PathAlias.ADB_Path]\supplementaldata.ddd'."

Either .dbf or .ddd will work on the localhost.

Neither .dbf or .ddd works on the VPS.

Alpha Printer is setup on the VPS.

[Hansolo]

Re: Print PDF or RTF letter works localhost but not on VPS

Steve,

Since this error is being returned from the Alpha Server on the VPS, shouldn't [PathAlias.ADB_Path] be resolved and reporting the absolute path in the reported error? Or I guess maybe the problem with the Script never lets it get that far. Slightly confused.

500 Internal Server Error
"Script Error
Error:
Amyuni Low Level Print:
Layout name: 'individual_ltr@[PathAlias.ADB_Path]\supplementaldata.ddd
Layout type: letter
Letter not found: 'individual_ltr@[PathAlias.ADB_Path]\supplementaldata.ddd'."

[Tommy Thompson]

Re: Print PDF or RTF letter works localhost but not on VPS

Try changing the [PathAlias.ADB_Path] to the actual path (c:\xxxx) and see if that works. If it does then at least you know where the problem lies. If it does not work, then make sure you have published the report to the server. In my case, that is usually the problem.

[Steve Wood]

Re: Print PDF or RTF letter works localhost but not on VPS

The error always shows the alias if one is used. How do you know your report is on the server? Did you publish your database files?

[Mike Reed]

Re: Print PDF or RTF letter works localhost but not on VPS

One other thing to check is to see if the VPS server is 32bit or 64bit. If it is 64bit, then you need to make some modification to the PDF driver. Do a search on this board for 64 bit pdf driver and you will find a post about how to make the change. It is easy to do.

mike

[Hansolo]

Re: Print PDF or RTF letter works localhost but not on VPS

This is ther error after providing the absolute path instead of [PathAlias.ADB_Path] which is set to the same path anyway.

500 Internal Server Error
"Script Error
Error:
Amyuni Low Level Print:
Layout name: 'individual_ltr@c:\A5V9\data\FitSup\supplementaldata.ddd
Layout type: letter
Letter not found: 'individual_ltr@c:\A5V9\data\FitSup\supplementaldata.ddd'."

Steve, I am positive the files have been published. I have RDCed into the VPS and short of a checksum algorithm I have verified the size and date/time of the database files. Originally I published them and specified the database files also be published. I have sence published again and copied and pasted using RDC just to make sure.

I seem to have partely cured it by compacting the database and then publishing again. But now the PDF does not show all the images (they were embedded by the way). Before compacting the .DDM file was over 14 MB in size. After compacting it is just over 8 MB and works partly now.

I really think there is a file size issue with these report and letter formats. I have several images in my letter which seem to bloat it even though the images themselves are quite small.

Anyone create letters and reports with several images that can report on how it worked on the WAS?

Chuck

[Hansolo]

Re: Print PDF or RTF letter works localhost but not on VPS

Multipule compacting has the .ddm file size down to just over 4 MB now. It now works very well on the VPS.

One other issue now is the fact that the PDF formatting is not the same as returned by the WAS on the VPS as it is on the localhost. Fonts look the same but space between paragraphs and images is different and underline and bold is much bigger in the PDF returned from the WAS on the VPS. This resulted in page overruns. I have corrected the formatting to account for it but at lost to explain it. Using the same Alpha print driver on the local host and WAS.