Impact 2024: The Industrial Data and AI Conference for and by Users | Nominate Speakers Now for a Ch...
I have a set of work orders with the following schema along with sample data for two assets (10010234, 10010235){Equipment Work Order # Order Type Start Date Start Time End Date End Time Cost}10010234 110025063 Unplanned 7/6/2018 11:31:15 7/6/2018 23:00:00 35,600 10010234 110026082 Planned 8/25/2018 12:27:15 8/27/2018 23:44:00 37,180 10010234 110027101 Unplanned 12/8/2018 13:30:15 12/8/2018 17:00:00 26,580 10010234 110028120 Unplanned 1/27/2019 14:40:15 1/29/2019 1:45:00 38,900 10010235 110023050 Planned 3/1/2018 15:57:15 3/2/2018 3:02:00 25,000 10010235 110024617 Planned 6/14/2018 17:21:15 6/16/2018 4:30:00 30,000 10010235 110026184 Planned 9/27/2018 0:25:00 9/27/2018 6:09:00 24,600 10010235 110027751 Unplanned 1/10/2019 20:30:15 1/12/2019 7:59:00 35,600 Equipment is stored as assets and the work orders are stored a
I was trying to complete learning exercise in contextualization. I’m nit able to find dataset ‘saurabh1985-IFSDB’ created by me in initial exercise. Please check image below. Can you please help me with issue ? thanks,Saurabh Lale
Data set is not available in the below path for the practice, kindly request your support to resolve this ASAP. Regards,Naveen
Hi,As part of the exercise -”Match time series to assets” I am not able to see the dataset i have created - Pavan1978-IFSDB when i used Quick Match..
I am doing the Working with CDF Integrate module, but I have the following sql query error: An error occurred when running this query"Mismatched input ''rocio1975'' expecting {'(', 'ADD', 'AFTER', 'ALL', 'ALTER', 'ANALYZE', 'AND', 'ANTI', 'ANY', 'ARCHIVE', 'ARRAY', 'AS', 'ASC', 'AT', 'AUTHORIZATION', 'BETWEEN', 'BOTH', 'BUCKET', 'BUCKETS', 'BY', 'CACHE', 'CASCADE', 'CASE', 'CAST', 'CHANGE', 'CHECK', 'CLEAR', 'CLUSTER', 'CLUSTERED', 'CODEGEN', 'COLLATE', 'COLLECTION', 'COLUMN', 'COLUMNS', 'COMMENT', 'COMMIT', 'COMPACT', 'COMPACTIONS', 'COMPUTE', 'CONCATENATE', 'CONSTRAINT', 'COST', 'CREATE', 'CROSS', 'CUBE', 'CURRENT', 'CURRENT_DATE', 'CURRENT_TIME', 'CURRENT_TIMESTAMP', 'CURRENT_USER', 'DAY', 'DATA', 'DATABASE', DATABASES, 'DBPROPERTIES', 'DEFINED', 'DELETE', 'DELIMITED', 'DESC', 'DESCRIBE', 'DFS', 'DIRECTORIES', 'DIRECTORY', 'DISTINCT', 'DISTRIBUTE', 'DIV', 'DROP', 'ELSE', 'END', 'ESCAPE', 'ESCAPED', 'EXCEPT', 'EXCHANGE', 'EXISTS', 'EXPLAIN', 'EXPORT', 'EXTENDED', 'EXTERNAL', 'EXTRACT
While setting up credentials while transforming getting this error.Error : Session Create Error:Request failed: Status code 401 Tried creating multiple times no luck any help pls
Hello All,I have created dataset, it is available at data set section and but when it comes to contextualize=> “Match entities”=> “Quick match”. and then tried to find my data set with resource type “time series” At this point, i am not able to find the data set, which is already there in the section “manage dataset catalog”. Any specific reason for this?
When I run the query below, I am getting an error. If I increase the end time by 1 second I can get a result, but it gives me 2 days and I only want 1. All my data is consistently daily at midnight, UTC. Any ideas how to get past this?SELECT dp.id, dp.externalId AS `key`, dp.timestamp, dp.valueFROM `_cdf`.`datapoints` dpWHERE dp.externalId IN ( 'f18ae31cbfe544cb7bca08da91e5245a-SuFMiCo0f7c8eca4ce444208853aedd00ded4fb', '730619216b764ba77bc708da91e5245a-SuFMiCo6bb90df0efbc461d863faedd00df009b' ) AND dp.timestamp >= TO_TIMESTAMP('2022-09-01T00:00:00Z') AND dp.timestamp < TO_TIMESTAMP('2022-09-02T00:00:00Z') Gives me a result, but not what I want: cc @Torgrim Aas @Sunil Krishnamoorthy
I have found a problem reading timeseries from Cognite with Power BI. The first bit of Power Query has a filter to limit the timeseries retrieved to just the ones I want. The second one is the same, but does not have the filter. What I have found is that adding the filter causes duplicate rows in the table. Once the timeseries rows are duplicated, the timeseries aggregation values are also duplicated. I know that the first query is not the most performant option, but it should still have the correct answer.let Source = Cognite.Contents( #"cogniteContentsParameters", #"cdfEnvironment"), Timeseries_table = Source{[Name="Timeseries",Signature="table"]}[Data], #"Filtered Rows" = Table.SelectRows(Timeseries_table, each ([IsString] = false)), #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"MetaData", "SecurityCategories", "IsStep", "DataSetId", "CreatedTime", "LastUpdatedTime", "Asset", "Latest", "DataPoints", "StringPoints", "Aggregate"}), #"Filtered Rows1" = Tabl
Hi!Almost three years ago we made a feature request regarding search. Specifically we want to:Have support for paging. Do grouping on metadata-fields. Define which fields yields relevance to the search-results. Inclusive search-terms using AND instead of OR.I do understand that satisfying the search-requirements of all your users is a daunting task, but perhaps it would be easier to let us do the job instead? I believe it would be very beneficial if we were able to access ElasticSearch directly in some manner.And please keep in mind that the data itself defines relevancy. No two customers are alike and therefore a good generic solution likely doesn’t exist. @Knut Vidvei @Andreea Pastinaru
I just finished the cognite academy examples on contextualization. I did notice on the PID contextualization example that there were quite a few errors in what seems potentially character recognition pipeline to identify tags in the PDF.The tutorial stated that “these were all good” and “we can accept all”. I suspect such a process would create missing or strange links in the contextualized dataset.Are these known issues?I lack a bit the understanding of the context for the importance of these mispredictions,but I thought to report them anyway just in case.Happy to support you on improving these if they are something that needs improvement.
<<URGENT>>Hi ,We are Unable to deploy Cognite Function. Below is the snippet for the same.Function ID : 269293733668660 @Philippe Bettler could you please prioritize this issue.
We are seeing inconsistencies between the number of files that an asset “Appears In” vs to the actual number of files that are in CDF:In the screenshot, the count is (5) however there are only 3 files. Upon checking further we realized that the count is coming from the number of Cognite Annotation events that were created during contextualization of the P&ID files.Even if the original file was deleted, the Cognite Annotation events for those file remain.This causes confusion to the user.Is it possible to have this fixed? i.e deleting a file would also then delete all Cognite Annotation events that was created for that file? Or if the Cognite Annotation events are to be kept, but the logic in how the number of files an asset appears in is updated so that it reflects the correct number of files that are still in the CDF project?
As Requested Creating this new bug on cognite function.Please assign this to below ids: ben.petree@cognite.com & philippe.bettler@cognite.com@Ben Petree @Philippe Bettler
Cognite Function throwing Bad Gateway Error:Function ID :4525036003390684Here are the details:error: Bad Gateway | code: 502 | X-Request-ID: d84d076d-6e59-9362-b58e-931d5a63644f
In CDF, when we click on any Asset , there is a file tab, where it shows Appears In and Linked files for that asset.But the Count is not matching with list of files its showing for Appears In.In the below screenshot, the appears in count showing as 20. But only 16 files were listed.
We are currently migrating to OIDC where we need to give access through access groups linked to Azure AD.On our Statnett cluster it seems that a user needs to explicitly be member of a group “transformations” in order to to delete (or edit) a transformation.The admin group has the capabilities (on “test”) {'transformationsAcl': {'actions': ['READ', 'WRITE'], 'scope': {'all': {}}}}]But we need to login to the legacy login without OIDC and have a service account linked explicitly to the group “transformations” in order to delete a transformation. The group “transformations” has no capabilities set.I have tried both Fusion and the API/python-SDK (read is possible):CogniteAPIError: Transformation not found. This may also be due to insufficient access rights. | code: 403 | X-Request-ID: b7c0beb6-d3e0-9ec4-ba50-895533ac1996
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.