IV29576: WMB WS-SECURITY POLICY FEED QUERIES FAIL ON ORACLE WITH ORA-00933

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • WMB WS-Security policy feed queries fail on Oracle with
    ORA-00933
    

Local fix

  • Not applicable
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All users of WebSphere Service Registry and Repository Server
    Version 7.5.0 and 8.0.0
    
    
    ****************************************************************
    PROBLEM SUMMARY:
    When using an Oracle database and attempting to view WebSphere
    Message Broker (WMB) policy data in the Business Space Service
    Registry Operational Policy Enforcement Overview widget, no data
    is displayed and the following errors are seen in the widget:
    
    No policy data available: Error: Unable to load
    /ServiceRegistryFeeds/WSRR/V.R/policyanalytics/WMB/ACCNTSTAT/pol
    icydatabytopmost?startdate=YYYY-MM-DDT00%3A00%3A00%2B01%3A00&end
    date=YYYY-MM-DDT23%3A59%3A59%2B00%3A00&dojo.preventCache=1352735
    078828 status:404.
    
    No policy data available: Error: Unable to load
    /ServiceRegistryFeeds/WSRR/V.R/policyanalytics/WMB/ACCNTSTAT/pol
    icydatabytopmost?topx=5&byactual=true&byfailing=true&startdate=Y
    YYY-MM-DDT00%3A00%3A00%2B01%3A00&enddate=YYYY-MM-DDT23%3A59%3A59
    %2B00%3A00&dojo.preventCache=1352735079516 status:404.
    
    where V.R is 7.5 or 8.0 depending on the version used and the
    YYYY-MM-DD dates depend on the widget settings.
    
    Additionally the following error is reported in the the
    SystemOut.log:
    
    java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not
    properly ended
    

Problem conclusion

  • The SQL which queries the database to retrieve the WMB policy
    data has been corrected for use against an Oracle database.
    
    This fix is targeted at WSRR v7.5.0.3 and v8.0.0.2.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV29576

  • Reported component name

    SERVICE REGISTR

  • Reported component ID

    5724N7200

  • Reported release

    750

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-05

  • Closed date

    2012-12-21

  • Last modified date

    2012-12-21

  • 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

    SERVICE REGISTR

  • Fixed component ID

    5724N7200

Applicable component levels

  • R750 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Service Registry and Repository

Software version:

7.5

Reference #:

IV29576

Modified date:

2012-12-21

Translate my page

Machine Translation

Content navigation