IBM Support

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

Subscribe

You can track all active APARs for this component.

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 number

    IV89129

  • Reported component name

    NETCOOL/IMPACT

  • Reported component ID

    5724O59IS

  • Reported release

    710

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-09-13

  • Closed date

    2017-01-05

  • Last modified date

    2017-01-05

  • 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



Document information

More support for: Tivoli Netcool/Impact
Netcool/Impact

Software version: 710

Reference #: IV89129

Modified date: 05 January 2017