AppWorx, Dollar Universe and Sysload Community

 View Only

AM 9.3 Hang when deleting Agent

  • 1.  AM 9.3 Hang when deleting Agent

    Posted Feb 14, 2020 04:05 PM
    I moved and upgraded an AM instance to a new server and the client is operating. We are also moving the remote machine and I need to upgrade the remote agents. I thought it would be best to just delete the agents on the old machine since they have weird issues. But I can't delete them. When I try the client UI just hangs. In the RMIServer log file I see this:
    ErrorMsg: AwE-5001 Database Query Error (2/14/20, 3:32 PM)
    Details: aw_web_api.aw_delete_objects
    0 tranmode: IN:VARCHAR2:java.lang.String:DF
    1 errorcode: IN:OUT:INTEGER::null
    2 errortext: IN:OUT:VARCHAR2::null
    3 type: IN:VARCHAR2:java.lang.String:N
    4 name: IN:VARCHAR2:java.lang.String:TRAIN
    5 api_username: IN:VARCHAR2:java.lang.String:SQLOPER
    6 api_password: IN:VARCHAR2:java.lang.String:*****

    jdbc:oracle:thin:@//na-rh-ora.lmc.onl:1521/AUTOPROD:AUTOMIC
    java.sql.SQLException: ORA-20170: Can not delete "Agent TRAIN. 1 references exist "
    ORA-06512: at "AUTOMIC.SO_OPERATOR_DEL_STMT", line 84
    ORA-06512: at "AUTOMIC.AWAPI2", line 477
    ORA-06512: at "AUTOMIC.SO_OPERATOR_DEL_STMT", line 37
    ORA-04088: error during execution of trigger 'AUTOMIC.SO_OPERATOR_DEL_STMT'
    ORA-06512: at "AUTOMIC.AW_WEB_API", line 1651
    ORA-06512: at "AUTOMIC.AW_WEB_API", line 1349
    ORA-06512: at line 1

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
    ...

    How can I find what is referencing this agent? I need specific help to find the way to do this. I'm new here. I tried creating a case, but they don't want to help me there. Any bump in the right direction will be greatly appreciated.


    Release: v9.3.0_28919_29103 Build: 29103 Tue Mar 12 14:25:12 PDT 2019
    VM Memory: 24.9 of 52.4 MB used, 27.6 MB free
    Client Java VM: Java(TM) SE Runtime Environment 11.0.6
    Server Java VM: OpenJDK Runtime Environment 11.0.5
    Workstation: NA-D10-C103C-1 (NA-D10-C103C-1/10.128.18.132)
    Remote host: automic.mylmc.org (10.134.2.161)
    RMI Port: 1099
    Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
    Oracle JDBC driver 12.2.0.1.0

    ------------------------------
    Contract DBA
    Lake Michigan College
    Michigan
    ------------------------------