Skip to Content
avatar image
Former Member

Error on RFC Conenction

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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.

    Add comment
    10|10000 characters needed characters exceeded