Assume that you try to extract a large volume of data from SAP Business Warehouse (SAP BW) by using Microsoft Connector 1.0 for SAP Business Intelligence (SAP BI) in a Microsoft SQL Server 2012 Integration Services (SSIS 2012) package. However, you receive the following error message:
[SAP BW Source] Error: System.ArgumentOutOfRangeException: Index and length must refer to a location within the string.
Parameter name: length
at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy)
at Microsoft.SqlServer.Dts.SapBw.Components.OHSExtractor.ExtractNow(Boolean InRuntimeMode, String GatewayHost, String GatewayService, String ProgramID, String ProcessChain, String DestinationName, String ExecutionMode, String PropertyRequestID, Int32 Timeout)
This issue is fixed by the SP1 refresh of the SapBI.msi file. The refreshed version of the SapBI.msi file is available on the SQL Server 2012 Feature Pack SP1 page at the following Microsoft website:http://www.microsoft.com/en-us/download/details.aspx?id=35580.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.
For more information about the Incremental Servicing Model for SQL Server, click the following article number to view the article in the Microsoft Knowledge Base:
An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems
For more information about the naming schema for SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:
Naming schema for Microsoft SQL Server software update packages
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
Description of the standard terminology that is used to describe Microsoft software updates