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
------------------------------