Community Discussions

Hi,I am running the DB Extractor, where my Source is an odbc connection(SQL DB) and destination is Timeseries. But I am getting the error: “ [ERROR   ] QueryExecutor_0 - Unexpected error in UB-Training-Timeseries-objects: 'NoneType' object has no attribute 'timestamp'”Attaching the screenshot of my data in SQL, error Log and config file.I am using DB extraction v3.0.0.Please reach out if you need more info.

Learn FDM GraphQL Queries . Aggregate query not supporting sort functionality. How to achieve sort functionality in aggregate  

How to fetch documents from multiple folder locations using single config.yml file by Cognite Documentum Extractor? how to write multiple DQL queries in same config.yml? Which configuration parameters to use?I am working on Cognite Documentum Extractor and using DFC Java SDK mode for connectivity.

Hi! I am trying to update “Planned End Date” for a specified work order in staging.I have prepared this table to join to my work order raw table:This is my sql and the error message I got:Is there a way I could update “Planned End Date”? Thanks in advance. :)

@Jørgen LundWe have a use case for Workflow Orchestration feature in a project – an example being we would like to run some workflows (Cognite functions) after successful runs of certain workflows as they have a dependency between them.There are some conversion and allocation factors that vary periodically and will be updated to SharePoint via end users. Based on the dates for these numbers, we will utilize them for further data munging and calculations in other Cognite functions, given that the previous function run was successful.Can we use workflows for this? If yes, can we enable this in our project?

Hi Team, IS there any unit testing examples for cogex based extractors to test integration with rest api

Hi! I have a question about the data modelling in Cognite Data Fusion.We record data from thousands of sensors from a factory. Today we record them as time series in CDF and organized in the asset hierarchy by manually constructing the relationships.I heared the data modelling toolkit is meant to replace asset hierarchies approach in future. Could you please elaborate a bit on how Cognite would suggest to approach our use case, if we started from scratch today.Thanks!

I have a set of timeseries objects t1,t2,t3,t4,t5…..etc. Now I would like to create a derived timeseries objects based on the existing timeseries objects. For instance  T1 = (t1/1000) *141.5T2 = (t2/100 - t3)T3 = (t3/100 - 14)T4 = t4 * t2/100T5 = t5/100How do I perform these steps using cognite SDK. Is there a way to perform these operations?Please advise. Retrieving dataframe from data-points and then create new timeseries objects (T1,T2….) will be challenging and hence wanted if there is an optimal way to handle this in a better way. Is this possible using synthetic time-series?IS there some examples and code snippets that can be shared so that I can grasp them better?  

I have had this problem before but it fixed it self by just waiting. But is the connection to CDF down when you get this error in PBI? Details: "Cognite: Request failed: The remote server returned an error: (503) Server Unavailable. (Service Unavailable)"

Hi, thanks for enabling the early adopter version.I’ve created a workflow and was planning to disable all my transformations to see if we can rely only on the workflow and get better results than transformation (which sometimes fails causing data latencies), but I’m missing one part: How do we trigger the workflow to run based ion new data arrival or schedule?

How do I perform upsert using this dataframe. I also need to associate the timeseries against a specified asset. Please advise. How to use this dataframe and perform associating to an asset id using this line:    client.time_series.data.insert_dataframe(df) I have a dataframe that looks like this as below: DATE LP_Crude API_Meter LP_FRN_KERO_SW_CUTPT LP_KERO_DSL_SW_CUTPT LP_DSL_AGO_SW_CUTPT LP_MVG_HVGO_SW_CUTPT 1/1/2023 28.75472705 271.8662 440.9032 680.3416 928.875 1/2/2023 28.21111702 269.3863 466.2317 686.5167 924.1292 1/3/2023 27.78340123 268.8638 484.6189 684.5542 919.9917 1/4/2023 27.5781529 269.3117 506.7792 686.6708 921.9375 1/5/2023 28.03229217 268.1567 500.2208 688.2208 917.575

