Welcome to the CDF Fundamentals Discussion!
This discussion is dedicated to help learners of the Cognite Data Fusion Fundamentals learning path succeed. If you’re struggling with the exercises in this learning path, try the tips & tricks below or post a comment with the challenge you’re facing. You can also post your own tips and respond to fellow learners’ questions. Cognite Academy’s instructors are also here to help.
+6
Hi
Did you try to run it without the data set part? Since datapoints is such a big amount of data it is not always ideal to ‘preview’ datapoints. But for the preview part, your additional line of code is doing the trick!
Hello,
For the Data points step “Transform RAW to Data points” I received the error “Query returned no results. The query is syntactically correct, but returned 0 rows of data.”
It seems the query does not filter for dataSetId and returns no matches. I changed the query to solve the issue on my end, here are the changes:
SELECT
concat('FirstnameBirthyear:',dp.sensor) AS externalId,
cast(time_stamp/1000 as timestamp) AS timestamp,
cast(value AS double)
FROM IFSDB.values AS dp
JOIN _cdf.timeseries AS ts
ON CONCAT('FirstnameBirthyear:', dp.sensor) = ts.externalId
AND ts.dataSetId = '1234567890'
Hello
I cant find the raw data for IFSDB data set i.e. where is the data for the maintenance events or the timeseries? I only loaded assets.csv file and that was for asset hierarchy.
Thanks
Kapil
+2
Hi
Hi Bbauri,
Thanks for providing the console snap short of browser.
I have investigate deeply and found out all is working fine with the fusion. In the console , you have problem with failed to load resource:net::ERR_CERT_AUTHORITY_INVALID, which is related to your network connection and SSL certificate.
I recommend you to check your network connection and SSL certificate in your browser.
Help link 1 and Help link 2
Regards
Kumar
Hello Rahul,
Thanks for your help! Attached is a snapshot of the console. Thanks
Hi Bburai,
Can you add the snapshot of your console as I can see in the snapshot you have 88 warning in console
look at the image the image below
Hello Rahul,
I verified that I am using the https in the start of the url. Here is a snapshot of the browser console.
Hi Bbauri,
If you are using any extension in the browser, please disable it, use the latest version of browsers and check your have - https in the start of url and not http
Please add the snapshot of the browser console and will help us to find the cause of the issue.
Regards
Kumar
Hi Rahul,
Thanks for the response. I am able to access the data files in manage data catalog with no issue. I am logged in to the cdf-fundamentals project as well. My data sets are named Bernard1977 as seen below:
When navigating to the charts section, I am having issues. Please see screenshots below.
First it shows as if its trying to load like this:
And I ultimately receive this after trying to reload;
Any help will be greatly appreciated. This is the final module prior to certification.
Thanks
Hi Bbauri,
Thanks for posting your query.
As I have investigate the problem, but I can’t replicate the issue and chart module in fusion works fine at my side like create the chart, adding the timeserise, visualize timeseries etc. I hope you are using the right project which is “ cdf-fundamentals” to perform the hands-on in fusion and advise you to use the chrome browser to open the https://fusion.cognite
Can you clear the cache of your browser and try again or open the fusion in incognito widow ?
If you face the problem again (failed to load Firebase), please can add the console snap shot of your browser and it will help us to investigate the issue further in details.
Regards
Kumar
Hello, I’m working on the lesson Working with CDF: Consume. I am having issues with loading the charts section. Endless loop of failed to load. Any tips? Here is a screenshot of what I am seeing. Thanks
Hi, I’m in the CDF-fundamentals last course “Working with CDF: Consume” but when I click on “+ New chart” I get a “busy” screen that goes on endlessly.
Is there something wrong with this? Have tried different browser types (MS Edge, Chrome), refreshed/reloaded page, removed pop-up blockers, anything I’ve come across in the tip notes but nothing seems to be working.
When I back out “← All charts” it seems the new chart has been created, but when I click the preview icon
I get the same busy screen again.
My data is all starting with Daniel1969. Thanks for checking.
Best Regards,
Danny
Calculate Delta T :
Click + Add Note, go to Source, and select both of the time series.
The above lines should be :
Click + Add Node, go to Source, and select both of the time series.
Please correct the training material.
Thanks
Dev
+6
Hi
Wow, amazing work! Thank you so much, we’ll update the course.
Sofie
Hi! I’m working through the CDF Fundamentals learning path and came across a bug with the bonus time series transformation exercise in the Working With CDF: Contextualize course. I used the SQL statement as it was provided and the preview resulted in 984 rows, but it correctly saved only 12 records when I ran the transformation. The issue I noticed is when I followed the entity matching for the time series records and got a message that it was going to overwrite all the asset ids for the 12 records.
After further review, it looks like the transformation query ran the metadata function for everyone’s test data in the system (the HashMap function shows externalIds for several/all users test data), and the asset id that was saved did not correspond to my data.
I was able to add a where clause to resolve the transformation and get the correct asset id’s in the result. Screenshots of each dataset attached for reference.
+6
Hi
Sofie
I am not able to see all events transform data in my data set. The query change which
+6
Thank you so much
Sofie
Hello all,
SQL statement for Events did not find records since all completion_time=start_time in maintenance table of IFSDB, so I modified ‘>’ to ‘>=’ in the WHERE clause but only get 8 records instead of the 18. Will this be a problem for my Contextualization and later modules?
I experienced the same issue and also made the same changes to the query.
+1
Hello all,
SQL statement for Events did not find records since all completion_time=start_time in maintenance table of IFSDB, so I modified ‘>’ to ‘>=’ in the WHERE clause but only get 8 records instead of the 18. Will this be a problem for my Contextualization and later modules?
Hi Jason,
Thanks for reaching out, I’ve created a Support ticket for this to further investigate, since I think we’ll need some more details from you.
Best,
Carin
Datasets I create cannot be searched or found. Therefore I’m unable to build the transform as I cannot find the dataset to look for it’s dataset ID. I’ve tested this various ways, creating and deleting various data sets. They are uanble to found in the general search and do not show up in drop downs like are available when creating a Transform. Kind of stuck at this point.
Hi
I’m creating a ticket for Support out of this, it looks like we can reproduce the same issue, and we’ll need to look into this further.
Best,
Carin
+5
Hi
I am sorry that you are experiencing the issue. I have reported the problem, and our Cognite Support will reach out to you regarding the issue.
Best regards,
Madina
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
