Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "java.io.FileNotFoundException /temp/*.zip (No such file or directory)" when linear taskflow fails in IICS
Problem Description
In IICS, a Linear taskflow stop working and shows a generic error message in the session log as displayed below:

****
SDKTempThread> JAVA PLUGIN_1762 [2018-12-27 11:14:01.071] [ERROR] java.io.FileNotFoundException: /tmp/request6549232498658243635.zip (No such file or directory)
SDKTempThread> CMN_1761 [2018-12-27 11:14:01.071] Timestamp Event: [Thu Dec 27 11:14:01 2018]
SDKTempThread> JAVA PLUGIN_1762 [2018-12-27 11:14:01.071] [ERROR]  at java.io.FileInputStream.open0(Native Method)
SDKTempThread> CMN_1761 [2018-12-27 11:14:01.072] Timestamp Event: [Thu Dec 27 11:14:01 2018]
SDKTempThread> JAVA PLUGIN_1762 [2018-12-27 11:14:01.072] [ERROR]  at java.io.FileInputStream.open(FileInputStream.java:195)
SDKTempThread> CMN_1761 [2018-12-27 11:14:01.072] Timestamp Event: [Thu Dec 27 11:14:01 2018]
SDKTempThread> JAVA PLUGIN_1762 [2018-12-27 11:14:01.072] [ERROR]  at java.io.FileInputStream.<init>(FileInputStream.java:138)
SDKTempThread> CMN_1761 [2018-12-27 11:14:01.072] Timestamp Event: [Thu Dec 27 11:14:01 2018]
SDKTempThread> JAVA PLUGIN_1762 [2018-12-27 11:14:01.072] [ERROR]  at com.informatica.cloud.adapter.sfdc.common.SFDCClient.createBatch(Unknown Source)
SDKTempThread> CMN_1761 [2018-12-27 11:14:01.072] Timestamp Event: [Thu Dec 27 11:14:01 2018]
SDKTempThread> JAVA PLUGIN_1762 [2018-12-27 11:14:01.072] [ERROR]  at com.informatica.cloud.adapter.sfdc.runtime.SFDCBulkWrite$SfdcCall.run(Unknown Source)
SDKTempThread> CMN_1761 [2018-12-27 11:14:01.073] Timestamp Event: [Thu Dec 27 11:14:01 2018]
SDKTempThread> JAVA PLUGIN_1762 [2018-12-27 11:14:01.073] [ERROR]  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
SDKTempThread> CMN_1761 [2018-12-27 11:14:01.073] Timestamp Event: [Thu Dec 27 11:14:01 2018]
SDKTempThread> JAVA PLUGIN_1762 [2018-12-27 11:14:01.073] [ERROR]  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
SDKTempThread> CMN_1761 [2018-12-27 11:14:01.073] Timestamp Event: [Thu Dec 27 11:14:01 2018]
SDKTempThread> JAVA PLUGIN_1762 [2018-12-27 11:14:01.073] [ERROR]  at java.lang.Thread.run(Thread.java:745)
WRITER_1_*_1> SFDC_WRITER_30002 [2018-12-27 11:14:01.569] [INFO] Total time spent on Informatica adapter is 4121 ms.
WRITER_1_*_1> SFDC_WRITER_10089 [2018-12-27 11:14:02.221] [INFO] Job Id [7505700000GrFBnAAN] has been closed.
WRITER_1_*_1> CMN_1761 [2018-12-27 11:14:03.909] Timestamp Event: [Thu Dec 27 11:14:03 2018]
WRITER_1_*_1> JAVA PLUGIN_1762 [2018-12-27 11:14:03.909] [ERROR] java.lang.NullPointerException
WRITER_1_*_1> CMN_1761 [2018-12-27 11:14:03.909] Timestamp Event: [Thu Dec 27 11:14:03 2018]
WRITER_1_*_1> JAVA PLUGIN_1762 [2018-12-27 11:14:03.909] [ERROR]  at com.informatica.cloud.api.adapter.writer.runtime.GenericWriterPartitionDriver.updateSessionStats(Unknown Source)
WRITER_1_*_1> CMN_1761 [2018-12-27 11:14:03.910] Timestamp Event: [Thu Dec 27 11:14:03 2018]
WRITER_1_*_1> JAVA PLUGIN_1762 [2018-12-27 11:14:03.910] [ERROR]  at com.informatica.cloud.api.adapter.writer.runtime.GenericWriterPartitionDriver.deinit(Unknown Source)
WRITER_1_*_1> CMN_1761 [2018-12-27 11:14:03.910] Timestamp Event: [Thu Dec 27 11:14:03 2018]
WRITER_1_*_1> JAVA PLUGIN_1762 [2018-12-27 11:14:03.910] [ERROR]  at com.informatica.cloud.adapter.sfdc.writer.runtime.SfdcWrtPartitionDriver.deinit(Unknown Source)
WRITER_1_*_1> CMN_1761 [2018-12-27 11:14:03.910] Timestamp Event: [Thu Dec 27 11:14:03 2018]
WRITER_1_*_1> SDKS_38502 [2018-12-27 11:14:03.910] Plug-in #500100's target [VehicleDelivery__c: Partition 1] failed in method [deinit].
WRITER_1_*_1> WRT_8035 [2018-12-27 11:14:03.910] Load complete time: Thu Dec 27 11:14:03 2018

Cause
​By reviewing the mapping structure considering error entry: WRITER_1_*_1> SDKS_38502 [2018-12-27 11:14:03.910] Plug-in #500100's target [VehicleDelivery__c: Partition 1] failed in method [deinit] (taken from the errors above), it is identified that the target is using the ID lookup instead of  **Use External ID**. 

As the ID Lookup was set but no ID field was selected, the session failed.

That was caused by some issue with the project import that did not set the ID field properly under the mapping target settings. The current documentation states that if you do not select ID Lookup property, it is necessary to use the external ID for the upsert operation. If you do not select this property and do not provide the external ID, the session fails.

Solution
​To resolve this issue, edit the mapping and fix the target properties to use the external ID for the upsert operation.
More Information
Applies To
Product: Cloud Data Integration
Problem Type: Configuration
User Type: Administrator
Project Phase: Configure
Product Version: Informatica Cloud
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:2/25/2020 11:34 PMID:566782
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)