Search Query Via Web Service Ends In Duplicate Rows and Lost Rows Using Agile SDK When Query Results over 100 records
Last updated on APRIL 27, 2018
Applies to:Oracle Agile PLM Framework - Version 188.8.131.52 and later
Information in this document applies to any platform.
Running Web Service Search returns duplicate record when output is above 100.
Suppose a search query that should return total record of 1000,
if the duplicate record appears, total record does not change so
it will return 1000 records but inside the records, it includes duplicates
and the record that should exist are lost from the output.
This issue does not occur always, but 1st trial of search mostly return duplicate records.
After running the same search criteria, for 2nd , 3rd trial, it does not include duplicate records.
If changing the search query, issue starts to occur again.
Below are the condition for search :
1) Preference : Search All Records for Duplicates : No
2) agile.properties file does not set query.batchSizeForRelatedObjectPrivCheck parameter
3) ITable is used from the code
Running Web Service Search returns unique record even when output is above 100.
1. Run Web Service Program that will retrieve search results above 100 records.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms