Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
 View Only
  • 1.  while generating a report got error like 'sqlScrollBulkFetch' status='-9'

    Posted 05/05/20 01:15 PM
      |   view attached
    ​Could not generate a PDF file of a particular Policy id,using the "Policy-PDF" funtion and received the following message:

    An error occurred while performing operation 'sqlScrollBulkFetch' status='-9'.

    Please see attached file for details.



    ------------------------------
    Vishal Das
    ------------------------------

    #CognosAnalyticswithWatson

    Attachment(s)

    docx
    PDF Error.docx   19 KB 1 version


  • 2.  RE: while generating a report got error like 'sqlScrollBulkFetch' status='-9'

    Posted 05/06/20 05:29 AM

    Hello Vishal,

    the key note in this message is: The file system is full. 
    Check disk and temp space on database end as well the IBM Cognos environment.

    Best regards, stay save and healthy.



    #CognosAnalyticswithWatson


  • 3.  RE: while generating a report got error like 'sqlScrollBulkFetch' status='-9'

    Posted 05/20/20 02:08 AM
    Hi Gertrud,
    Thanks for the information, the disk space is on the IBM cloud itself.
    Then I will have to reach IBM for that.



    ------------------------------
    Vishal Das
    ------------------------------



  • 4.  RE: while generating a report got error like 'sqlScrollBulkFetch' status='-9'

    Posted 05/25/20 08:13 PM

    The Db2 client is reporting that the Db2 server is throwing the error.

    Your query is running out of server (Db2 server) side resources.



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------