Skip to Content

Error on RFC Conenction

Jan 09, 2017 at 04:15 PM


avatar image
Former Member

Hi Everyone,

we connected Microsoft BI to SAP Table and extract al important table to MS BI. But today, there is an Error on the Table FAGLFLEXA:

DFT Load SAP FAGLFLEXA Delta:Error: ERPConnect.ERPException: Connection is not valid
at ERPConnect.RFCFunction.ExecuteRFC(Byte[] ti
at ERPConnect.RFCTableColumnCollection.Create(String tabname, RFCFunction rfcGetNametab)
at ERPConnect.RFCTable.RetrieveColumnsByStructure(String structureName, R3Connection connection
at ERPConnect.RFCTable.CreateFromDataDictionary(RFCStructure rfcFunInt, R3Connection r3Connection)
at ERPConnect.RFCFunction.RetrieveMetadata
at ERPConnect.RFCFunction.CreateFromDataDictionary(R3Connection r3Connection, String nam
at XtractKernel.Extractors.TableExtractor.Extract
at XtractKernel.Extractors.ExtractorBase`1.Extract(ProcessResultCallback processResult)
at XtractIS.XtractSourceTable.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManage

we don't know where is the Problem with the RFC Connection. Can anybody help?. Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Feb 08, 2017 at 11:09 PM

Apparently your connection was not established successfully, per the log on first line says. You have to analyze your RFC setup in SM59, system user credential and roles, and then gradually narrow down on the root cause. It's not a bad idea to talk to your Basis team.

10 |10000 characters needed characters left characters exceeded