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()

     

KKGamer's avatar
KKGamer
New Contributor III
2 years ago

The ERPConenct code is working in V7 to extract data from same table so i believe it's fine from SAP side. And below is the code I used to call the SIF function, is there anything wrong on return the datatable? Thanks.

    Dim rDto As RemoteRequestResultDto = BRApi.Utilities.ExecRemoteGatewayBusinessRule(si, "SAPConnection",Nothing, "sapdevtest", "RunOperation")
							
	If (rDto.RemoteResultStatus = RemoteMessageResultType.Success) Then
		BRAPI.ErrorLog.LogMessage(si,"Connect success")
		BRApi.ErrorLog.LogMessage(si, "Data Returned: " & rDto.ResultSet.Rows.Count)
		Dim dt As DataTable															
		dt = rDto.ResultSet								
		Return dt
	Else
		If (Not (rDto.remoteException Is Nothing)) Then
		BRAPI.ErrorLog.LogMessage(si,"Connect failed")
		Throw ErrorHandler.LogWrite(si, New XFException(si, rDto.remoteException))
		End If
	End If