Impact 2024: The Industrial Data and AI Conference for and by Users | Nominate Speakers Now for a Ch...
Hello Sumit,I assume you are seeing this error message while trying to connect to CDF From PowerBI Desktop. So, seems like your login has failed, if this is true, then one of your admins in CDF needs to follow steps as mentioned on this page.Regards,Neeraj B
Hello EinarThanks for your reply. Do you mean that the timestamps are always in UTC in OPC-UA. I checked and found that it supports storing of timestamps along with local timezone also. So said that there should be someway to tell extractor to interpret the time considering the timezone.Can you mention the rules that you are talking about ?
Hello,Can anyone checkout this ?
..
Ok thanks for your response. One more query We are seeing below warnings, can you comment what are they, how is it impacting us and anything that we can do to avoid this[urllib3.connectionpool] Connection pool is full, discarding connection: westeurope-1.cognitedata.com
In above case, we saw the error after 30k requests were successful and every this number changes. This might be different one altogether not related with Sauth, i think so. But just check
Ok. So is sdk/rest api calling Sauth everytime its getting invoked even if the name of client is same ? anykind of caching being done ? What if you get Client config with same name or same instance of Client Config instead new one each time will there be change in the pattern of calling Sauth ?Actually we saw below exception on rest endpoint invocation also for Sauth enabled cognite project.Exception occured in fetch_combined_data method:HTTPSConnectionPool(host='westeurope-1.cognitedata.com', port=443): Max retries exceeded with url: /api/v1/projects/slb-pdf/userapis/spaces/QA_Test_Space/datamodels/QA_PERF_DATA/versions/1/graphql (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x7f770f7466d0>: Failed to establish a new connection: [Errno 111] Connection refused'))
Hi Murad,Currently I checked on Sauth enabled project.
Back to square one, we cannot iterate over internal elements or structure using graphql.So I think we can say that there is no way to get the connected data anyhow from cognite system. Consumer needs to do it on its own by using the query endpoint or some other way. PS - I am not sure how this got marked as solved, may be I marked it accidently and no option to reopen.
THis is my query { "with": { "AssetNodes": { "limit": 3, "nodes": { "filter": { "and": [ { "matchAll": {} }, { "hasData": [ { "type": "view", "space": "test-data-model-demo-space", "externalId": "Asset", "version": "532d19de4194f1" } ] } ] } } }, "EdgesFromAssetToWellTest": { "limit": 10000, "edges": { "from": "AssetNodes", "maxDistance": 1, "direction": "outwards", "filter": { "equals": {
Yes thats what I did, but with this you cannot connect the data from 0_0 with 0.What we have to do is get the edges part as well and after iterating all the edges we get to know about the start nodes and end nodes and then we join the start nodes and end nodes data separately.I was looking for something which can give me the connected data together in one structure. This is something probably a consumer would want. I believe that there has to be some way where the connected data can be retrieved somehow without the end user parse and connect the data(between start and end nodes).Can we do this ?
Thanks @mattmurph9 for the reply.It works fine when we have to just get the data of the end node ie WellTest, but we need few properties from start node(Well Asset) as well along with data of end Node.I will have to get three different result sets and then join them based on the edge start node id and edge end node id.Is there any way we directly get the merged data set directly from query endpoint ? In other words I want Well id and Well Name for all wells in West region along with WellTest ids and passFail result merged together with Well Details. Graphql output is merged one, is there anyway to do so with query endpoint as well?
Hello mattmurph9Consider below sample FDM Model.Well{ id: String, name: String, region: String, wellTests : [WellTest] }WellTest{ id: String, passFail: Boolean}In above model WellMy scenario is I want all the wellTests performed for Wells say in region West.So it seems this cannot be done from graphql due to cursor limitation and some WIP.But we cannot stay blocked so meanwhile, is there any rest api that can give me above data in one call ? I was exploring instances/query api, not sure if that would be correct candidate for this usecase.Hope this information helps to help us :)
@mattmurph9 - Thanks for your reply.By using the getByIds means we will have to first get the ids in a separate query and then pass the ids to this getByIds query and then we can use the nested cursor, correct ? Means two queries separately, if I understand correct!
Hi @Vu Hai Nguyen I tried using approach 2 ie raw json string and transformed but getting error while querying. Will try with approach one having to_json'{ "int_val": 2, "string_val": "tata", "struct_val": { "name": "jetfire", "age": 25.0 }}' as data{ "errors": [ { "message": "Something went wrong, we were not able to run your query.", "code": 400, "type": "VALIDATION", "errors": [ { "message": "Can't serialize value (/listMovie/edges[0]/node/data) : Expected a type that could be converted to JSONObject, but was java.lang.String", "path": [ "listMovie", "edges", 0, "node", "data" ], "extensions": { "classification": "DataFetchingException" } } ] } ]} Regards,Neeraj Bhatewara
Hello @Dilini Fernando ,I was trying the json thing and stuck at transformation phase. If you check in the following screenshot look at “data” field.I have used to_json in the query thinking it will convert it to json. But as you can see in the Result section data is still String and not converting to JSON.Can you help ?
Thanks Vu Hai Nguyen, I was using the UI to built the query but did not worked somehow.Thanks for your input, it works!
Already have an account? Login
Enter your 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.