000039469 - When using Execute Search API to get all the records from an application, some random content record will be missing in Archer

Document created by RSA Customer Support Employee on Dec 10, 2020
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000039469
Applies ToProduct Set: Archer
Product/Service Type: Archer 
Version/Condition: 6.X
Platform: Windows
IssueWhen using Execute Search API to get all the contents of an application/questionnaire, we noticed that the results are not consistent and we miss some random content record every time.

This is a sample code to get all the contents of an application(_test) with module ID : 545

    <DisplayField name="Tracking ID">23266</DisplayField>
    <DisplayField name="Text Area">23274</DisplayField>
    <DisplayField name="Policy Ref">23269</DisplayField>
    <DisplayField name="Name">23285</DisplayField>
      <Module name="_test">545</Module>
        <SortField name="Sort1">
          <Field name="Last Updated">23268</Field>

      <Conditions />


The sort order caused the issue. When the content records in this application get updated while the API program is in flight, the order of records in each page gets changed and we miss some of the records. 

ResolutionRemove the  "Last Updated" sort order from the code.