Clean /hana/log in secondary database
In this article we will explain how to clean /hana/log in secondary site. Remember that we can’t delete any files manually under /hana/log/ folder. If this issue happen on the primary database, you should clean /hana/log/ using query “ALTER SYSTEM RECLAIM LOG”, but as you might be aware, you can’t connect to HDBSQL or run…
SAML is not working
Symptom: SAML is not working anymore Environment: BOBJ/DataServices Cause: CMC was not being redirected to SAML Trusted Authentication shared secret file is expired. Solution: Go to CMC -> Authentication -> EnterpriseUnder the Trusted Authentication enter 0 to “Shared Secret Validity Period (days) 3. Download Shared Secret clicking on the Button “Download Shared Secret” 4. Then…
OLAP Connections encoutered an unexpedted exception
Symptom: After an activity performed the OLAP Connection in the CMC is failing: Environment: BOBJS / Data Services Solution: Perform a Tomcat Clean cache: Navigate to usr/sap/SID/sap_bobj/Stop the tomcat by using the command: ./tomcatshutdown.shNavigate to tomcat/work folderRename the localhost directoryNavigate to usr/sap/SID/sap_bobj/ and start the tomcat by using the command: ./tomcatstartup.shWait until the cache is…
Data Service Repository cannot Resync
Symptom: ODBC call <SQLDriverConnect> to connect database <> failed with error: <ODBC call <SQLDriverConnect> to connect database <> failed with error: <[SAP AG] [LIBODBCHDB SO] [HDBODBC] General error; 10 authentication failed>. Environment: Data Services / HANA DB Cause: The error is a General error;10 authentication failed. In these scenario the cause was that the password…
Enable transport auto import
This time we will write about enabling transport auto import for an SAP system. Steps that we are going to perform: Delete all transports in the buffer where the auto import is going to be enabledSchedule the job for auto importing transportValidate it was scheduled correctly Delete transports from the buffer First we are going…
SUM Error: The command ‘disp+work’ from tool ‘disp+work’ could not be executed
Hello guys, When executing the SUM, we are having the below error: When checking SAPup.log under /usr/sap/sid/SUM/abap/log, we could see the below error: When checking disp+work_exe.out under /usr/sap/sid/SUM/abap/log, we could see the below error or similar: Some information: Red Hat Enterprise Linux Server release 7.7 (Maipo)Using SUM – Software Upgrade Manager 2.0 SP12 (PL6)Upgrading from…
HANA Backup Restore
Hello, Today we are going to talk about how to do a HANA Backup Restore. First go to HANA Studio, (1) right click on the system, (2) click on Backup and Recovery and (3) select Recover Tenant Database… Select the tenant where you want to restore the database. In the below screen I selected “Recover…
Renaming diagnostic agent (DAA) after migration of host
In this simple and short tutorial, we are going to see how to rename the diagnostic agent (DAA). In our case, we are doing this activity because we did a migration of host, so the host name changed and we must update it. We start by defining the below 3 environment variables and executing ./sapinst with…
Dump error: SYSTEM_SHMCONSTR_LOGON_FAILED
Today we will talk about dump “SYSTEM_SHMCONSTR_LOGON_FAILED”, which you can see below: In our system, we started getting this dump many times per day after a restart was done in the system. As you can see in the “Error analysis” it mention “The logon failed (rc=”1 (User unknown or password wrong)”).” and we can also…
Sapcontrol: FAIL: HTTP Error, HTTP/1.1 401 Unauthorized
When executing sapcontrol -nr <instance> -function Stop it returns the error “FAIL: HTTP Error, HTTP/1.1 401 Unauthorized” Fixing this error is simple with the below steps: 1- Using (1) ps -ef | grep sapstartsrv to identify the process id of the sapstartsrv process as shown below. In the below case we can see that it…
Loading…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
SAP Basis Guy 