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
Do you see any details in the tomcat stdout log file? For me, this looks like a timeout issue. DB views are known for this kind of issues.
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?
Thanks Stefan Helzle , I am attaching a stdout log file. Kindly help me to identify what is wrong. I am unable to find.TOMCAT Log.txt
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.
In the first line, it just repeats the error message you already have.
My first guess is a timeout issue. And you can only solve that by speeding up that database view.
My second guess is a memory issue. The query returns too many rows with too many fields. Paging ist the solution.
Thanks Stefan Helzle , let me work on the two things you mentioned.
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.