How should I handle connection issues during template deployment?

Whether you’re working with Privacy, Subset or Analyze, all DATPROF software relies on a connection with a source (and sometimes target) database to pull meta-data, and to push instructions to the database during a run. This meta-data is descriptive information about the structure of tables and their contents, as well as information as to how these tables are interconnected through foreign or primary keys.

Sometimes, a connection to the database either fails to establish, or is unstable, causing issues. When this happens, generally a module in the deployment of a template will throw an error.

Resolution

Connectivity issues are generally sporadic, and can be solved with an automatic retry, which will retry a failed step once after a specified amount of minutes. To configure this, go to Deployment → deployment options and logging → settings → automatically retry errors.

If a connection issue cannot be resolved with an automatic retry, follow these steps

• Do not skip any modules, as this will often cause a run to fail.

• In Subset/Privacy/Analyze, go to the Project Settings menu

• Open the connection editor

• Check the supplied credentials and connection parameters (if you are uncertain which fields are required, refer to the program’s manual).

• Check whether there have been any changes in the local network configuration such as a change to the firewall, or a change in the database configuration

Generally, if all of the above points are configured correctly, a run should execute without connectivity issues. However, if you need to cancel a run in order to troubleshoot connection issues, abort the run and retry once you’ve resolved the underlying network issue.