CDF Fundamental - Working With CDF: Integrate - Error while running Data points transformation: Timestamp too high

I’m afraid I’m having the same issue. Running through CDF Fundamentals. Got to the “Working with CDF: Integrate” portion. Going ok until the “Data points > Run the Data points transformation”. The previous “Preview” step appears to work, but actually running the Transformation results in the following error:

Request with id 22821b2d-6480-9d6b-9d13-10ec43d11500 to https://westeurope-1.cognitedata.com/api/v1/projects/learn/timeseries/data failed with status 400: Timestamp is too high, must be at most 2556143999999 which is 31-12-2050 23:59:59 GMT.

As this is coming from the IFS DB (which was preloaded into RAW), I don’t have the original dataset to look for the incorrect timestamp which is causing the error. 

And moving forward appears to fail, as “Data points > Check your IFSDB data set” shows no actual data points in the time series. 

Any advice would be appreciated. 

Going to the other thread linked above, I *BELIEVE* I have resolved the issue. 

In the “Data points > Transform RAW to Data points” section, the 3rd line of the code snippet is the following:

cast(time_stamp as timestamp) AS timestamp,  

That appears to fail. 

But if, instead, I do this:

cast(cast(time_stamp as double)/1000 as timestamp) as timestamp,

The Transformation appears to run, and I now have data in my Time Series in my FirstNameBirthYear-IFSDB data set.

So, yeah… appears that the instructions in the CDF Fundamentals guide needs to be updated.

If I’m totally off-base, please let me know, but I’m going to try and continue with the training assuming this is working.

Hi @Jason Wyatt , thank you for sharing your challenge and your proposed solution. Our are instructors are looking into it and will get back to you. Until then, as you’re saying, you can continue with the courses in the learning path.

Hi @Jason Wyatt, 

That’s really good that you could resolve the issue. We have updated the course accordingly. Please continue with the course, and let us know if you encounter any more issues. 

Best regards,
Madina