Solved

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

  • 17 November 2022
  • 5 replies
  • 120 views
M
Rank
Badge

Timestamp too high Error. 

Course: CDF Fundamentals

Module: Working With CDF: Integrate

Error: While running Data points transformation: Timestamp too high

icon

Best answer by Madina Kholmatova 17 November 2022, 09:30

View original
1 Attachment

5 replies

Madina Kholmatova
Rank
Userlevel 4
Badge +5

Hi @Marutla Chiranjeevi Singh , 

Thank you for reporting this! I see similar issue has been posted here: 


I have updated your transformation accordingly, and was able to run successfully.

Please let us know if you have any issues!

Best regards,
Madina​

J
Badge

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. 

J
Badge

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.

E
Rank
Userlevel 4

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.

Enikő from Cognite Academy
Madina Kholmatova
Rank
Userlevel 4
Badge +5

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

Reply


Terms & ConditionsCookie Settings