RVR-BSFEEDER-101
Issue summary
- The error
RVR-BSFEEDER-101suggests that the data connector, specifically usingstorages, is encountering an issue with timestamp formatting. The error description indicates that Unix timestamps in seconds is mandatory, but missing. Unix timestamps are a way to represent time as the number of seconds that have passed since January 1, 1970 (often referred to as the "epoch").
Action steps
To resolve the error, follow these steps:
-
Verify the data source setup to ensure Data Integration expects to handle Unix timestamps.
-
Convert all date-time fields in your dataset to Unix timestamps in seconds. In R, you can convert a regular date to a Unix timestamp using a function like:
as.numeric(as.POSIXct("2023-10-15 12:00:00", tz="UTC"))This will return a numeric value representing the Unix time.
-
If the data is in a CSV or other file format, ensure you convert the date columns before ingestion or apply a transformation step in Data Integration to handle the conversion.
-
Double-check the schema configuration in your Data Integration pipeline to ensure that the date fields are being correctly recognized and transformed into Unix timestamp format.
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.