SAP Knowledge Base Article - Preview

1989647 - Web Intelligence SQL query that returns a lot of data runs for over an hour in BI 4.1 that completed in 5 minutes in XI 3.1

Symptom

  • When viewing or scheduling a report in BI 4.1, the report takes more time to return data than in previous release
  • Web Intelligence SQL query that returns a lot of data runs for over an hour in BI 4.1 that completed in 5 minutes in XI 3.1
  • The report continues to fetch data all the way up to the database or server timeout
  • SQL generated between XI 3.1 and BI 4.1 are the same and returning the same amount of data


Read more...

Environment

  • SAP Business Intelligence 4
  • SAP BusinessObjects Enterprise
  • Web Intelligence
  • Oracle

Product

SAP BusinessObjects Business Intelligence platform 4.1

Keywords

WebI, WebIntelligence, Web Intelligence, long running query, a lot of data, returns, timeout, times out, migrate, upgrade, refresh, schedule, run, rows, records, million, BI4, ADAPT01712514, ADAPT1712514, ADAPT 01712514, 1712514, 5000536721,ADAPT01712515 , KBA , BI-RA-WBI , Web Intelligence , Bug Filed

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.