NetWorker: PostgreSQL Database Backup is Not Completing With Error "The Parameter 'NSR_BACKUP_SCRIPT' is Not Set"
Summary: NMDA PostreSQL DataBase backup fails through the Orchestrated Application Protection when: Level of backup set mismatching between NMC workflow configuration and NSR_BACKUP_LEVEL in postgresconfig.cfg, Only the schedule backup fails when it runs from NMC workflow, and Manual backup works from client command line following the level NSR_CONFIG_FILE = /nsr/apps/config/postgresconfig.cfg. ...
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Symptoms
Same Backup error reported to:
Figure 1: NMC Workflow Backup Fails NSR Backup Script Not Set
Figure 2: Workflow Error on Policy Log
Figure 3: NMDA PostgreSQL Logs Report Same Error
- The NetWorker Management Console (NMC) workflow backup fails passing savefs with error, pointing to 'NSR_BACKUP_SCRIPT' is not set.
Figure 1: NMC Workflow Backup Fails NSR Backup Script Not Set
- Workflow generates same error to policy log:
Figure 2: Workflow Error on Policy Log
- NMDA PostgreSQL logs reports same error from client under nsr/apps/logs/nsroappbackup_OAPP_year_month_day.hh_mm_ss.processID.log "Process ID#257129" from below example:
Figure 3: NMDA PostgreSQL Logs Report Same Error
Cause
The level of backup set incorrectly and mismatching the configuration file:
Figure 4: Backup Configuration's Backup Level is Set to Incremental.
Figure 5: Client's /nsr/apps/config/postgresconfig.cfg Set to Full
- The backup configuration's backup level is set to Incremental (Incr):
Figure 4: Backup Configuration's Backup Level is Set to Incremental.
- The client's /nsr/apps/config/postgresconfig.cfg set to Full:
Figure 5: Client's /nsr/apps/config/postgresconfig.cfg Set to Full
Resolution
Correct the level of backup to Full in Workflow Configuration in NMC matching the postgresconfig.cfg.
Figure 6: Set Level of Backup to Full in Workflow Configuration
Workflow backup runs and completes successfully.
Figure 7: Workflow Backup Successfully Completes-All Sessions
Figure 8: Workflow Backup Successfully Completes
Figure 6: Set Level of Backup to Full in Workflow Configuration
Workflow backup runs and completes successfully.
Figure 7: Workflow Backup Successfully Completes-All Sessions
Figure 8: Workflow Backup Successfully Completes
Affected Products
NetWorker, NetWorker Module for Databases and ApplicationsProducts
NetWorker Family, NetWorker Series, NetWorker ModuleArticle Properties
Article Number: 000212516
Article Type: Solution
Last Modified: 01 May 2023
Version: 2
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.