Reporting: Logging does not work inside chart script

[pturmel]

1. Move your code to a project library script, and move all imports outside the def, along with the creation of the logger object (so it is persistent).

2. In the first line inside the def, invoke the logger.

3. Ideally, nest all the rest of the code in a double-except try: construct, so you can log both java and jython errors. Something like this:

Database connection Faulted - Errors list

There's no fixed list, as different JDBC drivers all have there own error messages. Also, the only reliable point to trap errors is in scripted calls to perform database operations, where you use a double except clause. Something like this in a project library script: from java.lang import Throwable def someProcessingFunction(someArgument): # .... try: result = system.db.runPrepQuery(....) except Throwable, t: # handle java and jdbc errors here except Exceptio…