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

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

Cindy6 — Thu, 24 Oct 2019 19:48:22 GMT

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.

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

diremachine — Fri, 25 Oct 2019 18:26:30 GMT

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.

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

Rama_V — Sun, 27 Oct 2019 00:18:14 GMT

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

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

Cindy6 — Mon, 28 Oct 2019 12:53:41 GMT

Thanks. I will do that.