ARERR[94] Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation during recon

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Atrium CMDB Suite


    APPLIES TO:

    BMC Atrium CMDB Suite



    PROBLEM:

     

    Recon Merge: Total records do not equate to the number of processed records.

    LP: BMC Remedy IT Service Management Suite 7.6.04
    DR: BMC Atrium Core 7.6.04
    DM: RE 00.00.00

    Details: I ran a merge activity on 4-16. The number of records identified were 165582 and the number of processed records were 60600.

    On the 4/16 job there were lots of errors in the logs similiar to the following:
    [2012/04/16 20:43:55.3120] [WARNING] [TID: 0000004688] : Ignoring dataset id <BMC.PAC2000> weight for attribute <zTmp_LPS_ManufacturerName> because this dataset is not referenced in the dataset merge precedence set <SAM BDNA PRECEDENCE> for this activity
    [2012/04/16 20:43:55.3280] [ ERROR ] [TID: 0000004688] : Dataset name not found for dataset id <BMC.PAC2000>

    I ran the same merge activity the next morning (4-17) and Identified and processed were both 0.

    The logs had the following:
    [2012/04/17 10:54:47.1400] [ ERROR ] [TID: 0000005644] : ARERR[94] Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation
    [2012/04/17 10:54:47.1400] [ ERROR ] [TID: 0000005644] : ONC/RPC call timed out
    [2012/04/17 10:54:47.1400] [ ERROR ] [TID: 0000005644] : Activity ended with an error: SAM BDNA 2 ASSET Merge

    Later on 4-17, I updated less than about 10 records, enabled debug logs, and ran the same merge activity again. This time the identified records count was 59129 and 1942 processed.

    The following errors were in the log:
    "[2012/04/17 16:47:52.9400] [ ERROR ] [TID: 0000005488] : ARERR[100029]
    [2012/04/17 16:47:52.9400] [ ERROR ] [TID: 0000005488] : "Please give values to all required fields."
    [2012/04/17 16:47:52.9430] [ ERROR ] [TID: 0000005488] : Merging of record failed:
    [2012/04/17 16:47:52.9430] [ ERROR ] [TID: 0000005488] : Class: BMC.CORE:BMC_Dependency
    [2012/04/17 16:47:52.9430] [ ERROR ] [TID: 0000005488] : Reconciliation IdentityId: OI-2F0EE7C827D549E78D181FBE71E4EA85"


     

     


    SOLUTION:

     

    Legacy ID:KA370090

      

    RE_ID_LOAD_CHUNK_SIZE was used in 32 bit environment. It is not needed in 64 bit environment and can be removed.

      
    Related Products:  
       
    1. BMC Atrium CMDB Suite

     


    Article Number:

    000044582


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles