Skip to Content
Author's profile photo Evan Stoddard

Search not working in SAP Solution Manager 7.2 SAP CAL instances, with fix

Hello, we have discovered an issue with the Search functionality in the SAP Solution Manager 7.2 solutions “SAP Solution Manager 7.2: Design and Build in your SAP S/4HANA Planning Phase” and “SAP Solution Manager 7.2: Test Drive Content Activation of a Customer’s Own Documentation.”

This issue affects all instances created from these two SAP Solution Manager 7.2 solutions. You may see errors such as “Cannot determine HANA version for connection ESH” or “An error occurred when executing a search.”

As these two solutions were created from the same master system based on the Ramp-up version of SAP Solution Manager 7.2 (initially SP00, then 01 and 02), some issues were to be expected. However, this issue stems not from a bug, but from an configuration error.

The Search functionality accesses the SAP HANA database with user ESH, which normally has an indefinite life span. Unfortunately, this user life span was set to a limited duration, which is now exceeded. As a result, the error occurs on any instances created from these solutions.

However, we have just sucessfully tested a simple fix to this issue that can be done from an OS command line. If you access the OS level of your SAP Solution Manager 7.2 SAP CAL instance, you can execute the following command at the root level, where you will use the master password of the instance in place of the text MASTER PASSWORD in the command line below:

su – -c “hdbsql -i 02 -u SYSTEM -p ‘MASTER PASSWORD’ ALTER USER ESH DISABLE PASSWORD LIFETIME” hdbadm

To access the OS level of your instance, download the key file from your CAL tenant, and use it with a terminal client like PuTTY.

After the command is entered, we found that the Search worked properly again, without needing to reboot the instance. The SAP CAL team is incorporating this command into their creation script, so that new instances will automatically have the fix applied. We have already corrected this for any new SAP Solution Manager 7.2 appliances.

Note that this issue does not affect any solutions based on SAP Solution Manager 7.1.

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mahmoud M Younes
      Mahmoud M Younes

      Hi,
      only in SAP CAL these 2 instances exist for SOLMAN 7.2  :

      SAP Solution Manager 7.2: Design and Build in your SAP S/4HANA Planning Phase
      SAP Solution Manager 7.2: Test Drive Content Activation of a Customer’s Own Documentation

      can i use one of the above instances to test other scenario in SOLMAN 7.2 like PPM, ITSM new feature, Business requirement ?

      also i noticed that these 2 instances available only AMAZON, is it available to use it on MICROSOFT AZURE ? as we don't have access to AMAZON

      Regards,

      Author's profile photo Evan Stoddard
      Evan Stoddard
      Blog Post Author

      Hello, yes you can work with other scenarios in these 7.2 systems - however you will need to execute the configuration of other scenarios in SOLMAN_SETUP.

      We are constructing a new appliance now where other scenarios are configured, and a managed S/4HANA system is included in the appliance and defined as a managed system. We hope to release this solution by the end of October 2016. The CAL team is in discussions with Microsoft to also have the Solution Manager solutions available for Azure, and will announce this as soon as it's available.