0.0 00 It has become 4 years since I first met HANA in CodeJam İstanbul January 2014. From that time i have discovered many capabilities of HANA especially when it is located as seconday database. Unfortunately my company have neither…
Recently i have needed an ABAP program which reports ABAP programs with the related code line. My intention was catching Select sql statements without in connection keyword. By this means i had aimed to find all select statements which are selecting from HANA replicated tables but has no HANA connection.
Recently our client reported that some ABAP reports are retriggered by the same user many times which leads to memory and CPU leaks in SAP system. They have also stated that from functional perspective these reports could be executed by different users at the same time but not by the same user. This fact prevented me from consuming standart SAP Lock Objects(E*) as their usual usage is putting business locks on object level, not user level.
As you all know SAP provides a direct way to query database by ABAP programs. However sometimes we don’t have a chance to transport ABAP programs easily.On the other hand we have to write database queries in SAP to get complicated calculations. (Nowadays HANA provides SQL editor for this purpose)
After SAP has introduced HANA , i could finally had a chance to explore it. As a soft switch to HANA technology , companies can make use of HANA as a second database. Because it will not bring too much effort to switch HANA but will gain many profit. Following are the reasons why i think HANA as a secondary database is very efficient.
You can see this type of run time errors under DBIF_RSQL_SQL_ERROR. The main cause for this run time error is database system goes into deadlock situation while waiting resource. A deadlock situation occurs if a database transaction is blocked when it requests a database lock but it already has another lock. I know this explanation is very complicated. Now I will try to explain this with a simple example i have experienced lately.
I have mentioned about parallel processing in parallel processing strategy-1 and parallel processing strategy-2 posts. In order to prevent resource problems in parallel processing I had offered a custom code which is checking system resources for each new parallel function call.
There are four types of RFC in ABAP ,here is their meaning and a sample implementation for each.
Synchronous RFC : Sender waits while the RFC runs in the recipient process.