tFileOutputExcel: Fail to save error

Five Stars

tFileOutputExcel: Fail to save error

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]
Highlighted
Forteen Stars TRF
Forteen Stars

Re: tFileOutputExcel: Fail to save error

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


TRF
Five Stars

Re: tFileOutputExcel: Fail to save error

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


Community Manager

Re: tFileOutputExcel: Fail to save error

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
Five Stars

Re: tFileOutputExcel: Fail to save error

Hi Shong,

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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.