Impact 2024: The Industrial Data and AI Conference for and by Users | Nominate Speakers Now for a Ch...
With Murad’s help the solution is to add a line for “mode” to be “continuous” in the config file as seen here. extractor: state-store: raw: database: PlantPAx_FTAE table: AllEvent upload-interval: 3600 mode: continuous
implementing the schedule format above successfully started the service.However the service still runs once and then the service stops. There is an error in the log file about database/table already existing, does this matter? All feedback in attached zip Thanks
Thanks Murad, I’m thinking this is a once per hour scheduled chron job. Perhaps I’m wrong.schedule: "0 * * * *"when trying this, the service will not start.
Welcome Mohammed! I think you will find this community eager to provide help and advice as it has for me already. I’m a Solution Consultant with Rockwell Automation, a Cognite partner and I’d be interested to hear how SLB will use Cognite to solve operational problems. I wish you success!Chris
Noah, thanks a ton for taking the time to find my error. The code above is working!
this was solved with this:(to_timestamp(DateTimeStamp, 'yyyy-M-d HH:mm:ss') changing to use HH for 24 hour time.We also used the to_timestamp(DateTimeStamp, 'yyyy-M-d HH:mm:ss') Is Not Nullfor good measure.
@Gaetan Helness thank you for this solution. I found some help who suggested this which seems to work.to_timestamp(DateTimeStamp, 'M/d/yyyy h:mm') AS timestamp,I do not know why but the seconds (ss) do not appear to be present in the Raw table (but existed in the CSV) so I omitted the ss from the format in the transformation which satisfied it. Your solution may be helpful in other situations for me and others so thanks again!Chris
Perfect! I had my admin Add those permissions to my group and it worked. Thank you for a quick reply!
Thanks all. I’ve now moved to a completely different CDF instance and have other issues there that I will switch to a different topic here in the forum.
after another attempt in cdf-fundamentals, I get same result: It does not create the transformation. Thanks for looking into this. Chris
thanks will try now!
Thanks @Kristian Gjestad Vangsnes ! After cloning and installing requirements as you suggest, most seems to be working. I say most because when I began to execute code in 1_Authentication.ipynb, it made me install “ipykernel”. VS Code handled it fine, just a note that might help you.
[SOLVED] can someone tell me if it is a requirement to install and use poetry for this training? can i simply clone the git repo in VS code and proceed?
Not an expert but this post may be related.Cognite Hub
thanks @Eniko Farkas. Do you think Cognite will fix this course issue?
Perfect thanks for the fast reply!
How can SME create anomaly detection logic with output notifications?This is not a threshold alert like Arun is discussing now.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.