cancel
Showing results for 
Search instead for 
Did you mean: 

Error on RFC Conenction

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.