A couple days ago i played around with a SI7021 on my ESP8266 and recognized that the temperature output of the used Library was given as an integer, so without a comma or dot for the separation of the decimal places. Like 2495 instead of 24,95°C. Not really problematic, but for using the numbers with MQTT it was relevant to convert it to the proper type which was “Float” Solution That is how this works:...
If you try to manage your HANA certificates via SQL you might want to set the “OWN CERTIFICATE” where you come across the following error in your SQL Commandline: 1 2 Could not execute 'ALTER PSE HANA\_X509 SET OWN CERTIFICATE '-----BEGIN RSA PRIVATE KEY----- ...' SAP DBTech JDBC: [5634]: Certificate definition inconsistent Looking at the indexserver trace you will find: 1 2 [113263]{213394}[35/-1] 2016-05-24 15:44:56.384001 e Crypto check\_pse\_store.cc(00178) : Trying to add invalid certificate as part of own certificate PEM: exception 1: no....
Today i found a helpful Link at SAP regarding the virtualization of SAP HANA on VMware vSphere: http://www.saphana.com/docs/DOC-3334
http://scn.sap.com/community/hana-in-memory/blog/2015/06/30/sap-hana-sps-10-whats-new-sap-db-control-center--by-the-sap-hana-academy
I just researched how much the difference between a virtualized versus a native Installation of SAP HANA might be in terms of performance. When looking at the different sites, i was finally able to be find a blog entry of VMware where the author describes the result of the SAP BW-EML Benchmark which was run on native and virtual environments using a HP DL580 Gen8, 4 processors with 60 cores / 120 threads....
A while ago one of our HANA appliances crashed due to a hardware failure and i recognized that not all databases had started properly. This can be chose during the installation and different persons have installed the databases differently. But how to fix that? Logon to the operating system of the SAP HANA Appliance with adm or change to adm. Edit: /hana/shared/#SID#/profile/#SID#_HDB#INSTANCE_NUMBER#_#HOSTNAME#: 1 vi /hana/shared/$SAPSYSTEMNAME/profile/$SAPSYSTEMNAME\_HDB\* Change "Autostart = **0**" to "Autostart = **1**"...
If you want to create users on the HANA Database from the Netweaver 7.40 ABAP Stack, you might want to take a look at this tutorial on SAP SCN . As of the writing of this post, currently Netweaver 7.40 SP5 is the latest version which still does only support creating a user on the database without further synchronization of roles or other properties. Also users may only be created with a password not with Kerberos or X509 Certificate authentication....
Today i had issues with my browser in HANA Studio which lead to the issue that i was not able to open the memory utilization overview in HANA Studio. But after some debugging of the app, i found that it is possible to start it in Google Chrome as well. First open the memory utilization url in a Chrome Tab which is at: 1 2 HTTP: http://<hostname>:80/sap/hana/admin/st/index.html HTTPS: https://<hostname>:43/sap/hana/admin/st/index.html Then open the Javascript Developer Console in Chrome which is via Menu -> Tools -> Java Script Console or via CTRL+SHIFT+J: There enter first the Data for the connection:...