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 NOVEMBER 21, 2023

Applies to:

Oracle Agile PLM Framework - Version 9.3.3.0 and later
Information in this document applies to any platform.

Symptoms

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) agile.properties 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.

Steps
1. Run Web Service Program that will retrieve search results above 100 records.

Cause

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
Symptoms
Cause
Solution
References


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