IBM Support

PM60954: SQLSCROLLBULKFETCH AND UDA ERROR ON XML BASED REPORT AFTER INSTALLING 8.4.1 FP4

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • XML datasource based report fails with error
??"sqlScrollBulkFetch status =-9, UDA-SQL-0528 GeneralXMLParser
Error "????The report works in 8.4.1 base but fails with above
error once FP4 is installed.????A combination of XML datasource
and report having a prompt page with multiple select and search
prompt that uses the same single query  seems to be causing the
issue once FP4 is installed. (See testcase for more
details)????There are several reports of this same design that
all fail once FP4 is installed. ????

Local fix

  • copy the shared query to another one and rename so that it looks
 like they are 2 separate queries. However there are several rep
orts and do not want to modify each one of them.

Problem summary

  • ****************************************************************
* USERS AFFECTED:                                              *
* All Users                                                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See error description.                                       *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to IBM Cognos Business Intelligence 10.2  or         *
* Upgrade to IBM Cognos 8 Business Intelligence 8.4.1 Fix Pack *
* 5                                                            *
*  or  Upgrade to IBM Cognos Business Intelligence 10.1.1 Fix  *
* Pack 2                                                       *
****************************************************************

Problem conclusion

  • Code Fix

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PM60954
    • 

  • Reported component name
    COG8 BI INST CO
    • 

  • Reported component ID
    5724W12IC
    • 

  • Reported release
    841
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2012-03-22
    • 

  • Closed date
    2013-03-28
    • 

  • Last modified date
    2013-03-28
    • 





    

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

  • Fixed component ID
    5724W12AD
    • 



Applicable component levels


    

  • RA11  PSN
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"841","Edition":"","Line of Business":{"code":"","label":""}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            06 March 2023
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback