Extracting data (SAP Source in SSIS-2008)

Question

Extracting data (SAP Source in SSIS-2008)

saurabh.deshpande

SSCommitted

Points: 1738
More actions
October 15, 2010 at 5:53 am

#157263

HI ALL
I am connecting SAP BW through SSIS 2008 using
Microsoft connector 1.0.
I am getting following error while extracting.
[SAP BI 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)
---------
[SAP BI Source [1]] Error: System.ArgumentOutOfRangeException: Index and length must refer to a location within the string.
Parameter name: length
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)
at Microsoft.SqlServer.Dts.SapBw.Components.SapBwSourceOHS.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)
--------
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "SAP BI Source" (1) returned error code 0x80131502. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246991 More actions · Answer 1

I presume you want help identifying why this error is occurring and are not just telling everyone your plight for information purposes.

Are you doing any string manipulation (using functions such as instr, right, left, len, mid etc)?

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

saurabh.deshpande SSCommitted Points: 1738 More actions · Answer 2

Yes, this is error I am getting.

No, I am not writting any code here.

Just used Micosoft connector 1.0, which extracts the data from

SAP BW System.

I have simple package Src ---> Tgt

Please see the attachment.

thanks

COZYROC One Orange Chip Points: 28499 More actions · Answer 3

This looks like a bug in the Microsoft connector. I would recommend you contact them or post step-by-step report in SQL Connect.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

saurabh.deshpande SSCommitted Points: 1738 More actions · Answer 4

Yes, it is bug in Connector.

I got letest version of MS connector, here they fixed the bug.

Thanks