Encountering Failure during SQL operation to the database : ARERR 552 errors on Production Server after making workflow changes on server in server group configuration.

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


    APPLIES TO:

    BMC Remedy AR System Server



    PROBLEM:

     

    Error occurs when opening an object (form, actlink etc) in the admin tool. Also affecting Brie service (see arerror.log below).
    Users seem to be ok.
    ARS6.3 patch 1546. 2 servers in the servergroup. Server1 has this error but server2 seems ok. We had been making workflow changes on server1 at the time (10:52).

    arerror.log only shows:
    Fri Apr 17 11:41:04 2009 390600 : Failure during an attempt to perform an application command (ARERR 4554)
    Fri Apr 17 11:41:04 2009 Application-Command Dispatch Register-Category -s" Engine" -tBR-BRIE -o"araps_brie.lck" -l"/local/0/ar/losinpremedyapp1/confRemedyBRIESigEvent"
    Fri Apr 17 11:41:04 2009 BRIE : Failure during SQL operation to the database (T258 not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
    (Sybase 208)) ARERR - 552

    From the admin tool we get different tables specified in the error:
    "Failure during SQL operation to the database : arschema not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
    (Sybase 208) (ARERR 552)."
    &
    "Failure during SQL operation to the database : filter not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
    (Sybase 208) (ARERR 552)."

    Remedy AR System Server (version 6.3.00) DR: AR System Server for Unix; Server: Solaris / SunOS; Database: Oracle;

     


    SOLUTION:

     

    Legacy ID:KA306843

      
      Restart both AR Servers in the server groups 
      
    Related Products:  
       
    1. BMC Remedy AR System Server

     


    Article Number:

    000038900


    Article Type:

    Solutions to a Product Problem



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