BookmarkSubscribeRSS Feed
mal
Calcite | Level 5 mal
Calcite | Level 5

Hi everyone,

I want to capture any run-time errors (as events) that may occur, like the password failing, or a database connection timeout. How do I get the Event Listener node to capture these so I can report them? I'm using DataFlux Data Management Studio 2.6.

I have tried using the Event Listener node in a process job that references two data jobs. The Event Listener node is configured for All events. It outputs to an Expression node where I write any captured information to a log file. As a test of this, I cleared the db credentials for the driver that I’m using, and when I run the job within DM Studio, the DM Studio logging (in-application logging) is reporting

“__ERRORMSG = [3:DEST_ODBC:Data Target (Insert) - LINK_OD_DF.DF_BRIDGE_ANIMAL_ASSUR_NUMS_T] [HY000] [DataFlux][ODBC Oracle Wire Protocol driver]Insufficient information to connect to the data source. (0)”

So an event is definitely thrown. But my Event Listen node is not capturing this, or any, error. The node is placed within the process job, where it theoretically will catch errors/events raised from the referenced data jobs. It is not connected to any other node in the job, other than the Expression node, if this matters.

Does anyone know how I can capture all run-time errors from a process job?

Thanks!

-  mark

2 REPLIES 2
MikeFrost
SAS Employee

Hi Mal,

You need to go into settings on the node that you expect to throw the error (in this case the process-level node that houses the data flow) and set the Node Errors behavior to “Only abort the flow that had the error”. This will give the event handler node a chance to process. By default, an error causes the whole job to abort, and so the event handler will not get a chance to run.

Regards,

Mike F.

mal
Calcite | Level 5 mal
Calcite | Level 5

HI Mike,

thanks! This is very helpful. after recording the error, if I want to abort the entire job, how do I configure that? I don't want the job to continue to the next data job.

THanks again!

- Mark

-

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1216 views
  • 0 likes
  • 2 in conversation