on 04-04-2014 6:13 AM
Hi,
We are scheduling the HANA DB backup using DB13, which returns with
immediate error as below. please suggest.
Regards
Vinay
Hello,
When using DBACOCKPIT to schedule backups, please refer to Note #2164096 firstly.
Also, from your error you are receiving a privileges error.
To see what privilege you are missing you can run the following authorisation trace in HANA first:
1) Please run the following statement in the HANA database to set the DB trace: alter system alter configuration ('indexserver.ini','SYSTEM') SET ('trace','authorization')='info' with reconfigure;
2) Reproduce the issue/execute the command again/
3) When the execution finishes please turn off the trace as follows in the Hana studio: alter system alter configuration ('indexserver.ini','SYSTEM') unset ('trace','authorization') with reconfigure;
This trace file will show you the exact privilege you are missing.
Kind Regards,
Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If the solution is not yet available:
1) User does not have privilege:
2) In the Command you have to give only Backup Prefix not the absolute path:
backup data using file ('COMPLETE_DATA_BACKUP_04_04');
is correct command.
-Sadanand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sadanad,
We are using DB13 to schedule the backup for HANA Database
so which user are you suggesting needs to be granted the BACKUP_ADMIN provilege?
I beleive when we schedule the backup via DB13 the back is launched on HANA under the DBACOCKPIT user and I already checked this user has the DBA_COCKPIT ROLE with BACKUP_ADMIN privilege
Please note the backups were running fine until about a few days after they were set from DB13
We have not changed any setup
Regards,
Sunil
Hi,
We have found the issue and here are some quick ways to check and resolve the issue:
1. Check the user under which the DBACockpit is connected to SAP HANA from the
DBACockpit-->Current Status-->Overview
Look for the Top left corner and you should find the USER indicated after the SID
2. Check if this user has the right authentication to perform a backup
connect to HANA Studio and check if the user from Step1 has the BACKUP_ADMIN privileges
3. You can also check tcode DBCO to identify which user is being used to connect to the SAP HANA Database, if there is no indication of a particular user mapped to the SID in DBCO it means DBACockpit is using SAPSID to connect to the SAP HANA Database
In our case we identified the user did not have the right privilege
We had to remove that user from DBCO to ensure the connection is established using the SAPSID
Do let me know if you have any questions
Regards,
Sunil
Hi Vinay,
Have you been abl to find a solution to this error?
Regards,
Sunil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.