3 Replies Latest reply: Oct 25, 2011 1:43 PM by David Heisler-Oracle RSS

    MW version 2.19 scripts still reference dropped table EOF_INSTANCE_CONFIG

    user99472
      NOTE: It appears that table MW.EOF_INSTANCE_CONFIG was dropped as part of MW v2.19 and replaced by table EOF_CONFIG.

      I upgraded to 2.19 and tried to run "Utilities->Alter Debug Mode" and received this error:

      ...................................
      Enter value for 1: Enter value for 2: Enter value for 3: update EOF_INSTANCE_CONFIG
      *
      ERROR at line 1:
      ORA-00942: table or view does not exist
      from EOF_INSTANCE_CONFIG
      *ERROR at line 2:
      ORA-00942: table or view does not exist
      Process Returned: 0 Results in: /up2001/R12/10g/102/eof/log/INSTANCE_1703/script_10432.sh (128 bytes)
      ...................................


      The "upd_attrib.sql" script is the one that is failing in the "script_10432.sh" above.

      Here are the contents of the "script_10432.sh" script:
      ...................................
      #!/bin/sh

      sqlplus -s /nolog << SQL
      connect ${EOFUSER}/${EOFPASSWORD}
      @${EOF_COMMON}/upd_attrib.sql
      YES
      DEBUG
      $INSTANCE_ID
      SQL
      ...................................


      I replaced EOF_INSTANCE_CONFIG with EOF_CONFIG in the upd_attrib.sql file and re-ran the "Utilities->Alter Debug Mode" action and it worked.