星期三, 八月 27, 2014

SAP HANA Live slow query times

If they are running slow the first time they are run them then that is likely that some of the tables (or columns used) have been offloaded from memory previously, and need to be reloaded on the first run.

http://scn.sap.com/thread/3518051

星期五, 八月 15, 2014

How to deleted released change request

1. Table E070 store status:

D Modifiable
L Modifiable, Protected
O Release Started
R Released
N Released (with Import Protection for Repaired Objects)

Sample coding:

UPDATE E070
SET TRSTATUS 'D'
WHERE TRKORR 'PI6K000595'.

If you have authorization, you could simply do the following:


SE03-> Unlock Objects (Expert Tool) to do the same job for all entries in particular TR

2. Cannot delete (request locks still exist) 

Contact your system administrator, who must ensure that the request locks (table TLOCK) correspond to the locked objects in your request.