The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

NicolasArgente's avatar
NicolasArgente
Valued Contributor
2 years ago
Solved

SIC and SAP CreateFunction from ERPConnectStandard20.dll

Hi there! I am using OS v8.1 and SIC with latest ERPConnectStandard20.dll and the other dlls. I can connect to SAP and retrieve data using READTABLE. Now I am trying to use CreateFunction but I...
Connectors
  • NicolasArgente's avatar
    NicolasArgente
    2 years ago

    Problem solved. All my code was fine, the mistake was on the client side. It was missing an error an export field! We had to use ABAP debugger to find out.
    Thanks guys!

  • jwagner's avatar
    jwagner
    1 year ago

    Found the resolution

    Dim r3Conn As R3Connection =  New R3Connection()
r3conn.Protocol = ClientProtocol.NWRFC
r3Conn.Open()

     

Krishna's avatar
Krishna
Valued Contributor
2 years ago

NicolasArgente  - Could you please let me know what are the other DLL's are required apart from ERPConnect ? moreover could you please let me know what was the issue at SAP side ? I am using 8.3 & SIC and similar issue it is not returning any data.

Dim r3Conn = New R3Connection(SAPHost, SAPSysNum, SAPUser, SAPPwd, SAPLang, SAPClient)
Dim rfcFunction As New RFCFunction(r3Conn, "FUNNAME")

            ' Set the import parameters (if any)
            rfcFunction.Exports("YR").ParamValue = "2021"
	rfcFunction.Exports("MON").ParamValue = "01"
  rfcFunction.Execute()
				Dim data As DataTable = rfcFunction.Imports("TB").ParamValue.ToADOTable()
				Return data

 

  • jwagner's avatar
    jwagner
    New Contributor III
    1 year ago

    Has anyone ever seen this error message when trying to run a remote business rule through ERPConnect? I installed VisualStudio 2013, and I have the rfclib.dll sitting in System32 path.  Unsure where to go from here...

    ---> (Inner Exception #0) ERPConnect.RfcLibraryException: Cannot call classic RFC API.  See help for details.
Please put a recent 64-bit version of librfc32.dll in your System32 folder (typically C:\Windows\System32).
See SAP note 413708. Please make sure you have installed Visual C++ 2013 Redistributable (x64). ---> System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
   at ERPConnect.Classic.NativeMethods.RfcResetTraceDir(String newTraceDirectory)
   at ERPConnect.RFCAPI.ResetTraceDirectory(String path)
   --- End of inner exception stack trace ---
   at ERPConnect.RFCAPI.ResetTraceDirectory(String path)
   at ERPConnect.Classic.ClassicClient.Connect(String connectionString)
   at ERPConnect.R3Connection.Open(String& connectionString, String& ticket, Boolean& usesLoadBalancing)
   at ERPConnect.R3Connection.Open()
   at OneStream.BusinessRule.SmartIntegrationFunction.SAP_SIC_SmartIntegrationFunction.MainClass.RunOperation(String monthName, String yearName, String costUnit)
   at RunOperation_Proxy(Object , Object[] )
   at System.Threading.Tasks.Task`1.InnerInvoke()
   at System.Threading.Tasks.Task.Execute()<---

     

    • jwagner's avatar
      jwagner
      New Contributor III
      1 year ago

      Found the resolution

      Dim r3Conn As R3Connection =  New R3Connection()
r3conn.Protocol = ClientProtocol.NWRFC
r3Conn.Open()