Error message on last node of data job (Match Report) - "Create file: unable to open database file"

[Cindy6]

We have a DataFlux data job with clustering, surviving records, and the last node, a match report node, is giving an error when we try to run the job. The error message is "Create file:  unable to open database file."

The first node gets the data from the database just fine, all of the nodes preview fine.

When we run the job, all of the nodes execute fine, but the last node, the match report node gives this error.

We are running version 2.5.0.19.

Can anyone help?

We are new users.

Thank you.

[diremachine]

Found the issue, had to do with embedded macros in the node set by a previous user. When reconstructing the problematic node from scratch, it ran without a problem.

[Rama_V · Accepted solution]

Can you open Advanced properties and look for destination path, Macro Variables? Check those paths are valid? 

[Cindy6]

Thanks. I will do that.