* 10: authentication failed SQLSTATE: 28000

[Former Member]

Hello,

As a part of daily hana backup I have triggered  backup via crontab using backint  -- tsm  . I check from the server logs backup not successful but when i check from hana studio backup catalog  and backup.log file I see it is successful.

Do I assume backup is successful?

********** script**********

INSTANCE_NUMBER="00"

USERSTORE_BACKUP_RECORD="BACKUP"

LOGDIR="/var/tmp/tsmlog"

TIMESTAMP=$(date +%b_%d_%Y)

LOGFILE="daily_data_bck_$TIMESTAMP.log"

LOGRETENTION="45" #in days

$HDBSQL -i $INSTANCE_NUMBER -n $HOSTNAME -U $USERSTORE_BACKUP_RECORD -f -t "backup data using backint ('$TIMESTAMP')" > $LOGDIR/$LOGFILE 2>&1

**********

from daily_data_bck_<data>.log

----

* 10: invalid username or password SQLSTATE: 28000

backup data using backint ( ' date ')

Password:Backup not succesfull

Regards,

DK

[lucas_oliveira · Accepted solution]

No. Don't assume it was successful. It seems clear that is not executing the backup due to wrong credentials.

For backint there's a specifc backup log (backint.log instead of backup.log). Double check it from you TSM tools as well.

Regards,

Lucas de Oliveira

[Former Member · Accepted solution]

Hi Lucas,

I find hdbuserstore password was deactivated.

Regards,

DK

[Former Member]

This message was moderated.