Posts

Hana XS Engine Troubleshooting

Overview:  HANA 2.0 is having XSA as base for many application like HANA cockpit, WEB IDE, Big Data Hub to name a few. You are lucky if you get it through for installation but sometimes you are stuck with few issues which you keep trying to solve , you don find solution. This Blog identifies and help you solve few of them. Getting a guide is very easy. But troubleshooting in real world might make your head spin. So sharing my experience. XX will represent the instance no. used in this blog. Error:  Adding role ‘xs_worker’ failed: Check /var/tmp latest update folder and it will mention the file name which contains more details. It should be with name like hdbmodify_addlocalroles.log. and Reason :  FAIL: process hdbxscontroller HDB XS Controller not running Sub Reason:   Could not startup the controller components: SAP WebDispatcher failed to bind application port (already occupied). Route to application will be unavailable. Restarting the...
Post a Comment
Read more

Xsengine not running

Enable the embedded XS Engine of the indexserver by executing the following statements on the system database: ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'database', ' ') SET ('httpserver', 'embedded') = 'true' with reconfigure; ALTER SYSTEM STOP DATABASE  ; ALTER SYSTEM START DATABASE ;
Post a Comment
Read more

Hana ini file location

The ini files are stored at the following default location on the server: /hana/shared/$SID/global/hdb/custom/config. File Details /usr/sap/ /HDB /exe/config Default values (not to be adjusted) /usr/sap/ /SYS/global/hdb/custom/config/ .ini Valid for a specific service (e.g. indexserver) or component (e.g. multidb) on all hosts /usr/sap/ /SYS/global/hdb/custom/config/global.ini Valid for all services on all hosts /usr/sap/ /HDB / / .ini Valid for a specific service (e.g. indexserver) or component (e.g. multidb) on a specific host /usr/sap/ /HDB / /global.ini Valid for all services on a specific host
Post a Comment
Read more

hdbxcontroller is not running

Image
during update or installation of new Version of Hana , you can get above message in Log. Solution: use Physical hostname instead of virtual name . if necessary , uninstall xs engine and shutdown server, clean install would be great
Post a Comment
Read more

Check Users Locked or deactivated in Hana or Hana Studio

Check Users; select * from users where user_deactivated= ‘TRUE’; Deactive hana user We can use the following SQL query to DEACTIVATE HANA DB user ; ALTER USER DEACTIVATE USER NOW; Example ; alter user HanaUser deactivate user now; To activate the user again we can use the below SQL query ; ALTER USER ACTIVATE USER NOW; Example ; alter user Hanauser activate user now;
Post a Comment
Read more

Linux, Copy, Delete, File Permission, Check User lock or not command

Copy command Remote   scp -pr HDBSp3.zip 'domain\user1'@servername:/var/tmp Delete Command: Rm command Rm -ir folder Permission : ---> Group und Permission / Berechtigung Chown -R root.root File Permission Chmod -R 755 File Check User Lock or not / User Entsperrt oder Gesperrt net user %username% /dom
Post a Comment
Read more

Linux Shell Change

To change your shell with  chsh : cat /etc/shells At the shell prompt, list the available shells on your system with  cat /etc/shells . chsh Enter  chsh  (for "change shell"). Code Listing 3.5 shows the system response. Some systems prompt for a password, and some don't. /bin/zsh Type in the path and name of your new shell. su - yourid Type in  su -  and your userid to relog in to verify that everything works correctly. If it doesn't, use  chsh  again and change back to the original shell or to a different one. If you can't change back, email your system administrator for help.
Post a Comment
Read more