K_one
Member
Hi All -
We move report output files older then a certain date from the printqueue on the AS/400 to the printqueue on a Windows 2003 Server application server. We also copy the related records from the F986110 table to a separate server map and update the JCEXEHOST field.
When we do a View PDF in WSJ for a job that was submitted on AS/400 then the system gets the file from the application and shows the PDF correctly.
The View CSV function however does not work. The message ‘Unable to retrieve output from …’ is shown. This is the only error in the log on the application server:
“KNT0000114 - File e:\jdedwardsoneworld\ddp\b7333\PrintQueue\R55CD004_OCDEU200_3294119_PDF is an invalid file!”
Notice that it doesn’t add the .CSV extension as it should. It looks like that’s the reason it doesn’t find the file. For reports submitted on the application itself we can see the CSV fine. Here it also adds the CSV extension. This is in the log when it’s working:
6672/6872 Mon Apr 02 13:52:26 2007 JDEKNUBE.C5057
KNT0010000 - INFO: client file is R0010P_APPL01_32_PDF.csv
6672/6872 Mon Apr 02 13:52:26 2007 JDEKNUBE.C5080
KNT0010000 - INFO: server file is e:\jdedwardsoneworld\ddp\b7333\PrintQueue\R0010P_APPL01_32_PDF.csv
6672/6872 Mon Apr 02 13:52:26 2007 JDEKNUBE.C5098
e:\jdedwardsoneworld\ddp\b7333\PrintQueue\R0010P_APPL01_32_PDF.csv
So only when the CSV file and record in the F986110 table is coming from the AS/400 it does not work.
There is a difference between the records in the F986110 tables. They are both on the AS/400.
The difference is in the JCSRVBLOBA field. They are in a different blob format.
Maybe that’s the reason it does not work for CSV files?
Anyone an idea what the problem can be? Is there anyone doing the same and can see CSV files coming from the AS/400 on a Windows server?
Thanks for your help,
We move report output files older then a certain date from the printqueue on the AS/400 to the printqueue on a Windows 2003 Server application server. We also copy the related records from the F986110 table to a separate server map and update the JCEXEHOST field.
When we do a View PDF in WSJ for a job that was submitted on AS/400 then the system gets the file from the application and shows the PDF correctly.
The View CSV function however does not work. The message ‘Unable to retrieve output from …’ is shown. This is the only error in the log on the application server:
“KNT0000114 - File e:\jdedwardsoneworld\ddp\b7333\PrintQueue\R55CD004_OCDEU200_3294119_PDF is an invalid file!”
Notice that it doesn’t add the .CSV extension as it should. It looks like that’s the reason it doesn’t find the file. For reports submitted on the application itself we can see the CSV fine. Here it also adds the CSV extension. This is in the log when it’s working:
6672/6872 Mon Apr 02 13:52:26 2007 JDEKNUBE.C5057
KNT0010000 - INFO: client file is R0010P_APPL01_32_PDF.csv
6672/6872 Mon Apr 02 13:52:26 2007 JDEKNUBE.C5080
KNT0010000 - INFO: server file is e:\jdedwardsoneworld\ddp\b7333\PrintQueue\R0010P_APPL01_32_PDF.csv
6672/6872 Mon Apr 02 13:52:26 2007 JDEKNUBE.C5098
e:\jdedwardsoneworld\ddp\b7333\PrintQueue\R0010P_APPL01_32_PDF.csv
So only when the CSV file and record in the F986110 table is coming from the AS/400 it does not work.
There is a difference between the records in the F986110 tables. They are both on the AS/400.
The difference is in the JCSRVBLOBA field. They are in a different blob format.
Maybe that’s the reason it does not work for CSV files?
Anyone an idea what the problem can be? Is there anyone doing the same and can see CSV files coming from the AS/400 on a Windows server?
Thanks for your help,
