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]
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
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)?
