SFTP Connection with PPK file
Hi Everyone, Has anyone worked on establishing an SFTP connection in extensibility rules using a PPK file? I am currently facing an issue where, despite setting the SshPrivateKeyPath property in the session options, I receive the error: "No supported authentication methods available (server sent: publickey)." Any insights or solutions would be greatly appreciated. Thank you, MithunSolved159Views1like8CommentsDecimal column is always dirty
Hi, I need to check in a Table View if certain column values are dirty and I've noticed that when you call the IsDirty() function on any decimal type column (and this only happens on that type), it always returns 'true' even though no changes took place. Because of this i need to manually parse the value and check if the originalValue is different from the current value. At this point I was wondering if this behaviour is intended or not, it seems odd that IsDirty() returns the correct value for every type of value BUT a decimal one. Any clarification on this matter is appreciated, thanks in advance. 🙂33Views0likes0CommentsTable view service - get customSubstVars inside SaveTableView function
Hi, I need to use inside my Table View service some parameters that are bound to combo boxes in order to write a query, and execute it when the "SaveTableView" function is called. Unlike the "GetTableView" function, SaveTableView's signature doesn't provide a parameter that contains all substitution variables (Dictionary<string, string> customSubstVars for GetTableView) I also tried setting the customSubstVars dictionary into the BRGlobals from the GetTableView function, but once you try getting the dictionary from the globals, it returns null. Is there no way of getting this customSubstVars dictionary to use it inside SaveTableView?Solved31Views0likes3Commentsapi.data.clearcalculateddata vs. clearing data using databuffer
Hi OS Community, Hope you are doing well! Out of curiosity, I wanted to check which approach is more efficient for clearing data: using api.data.clearcalculateddata or clearing combinations using databuffer? Few examples would be really helpful. Thank you!42Views0likes1CommentBR Error Version 8.5 from Version 7.4
Hello OS Community - We are in process of testing 8.5 version upgrade and running into below error on one of the BR, looking for solution any help is appreciated. Error at line 963: Overload resolution failed because no accessible 'GetMemberInfo' is most specific for these arguments: 'Public Overloads Function GetMemberInfo(si As SessionInfo, dimTypeId As Integer, memberName As String, [includeProperties As Boolean = False], [dimDisplayOptions As DimDisplayOptions = Nothing], [memberDisplayOptions As MemberDisplayOptions = Nothing]) As MemberInfo': Not most specific. 'Public Overloads Function GetMemberInfo(si As SessionInfo, dimTypeId As Integer, dimNameOrEmpty As String, includeInheritedDims As Boolean, memberName As String, [includeProperties As Boolean = False], [dimDisplayOptions As DimDisplayOptions = Nothing], [memberDisplayOptions As MemberDisplayOptions = Nothing]) As MemberInfo': Not most specific.Solved53Views0likes6CommentsHow do I get workflow info on a DataQualityEventHandler rule?
I'm making a simple event handler rule that sends an email when a workflow is processed. I would like the email to include the datetime when it was processed, the user who did it, the workflow, workflow profile and entity. However I've only been able to include the date and time. My code is structured like this: Main calls the sub XFR_HandleEndProcessCube() Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DataQualityEventHandlerArgs) As Object Try Dim returnValue As Object = args.DefaultReturnValue args.UseReturnValueFromBusinessRule = False args.Cancel = False Select Case args.OperationName Case Is = BREventOperationType.DataQuality.ProcessCube.EndProcessCube Me.XFR_HandleEndProcessCube(si, globals, api, args) End Select Return returnValue Catch ex As Exception Throw ErrorHandler.LogWrite(si, New XFException(si, ex)) End Try End Function XFR_HandleEndProcessCube() sub sends the email, using the helper function ComposeMessageBody() Private Sub XFR_HandleEndProcessCube(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DataQualityEventHandlerArgs) Try ' Send an email when EndProcessCube happens ' Set email parameters Dim emailConnectionName As String = "..." Dim toEmailAddresses As New List(Of String) From {"..."} 'TODO: Make dynamic! Dim subject As String = "Test Email from OneStream" Dim body As String = ComposeMessageBody(si, api, args) Dim isBodyHtml As Boolean = True BRApi.Utilities.SendMail(si, emailConnectionName, toEmailAddresses, subject, body, isBodyHtml, Nothing) Catch ex As Exception Throw ErrorHandler.LogWrite(si, New XFException(si, ex)) End Try End Sub The code for ComposeMessageBody(): Private Function ComposeMessageBody(ByVal si As SessionInfo, ByVal api As Object, ByVal args As DataQualityEventHandlerArgs) As String Try Dim messageBody As New Text.StringBuilder messageBody.AppendLine("<style>th,td{border: 1px solid; padding: 5px;}</style>") messageBody.AppendLine("<h2>The following workflow has been processed successfully:</h2>") messageBody.AppendLine("<table>") messageBody.AppendLine("<tr><th>Attribute</th><th>Description</th></tr>") messageBody.AppendLine("<tr><td>User</td><td>" & si.UserName & "</td></tr>") messageBody.AppendLine("<tr><td>Time Completed</td><td>" & DateTime.Now.ToLocalTime.ToString() & "</td></tr>") 'messageBody.AppendLine("<tr><td>Workflow</td><td>" & api.Workflow.CurrentWorkflowProfile.Name & "</td></tr>") 'messageBody.AppendLine("<tr><td>Cube</td><td>" & api.Pov.Cube.Name & "</td></tr>") messageBody.AppendLine("</table>") Return messageBody.ToString() Catch ex As Exception Throw ErrorHandler.LogWrite(si, New XFException(si, ex)) End Try End Function As you can see from the lines commented above I've tried using api.Workflow and api.Pov. However, using either results in a "object variable or with block variable not set" error. What alternatives do I have for including this data in the business rule?Solved63Views0likes6Comments