We just switched our web app from one ZebraHost Server to a different ZebraHost Server. Now we are unable to stitch together PDF's. We have some documents that we print that are just composed of one report. These print great for all users. But most of our documents are composed of multiple reports that appended together to make the final PDF document. The error we are getting is:
500 Internal Server Error
Script Error
Error:Could not append file. File is in use. 'C:\A5webroot\Yellow_Web\session_folders-81\bb72eba3e4f346a9aa78ef19db8ffa88\tempreport2.pdf'.
Alpha Five Application Server/11.0 Build/3381-4096 at Yellow Port 81
We are running multiple instances on the WAS just like we were on the old server. These are setup on ports 81, 82 and 83.
This worked great on the old ZebraHost server. I think it is a security issue. If anyone has a suggestion please let me know.
Here is my code for appending the reports. This has worked for two years without issues:
<%a5
filename = session.session_folder + "tempreport.pdf"
filename2 = session.session_folder + "tempreport2.pdf"
filename3 = session.session_folder + "tempreport3.pdf"
filename35 = session.session_folder + "tempreport35.pdf"
filename4 = session.session_folder + "tempreport4.pdf"
filename5 = session.session_folder + "tempreport5.pdf"
filename6 = session.session_folder + "tempreport6.pdf"
filename7 = session.session_folder + "tempreport7.pdf"
filename8 = session.session_folder + "tempreport8.pdf"
filename9 = session.session_folder + "tempreport9.pdf"
filename10 = session.session_folder + "tempreport10.pdf"
filename11 = session.session_folder + "tempreport11.pdf"
filename12 = session.session_folder + "tempreport12.pdf"
cvar_coapp=lookupl("F",pro_id,"Two_Signers","[PathAlias.ADB_Path]\tax_worksheet","pro_Id")
payment_method=lookupc("F",pro_id,"phase1_method","[PathAlias.ADB_Path]\tax_worksheet","pro_Id")
filename = report.saveas("Tax_JAW_1@[PathAlias.ADB_Path]\tax_paperwork.set","pdf","pro_id = " + quote(pro_id),"",filename,.f.)
filename2 = Report.saveas("Tax_JAW_2@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename2,.f.)
pdf_append(filename,filename2)
filename2 = Report.saveas("Tax_JAW_3@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename3,.f.)
pdf_append(filename,filename3)
'filename2 = Report.saveas("Tax_JAW_4@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename35,.f.)
'pdf_append(filename,filename35)
if payment_method="Bank" then
filename2 = Report.saveas("Tax_ACH_P1@[PathAlias.ADB_Path]\tax_paperwork_phase1.set","PDF","pro_id = " + quote(pro_id),"",filename4,.f.)
pdf_append(filename,filename4)
else
filename2 = Report.saveas("Tax_Credit_Card_P1@[PathAlias.ADB_Path]\tax_paperwork_phase1.set","PDF","pro_id = " + quote(pro_id),"",filename5,.f.)
pdf_append(filename,filename5)
end if
filename2 = Report.saveas("Tax_JAW_2848_1@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename6,.f.)
pdf_append(filename,filename6)
filename2 = Report.saveas("Tax_JAW_2848_2@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename7,.f.)
pdf_append(filename,filename7)
filename2 = Report.saveas("Tax_JAW_8821@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename8,.f.)
pdf_append(filename,filename8)
if cvar_coapp=.t. then
filename2 = Report.saveas("Tax_JAW_2848_1_2@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename9,.f.)
pdf_append(filename,filename9)
filename2 = Report.saveas("Tax_JAW_2848_2_2@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename10,.f.)
pdf_append(filename,filename10)
filename2 = Report.saveas("Tax_JAW_8821_2@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename11,.f.)
pdf_append(filename,filename11)
end if
pdf_append(filename,"c:\yellow\tax\FinancialWorksheet.pdf")
if file.exists(filename) then
response.redirect(session.session_url + "tempreport.pdf?" + time("hms3"))
end if
%>
500 Internal Server Error
Script Error
Error:Could not append file. File is in use. 'C:\A5webroot\Yellow_Web\session_folders-81\bb72eba3e4f346a9aa78ef19db8ffa88\tempreport2.pdf'.
Alpha Five Application Server/11.0 Build/3381-4096 at Yellow Port 81
We are running multiple instances on the WAS just like we were on the old server. These are setup on ports 81, 82 and 83.
This worked great on the old ZebraHost server. I think it is a security issue. If anyone has a suggestion please let me know.
Here is my code for appending the reports. This has worked for two years without issues:
<%a5
filename = session.session_folder + "tempreport.pdf"
filename2 = session.session_folder + "tempreport2.pdf"
filename3 = session.session_folder + "tempreport3.pdf"
filename35 = session.session_folder + "tempreport35.pdf"
filename4 = session.session_folder + "tempreport4.pdf"
filename5 = session.session_folder + "tempreport5.pdf"
filename6 = session.session_folder + "tempreport6.pdf"
filename7 = session.session_folder + "tempreport7.pdf"
filename8 = session.session_folder + "tempreport8.pdf"
filename9 = session.session_folder + "tempreport9.pdf"
filename10 = session.session_folder + "tempreport10.pdf"
filename11 = session.session_folder + "tempreport11.pdf"
filename12 = session.session_folder + "tempreport12.pdf"
cvar_coapp=lookupl("F",pro_id,"Two_Signers","[PathAlias.ADB_Path]\tax_worksheet","pro_Id")
payment_method=lookupc("F",pro_id,"phase1_method","[PathAlias.ADB_Path]\tax_worksheet","pro_Id")
filename = report.saveas("Tax_JAW_1@[PathAlias.ADB_Path]\tax_paperwork.set","pdf","pro_id = " + quote(pro_id),"",filename,.f.)
filename2 = Report.saveas("Tax_JAW_2@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename2,.f.)
pdf_append(filename,filename2)
filename2 = Report.saveas("Tax_JAW_3@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename3,.f.)
pdf_append(filename,filename3)
'filename2 = Report.saveas("Tax_JAW_4@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename35,.f.)
'pdf_append(filename,filename35)
if payment_method="Bank" then
filename2 = Report.saveas("Tax_ACH_P1@[PathAlias.ADB_Path]\tax_paperwork_phase1.set","PDF","pro_id = " + quote(pro_id),"",filename4,.f.)
pdf_append(filename,filename4)
else
filename2 = Report.saveas("Tax_Credit_Card_P1@[PathAlias.ADB_Path]\tax_paperwork_phase1.set","PDF","pro_id = " + quote(pro_id),"",filename5,.f.)
pdf_append(filename,filename5)
end if
filename2 = Report.saveas("Tax_JAW_2848_1@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename6,.f.)
pdf_append(filename,filename6)
filename2 = Report.saveas("Tax_JAW_2848_2@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename7,.f.)
pdf_append(filename,filename7)
filename2 = Report.saveas("Tax_JAW_8821@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename8,.f.)
pdf_append(filename,filename8)
if cvar_coapp=.t. then
filename2 = Report.saveas("Tax_JAW_2848_1_2@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename9,.f.)
pdf_append(filename,filename9)
filename2 = Report.saveas("Tax_JAW_2848_2_2@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename10,.f.)
pdf_append(filename,filename10)
filename2 = Report.saveas("Tax_JAW_8821_2@[PathAlias.ADB_Path]\tax_paperwork.set","PDF","pro_id = " + quote(pro_id),"",filename11,.f.)
pdf_append(filename,filename11)
end if
pdf_append(filename,"c:\yellow\tax\FinancialWorksheet.pdf")
if file.exists(filename) then
response.redirect(session.session_url + "tempreport.pdf?" + time("hms3"))
end if
%>
Comment