IV89129: SYBASE DATATYPE CONFIG DOES NOT WORK PROPERYLY UNDER IMPACT 7.1 WITH FIXPACK6.

7.1.0-TIV-NCI-LINUX-FP0009
7.1.0-TIV-NCI-ZLINUX-FP0009
7.1.0-TIV-NCI-WINDOWS-FP0009
7.1.0-TIV-NCI-SOLARIS-FP0009
7.1.0-TIV-NCI-AIX-FP0009
IBM Tivoli Netcool/Impact V7.1.0 Fix Pack 9(7.1.0-TIV-NCI-FP0009)
IBM Tivoli Netcool/Impact V7.1.0 Fix Pack 10(7.1.0-TIV-NCI-FP0010)
IBM Tivoli Netcool/Impact V7.1.0 Fix Pack 11(7.1.0-TIV-NCI-FP0011)
IBM Tivoli Netcool/Impact V7.1.0 Fix Pack 12 (7.1.0-TIV-NCI-FP0012)
IBM Tivoli Netcool/Impact V7.1.0 Fix Pack 13 (7.1.0-TIV-NCI-FP0013)

APAR status

• Closed as program error.

Error description

• After upgrade from 7101 to 7106 could not  discover schema for
  table
  Sybase. With same database same table, it is working fine on
  7101.
  
  In 7106, after create data source, then create datatype, when
  click
  Refresh Fields, there is error popup :
  
  "Could not discover schema for table 'iams.RootLevel'. Please
  check the
  database type, location, username and password. For more
  information,
  consult the documentation. It is also possible that the
  specified
  database is not compatible with auto schema discovery."
  
  Error in impactserver-error.log:
  
  Could not discover schema for table 'iams.AlertSource'. Please
  check
  the database type, location, username and password. For more
  information, consult the documentation. It is also possible
  that the
  specified database is not compatible with auto schema discovery.
  com.micromuse.response.common.RespException: Could not discover
  schema
  for table 'iams.AlertSource'. Please check the database type,
  location,
  username and password. For more information, consult the
  documentation.
  It is also possible that the specified database is not
  compatible with
  auto schema discovery.
      at
  com.micromuse.response.common.SQLSchemaDiscoverer$1GetSchemaTran
  sBlock.d
  oit(SQLSchemaDiscoverer.java:266)
      at
  com.micromuse.common.util.TimedExecutor$CallableTransBlockAdapte
  r.call(T
  imedExecutor.java:112)
      at
  com.micromuse.common.util.concurrent.NamedDelegatingCallable.cal
  l(NamedD
  elegatingCallable.java:71)
      at java.util.concurrent.FutureTask.run(FutureTask.java:274)
      at
  com.micromuse.common.util.concurrent.TrackingExecutor$1.run(Trac
  kingExec
  utor.java:105)
      at
  java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExec
  utor.jav
  a:1157)
      at
  java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExe
  cutor.ja
  va:627)
      at java.lang.Thread.run(Thread.java:798)
  Caused by:
  com.micromuse.common.datasource.SQLDataSourceException: Syntax,
  Duplicate or Resync Error...
      at
  com.micromuse.common.datasource.JDBCVirtualStatement.tryAndRetry
  (JDBCVir
  tualStatement.java:391)
      at
  com.micromuse.common.datasource.JDBCVirtualStatement.executeQuer
  y(JDBCVi
  rtualStatement.java:511)
      at
  com.micromuse.common.datasource.JDBCVirtualStatement.executeQuer
  y(JDBCVi
  rtualStatement.java:495)
      at
  com.micromuse.common.datasource.JDBCVirtualStatement.executeQuer
  y(JDBCVi
  rtualStatement.java:489)
      at
  com.micromuse.response.common.SQLSchemaDiscoverer$1GetSchemaTran
  sBlock.d
  oit(SQLSchemaDiscoverer.java:259)
      ... 7 more
  Caused by:
  com.sybase.jdbc3.jdbc.SybSQLException: iams.AlertSource not
  found.
  Specify owner.objectname or use sp_help to check whether the
  object
  exists (sp_help may produce lots of output).
  
      at com.sybase.jdbc3.tds.Tds.processEed(Unknown Source)
      at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
      at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown
  Source)
      at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown
  Source)
      at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown
  Source)
      at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown
  Source)
      at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown
  Source)
      at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown
  Source)
      at
  com.micromuse.common.datasource.JDBCVirtualStatement$ResultSetEx
  ecutor.d
  oit(JDBCVirtualStatement.java:259)
      ... 7 more
  

Local fix

• No local fix.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Impact Users                                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * In Impact 7106, after create Sybase data source, then create *
  * datatype, when                                               *
  * click Refresh Fields, there is error popup :                 *
  *                                                              *
  * "Could not discover schema for table 'schema.table'. Please  *
  * check the database type, location, username and password.    *
  * For more                                                     *
  * information, consult the documentation. It is also possible  *
  * that the                                                     *
  * specified database is not compatible with auto schema        *
  * discovery."                                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Single dot is use for separator between schema and table, but
  Sybase is double dot instead, so change separator  to double
  dot.
  
  The fix for this APAR is contained in the following
  maintenance packages:
  | Fix Pack | 7.1.0-TIV-NCI-FP0009
  

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:

Modules/Macros

• UNKNOWN
  

Fix information

• Fixed component name

  NETCOOL/IMPACT

• Fixed component ID

  5724O59IS

Applicable component levels

• R710 PSY

     UP