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
Error with Snowflake process. missing values to continue process. Error Code: RVR-SNFLGC-40002Likely causes
- Critical values required by the Snowflake process are missing.
03How to fix it
- Confirm required fields and parameters in the Data Flow are provided, including column mapping.
- Check the source data for nulls. Nulls in primary keys are not allowed with the Upsert-Merge loading mode.
- Confirm the Snowflake connection's credentials can access and modify the target database and schema.
- Check that column names and data types are compatible with Snowflake.
04Official documentation
→Related errors
- RVR-SNF-001: Snowflake connection problemRVR-SNF-001 means Data Integration could not connect to Snowflake, usually because of wrong connection details or credentials without enough privileges. Verify the account, username, warehouse and role.
- RVR-LTBQ-102: keys not selected in mapping for mergeRVR-LTBQ-102 means no key fields are selected in the column mapping, and the upsert-merge mode needs keys to match records. Select the key fields in Column Mapping and save.
- RVR-CONFIG-400: Data Flow is not configured correctlyRVR-CONFIG-400 means the Data Flow is not configured correctly: a parameter is wrong, a credential is missing or settings do not line up. Review the Data Flow's required fields, credentials and mappings.
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