The administrator can “activate / deactivate” a user account with the following SQL command or SQL console of the SAP HANA studio, the only prerequisite is, you need to have system privilege “USER ADMIN”.

You are trying to update your SPAM version on your SAP system and process canceled with the error CHECK_REQUIREMENTS –> QUEUE_NOT_EMPTY.In this case, you can check the below steps to clarify and solve the issue…

SAP HANA cleanup tasks like purging the backup catalog or deleting old trace files need to be implemented individually.SAP created a Python script which called as HANACLEANER.PY to perform these tasks automatically.

“S/4 HANA Readiness Check” is a tool from SAP that help you to prepare your SAP system to S/4 HANA upgrade.You can use this cloud-based tool to create a detail report of your current SAP system before start the S/4 HANA project.

If you are getting the error like “duplicate type ‘ASCS’ found at instance list” on upgrade phase “HA_SYSTEM_CHK”while EHP8 running on the SAP Business Suite ECC 6.0 system then you can check the below parameter value to eliminate this problem and continue your Upgrade process…

We can use the crytography tool SAPGENPSE to generate a keystore in which we can store a certificate.
First of all we need to define SECUDIR environment variable.The crytography tool SAPGENPSE generates the keystores and stores in this directory.

If you are getting an error message like “Background jobs cannot be started.” in your “tp system log” then probably RDDIMPDP job is not triggered by sapevt on your SAP system, in this case you can check the following parameter to solve the issue…

There are several terms used to describe parts of the SAP HANA release strategy.Also HANA 1.0 and HANA 2.0 have big differences according to SAP HANA release strategy documentations and snotes which i am going to try to explain in this article.

If you have a Standalone Gateway installation, or a Java instance system, then you can reload the security files (reginfo and secinfo) without having to restart the Gateway or the (A)SCS instance via GWMON tool.

You can upgrade your “HANA Database Revision Level” with Web Support or OS level steps, in this note; i would like to share my “HANA 1.0″ revision upgrade from level 03 to level 11 on “SUSE Linux 12 SP2″ Operating System via OS level steps.

HANA database can be updated using SAP HANA Platform Lifecycle Management, before that you should download the needed files and at this point you can use “Check for SAP HANA Components Update” option to make life eaiser…

If you want to make a connection from your SAP system which is working on SUSE linux to remote SQL server then you can follow the below steps and check the related OSS notes which are defined in this article.

SYNCMARK entries are only needed when TP is allowed to import several transport requests in parallel, ans it’s used to avoid that two transport requests that contain the same object are imported parallel and should be automatically removed after the process.