Remedy - Server - v9.x (Oracle only) The TEMP database space is consumed rapidly while performing Reconciliation Engine activity or by consuming web services with REST api and is not released

Version 2
    Share:|

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


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    AR System


    APPLIES TO:

    BMC Remedy AR System Server v9.0, v9.0.01, v9.1.00



    PROBLEM:

    The Oracle TEMP database space is consumed rapidly while performing Reconciliation Engine activity or by consuming web services with REST api and is not released.

    Example (from a graphic report):

    User-added image

     


    CAUSE:

    Reported as the following defects: SW00510724/SW00515282 - Temp DB growth - After upgrade Remedy AR Server consuming lot of temp table space without releasing the space.


    SOLUTION:

    The following defects resolve the issue.

    9.0.01 - SR_ARS_9.0.01_HF_20160909_CU_ALL
    9.1 - SR_9100_20160818_CU_ALL

    The latest SR* hot fix can be accessed under the following location on the BMC FTP Server:

    ftp://ftp.bmc.com/pub/ARRecommendedFixes/Server.

    The readme files will contain a list of defects that are addressed.


     


    Article Number:

    000116925


    Article Type:

    Solutions to a Product Problem



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