Replies posted by Neerajkumar Bhatewara

17 Replies

Sumit Bondlewad
Committed
Sumit BondlewadCommitted
asked in Developer and User Community

Getting error whil connecting to powerbi

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

2
Sumit Bondlewad
Committed
2 months ago
N
Seasoned
Neerajkumar BhatewaraSchlumberger
asked in Developer and User Community

OPC UA Extractor - is there a parameter to handle the source timezone similar to DB Extractor

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 ?

3
E
Practitioner
4 months ago
N
Seasoned
Neerajkumar BhatewaraSchlumberger
asked in Developer and User Community

SDK - Questions around Global Config

Hello,Can anyone checkout this ? 

13
H
Practitioner
3 months ago
N
Seasoned
Neerajkumar BhatewaraSchlumberger
asked in Developer and User Community

Cognite Python SDK - Error generating access token: invalid_request, 400, too many calls

..

8
N
Seasoned
6 months ago
N
Seasoned
Neerajkumar BhatewaraSchlumberger
asked in Developer and User Community

Cognite Python SDK - Error generating access token: invalid_request, 400, too many calls

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

8
N
Seasoned
6 months ago
N
Seasoned
Neerajkumar BhatewaraSchlumberger
asked in Developer and User Community

Cognite Python SDK - Error generating access token: invalid_request, 400, too many calls

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

8
N
Seasoned
6 months ago
N
Seasoned
Neerajkumar BhatewaraSchlumberger
asked in Developer and User Community

Cognite Python SDK - Error generating access token: invalid_request, 400, too many calls

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'))

8
N
Seasoned
6 months ago
N
Seasoned
Neerajkumar BhatewaraSchlumberger
asked in Developer and User Community

Cognite Python SDK - Error generating access token: invalid_request, 400, too many calls

Hi Murad,Currently I checked on Sauth enabled project.

8
N
Seasoned
6 months ago
N
Seasoned
Neerajkumar BhatewaraSchlumberger
asked in Developer and User Community

FDM Graphql - Edges - Limitation over the number of edges fetched (only 50) when it is as a nested property

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.

13
M
Practitioner
8 months ago
N
Seasoned
Neerajkumar BhatewaraSchlumberger
asked in Developer and User Community

FDM Graphql - Edges - Limitation over the number of edges fetched (only 50) when it is as a nested property

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": {       

13
M
Practitioner
8 months ago
N
Seasoned
Neerajkumar BhatewaraSchlumberger
asked in Developer and User Community

FDM Graphql - Edges - Limitation over the number of edges fetched (only 50) when it is as a nested property

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 ?

13
M
Practitioner
8 months ago
N
Seasoned
Neerajkumar BhatewaraSchlumberger
asked in Developer and User Community

FDM Graphql - Edges - Limitation over the number of edges fetched (only 50) when it is as a nested property

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?

13
M
Practitioner
8 months ago
N
Seasoned
Neerajkumar BhatewaraSchlumberger
asked in Developer and User Community

FDM Graphql - Edges - Limitation over the number of edges fetched (only 50) when it is as a nested property

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 :)

13
M
Practitioner
8 months ago
N
Seasoned
Neerajkumar BhatewaraSchlumberger
asked in Developer and User Community

FDM Graphql - Edges - Limitation over the number of edges fetched (only 50) when it is as a nested property

@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! 

13
M
Practitioner
8 months ago
N
Committed
Niranjan Madhukar KarvekarCommitted
asked in Developer and User Community

Flexible data modeling - transformation to JsonObject type

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

10
Dilini Fernando
Seasoned Practitioner
1 year ago
N
Committed
Niranjan Madhukar KarvekarCommitted
asked in Developer and User Community

Flexible data modeling - transformation to JsonObject type

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 ?  

10
Dilini Fernando
Seasoned Practitioner
1 year ago
N
Seasoned
Neerajkumar BhatewaraSchlumberger
asked in Developer and User Community

FDM - Querying using multiple filters

Thanks Vu Hai Nguyen, I was using the UI to built the query but did not worked somehow.Thanks for your input, it works!

3
David Liu
Seasoned Practitioner
1 year ago

Badge winners

Show all badges
Terms & ConditionsCookie Settings