SSIS使用SAP Connector 连接BW
冷箫轻笛 2015-12-16 11:25:48 SSIS使用SAP Connector 连接BW
SAP Connector 1.0
SQL SERVER 2008 R2
配置好SSIS之后,不够稳定,经常会隔三差五会报错。
但是出现错误以后重新执行一般就好了。
不知道有没有高手用过这个。
最经常的错误如下:
消息
Executed as user: ABICHNMOBDB01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 9:03:44 AM Error: 2015-12-16 09:13:53.05 Code: 0xC0047062 Source: ????? SAP BI ?? [487] Description: System.Exception: A time out has occurred while waiting for the Request. at Microsoft.SqlServer.Dts.SapBw.Components.SapBwSourceBWLoader.ProcessInput(Int32 inputID, PipelineBuffer buffer) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket) End Error Error: 2015-12-16 09:13:53.05 Code: 0xC0047022 Source: ????? SSIS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "SAP BI ??" (487) failed with error code 0x80131500 while processing input "SAP BI ????" (490). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:03:44 AM Finished: 9:13:53 AM Elapsed: 608.922 seconds. The package execution failed. The step failed.