Posts

Adding multiple printers to a single transport requeset

If you wish to include the printer devices into one transport request: Create a new transport request. Double click on the transport request and go to objects tab. Change to edit mode and then enter the following values to the below fields Project ID: R3TR Object Type: SPDV Object Name: <Printer name> After you have added all the printers that you wanted to include, save the changes and release the transport.

Fixing Inconsistent Table - Table activation fails due to inconsistency between DD and DB

If you find a table to be available on the database, but not active in ABAP dictionary, try calling SE14 as DDIC user, enter the table name and choose Table > Reconstruct, Execute. If this method fails follow these steps: Call transaction code SE37 and execute the function module  DD_TABL_ACTM with single test On the next screen, do not change any other field except the following and set them as shown below: MODE: 12 NTAB_PUTSTATE: N TABNAME: <enter the correct table name> Click on Execute The export parameter ACT_RESULT should show 0. To verify if the inconsistency is fixed, call transaction SE14 > Extras > Database Object > Check and  SE14 > Extras > Runtime object > Check.

Monitoring response time of a transaction code or a client using CCMS

Image
There are always those important transactions that business users execute on a regular basis and cannot accept it to take too much time. One of the important aspects of addressing bad response on a transaction code is to be able to measure and alert if the response time is tending to increase. If you get an alert you might be able to check the reason for slowness before a widespread impact on business occurs. Log on to your CCMS system Call transaction SE16 and give the table name ALTRAMONI If you want to set alert on the response time of the entire client, you have to set TCODE as * and MON_CLIENT as the client number (for example 100 if the business client is 100) If you want to set alert on the response time of the transaction MIRO on client 100, set TCODE as MIRO and MON_CLIENT as 100. Set MO_NAME to aptly describe what the alert is about. Ex: "Avg response time on txn MIRO on 100 client" Set MTECLASS as you see fit. Ex: "MIRO100RESP" Set SERVER ID to...

Finding Corrupt Indexes on Oracle Database

You can find out all the indexes that are corrupted by matching up v$database_block_corruption view. Let's begin with formatting the output: set pagesize 50 linesize 170 col segment_name format a30 col partition_name format a30 Now the following SQL will list out the corrupt indexes: select distinct file#,segment_name,segment_type, TABLESPACE_NAME, partition_name from dba_extents a,v$database_block_corruption b where a.file_id=b.file# and a.BLOCK_ID <= b.BLOCK# and a.BLOCK_ID + a.BLOCKS  >= b.BLOCK#;

Fix Ubuntu - Change the default privacy settings on Ubuntu

The search terms that you use to open applications or search for files on you computer, are sent to third party, which can use this information to display targeted advertisement to you. You can opt out from this default behavior of Ubuntu by executing the commands available at fixubuntu.com .

Function code &SAP_EDIT

&SAP_EDIT was an easy function available for SAP Support experts to provide a fast solution for customers in a highly critical situation. As this function became increasingly known to others, SAP chose to deactivate it with Release 600 with Support Package 17 and Support Package 18. If you want the function back, implement SAP note 1446530 or use other techniques such as using function module se16n_interface or from SE16 in debug mode (Open the exact record you want to edit. Hit /h. Change the mode to EDIT, INSERT, etc.)

Icon appearing on the Taskbar for a second

Image
After a recent patch, I started seeing an icon appear every minute or so on the taskbar and vanishing within a second. This was quite annoying while typing or watching full screen videos as it removed focus from my active window. To check what is causing the problem, I opened Task Manager (Ctrl+Shift+Esc) and sorted the processes by CPU. As soon as the icon reappeared, I notice  UI0Detect.exe showing on the top. UI0Detect.exe is an "Interactive Services Detection" that helps with user interaction if required by Windows services. Whatever UI this service was trying to present was not helping me as it popped up only for a fraction of a second, so I decided to disable it. The following steps helped me: Right-click on "Computer" icon on desktop and select "Manage" Expand "Services and Applications" Click on "Services" Right-click on "Interactive Services Detection" from the list Select "Stop" Right-click...