Hi Experts,
Need your help in the following issue:
I have created one view that is getting data from a table in a DB.
Then I created the CDT for the same from that DB and then the DS is also verified and published with no error.
But on retrieving the data from a DB rom a query entity I am getting the following error:
Using the Record Type also I am getting the following error while viewing the Record list, We have only 194 records in that view:
Please help me to identify the cause of the error.
Discussion posts and replies are publicly visible
Can you share the code of QE?
Also, did you check that your view has a column with unique identifier which you are using as a primary key?
Sure Harsh Kumar Agarwal ,
Up on selecting the constant of the Entity, I am getting this error in Query Editor:
Yes I created a Unique identifier column for my view which we are using as a PK.
Can you share the output of following code:
a!queryEntity( entity: cons!Test_DSE_VW_MULT_TARGET, query: a!query( selection: a!querySelection(columns: { a!queryColumn(field: "vwid") }), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 1) ), fetchTotalCount: false() )
Sure Harsh Kumar Agarwal , Output of the above code:
is your view loading fine at database side?
Yes, it is working fine. The only problem is in only when I am retrieving. Even though the Data Store is not showing any error.
Can you share the CDT and XSD details of view? Specifically, primary key information.
It appears to me a silly mistake around primary key configuration.
I am ruling out the threshold or memory issue as QE not retrieving a single row with primary key only.