IBM Support

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

Direct links to fixes

8.0.0.3-WS-WSRR-ZOS-IFIV65487_IV79085_IV87422_IV87429_IV89477
8.0.0.3-WS-WSRR-MultiOS-IFIV65487_IV79085_IV87422_IV87429_IV89477
WebSphere Service Registry and Repository V8.0 Fix Pack 2

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 / Xsystem
    • 

  • 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
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSWLGF","label":"WebSphere Service Registry and Repository"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            21 December 2012
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback