IV35842: POLLER THROWS UNSUPPORTED DATABASE TYPE: ORACLE11 WHEN POLLING IS FILTERED ON A VIEW.

IBM Tivoli Network Manager IP 3.9.0 Fix Pack 4, 3.9.0-TIV-ITNMIP-FP0004
IBM Tivoli Network Manager IP 3.9.0.3 Interim Fix 1, 3.9.0.3-TIV-ITNMIP-IF0001
IBM Tivoli Network Manager IP Edition 3.9.0 Fix Pack 5, 3.9.0-TIV-ITNMIP-FP0005

APAR status

• Closed as program error.

Error description

• ITNM 3.9 FP2 ( refresh) + database on Oracle 11 g
  Create a snmp policy. Filter the policy on a view created in the
  Network Views. Save the policy.
  In the ncp_poller.DOMAINNAME.trace we get the following error
  message:
  
  Exception in thread "Thread-21" java.lang.RuntimeException:
  Unsupported database type: oracle11
          at
  com.micromuse.topoviz.server.dblayer.NetworkViewDAOProvider.getN
  etworkViewDAO(NetworkViewDAOProvider.java:66)
  
  The poll might succeed but in some cases they will not.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All ITNM 3.9 poller users.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * POLLER THROWS UNSUPPORTED DATABASE TYPE: ORACLE11 WHEN       *
  * POLLING                                                      *
  * IS FILTERED ON A VIEW.                                       *
  * Create a snmp policy. Filter the policy on a view created in *
  * the Network Views. Save the policy.                          *
  * In the ncp_poller.DOMAINNAME.trace we get errors.            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * | fix pack | 3.9.0-ITNMIP-FP0004                             *
  ****************************************************************
  

Problem conclusion

• Change the code to handle all ""oracle" version.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TIV NETWK MGR I

• Fixed component ID

  5724S4500

Applicable component levels

• R390 PSN

     UP

• R390 PSY

     UP