SAP NW Newbie

Please read Part1: Introduction to AWK if you are new to using awk Let's consider awk.input as the input file for the examples we are going to look at in this post. cat awk.input SQL> select distinct 'alter tablespace ' || tablespace_name || ' end backup;' from v$backup, dba_data_files where v$backup.status='ACTIVE' and v$backup.file#=file_id; 'ALTERTABLESPACE'||TABLESPACE_NAME||'ENDBACKUP;' ----------------------------------------------------------- alter tablespace PSAPUNDO end backup; alter tablespace SYSAUX end backup; alter tablespace PSAPSIDDB end backup; alter tablespace PSAPSID640 end backup; alter tablespace PSAPSID end backup; alter tablespace PSAPSIDUSR end backup; alter tablespace SYSTEM end backup; SQL> spool off This file is the (altered) spool output of the endbackup script . To print the lines containing the word alter : awk '/alter/ { print }' < awk.input SQL> select distinct 'a...

The flash elements like buttons, sliders and controls are designed in RGB color space, whereas the video is streamed in YUV. While presenting, the YUV video stream is converted to RGB and then combined with the RGB flash elements. This conversion is CPU intensive. The problem is magnified when you see the video in full screen mode. You can avoid this problem by installing  FlashVideoReplacer add-on on Firefox. This add-on will open the video with a standard multimedia player of your choice.

You might be familiar with Web Diagtool (or Web Trace Collector) , which lets you increase trace level on certain components and collects them as a zip file. XPI Inspector is a similar tool specifically designed for troubleshooting problems on XI or PI XPI Inspector has pre-defined set of examples to make trace collection simpler. Here is the list.   Example 1   (CPA Cache):   Example 2   (Module Processor):   Example 3   (AFW Security):   Example 4   (TREX):   Example 5   (SOAP Adapter):   Example 6   (JDBC Adapter):   Example 7   (File Adapter):   Example 8   (Mail Adapter):   Example 9   (RFC Adapter):   Example 10  (JMS Adapter)   Example 11  (Authentication & SSL)   Example 12  (Performance Monitoring)   Example 13  (ISpeak Adapters)   Example 14  (SR & UDDI)   Example 15  (MarketPlace Adapter)   E...

The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.'. For details, contact your database server vendor. If you see the above error while connecting to SQL Server, please ask the Sender or Receiver system's administrator to enable Distributed Transaction Coordinator (DTS) service and network DTC access. You can also work around this problem, by checking " Database Auto-Commit Enabled " option in the Communication Channel.

It is very important to keep up with SAP's recommendation to upgrade the JDK to the recommended release. If you ever take J2EE specific performance issues to SAP, upgrading to the latest JDK would be one of their recommendations. SAP note 709140 is the central note pointing to other SAP notes on JDK recommendations. You must go through the note specific to the JVM you use to check for any pre-requisites. Here are some steps that you will have to follow regardless of the JDK you use, when upgrading JDK. 1. Check SAP notes for pre-requisites to apply the latest recommended JDK and implement them. 2. Upgrade the JDK. 3. Reinstall " Unlimited Strength Jurisdiction Policy Files ". You will have to implement this step even if you were using unrestricted policy files earlier as these files would be replaced by the upgrade. 4. Check the java vesion as <sid>adm to ensure that the new JDK is reflecting. If not, please ensure that the JDK was installed at the same p...

On UNIX based systems, if you do not have Xmanager or any other X11 facility, you can use the command-prompt based tool, tshark to capture trace on a network interface. To install tshark, go to http://www.wireshark.org/download.html and see if there aer pre-compled binaries available for your OS. If there is none, you need to compile the source code yourself. 1. Run the following command (as root or sudo root) to list the network interfaces: tshark -D 2. Let us say you want to trace eth0, run the follwoing command: tshark -F libpcap -w /tmp/eth0_tshark_trace.pcap -i eth0 -F libpcap specifies the file format of the trace. SAP support usually requests for libpcap. -w /tmp/eth0_tshark_trace.pcap specifies the file name where the trace is written. -i eth0 specifies that the trace is being written for the network interface eth0. If you want to see the trace on the scree, use the following command: tshark -i eth0 3. Once you have recreated the problem close tshark with c...

By default, an Integration Process is assigned one queue. This may cause delays when a large number of processes are executed. To increase throughput, the BPM may be designed to used multiple queues. Edit the property area for the entire Integration Process and set the parameter QueueAssignment from 'One Queue' to 'Multipe (Random)'. Call transaction SWF_INB_CONF and change the Delivery Mode of the process. Select your process and change to delivery mode "without buffering" with queue assignment "Multiple Queues (Random)".

