You are currently offline, waiting for your internet to reconnect

FIX: "Index and length must refer to a location within the string" error message when you extract a large volume of data from SAP BW in an SSIS 2012 package

Microsoft distributes Microsoft SQL Server 2012 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2012 fix release.
Symptoms
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)
Resolution
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.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
More information
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.
References
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:
935897 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:
822499 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:
824684 Description of the standard terminology that is used to describe Microsoft software updates
Properties

Article ID: 2754444 - Last Review: 01/14/2013 18:30:00 - Revision: 6.0

Microsoft SQL Server 2012 Enterprise, Microsoft SQL Server 2012 Developer, Microsoft SQL Server 2012 Standard

  • kbtshoot kbqfe kbfix kbsurveynew kbexpertiseadvanced KB2754444
Feedback