SAP HANA and ODBC access

Q: Can I connect directly to the SAP HANA database via ODBC when SAP HANA RUNTIME edition was used?

A: Official answer from SAP: No, you can’t.

Any direct connectors to the SAP HANA DB are prohibited if RUNTIME license was used. Connections are allowed only through the application layer, whether it is the web services of your application or something else.

See more at SAP SUR 2022:

https://assets.cdn.sap.com/agreements/product-use-and-support-terms/sur/sap-software-use-rights-english-v1-2022.pdf

SAP HANA replication problem. Secondary has different systemPKI SSFS data

During configuring SAP HANA replication you are getting the error:

Error while executing the register command: hdbnsutil -sr_register

Primary and secondary has different systemPKI SSFS data and key or unable to check; Secondary system PKI SSFS-data-file checksum is different from primary!

You just need to copy keys from the source system to the target:

su - <sidadm>
cdglo
scp security/rsecssfs/key/*.KEY $USER@<sap_db_host_name>:/usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/key/

scp security/rsecssfs/data/*.DAT $USER@<sap_db_host_name>:/usr/sap/$SAPSYSTEMNAME/SYS/global/security/rsecssfs/data/

SAP Basis transaction list

A SAP transaction is an application that executes a business process on a system, performs a set of logically completed actions over data. (Technically, it is a “shortcut” for calling a program on ABAP/4).   For example, it can be the input and accounting entry of an invoice, forming some reports. (Programmers: SAP transaction is not synonymous with DB transaction).

When analyzing problems with a SAP system, it is often sufficient to analyze transactions in the following order:

sm50 – see how fast workflows are running. Are there many free ones, are there many long-term employees, are there any processes in PRIV mode?

st22 – see the presence of dumps in the system, their count

Continue reading »