LAE

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

Originally posted by: xathras

Hi All,

I am starting to make us of the Execute BRX Node more, as I look to repeat several tasks, like loop loading data into 3 databases for a particular extract.

The issue is, lets say a node failes for whatever reason it that BRX e.g. DB connectivity is unavailable, the most unhelpful error messages are passed. See example below:

Node Load.Execute+BRX (508e96ea607c7a72) Node Completed with Errors.

Installing log (11/01/2012 17:37:21) ...
2012-11-01 17:38:06; Level: 3; Type: 0; Desc: "BRX exited with non-zero status: 6"; File: "ls.brain.node.brainpython.python2implementationfi le"; Line: 122; Context: "execute( ) - Exception"
2012-11-01 17:38:06; Level: 3; Type: 0; Desc: "Error pumping node (Traceback (most recent call last):
File "/opt/software/lae/4.1.8/lib/python/lavastorm/brain/python1.py", line 912, in Run
while n.pump(quant):
File "/work/tmp/brain/ECG_PCG_Extract/PRODUCTION/temp.til-bl-lap-02.aircell.prod.3641.1061520.1351791441773.prop", line 161, in pump
self.executor.execute(self.brx, self.username, self.password, props, self.doProps)
File "/work/tmp/brain/ECG_PCG_Extract/PRODUCTION/temp.til-bl-lap-02.aircell.prod.3641.1061520.1351791441773.prop", line 122, in execute
raise Exception, "BRX exited with non-zero status: %d" % (exitCode)
Exception: BRX exited with non-zero status: 6
)"; File: "ls.brain.node.brainpython.python2implementationfi le"; Line: 122; Context: "execute( ) - Exception"
Uninstalling log (11/01/2012 17:38:06) ...


Like wise, when configuring a BRX, the pass through parameters need to be in a specific order, if not, the BRX errors but no error message is through.

Is it possible to fix to:
1. Log the details of an Execute BRX so that I could pull a log file and see where specifically in an Execute BRX something failed
2. A more meaning error when running an there is an issue like the order of properties being based in. It seems like in the Controlling Graph properties in any order doesn't matter. But in an Execute BRX it does.

Please let me know if you need more information.

Regards
Wayne

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

Originally posted by: rboccuzzi

Hey Wayne, which version of ExecuteBRX are you using? It looks from above that you are using 4.1.8.

We added a lot more logging and better functionality in a newer version of ExecuteBRX (one that has two output pins and a ContinueOnError parameter.

If you use that one, make sure you set ContinueOnError? This should provide a lot more error logging.

I have attached an example graph and sub-graph...the graph calls the sub-graph using parameters in different orders (first two examples), and calls using wrong username in last example, and I get an output on the first output pin saying it failed, and on the second output pin, I get the actual node error:

ERROR opening i/o streams:
unable to begin session: ORA-01017: invalid username/password; logon denied

Hope this helps, sorry for the delay in answering

Cheers
Rich
Attachments:
Execute BRX Example.zip

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

Originally posted by: xathras

Hi Rich,

Thanks for the update. This was being run on the old 4.1.8 server version before we migrated to the newer server version last week. Thankyou for the example. I will try a negative test case on the new version and see what I get and update the forum.

Regards
Wayne