Source:Troubleshooting SAP HANA

From SEPsesam
Revision as of 16:08, 29 March 2022 by Unknown (talk | contribs) (Updating to match new version of source page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Other languages:

Template:Copyright SEP AG en

Docs latest icon.png Welcome to the latest SEP sesam documentation version 4.4.3 Beefalo/5.0.0 Jaglion. For previous documentation version(s), check documentation archive.


SAP HANA

After initial configuration the first test backup out of the HANA Studio shows errors

Problem

  • Once you configured SAP HANA to work with SEP sesam and start the first test backup, it finishes with errors.

Cause

  • There might be an issue with case sensitive file paths, written in the /var/opt/sesam/var/ini/backint_saphana.utl files.

Solution

  • Open the /var/opt/sesam/var/ini/backint_saphana.utl files and make sure that the directory names are listed in the appropriate case (lower case or upper case respectively).

SAP HANA backup fails as sbc_hana.sh tries to back up SAP HANA DB on a secondary system

Problem

  • sbc_hana.sh does not recognize the secondary SAP HANA server as the secondary system and attempts to back up the SAP HANA database. Backup fails with error Connection refused.

Cause

  • The secondary SAP HANA DB cannot be backed up as it permanently synchronizing data with the primary SAP HANA DB. Only the primary system is able to access the database when the database is running in SYNC mode. Therefore accessing the secondary system and running the backups on the replication target will fail.

Solution

Not enough streams for SAP HANA external backups

Problem

  • SAP HANA external backups can no longer be performed due to the following error:
2018-07-26 08:04:35 W007-SBC_COM[  6664]: Timeout reached, drive group HANA has no free streams anymore

Cause

  • There are not enough streams available to run SAP HANA external backups.

Solution

  • In the data store properties, check the available streams per drive (by default, 5) and adjust them to 20.

SAP HANA backups are not started anymore

Problem

  • After a while SAP HANA backups are not starting.

Solution

  • Connect to the SAP HANA server and stop the client:
  1. /opt/sesam/bin/sesam/sm_main stop
  2. ps –ef | grep sm_sbc*
  3. Search for old sm_sbc* services and kill these services.
  4. Start the SEP sesam Client again with the command /opt/sesam/bin/sesam/sm_main start.

Backup finished with error [447]

Problem

  • Backup failed with error.
YYYY-MM-DDTHH:MM:SS+00:00  P11252      1480e025c70 ERROR   BACKUP   SAVE DATA finished with error: [447] backup could not be completed, [110507] Backint exited with exit code 1, Traceback (most recent call last):
 File "/usr/local/sesam/lib/python2.7/site-packages/cx_Freeze/initscripts/Console.py", line 27, in <module>
 File "backint_saphana.py", line 124, in <module>
 File "sm_common.py", line 55, in __init__
IOError: [Errno 13] Permission denied: '/var/opt/sesam/var/log/lgc/sbc_backint_NOT DEFINED.log'

Cause

  • The hdbbackint does not have the permissions to write to the logging directory.

Solution

  • Execute chmod 755 (directory) to fix the issue.

SAP HANA backup failure – analyze log files for cause

Problem

  • Backup was unsuccessful and is shown with a red dot in either the SAP HANA Studio or the SEP sesam GUI.

Solution

  • Go to /var/opt/sesam/var/log/lgc and search for the hdbbackint_SID.log or hdbbackint_SID_log.log. These logs contain the logging information for the data connections to the SEP sesam Server and Remote Device Server (if used).


On the SEP sesam Server/RDS, <sesam_install>/var/log/sms will contain stpd_pid.log and stpd_pid.com.log files with the server-side logging information. Additional log information on the SEP sesam Server can also be found in <sesam_install>/var/log/lgc in sm_sbc_com*.log files.

Job status displays multiple running jobs

Problem

  • Even though only a single backup or restore is running, multiple jobs are displayed in the Job Status view of the SEP sesam GUI.

Solution

  • This is the usual behaviour. When performing a backup, HANA bundles the data to be saved into a few separate save sets and sends them to the SEP sesam device server. Therefore, multiple jobs will be displayed in the job status. The same in reverse applies to restores.

Log backups running too frequent

Problem

  • Log backups are processed every 15 minutes. The time among log backups should be extended.

Solution

  • Open the backup configuration in the SAP HANA Studio. On the right, there is a box where the interval can be adjusted. But be careful: The log area will grow bigger. If the log area is full, the database will stop performing transactions!

After recovery the hardware key changed

Problem

Solution

  • This is a known issue which can occur even if there is no change in the hardware and hostname with the same configuration: re-installation, restore, recovery, or rename will change the hardware key. Please contact SAP support. For details, see Hardware Key for the HANA Database.

See also

Analyzing SEP sesam Log FilesSAP