Forum Discussion

ddgonzalez's avatar
ddgonzalez
Icon for OneStream Employee rankOneStream Employee
3 days ago

Connector BR fails to execute successfully

Hello Team,

I am currently writing a connector business rule that connects an EDM system to retrieve a file, apply mapping logic, and process the resulting DataTable into ACM. I have successfully implemented the same integration code for several other connectors, all of which are functioning as intended. 

However, when I attempt to apply the same logic for the Account connector, I encounter the following error:
"Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index')"

I have rewritten the rule twice but have not been able to resolve the issue.
Do you have any insights into why this might be occurring?

Connectors
Parsing
System

2 Replies

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    2 days ago

    Use BRApi.ErrorLog.LogMessage to identify the line that is failing. TBH if the failing bit is in the screenshot you attached, this does not seem to be anything to do with OneStream as much as your payload not being what you expect it to be (either not something that can be parsed as correct json, or receiving an error from the external webservice about a parameter you should have passed).

  • ddgonzalez's avatar
    ddgonzalez
    Icon for OneStream Employee rankOneStream Employee
    2 days ago

    Thanks for having a look JackLacava​! 
    Per your advice and the error log, looks like the system errors out once it begins evaluating the rows within the DataTable. 
    Could this serve as evidence that there is something wrong with the incoming payload? I did notice in the supplied file that there is a formula column that has an unusual long list of characters. I suspected this to be the issue, but was not entirely certain.