Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "No space left on device" while reading/writing data to GoogleBigQuery (GBQ) in PowerCenter session
Problem Description
PowerCenter session fails with No space left on device error for Google BigQuery Source and Target. 

For Reading, Staging mode is used, and Bulk mode is used for write.

The following error message is displayed in the session log:

2020-01-22 15:08:43 : INFO : (2416 | READER_1_1_1) : (IS | IS_NAME) : NODE_NAME : BIGQUERY_10000 : : [INFO] The reader is configured to downloaded files to the following directory: [/opt/informatica/server/server/infa_shared/Temp/].


2020-01-22 15:08:43 : INFO : (2416 | READER_1_1_1) : (IS | IS_NAME) : NODE_NAME : BIGQUERY_10000 : [INFO] File [gs://gcs/informatica/Informatica_Stage_File_1579685270873.json.gz-000000000016] downloaded successfully.
2020-01-22 15:08:43 : INFO : (2416 | WRITER_1_*_1) : (IS | IS_NAME) : NODE_NAME : WRT_8167 : Start loading table [ABC: Partition 1] at: Wed Jan 22 10:38:42 2020
2020-01-22 15:15:31 : ERROR : (2416 | WRITER_1_*_1) : (IS | IS_NAME) : NODE_NAME : BIGQUERY_10000 : [ERROR] The following error occurred: [No space left on device]
2020-01-22 15:15:31 : ERROR : (2416 | WRITER_1_*_1) : (IS | IS_NAME) : NODE_NAME : JAVA PLUGIN_1762 : [ERROR] com.informatica.powercenter.sdk.SDKException: Write Failed. Internal Error: Adapter Write returned Failure!!!
2020-01-22 15:15:31 : ERROR : (2416 | WRITER_1_*_1) : (IS | IS_NAME) : NODE_NAME : JAVA PLUGIN_1762 : [ERROR] at com.informatica.cloud.api.adapter.cci.writer.CCIWrtPartitionDriver.execute(CCIWrtPartitionDriver.java:204)

Cause
This issue occurs because of high data volume and no enough space available under the Temp directory ($PMRootDir) where the staging files are configured to download.

When "Staging Mode" for READ and "Bulk mode" for WRITE is configured in the session, Informatica creates temporary staging files under the configured Temp location and if the data volume is huge, there would be a chance of running out of free space for staging files.
Solution
To resolve this issue, make sure the Temp directory ($PMRootDir) has enough free space available to create staging files according to your data volume.
More Information
Applies To
Product: PowerExchange; PowerCenter
Problem Type: Stability; Configuration
User Type: Developer; Administrator
Project Phase: Configure; Implement; Onboard; Optimize
Product Version: PowerCenter 10.2; HotFix
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:6/2/2020 2:09 PMID:615727
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)