SAP NW Newbie

Someone right-clicked on an exe file and in the Open With option chose it to open with Internet Explorer. S/he probably left the check mark on "Always use the selected program to open this kind of file". All executables now started showing Internet Explorer's icon and started opening them with IE. If you are in a similar situation, here is what you can do to fix the problem: 1. Open the command prompt (Windows+r and type cmd) 2. Go to windows folder cd\windows 3. Open the Registry Editor using the following command regedit 4. Navigate to HKEY_CLASSES_ROOT\.exe and in right-hand-side pane, change value of Default key to exefile 5. Next, navigate to HKEY_CLASSES_ROOT\exefile\shell\open\command and in right-hand-side pane change value of Default key to "%1" %* 6. Restart your computer.

Sandboxie runs other applications by injecting the application code into Windows kernel by API hooking. by doing this it redirects all the file system calls by the application to a virtual space. This essentially works as if a virtual hard disk is used by the application. The advantage of such mechanism is that any malware downloaded by the application (a web browser in most cases) is limited to the virtual space. For this reason sandboxie is regarded as great security tool. Another advantage of using sandboxie is that if you install a trial software on sandboxie, you will be able to use it beyond the trial period. Sandboxie doesn't work with 64 bit versions of windows 7. You may try DeepFreeze or Microsoft's SteadyState.  Returnil is a more powerful (paid) application. There is a free version of Returnil available for home use.

This post is meant for people who are new to SAP administration. It will teach you how to unlock a user by altering the table field where the user's lock status is stored. Since the lock status of a user is persisted at the database level. One can unlock (or lock) a user using SQL commands or using transaction SE16. If you intend to use the SQL methods, please ensure that it is done on DEV/QA systems and you are not violating your company's security policies. The lock status is stored in the field uflag in the table  usr02 . If uflag is 128, the user is locked. By changing it to 0, you will be able to unlock it. Here is an example to unlock the user DDIC in client 000: UPDATE sapr3.usr02 SET uflag = 0 WHERE bname = 'DDIC' AND mandt = '000'; commit ;  This technique is useful when you need a mass lock/unlock of users. 

This post is targeted at someone who is new to SAP administration. It will teach you how to terminate an active SAP job. You may have noticed that cancelling an active job using the menu option in SM37 doesn't work most of the times (It never worked for me). Follow these steps to terminate a job. Get the Workprocess which is running the Job Search for the job using SM37. The status of the job should be Active. Double-click on the job name and go to Job Details [F7] Note down "Executing server", "WP number/PID" values Restart the Workprocess Call SM66 Match  Server, WP Number and PID with that of the job. Click on the process Navigate to Goto -> Local Workprocess Select the workprocess Click on Process -> Restart after error -> No Click on Process -> Cancel without core Wait till Status changes to Complete Click on Process -> Restart after error -> Yes Status should change to running

CRM (Customer Relationship Management) software is an application to support the customer-facing employees from marketing, sales, and service departments help increase customer satisfaction and loyalty. The CRM software provides web and mobile interfaces to help the business representatives to provide real time information to the customers. In the background, the CRM system is strongly coupled with other datasources such as ERP systems, BI and SCM systems to provide a unified view. SAP's CRM solutions not only aim at reducing cost and providing data to help make quick and good decisions, it also helps in maintaining a long-term competitive edge.

ICF recorder provides debugging facilities to analyse HTTP problems when using Internet Communication Framework (ICF). It also allows reproduction of the error whenever you need from the details logged into the database. The recorder logs the exchange of HTTP(S) documents. To activate ICF Recorder Call transaction SICF Go to "Edit" -> "Recorder (If ICF acts as server to http requests) and/or Go to "Client" -> "Recorder" (If ICF acts as client making http requests) Choose "Activate Recording" Enter the URL prefix Ex: "/sap/bc/bsp/sap" Specify the recording time and lifetime (to indicate the amount of time this data remains in the database for troubleshooting) You can use "User-Dependent" option to set the recording for a particular user. You can use "Recording Level" to specify "Request" or "Request+Response". To deactivate ICF Recorder Call transaction SICF Go to ...

The JDBC channel connecting to SQL server fails with one of these errors: Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://**************;databaseName=***************;user=sa;password=****************;':  SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Can not establish connection:: SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver The class names for drivers are different for SQL Server 2000 and SQ...