Results 1 to 2 of 2

Thread: 'ls.brain.node.sqlRunner.commitFrequency' Substitution not found

  1. #1

    Default 'ls.brain.node.sqlRunner.commitFrequency' Substitution not found

    Graph errored: Error in execution
    caused by: Error substituting run arguments: Error substituting in node '58acbc407b48140d': Error substituting in property 'ls.brain.node.sqlRunner.commitFrequency': Substitution not found for key CommitFrequency for substition type {{$$}}.
    Graph Completed with Errors.

    So when I look at all my database nodes the commit frequency is blank and thus I believe the resulting error. However when I run it manually there is no issue. The graph finishes successfully.

    Is there a file where a setting needs to be set?

    Thank you

  2. #2
    Lavastorm Employee gmullin's Avatar
    Join Date
    May 2014
    Location
    Chicago
    Posts
    185

    Default

    This happens when you run your graph as BRX or through Logistics Manager? I presume it's the DB or JDBC Execute. Do you have any Graph or Run Parameters named CommitFrequency? Or any other parameters created within the node causing the problem?

    It might be worth trying putting in the value {{^^}} in the CommitFrequency parameter, compiling the graph and executing it again. I tried executing a graph with the DB Execute node as BRX on an Oracle database and it worked fine as blank or with {{^^}}. If I explicitly put in {{$$}} I get the same error as you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •