SAP Knowledge Base Article - Preview

1667913 - BI 4.0: "No data to retrieve" and BW dump when trying to run a Web Intelligence report based on BEx (BICS)


  • Error message "No data to retrieve" when trying to run a Web Intelligence report based on BEx (BICS). Whereas data is retrieved in BEx Analyser and when using transaction RSRT in the BW backend.
  • SAP BW dump that shows the error "ITAB_DUPLICATE_KEY".
  • No list of values is available when creating a query filter.



  • SAP BusinessObjects BI 4.0 SP02 Patch 2.9 
  • Web Intelligence BI Launchpad
  • Web Intelligence Rich Client
  • SAP BW 7.01 SPS 06+



SAP BusinessObjects Business Intelligence platform 4.0


xi 4.0 xi4.0 xi4 BASIS configuration query execution Bi client tools crash exception not enough memory webi report connection transports transport files not installed set up not performing performance data not returned bi4 bi40 LOV LOVs query results query filters unavailable not available infoview a row with the same name already exists ABAP terminated statement cannot be executed the statement insert initial line cannot be cannot be used to insert several initial lines into a table with a unique key termination message st22 , KBA , BI-RA-WBI , Web Intelligence , BI-RA-BICS , BI consumer services , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.