LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
  • 1.  'ls.brain.node.sqlRunner.commitFrequency' Substitution not found

    Employee
    Posted 10-19-2017 11:46

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: the1don

    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
    Don


  • 2.  RE: 'ls.brain.node.sqlRunner.commitFrequency' Substitution not found

    Employee
    Posted 10-19-2017 12:33

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: gmullin

    Can you try putting the value {{^^}} for the CommitFrequency parameter? It will explicitly tell it to be blank.


  • 3.  RE: 'ls.brain.node.sqlRunner.commitFrequency' Substitution not found

    Employee
    Posted 10-19-2017 14:24

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: the1don

    Thank you. That worked. Still confused however on 2 points.
    1) The graph runs without issues when it is run interactively and only fails when run command line on Linux.
    2) We have other graphs where the commit frequency is not set and they run successfully in both interactive and command line mode.

    I will need to do more research but for the time being this solves my problem.

    Thanks again