Timestamp too high Error.
Course: CDF Fundamentals
Module: Working With CDF: Integrate
Error: While running Data points transformation: Timestamp too high
Best answer by Madina Kholmatova
View originalTimestamp too high Error.
Course: CDF Fundamentals
Module: Working With CDF: Integrate
Error: While running Data points transformation: Timestamp too high
Best answer by Madina Kholmatova
View originalHi
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
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.