IV36819: MQL STATEMENT (OR API FIND) USING DATABASES ATTRIBUTE ON AN APPSERVER OBJECT FAILS WITH NUCLEUSEXCEPTION.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • When running the following api command, the exception occurs:
    ./api.sh -u administrator -p collation find "select * from
    SqlServer where exists (databases.name contains 'foo')"
    
    The result is:
    =============================
    CTJOX0101E There is an API processing error:
    java.rmi.ServerException:
    RemoteException occurred in server thread; nested exception is:
    java.rmi.RemoteException: CTJOX0193E The application cannot get
    objects from the Topology Manager: java.rmi.RemoteException:
    CTJOX0193E The application cannot get objects from the Topology
    Manager:
    java.rmi.ServerException: RemoteException occurred in server
    thread;
    nested exception is:
    java.rmi.RemoteException: Table APPSRVR manages at least 2
    subclasses that both define a field "databases_", and the
    fields' metadata is different or they have different type! That
    means you can get e.g. wrong fetch results.; nested exception
    is:
    javax.jdo.JDOFatalInternalException: Table APPSRVR manages at
    least 2 subclasses that both define a field "databases_", and
    the fields' metadata is different or they have different type!
    That means you can get e.g. wrong fetch results.
    NestedThrowables:
    org.datanucleus.exceptions.NucleusException: Table APPSRVR
    manages at least 2 subclasses that both define a field
    "databases_", and the fields' metadata is different or they
    have different type! That means you can get e.g. wrong fetch
    results....
    

Local fix

Problem summary

  • When running the following api command, the exception occurs:
    ./api.sh -u
    administrator -p collation find "select * from SqlServer where
    exists
    (databases.name contains 'foo')" The result is:
    =============================
    CTJOX0101E There is an API processing error:
    java.rmi.ServerException:
    RemoteException occurred in server thread; nested exception is:
    java.rmi.RemoteException: CTJOX0193E The application cannot get
    objects from the
    Topology Manager: java.rmi.RemoteException: CTJOX0193E The
    application cannot get
    objects from the Topology Manager: java.rmi.ServerException:
    RemoteException
    occurred in server thread; nested exception is:
    java.rmi.RemoteException: Table
    APPSRVR manages at least 2 subclasses that both define a field
    "databases_", and
    the fields' metadata is different or they have different type!
    That means you can
    get e.g. wrong fetch results.; nested exception is:
    javax.jdo.JDOFatalInternalException: Table APPSRVR manages at
    least 2 subclasses
    that both define a field "databases_", and the fields' metadata
    is different or
    they have different type! That means you can get e.g. wrong
    fetch results.
    NestedThrowables: org.datanucleus.exceptions.NucleusException:
    Table APPSRVR
    manages at least 2 subclasses that both define a field
    "databases_", and the
    fields' metadata is different or they have different type! That
    means you can get
    e.g. wrong fetch results....
    

Problem conclusion

  • The fix for this APAR is contained in the following maintenance
    packages:
    | Fix Pack | 7.2.1-TIV-ITADDM-FP0005
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV36819

  • Reported component name

    APP DEPENDENCY

  • Reported component ID

    5724N5500

  • Reported release

    721

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-15

  • Closed date

    2013-04-12

  • Last modified date

    2013-04-12

  • 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

    APP DEPENDENCY

  • Fixed component ID

    5724N5500

Applicable component levels

  • R721 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Application Dependency Discovery Manager

Software version:

721

Reference #:

IV36819

Modified date:

2013-04-12

Translate my page

Machine Translation

Content navigation