Boomi · Data Integration: Snowflake

RVR-SNFLGC-400: Snowflake process is missing values

Short answer

RVR-SNFLGC-400 means the Snowflake process lacks values it needs to continue. Check the Data Flow's required fields and column mapping, and look for nulls in key fields.

VerifiedLast verified

01Error text

Boomi error
Error with Snowflake process. missing values to continue process. Error Code: RVR-SNFLGC-400

02Likely causes

  • Critical values required by the Snowflake process are missing.

03How to fix it

  1. Confirm required fields and parameters in the Data Flow are provided, including column mapping.
  2. Check the source data for nulls. Nulls in primary keys are not allowed with the Upsert-Merge loading mode.
  3. Confirm the Snowflake connection's credentials can access and modify the target database and schema.
  4. Check that column names and data types are compatible with Snowflake.

04Official documentation

Test every fix in a non-production environment before you apply it to production. See how entries are verified.

More for Boomi work:Open Boomi jobsBoomi rates and salaries

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.