Getting FP_QUERY_RESULT_CODE_ABORT status for time based query to Centera

We have reconciliation application (Java) which queries to Centera and get the content address list and compare it with content address list in database. We have 10 thread which query for 1 hour each to centera and process them parallel.

Typical processing of each thread is

- Connect  to Centera and query using start and end time + few attributes

- Get the list of content address

- Close connection

- Query to database and get content address list

- Compare content address lists and record differences.

- Status marked completed

We are using QueryCluster.java sample program provided along with CEntera SDK 3.3.719. Drawback of code is it connect and disconnect Centera for every request.

When we query to Centera we receive FP_QUERY_RESULT_CODE_ABORT status. We retry same query again for maximum 3 times with 30 sec delay but we are receiving same status. Intersting thing is if we switch primary server IP address with replica server all works fine and no need of retry as well.

Any pointers will be much appreciated.