RVR-FRB-100

Issue summary

• You are encountering the error "Error trying to cast null values for required column" with error code RVR-FRB-100 while working with a Firebolt data connector in Data Integration. This error typically occurs when an operation attempts to input or transform null values into columns that do not accept nulls. It is crucial to ensure columns, especially those set as primary indexes or with not-null constraints, do not receive null values.

Action steps

To resolve the error, follow these steps:

• Identify Null Columns: Check which columns in your data have null values and cross-reference them with your Firebolt table schema to identify columns that cannot accept nulls.
• Modify Schema or Data: You have two options:
  1. Adjust your Data Integration input data to ensure no null values are present in columns that must not be null.
  2. Edit your Firebolt table schema to allow nulls if applicable and does not contradict your data integrity requirements.
• Cast Null Values: Before the data load, convert null values in your Data Integration processes to suitable default values using Data Integration transformations. This is especially important for primary key columns in Firebolt, as they must not contain nulls.

External references

• For further guidance, you may visit Firebolt's official documentation on handling null values here: Firebolt Documentation on Null Values.
• For more on Data Integration data transformations and mappings, refer to Data Integration documentation: Data Integration Official Documentation.

note

If the issue persists or you need help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.