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.  execute BRX node issue

    Employee
    Posted 10-11-2012 03:46

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

    Originally posted by: mgreenbank

    Hi,

    I've got a graph deployed onto the LAE server and scheduled, this graph contains an 'execute BRX' node to trigger another graph, I can get the first graph to run successfully but it doesn't trigger the second to run, has anyone had this issue?


    Thanks

    Matt


  • 2.  RE: execute BRX node issue

    Employee
    Posted 10-11-2012 18:49

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

    Originally posted by: stonysmith

    Both graphs have to be stored on the server.

    On the server is a "server log". You should check the messages in that log to see if any errors are being recorded there.

    I need to know a bit more about your configuration, but I should be able to help.. I run several hundred ExecuteBRX graphs per week.


  • 3.  RE: execute BRX node issue

    Employee
    Posted 10-18-2012 08:05

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

    Originally posted by: khopkins

    Hi Stony,

    I have attached the graphs in a zip file that are almost identical to the ones we are attempting to run.
    Both of these are deployed onto the LAE server but the "Marketing_Usage_Calls.brx" does not run when the other brx runs.

    I believe that we are probably missing something simple but if you could help it would be appreciated.

    Regards,

    Keith
    Attachments:
    ExecuteBrx.zip


  • 4.  RE: execute BRX node issue

    Employee
    Posted 10-18-2012 10:39

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

    Originally posted by: stonysmith

    On the ExecuteBRX node, go ahead and fill in a field named for ResultField, and LogField, then run the node again.
    Then, examine the output of ExecuteBRX to see if either of those fields contain any useful info.


  • 5.  RE: execute BRX node issue

    Employee
    Posted 10-22-2012 03:10

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

    Originally posted by: khopkins

    Sorry Stoney,

    What should we be filling these fields with Inputs or parameters?


  • 6.  RE: execute BRX node issue

    Employee
    Posted 10-22-2012 06:56

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

    Originally posted by: stonysmith

    Just put in any name.. use "ResultField" and "LogField" if you wish... these will be the names of two new columns added to the output stream.


  • 7.  RE: execute BRX node issue

    Employee
    Posted 10-23-2012 05:38

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

    Originally posted by: khopkins

    Thanks Stoney,

    I have sorted out the issue now and have discovered that if you are passing parameters into the brx to be executed they need to be blank as these will be passed from the execute brx node causing a failure.
    Also if there are jdbc query nodes you can not have any parametrised contents otherwise this also causes it to fail EG DbDriver needs to be hardcoded with com.ibm.as400.access.AS400JDBCDriver instead of {{^Parameter^}}

    Regards,

    Keith