Will custom data formats for hosted extractors support events as target type in the future, and if so, do you have a rough estimate on when? 

How can i connect to CDF, using Alteryx ETL tool.Is there any documentation available?

Hello,I am running a csv_extractor that loads data to Raw explorer. I run the extractor from my machine locally through cmd. How do I set up an extraction pipeline to monitor this extractor? I created an extraction pipeline from “monitor extractor”, but not sure how to link it to my extractor.Regards,Diana

What is “YOUR_SECRET_API_KEY”? How to get this secret key? Please tell 

Hello,Can I get an example of a CDF function that deploys a .pickle or .joblib model into CDF, then calls the model?Thanks,Diana

Hello all, I’m trying to connect CDF data source to my Grafana instance that I already installed as a plugin, and I get this message:“Angular plugin This data source plugin uses a deprecated, legacy platform based on AngularJS and is incompatible with your current Grafana configuration.”  Then when I try to add it as a new data source, the CDF is not available on the drop list  Is the Angular plugin warning message preventing me from adding the data source? if so, is there any way I can resolve this? Thank you,Yasir

I am working on Cognite Documentum Extractor and using D2 as mode of connectivity. I have not received any CA root certificate from Documentum Server from Client. Client have mentioned that, they don’t have the certificate. So, Can Documentum Extractor work without CA root certificate? If not, Is there any alternate approach which we can use to make it work using D2 mode?Also, If it can’t work without root CA certificate, Please suggest me an approach or steps to generate the certificate from Documentum Server.

Hi team, We are facing an issue while uploading a file to CDF using smb yaml configurations using File Extractor, please find the error below.2023-10-05 12:38:42.043 UTC [ERROR   ] MainThread - Could not upload file xxx.pdf to CDF: [Error 1] [NtStatus 0xc0000043] The process cannot access the file because it is being used by another process: xxx.pdf'How can we fix this issue as many users might be using file share in different locations at the same time while uploading it will be difficult to know? 

Hello Cognite team, Greetings! Below is a screen shot of 4 data points available for a specific timeseries id in a duration of 1 hour For the above mentioned data points when i select the aggregate function (similar value being resulted from aggregate function api) i see an average value which is significantly higher than the original value (calculated manually) The data interval for the below points is for every 15 mins the first 4 data points for this timeseries is what you see in the below screen shot  

New to Cognite.Can anyone help on this:We have CSV files uploaded into CDF dataset (thru’ FileExtractor), and now need to read and parse the csv files contents in the CDF into TimeSeries? And how to run it automatically or scheduled?Thank a lots.​​​​​

Hi Cognite Team,Is there any document which can show , how to fetch confidential information from private end point key vault  on Microsoft azure key vault. 

Hello,We have off late moved from Rest calls to SDK and post that we have started seeing the below errorError generating access token: invalid_request, 400, too many calls What is recommended for this type of error ? Can’t we add a exponential delay at sdk side ?Also it would be important for us to know that this error is given after how many calls ? 

How to load data from Alteryx (ETL tool) to CDF Raw Database? I don’t see any connector in Alteryx for connecting to CDF. 

I am getting below error while executing Documentum Extractor. FATAL: Invalid YAML file: Both database and table must be set when metadata destination is RAWcom.cognite.connector.dctm.config.InvalidConfigException: Invalid YAML file: Both database and table must be set when metadata destination is RAW. I have gone through the cognite documentation for possible configuration, it is not mentioned in the documentation. There is no parameter for metadata_destination, database, table. Please help me with details, from where we can get this parameter info? or how can I configure it in YAML? Please find my config.yaml file contents as below: version: 1logger:    console:        level: INFOcognite:    # Read these from environment variables    host: #${COGNITE_BASE_URL}    project: #${COGNITE_PROJECT}    idp-authentication:        # token-url: ${COGNITE_TOKEN_URL}        tenant: #${tenant}        client-id: #${COGNITE_CLIENT_ID}        secret: #${COGNITE_CLIENT_SECRET}        scopes: