Parent and grandparent jobs of SAP HANA backups fail
Description:
Parent and Grandparent jobs of SAP HANA backups fail with the following error:
The backup failed to back up the requested files (6)
Snippet of job details:
Info bphdb (pid=40259) INF - SAP HANA backup statement: SQL execution failed with status: [SAP AG][LIBODBCHDB SO][HDBODBC] General error;447 backup could not be completed: [110090] Error while backing up backup catalog, [110507] Backint exited with exit code 1 instead of 0. console output: /bin/sh: which: line 1: syntax error: unexpected end o.
Solution or workaround:
The SAP intelligent policy sets the configuration changes to global.ini for SYSTEM and sets the dynamic path for utl files with the policyname prefix.
The file will be persisted in the following pat:h /usr/openv/tmp/
If DATABASE has the path of initSAP.utl file, it takes the precedence over SYSTEM and backup fails with error 6.
The solution to resolve the issue is to clear the path for the backup_parameter_path configuration option of DATABASE.