Posts

Filtering URLs by using Permission Table in SAP Web Dispatcher

Let us say, you have installed a Web Dispatcher in the DMZ and it is used so that the business partners can send SOAP messages over the internet to you. From a security perspective, you may want the business partners to access the SOAP URLs alone; they should even be calling admin related URLs. To achieve this, you can use a permission table (ptab) in the Web Dispatcher. Create a file (say ptabfile) which allows SOAP URL pattern /XISOAPAdapter/MessagingServlet*, so that a call to the SOAP URL (http://<host>:<port>/XISOAPAdapter/MessagingServlet?channel=<party>:<sendersystem>:<CC_sender>) is permitted. The contents of the file would then be: P    /XISOAPAdapter/MessagingServlet* D   * Add the following parameter to the web dispatcher profile file: wdisp/permission_table = <absolute_path_to_ptabfile> Restart web dispatcher for the change to get activated. When a call to the web dispatcher is made containing the pattern...

SYSTAT IDocs Causing High IO Load

Image
The status idocs processed by SAP PI/XI can cause high CPU wait times (because of increased I/O activity). If you notice high CPU usage with most of the CPU spent on wait, check if there are SYSTAT IDocs are being processed (you can check SMQ1/SMQ2 with slow moving queues) If you check the SQL statements being executed at that moment, you might notice the following statement: SELECT * FROM IDXRCVPOR WHERE IDOCNUMBER = <some IDOC number> You might notice the SQL statement showing up in SM66 for 5-6 seconds and the explain statement would show very high IO-Costs in it is performing a full table scan. To address this performance problem, create an index on IDOCNUMBER column of the table IDXRCVPOR

How to Clear RFC Function Module Metadata in SAP PI

Image
The RFC Adapter in SAP PI stores all the metadata of the function modules. This means it caches the definition of function modules, structures and other datatypes. This cache is filled when the Communication Channel processes its first messages after the system restart, and pins the metadata so that the subsequent messages need not fetch the metadata again. Having the metadata readily available at runtime improves the message processing speed. If the function module is changed in the Sender or Receiver system, its metadata has to be updated in the RFC Adapter's metadata repository. This can be done by: Changing the Communication Channel in Integration Builder, so that a cache update on the entire channel is triggered (which includes removing the old metadata) Restarting the RFC Adapter service Restarting the J2EE Engine(s) All the above three steps will clear the metadata and it is fetched when a new message is processed by the Communication Channel.

Clearing Empty File Repositories in BI 4.x using Fileserver Prune Command

To cleanup empty folders from the file repositories Stop the input and output file repository server using CMC From windows command prompt, run the following command to clean up the input repositories "C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\ fileserver " -rootdir "c:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/FileStore/ Input /" -prune -fg Now run the following command to cleanup output repositories "C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\ fileserver " -rootdir "c:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/FileStore/ Output /" -prune -fg Start the file repository servers using CMC

Extracting Multipart SAP DVDs in Unix .exe followed by .rar

Large SAP DVDs are split into multiple parts. The first part is a rar file and the next parts are .rar or .zip files. One option is to double-click on the exe file from your windows PC, the DVD will be extracted to a folder, upload the folder to your UNIX system. The better way of doing this is extracting the files on UNIX system itself. Place all the DVD part files (.exe and .rar files in a single folder) Download the command line extractor unrar for your UNIX system. Run the unrar command against the .exe DVD part file: unrar x <archiv-name(exe-file)> <targetdir> As all the files are in a sequence (part1, part2 ...) all the files will be picked up and extracted. NOTE: On some system you need to execute ./unrar xvf <filename>.exe or ./unrar xvf <filename>.rar

Allowing HTTPS Connecton to SAP BI Explorer via iPad

When you call the SBO explorer in iPad to connect by using HTTPS, you may notice an error stating that the server did not accept the certificate. When an HTTPS call is made the server sends its certificate to the client (browser) the client verifies if this certificate can be trusted (if configured) the server asks for client certificate the client sends its certificate server verifies if this certificate can be trusted client and server complete the handshake The error that the server did not accept the server happens because there is no functionality to import the Safari client certificates into the iPad app and send them to the server. In order to continue with the handshake the server should be configured not to ask for client certificate (so that steps 3, 4 and 5 are avoided). You can disable the client certificate check process on Tomcat by setting  clientAuth=want in C:\Program Files (x86)\SAP BusinessObjects\Tomcat6\conf\server.xml

YouTube slow on Chrome

Looks like Adblock is causing youtube videos to not load or buffer slowly. Try disabling Adblock or Adblock Pro and see if it fixes the problem. If that doesn't work, try disabling pepflashplayer.dll