My Oracle Support Banner

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 and later
Information in this document applies to any platform.


Actual Behavior
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) file does not set query.batchSizeForRelatedObjectPrivCheck parameter
3) ITable is used from the code

Expected Behavior
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.