Search Query Via Web Service Ends In Duplicate Rows and Lost Rows Using Agile SDK When Query Results over 100 records
(Doc ID 2391919.1)
Last updated on FEBRUARY 21, 2019
Applies to:Oracle Agile PLM Framework - Version 220.127.116.11 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document