tFileOutputExcel: Fail to save error

gt0731 — Sat, 16 Nov 2024 07:02:45 GMT

When i am trying to integrate linkedin -salesforce . getting this error . Here i am attaching the job zip file. any help on it would be much appreciated?

Getting error

Exception in component tFileOutputExcel_11
org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save: an error occurs while saving the package : An unexpected network error occurred

Detail of error

Exception in component tFileOutputExcel_11
org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save: an error occurs while saving the package : An unexpected network error occurred
	at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:503)
	at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1425)
	at org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:201)
	at org.talend.ExcelTool.writeExcel(ExcelTool.java:298)
	at test_2.rms_linkedin_sync_0_10.RMS_LinkedIn_Sync.tFileInputExcel_11Process(RMS_LinkedIn_Sync.java:47523)
	at test_2.rms_linkedin_sync_0_10.RMS_LinkedIn_Sync.tFileList_2Process(RMS_LinkedIn_Sync.java:16356)
	at test_2.rms_linkedin_sync_0_10.RMS_LinkedIn_Sync.tFileDelete_8Process(RMS_LinkedIn_Sync.java:15036)
	at test_2.rms_linkedin_sync_0_10.RMS_LinkedIn_Sync.tFileDelete_7Process(RMS_LinkedIn_Sync.java:14860)
	at test_2.rms_linkedin_sync_0_10.RMS_LinkedIn_Sync.tFileDelete_4Process(RMS_LinkedIn_Sync.java:14684)
	at test_2.rms_linkedin_sync_0_10.RMS_LinkedIn_Sync.tRunJob_7Process(RMS_LinkedIn_Sync.java:51585)
[statistics] disconnected
	at test_2.rms_linkedin_sync_0_10.RMS_LinkedIn_Sync.tRunJob_6Process(RMS_LinkedIn_Sync.java:51355)
	at test_2.rms_linkedin_sync_0_10.RMS_LinkedIn_Sync.tRunJob_5Process(RMS_LinkedIn_Sync.java:51125)
	at test_2.rms_linkedin_sync_0_10.RMS_LinkedIn_Sync.tRunJob_4Process(RMS_LinkedIn_Sync.java:50895)
	at test_2.rms_linkedin_sync_0_10.RMS_LinkedIn_Sync.tRunJob_3Process(RMS_LinkedIn_Sync.java:50665)
	at test_2.rms_linkedin_sync_0_10.RMS_LinkedIn_Sync.tRunJob_2Process(RMS_LinkedIn_Sync.java:50435)
	at test_2.rms_linkedin_sync_0_10.RMS_LinkedIn_Sync.tSalesforceConnection_1Process(RMS_LinkedIn_Sync.java:50203)
	at test_2.rms_linkedin_sync_0_10.RMS_LinkedIn_Sync.tFileExist_1Process(RMS_LinkedIn_Sync.java:50012)
	at test_2.rms_linkedin_sync_0_10.RMS_LinkedIn_Sync.runJobInTOS(RMS_LinkedIn_Sync.java:45485)
	at test_2.rms_linkedin_sync_0_10.RMS_LinkedIn_Sync.main(RMS_LinkedIn_Sync.java:45307)
Caused by: java.io.IOException: An unexpected network error occurred
	at java.io.FileOutputStream.write(Native Method)
	at java.io.FileOutputStream.write(Unknown Source)
	at java.util.zip.ZipOutputStream.writeShort(Unknown Source)
	at java.util.zip.ZipOutputStream.writeEND(Unknown Source)
	at java.util.zip.ZipOutputStream.finish(Unknown Source)
	at java.util.zip.DeflaterOutputStream.close(Unknown Source)
	at java.util.zip.ZipOutputStream.close(Unknown Source)
	at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:501)
	... 18 more
Job RMS_LinkedIn_Sync ended at 18:11 13/12/2018. [exit code=1]

Re: tFileOutputExcel: Fail to save error

TRF — Fri, 14 Dec 2018 13:39:45 GMT

"An unexpected network error occurred"... did you try to save the output file locally?

Re: tFileOutputExcel: Fail to save error

gt0731 — Tue, 18 Dec 2018 09:50:46 GMT

No the file should be saving on our server
most of them are saved as temp files i believe
theres probably a bit of the job later to delete all the residual files

Re: tFileOutputExcel: Fail to save error

Anonymous — Fri, 21 Dec 2018 01:23:30 GMT

Hi gt0731
I see the 'write excel 2007 file format(xlsx) option is checked, so please change the file name to xxxx.xlsx format. You are using global variables in the file path, for testing, please print the value of file path to see if it is the expected value (valid file path)?

Regards
Shong

Re: tFileOutputExcel: Fail to save error

gt0731 — Fri, 21 Dec 2018 06:11:33 GMT

Hi Shong,

Thank you for response .Sure i will implement the changes and Let you know outcome soon.

topic Re: tFileOutputExcel: Fail to save error in Talend Studio

tFileOutputExcel: Fail to save error

Re: tFileOutputExcel: Fail to save error

Re: tFileOutputExcel: Fail to save error

Re: tFileOutputExcel: Fail to save error

Re: tFileOutputExcel: Fail to save error