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

Article translations Article translations
Article ID: 2754444 - View products that this article applies to.
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.
Expand all | Collapse all

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: January 14, 2013 - Revision: 6.0
Applies to
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Standard
Keywords: 
kbtshoot kbqfe kbfix kbsurveynew kbexpertiseadvanced KB2754444

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com