myHelp for SAP Professionals helps you search help.sap.com and obtain information while you are away from a PC. Very handy application when you want to look up information while you are in a meeting or transit. SAP Note Browser lets you search SAP notes without needing a S-user. Another excellent application to quickly look up error details or other information on SAP portal. SCN Blogs keeps you up-to-date with latest SCN blogs. Some of us working in retarded organizations that won't let us access useful information on the internet will find it extremely useful. Another great app to keep yourself busy while in transit. SAP Guest Logon lets you logon to SAP office locations in a secure way. The application can be configured to remember the credentials.

In order to closely integrate SAP and printer system , SAP allows handling of print requests by an external Output Management System (acess method E). Large enterprises use OMS for more reliability, better print monitoring and fax/email facilities with printer. If your prints involve OMS, TSPEVJOB table is involved to handle OMS events for print requests. Ensure that the report RSPO1041 runs every day to cleanup the print tables (including TSPEVJOB). If you have not run this report for a long time, try its first run during a low system usage time as the report locks the printing system. To avoid prolonged lock down of print system by this report, chose a commit parameter of 1 instead of the default 10. In addition to running this report, check the bug reported in SAP Note 1566659 .

This post explains why File Sender channel fails with the following error: com.sap.aii.adapter.file.ftp.FTPEx: 550 *** ERROR *** NO BATCHES FOR TRANSMISSION In the file sender, you indicate the directory from which the file must be picked. Let us say /SourceDirectory. Let us assume that the communication channel is configured to pick the file filename.ext. Now when a channel polls, it tries to pull ftp://senderftp.com/SourceDirectory/filename.ext. This access would fail if the FTP server is configured with /SourceDirectory as root location as the access would then be translated at the ftp server as ftp://senderftp.com/SourceDirectory/SourceDirectory/filename.ext. You should either adjust the directory location or ask the FTP server support team to correct the FTP root; the latter is recommended.

If you log off hurriedly while editing XI objects or if you lose network connection, the locks corresponding to the objects are left hangling. When you log back in, you will not be allowed until the lock is removed. If you contact Basis team to get these locks removed, you should know that you can do it for yourselves. Non-admins can remove the locks that are set on their name. Therefore you can remove lock on the XI object that only you were editing. To unlock call http://<host>:<port>/rep/support/public/LockAdminService

SAPPLAPP lets you use SAP GUI with Apple iPod, IPad and iPhone . Download the application from iTunes and hook up to your company's VPN. The GUI will ask for details similar to those used by SAPGUI. The pre-requisite to using this tool is that your system must have an ITS server. ITS comes built in with WebAS 640 onwards. If you wish to connect to an older SAP system, you need to install an external ITS server in the landscape. The application is priced at $ 0.99. Here is the link to the developer's site.

It is very likely that you have not performed all the post installations steps if you see the following error at Call adapter step: The termination occurred in system <SID> with error code 403 and for the reason Forbidden If <SID> is an ECC system, log on to the ECC system and call transaction SICF. Activate the sap/xi services to get rid of the errors. If <SID> is XI/PI system: Run the ABAP report RSXMB_ACTIVATE_ICF_SERVICES If you are using Web Dispatcher and maintaining a permissions table, ensure that the services are not blocked. 403 error are often misguided as user authentication errors causing the admins to reset passwords blindly. For authorization errors the return code would be 401.

One of the most likely cause of high CPU usage by Firefox is fragmentation of its database files (.sqlite files). If you have a habit of bookmarking and deleting unused bookmarks, places.sqlite, where bookmarks are stored, would be fragmented. You can shrink this file using sqlite3. If you are using Windows OS, downlod this file from http://www.sqlite.org/download.html and extract the executable to C:\Windows folder (or any other folder included in the PATH variable). If you are using Ubuntu, install sqlite3 using the following command sudo apt-get install sqlite3 To shrink the database file, run the following command after replacing <your profile>  with your profile name Windows: sqlite3 "%APPDATA%\Mozilla\Firefox\Profiles\<your profile >\places.sqlite" "vacuum" Ubuntu: sqlite3 $HOME/.mozilla/firefox/<your profile >/places.sqlite "vacuum" It is recommended that you take a backup of the sqlite file you are about to shri...