SAP Knowledge Base Article - Public

1216043 - Report based off an SAP Infoset in Crystal Reports, times out when refreshed or scheduled in SAP BusinessObjects BI Platform

Symptom

  • Report fails to refresh.
  • When refreshing a report based off an Infoset, it times out.
  • Some report created off an SAP Infoset in Crystal Reports, times out when refreshed or scheduled in SAP BusinessObjects BI Platform.

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
       
  • SAP BusinessObjects Business Intelligence Platform 4.0
  • SAP BusinessObjects Business Intelligence Platform 4.1
  • SAP BusinessObjects Business Intelligence Platform 4.2

Reproducing the Issue

  1. In Crystal Reports, create  a report off an SAP Infoset.
  2. Filter the report data by creating a Record Selection Formula that use the function: isNull, like:
       
          isNull({IL Z_SALESBYREGION.CE31000-VERSI} OR {IL Z_SALESBYREGION.CE31000-VERSI} = "000"
            
  3. Save the report to the SAP BusinessObjects Repository.
  4. In SAP LaunchPad, refresh or schedule the report, and notice it times out.

Cause

  • The issue occurs when an Infoset returns a large data set, and the report contains a Record Selection Formula using: OR, or the isNULL function
  • Since OR, and isNull function cannot be translated into the ABAP code sent when using an SAP InfoSet driver, it fetch all the data back, and filter the data in Crystal Reports processing server, which takes time, and causes the time out.

Resolution

  • To ensure the report does not time out, remove the Record Selection Formula from the report, and add the filter in the InfoSets directly, so that a selection criteria is not needed inside the report, and performed on the SAP Server.

Keywords

INFOSET NULL RECORD SELECTION SAP R/3 BW3 Crystal Reports Crystal Enterprise mySAP solution kits enhanced SAP editions , c2013379 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016