1 2 3 10 Previous Next

SAP NetWeaver Administrator

142 Posts

A large variety of custom VB functions can be created and used in BEx analyzer. That method may be useful especially when somebody don’t know ABAP.  


As an example creating VB functions converting 0fiscper value into full date is described here.


First, we have to be sure that macros can be saved in the workbook we use. Standard MS workbook .xlsx can’t do that. On such occasions I save the workbook as The Excel 97 - Excel 2003 file format.


After doing this you have to save the workbook on the server again



Now we can add macros to the workbook. We can do this in VB editor (Alt-F11)  

If we want to store our macros locally (as in this example) we should add a new module


vb creating module.png

and write down the code for the macro

vb writting a code.png

If we have the code stored in .bas file it can be imported here (we can do this when we want to use the same code in many workbooks).

vb importing module.png

  After writing or importing the code the workbook should be saved on the server with the “Save workbook” button.



Now function we stored in workbook can be used like this:

vb function usage.png

Please find attached file containing the code that was used here (the extention of the file has been changed to .txt so that the file could be stored in SCN server).


Regards, Leszek


Sum and Sum with DMO

Posted by V V Jul 7, 2014


I started the upgrade of 7.3 portal system and sum is expecting <sid>adm password, and due to audit restriction we were not able use the <sid>adm in sum for the upgrade.  I checked couple of documents about sum and I didn’t see any workaround for the same.

I checked one document which talks about  DMO for HANA , observed that there was option where we can skip <sid>adm user/password(by changing the sumstart.conf file) and tried that option  we moved forward but unfortunately started several issues with schema user and  and several other issues(Even though I have given full permission and groups to the user) and ultimately resulted the restart of the upgrade with JSPM with the help of note 1563660 .

I checked with sap and they told that it is not meant for normal upgrade and it’s is only meant for DMO and it was not tested for other scenarios


I spent several hours for investigating the workaround and picking the wrong tool again wasted several more working hours in solving the actual issue. I checked several blogs in SDN and here I would like summarize few points which gives idea when to use sum and sum with DMO  ,   this is not new blog with entirely new content but I would like differentiate both the tools .

Software Update Manager:

    • Release uprade (major release change)
    • System update (EHP installation)
    • applying Support Packages (SPs) / Support Package Stacks
    • applying Java patches
    • correction of installed software information

  SUM is used for all SAP NetWeaver based systems, so systems either based on AS ABAP, or AS Java, or based on a dual-stack system. 


http://<host name>:4239.

SUM with DMO

Database migration option (DMO) is an option in SUM - DMO is not a separate tool and this build is only using the ABAP part of SUM, called SAPup

  1. 1. Although DMO is based on the "standard" SUM, a new user interface (UI) is used - but only for the DMO procedure. The UI is based on SAPUI5, so it's running in a browser, and offers some comfortable features like checking the log files without having to log on to the OS of the application server.

   2.  Different start procedure

SUM is started in a different way: a browser request to the SAPHostAgent is used to start SUM, instead of starting SUM from the prompt/console. This allows you to start the SAPup process without having an additional server window open

Different UI

   3. SUM shows a new user interface which is based on SAPUI5, which is currently exclusively available for DMO only.

   4. The new UI is currently only available for the DMO procedure, but in the long run, it may become available for other use cases as well.

Where we can use


  • You want to migrate your existing SAP ABAP system to the SAP HANA database
  • Your SAP release needs to be upgraded prior to migration
  • MO for SAP NetWeaver BW and for SAP Business Suite systems
  • DMO is available with Software Update Manager 1.0 SP09, and can be used for systems based on AS ABAP. It can be used for SAP NetWeaver BW systems from 7.0 SP17 (and higher) to migrate to 7.31 (and higher). And it can be used for systems part of the SAP Business Suite 7.0 (and higher) to migrate to a level corresponding to SAP BASIS 7.40 (for example "SAP enhancement package 7 for SAP ERP 6.0").

How to start SUM with DMO option

Run the command /usr/sap/<SID>/SUM/abap/SUMSTART confighostagent to create the file sumstart.conf in

Start the DMO Frontend with the following URL – (HTTP/HTTPS)



Using proper tools as suggested by sap will save your time And always it is  recommend to use sap prefered tools and follow release notes and guides before planning any upgrade .





1600846 - JSPM/SUM Calls sapcontrol without user credentials

1563660 - sapcontrol, <sid>adm authorization issues (SUM)


SAP First Guidance - migrate BW on HANA with the

database migration option (DMO)

Hi Techies,


I have performed Migration using Oracle Golden Gate. Please find the High level Steps.


Would be sharing the detailed Documentation.


Advantages of Oracle Golden Gate is there no down time for the source system. only down time is during the switch over.



  • Initialize the Oracle Advanced Customer Service (ACS) for SAP O2O (Oracle to Oracle) package which includes all functionality to create a complete set of migration scripts including a new source user creation, target database and related tablespace creation, and the OGG source and target configurations.
  • Install the Oracle GoldenGate software on source and target
  • Run the O2O package on the source system 4. Start GoldenGate change data extract and pump processes on the source system, which will being capturing and queuing change data and DDL (as needed).

Note: All tables in the SAPR3 schema will be included and will contain a SCN/CSN token so that later each table can be filtered by SCN/CSN. A code snippet to add such as token is:\

Table SAPR3.*, Tokens (tk-csn = @GETENV ("TRANSACTION", "CSN"));

  • Start the initial database load to copy the database objects from the source to target database.
  • Validate initial database load.
  • Start GoldenGate replicat apply processes on the target system, which will be applying captured change data and DDL (as needed). Note: While the replicat process(es) will be started using the AFTERCSN option, tables within a single replicat will be configured to skip transactions based on the table grouping of the initial loads. This automatically configured by the O2O scripts. Transaction filter by table will be done with something similar to the following code snippet:\

Map SAPR3.MYTABLE, Target SAPR3.MYTABLE, Filter ( @NUMSTR (@TOKEN ("TK-CSN")) > 1234567);

  • Switch over. Once both system are in sync the source SAP system may be stopped. After the last changes is applied to the target the SAP system can be started
  • on the target system. The source SAP shutdown and target SAP startup will typically take approximately 10 minutes regardless of the system size.



Sandeep Singh

Many a times CMS database in Business Objects can become inconsistent resulting in issues while logging in. While repository diagnostic tool can be used to point out the inconsistencies, some of them need to be resolved by query designer tool. One such issue and it's resolution has been described below having exceptions related to SI_APPLIED_PROPERTIES at the time of logging in.


Encountering below error while trying to login into BO BI 4.0. Issue happened during login into CMC as well as launchpad. Please find below the snap-shot of the error,


The CMS database somehow got inconsistent. Firing the following query in the Business Objects Query Builder,



This resulted in the following 3 infoobjects being returned




Make a note of the SI_CUID value for each of the three returned info-objects. Then use these SI_CUID to delete the entries from the database


delete from cms_infoobjects7 where si_cuid in

The stale entries in the CMS database pointing to DFO files are removed. Now you can successfully login into CMC and launchpad.

Please Note :

1. The url for query builder is http://[ServerIP]:[Port]/AdminTools/querybuilder/ie.jsp You can give host name also instead of server IP if you are using the local terminal server. Also you can check what all files are present in you Tomcat directory structure inside the host where the Tomcat web application server is installed for BO.

2. This issue is not release specific as CMS database can become inconsistent irrespective of product releases.

3. SAP was supposed to release a KBA for this issue, though I didn't found any. Somewhat identical issue has been captured in SAP KBA# 1563662.

4. While firing the delete query you might need the owner of the table name cms_infoobjects7. Use the query, select owner from dba_tables where table_name=''ÇMS_INFOOBJECTS7'

Once owner is retrieved you can use the CMS schema name in front of the table name to fire the delete query in oracle.

Finally, COMMIT is a strong word. Don't forget to communicate the same to Oracle.




This blog is about installing SAP NetWeaver Application Server ABAP 7.03 64-bit Trial on SAP Process Orchestration 7.31 SP 11 Trial in Amazon Web Services (AWS) Public Cloud (described in ‘Try SAP NetWeaver Process Orchestration in Public Cloud!’ blog - http://scn.sap.com/docs/DOC-33765). The target is to have two working systems in one cloud – SAP NetWeaver ABAP and SAP PO.

1. Make sure that your AWS cloud instance with SAP Process Orchestration 7.31 SP 11 Trial is installed and running (as described in ‘Try SAP NetWeaver Process Orchestration in Public Cloud!http://scn.sap.com/docs/DOC-33765).

2. Using Remote Desktop log into your virtual operating system.

3. Go to https://store.sap.com/ web and look for SAP NetWeaver 7.03 64-bit trial.

4. Click on ‘Trial Version’


5. Fill the form and click on ‘Submit’

6. Go to email that you used in form in point 5. There should be a link to the SAP NetWeaver Trial. Choose ABAP_7_03_SP04_64_bit_Trial_3_9_2_GB and download it. You have in this package SAP GUI also.

7. To unpack SAP Netweaver Trial download and install any program that unpacks archives for example 7-zip ( http://www.7-zip.org/ ). Unpack the SAP NetWeaver Trial.

8. If your hostname is longer than 13 characters you need to change for shorter one. To do that go to system properties (right click on computer -> properties), click ‘Change settings’ and then ‘Change…’  button. Change the computer name and save it. Computer needs to restart and it may take a few minutes.

9. After hostname changes your pi license might stop to be valid. To check this out go to http://localhost:50000/nwa Configuration -> Infrastructure -> Licenses.  If it is not valid  you need to install new license on your PI system. To do that go to https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/minisap/minisap.htm, fill the form and click ‘Submit’, go to mail that you used in form and download new license key. To install it go again to http://localhost:50000/nwa Configuration -> Infrastructure -> Licenses, click ‘Install from File’, find the file and add it. You should see now license with valid license status. The old license with not valid status you may delete by selecting it and clicking on ‘Delete License’

10. Install loopback adapter. Press ‘Start’-> cmd. Run hdwwiz.exe. Click ‘Next’. Set ‘Install the hardware that I manually select from a list (Advanced)’ and click ‘Next’. Choose ‘Network adapters’ and click ‘Next’. Then set as below:


Click twice ‘Next’ and then ‘Finish’.

Go to network properties. Click ‘Change adapter settings’. Right click on loopback adapter that you just added and click ‘Properties’.

Go to IPv4 Properties


Set the IP address and Subnet mask and save it. You will use this ip address in point 16.

Go to C:\Windows\System32\drivers\etc and edit file ‘hosts’.

Add line (with defined by you values from points 8 and 10 instead of these variables) to the end of a file

<ip_address_that_you_added_to_loobpack_adapter> <hostname>

For example: Host1


and save it.

11. Now you can start the installing. Go to folder:

NWABAPTRIAL70304_64\SAP_NetWeaver_703_Installation_Master\DATA_UNITS\BS2011_IM_WINDOWS_X86_64 and run sapinst.exe

12. Choose Central System as below and click ‘Next’.


13. Accept the license, enter master password (only ‘Abcd1234’ password worked for me. Other password that I tried were causing errors further steps of      installation) and set your installation drive to C.


if in prerequisites checker you will have condition ‘Swap Size’ not met then change your swap space to the recommended one and start installation again from point 11. To change swap size go to system properties, click ‘Advanced system settings’


Press ‘Settings...’


tab Advanced and press ‘Change…’. Change size to the recommended one and save it.

14. In Parameter Summary there might be one thing needed to be changed. If any of your installing locations there is set on Temporary Storage drive (had it as drive Z) then you have to change it on other not temporary drive like C.


Like above data volume is set to Z. If it will not be changed after installing system end restarting it might not start because of lack data volume (due to installing it on temporary storage). That is why you need to select ‘MaxDB Data Volumes’, click ‘Revise’ button and change all locations to other drive, for example on C:\sapdb\NSP\sapdata. Remember SAP System ID and Central Instance Number because it will be needed in point 16.


15. If you don’t want to change parameters go next. Installation should begin and after few hours should be finished. After that in SAP Management Console there should be your abap server in green color. That means installation was successful. If it is grey then right click on it and press ‘Start’. Log in if needed and after a moment server should be working (green color). Actually both – PI system and ABAP server should be green to be sure that they are both working well. To be sure that they are working you may restart computer and start them again.


16. To connect with server you need to install SAP GUI. It is in package that you unpacked in point 7. Install it. Run ‘SAP Logon’ icon from desktop and create new entry (right click -> add new entry). In application server use the ip address from point 10 and in Instance Number and System ID fields use values from point 14. Then click ‘Finish’. Now you should be able to connect to ABAP Server and log in there.




VB coding in BEx Analyzer.

In some situations MS Visual Basic coding may be used to transform data displayed in BEx Analyzer.
Let’s suppose we have to create a report that presents service costs with respect to the country of vendor and the code of service.  

The problem is that two queries should be used in this case. First query where we can see country associated with vendor (0vendor__0country) and second query using 0pcompany__0counry (as we have no data in 0vendor in some records ). 

Now we have two tables that we have to combine into one to see the data in a proper way.
First: based on 0vendor_0country:

SERVICE (code and text); 0VENDOR__COUNTRY (code); AMOUNT (rounded); AMOUNT
232 service group 1  DE 100 100,01 
232 service group 1  GB 200 200,01
236 service group 1  DE 150 150,02


Second (based on 0pcompany_0country)

SERVICE (code and text); 0PCOMPANY__COUNTRY (code); AMOUNT (rounded); AMOUNT
232 service group 1  DE 300 300,01 
232 service group 1  GB 100 100,01
236 service group 1  DE 50 50,02


We need combine data from both tables into:

SERVICE (code and text); COUNTRY (code); AMOUNT (rounded); AMOUNT
232 service group 1  DE 400 400,02 
232 service group 1  GB 300 300,02
236 service group 1  DE 200 200,02


Here is the moment when we may use VB coding. 

What should be done in this case is:
1. data from the first table should be copied to another location.
2. data from the second table should be copied to the same location just below the last row from first table
(here we have one table containing the data from both tables)
3. data in the new table should be sorted by service and country
4. data should be aggregated by service and country

Copying the data from first table may be realized by code:

   Sheets("0VENDOR SHEET").Select   
    r = 2
    t = Cells(r, 1).Value
    While t <> ""
        r = r + 1
        t = Cells(r, 1).Value
    RwMax = r
    Range(Cells(3, 1), Cells(RwMax - 2, 7)).Select
    Cells(2, 1).Select
Copying the data from the second table is slightly more difficult because the first row of that table have to be just under the last row of the first table.

   Sheets("0PCOMPANY SHEET").Select   
    r = 2
    t = Cells(r, 1).Value
    While t <> ""
        r = r + 1
        t = Cells(r, 1).Value
    RwMax2 = r
    Range(Cells(3, 1), Cells(RwMax2 - 2, 7)).Select
    last_row = Selection.SpecialCells(xlCellTypeLastCell).Row
    Cells(last_row + 1, 1).Select
    Application.CutCopyMode = False


To sort the data we use code like this 

    ActiveWorkbook.Worksheets("OdbRazem").Sort.SortFields.Add Key:=Range( _
        "A2:A300"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
    ActiveWorkbook.Worksheets("OdbRazem").Sort.SortFields.Add Key:=Range( _
        "C2:C300"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
    With ActiveWorkbook.Worksheets("OdbRazem").Sort
        .SetRange Range("A1:F100")
        .Header = xlYes
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
    End With


Aggregation of records is not very complicated 

    serviceCode = ""
    serviceText = ""
    vCountry = ""
    roundedValue = 0
    myValue = 0
    sumRow = last_row + 7
    cRow = 2
    serviceCode = Cells(cRow, 1).Value
    serviceText = Cells(cRow, 2).Value
    vCountry = Cells(cRow, 3).Value
    roundedValue = Cells(cRow, 4).Value
    myValue = Cells(cRow, 5).Value
    For row = 3 To last_row + 1
        If Cells(cRow, 1).Value <> serviceCode Or Cells(cRow, 3).Value <> vCountry Then
            sumRow = sumRow + 1
            Cells(sumRow, 1).Value = serviceCode
            Cells(sumRow, 2).Value = serviceText
            Cells(sumRow, 3).Value = vCountry
            Cells(sumRow, 4).Value = roundedValue
            Cells(sumRow, 5).Value = value
            serviceCode = Cells(cRow, 1).Value
            serviceText = Cells(cRow, 2).Value
            vCountry = Cells(cRow, 3).Value
            roundedValue = Cells(cRow, 4).Value
            myValue = Cells(cRow, 5).Value
            roundedValue = roundedValue + Cells(cRow, 4).Value
            myValue = myValue + Cells(cRow, 5).Value
        End If


Now we have aggregated data that may be used in a beautiful report.

The program of course may be associated with a button that we create in one of the sheets.


This is only an example of a method. The program may be much more elaborated. Using VB we can do everything in what we need.


Hope it encouraged you to use VB coding in analyzer.

Regards, Leszek

We were using SUM 1.0 SP10 Patch 3 for upgrading the JAVA system/DUAL System. We got an error in Execution phase in step Import cr-sda models.


The ERROR which was recorded in IMPORT-CR-SDA-MODELS_01



<!--HELP[Manual modification of the header may cause parsing problem!]/-->




<!--FORMATTER[com.sap.tc.logging.TraceFormatter(%d [%6s]: %m)]/-->



Apr 23, 2014 11:47:28 AM [Info  ]: About to process archive G:/SUM_xxx/SJL_Download/LMMODELNW04_0-20009684.SCA. The CR-SDA content will be extracted first.

Apr 23, 2014 11:47:28 AM [Info  ]: About to import archive G:\SUM_xxx\SUM\sdt\tmp\sap.com~product~lm-model-nw.sda.

Apr 23, 2014 11:48:17 AM [Error ]: The following problem has occurred during step execution: com.sap.sdt.j2ee.tools.feimport.FunctionalElementsImporterException: Cannot import file G:\SUM_xxx\SUM\sdt\tmp\sap.com~product~lm-model-nw.sda. See next messages for details.

com.sap.sdt.sldeploymentlib.SLDeploymentException: CIM_ERR_FAILED: CIM model version insufficient, version in <local>, namespace active is 1.6.17, but should be greater or equal to 1.6.37

com.sap.sld.api.wbem.exception.CIMException: CIM_ERR_FAILED: CIM model version insufficient, version in <local>, namespace active is 1.6.17, but should be greater or equal to 1.6.37



We have upgrade the CR Content and CIM Model to latest patch , but error was not resolved.

Searched in SCN :

We have looked for the error in SCN community and found that its a bug in SUM 1.0 SP 10 patch 3.

1. Re: CIM_ERR_FAILED: CIM model version insufficient

2. SUM Netweaver 7.4 Java SP update error





Reset the upgrade and start the upgrade with SUM 1.0 SP8 patch (X) or SUM 1.0 SP9 patch (X).



Hope this will help you all



With Regards

Ashutosh Chaturvedi

Moderator note: This event is only available in German. The blog is therefore only in German. Please ignore if you are not German.


Sicherheit in Ihren Prozessen und Abläufen ist von größter Bedeutung für Ihr Unternehmen. Doch wie gelingt es Ihnen die Anforderungen aus dem Bereich Security optimal umzusetzen? SAP Education Services unterstützt Sie professionell mit den SAP Security Days 2014. Das Programm deckt in kompakter und praxisnaher Form  aktuelle SAP Security Themen ab und Sie haben zwei Tage lang die Möglichkeit, in verschiedenen Sessions ihre Qualifikationen zu erweitern und aktuelles Wissen zu sammeln. Von SAP Infrastruktur und Kommunikationssicherheit über Compliant und Identity Management bis hin zu GRC (Governance, Risk & Compliance) Themen.


Die Highlights im Überblick:

Mit hochkarätigen Plenumsvorträgen zu den Themen Produktsicherheit der SAP Produkte sowie einer Live Hacking Demo eröffnen wir die SAP Security Days 2014 am 15. Mai. Insgesamt stehen  15 unterschiedliche Vorträge zur Verfügung, aus denen Sie idealerweise fünf frei wählen können. Sämtliche Vorträge werden Ihnen im Anschluss der Veranstaltung zur Verfügung gestellt.



§   Security in unterschiedlichen SAP HANA Szenarien

§   SAP NetWeaver Identity Management 7.2

§   Fraud Indikatoren mit  SAP Fraud Management

§   Einschränkung des Zugangs von Cloud Apps zu On-Premise

§   Compliant Identity Management

§   SAP Audit Management 1.0 on HANA.

§   RFC Schnittstellensicherheit  – Good Bye für SAP_ALL

§   Finding the Leak – Nutzung von Read Access

§   SAP NetWeaver Identity Management 7.2 New Features

§   Identity Management und GRC for SAP HANA

§   Re-Design von Rollenkonzepte im SAP ERP.

§   SAP GRC Smart Business App / SAP FIORI Access Request

§   Access Request Management und Segregation of Duties Checks

Weitere Informationen sowie Agenda zu den SAP Security Days 2014 finden Sie hier.

Hi all,
I hope this helps.
ADS Installation and Configuration
Introduction: Adobe Document Services (ADS) enable form-based processing of business data triggered by both ABAP- and Java-based applications. It is an additional SAP NetWeaver solution extension included in the SAP NetWeaver usage type AS Java
Installation checks:
  1. Check whether ADS is installed on PI Java Stack
http://<AS Java hostname>:<port>/monitoring/ComponentInfo

    2. If it is installed, Configure the communication between PI and ECC

If it’s not installed follow below steps to install it.
      • Download support package ADSSAP07_0-10009589.SCA (SP07for ADOBE DOCUMENT SERVICES 7.31) from SAP support portal.
      • Upload SCA file to AS Java server (any temp location).
      • Logon to AS Java server console via SSH with <sapsid>adm user.
      • Execute telnet localhost <telnet port> and login with administrator of AS Java user (Administrator or similar).
      • Execute lsc (refer to SAP Note 1715441)
      • Deploy SP07 for ADOBE DOCUMENT SERVICES 7.31
        (refer to
        with command:

        deploy /tmp/ADSSAP07_0-10009589.SCA on_deploy_error=stop
        Note: during deployment of ADSSAP component AS Java server instance is restarted.


  • Execute
  • telnet localhost <telnet port> and login with administrator of AS Java user to re-connect to Deploy ControllerTelnet.
  • Execute get_result to view results of deployment.
  • Open http://<AS Java hostname>:<port>/monitoring/ComponentInfo and verify that ADSSAP is listed under System information: Components Info.
  • 1.jpg

Configuration: As ADS
are running on an AS Java (PI) and form processing is performed in an ABAP (ECC) environment, we have to configure the communication
between the Form Processing Framework running on AS ABAP and the ADS running on
AS Java.
Note: Refer to SAP Note 925741
AS ABAP configuration:

  1. Log on to the ABAP system, call transaction SM59,and select 'ADS' from 'HTTP connection to ext. server'.
  2. Specify the server name and http port number of the additional stand-alone AS Java.
  3. You also need to update the corresponding user and password information on the 'Logon/Security' tab.


4. Make sure that create the user ADS_AGENT with the
corresponding role SAP_BC_FP_ICF and SAP_BC_FPADS_ICF exist in AS ABAP. If this
user does not exist, create it according to the steps in ADS Configuration



When you do connection test for ADS destination in SM59 the result can be “HTTP
response: (405) Method not allowed”. This is normal.

5. Open transaction SICF.

6. Choose default_host →  sap  → bc →  fp in the tree.

7.Choose Service/Virt.Host  →  Activate

8. If AS ABAP and AS Java (with ADS) are installed in different systems, and you want to bundle your forms to
     improve performance, you also have to activate the fpads ICFservice.



AS Java configuration:       


  1. Log on to the NetWeaver Administrator of your additional standalone AS Java.
  2. Select Server -> Service -> destination -> HTTP.
  3. Create an entry 'FP_ICF_DATA_<SID>',   where <SID> is the ABAP backend System ID.
  4. Enter the ABAP HTTP port (http://<servername>:<port>) in the 'URL' field.
  5. Enter the user 'ADS_AGENT' in the User name field, and the corresponding password of ABAP backend system.
  6. Save your entries.


Note: When
you do ping test for the destination the result can be “Error 404: Not found”.
This is normal.


As Java configuration for WebDynpro Application:


1.    Log on to the NetWeaver Administrator of your additional standalone AS Java.


2.    Select SOA Management -> Technical Configuration -> Destination Template


3.    Management


4.    Select'Create Destination' and Enter following entry:


5.    Destination Type: WSIL


6.    Destination Name: ConfigPort_Document


7.    URL:http://<standalone AS Java server name>:<http port>/inspection.wsil


8.    SecurityTab


9.    Select Authentication 'HTTP Authentication' and 'User ID/Password (Basic)'


10.  Select 'Details' and enter the user ADSUser and the corresponding password.


11.  Select 'Save


Testing ADS Configuration:


·       Checking ADS Configuration in an ABAP Environment


1.  Log on to the AS ABAP system.


2.  Start the transaction SA38.


3.  Enter the program name FP_TEST_00.


4.  Choose Program Execute (F8)


5.  Make sure, that the following default values are entered in the respective fields:




ADS Connection:
ADS or the RFC Destination name specified in your system (if it does not
correspond to the default entry)


6.  Choose Program Execute (F8)


7.  Enter the Output Device.


8.  Choose Print Preview.


9.  If the system displays a form containing several lines on two pages, the ADS configuration is correct. Otherwise, perform the
tests described below.



·       Checking the ABAP Connection to ADS
  1. Log on to your SAP system.
  2. Start the transaction SA38.
  3. Enter the name of the test report FP_PDF_TEST_00.
  4. Enter the name of the connection. Enter the default name ADS, or, if you have specified another name, the one you are using in your system.
  5. Choose Execute (F8).
  6. If the configuration is correct, the system displays the version number of the Adobe Document Services.



        ·       Checking the Destination Service and the ICF Service

          1. Log on to your SAP NetWeaver AS ABAP system.
          2. Call transaction SA38.
          3. Enter the name of the test report
          4. Execute the test without choosing the option With
            Destination Service.
          5. The system renders a test form in the background
            without using the destination service and displays the size of the created PDF.
          6. Execute the test again. Now select the option With
            Destination Service.
          7. If the settings of the destination service are
            correct, the system displays the same message as before (see step 5).


Note: Please refer to SAP Note 944221 for Adobe Document Services troubleshooting.

Dear All,


I would like to share below checklist which helped me to remind of doing things before starting SUM tool while working with multiple systems in a upgrade project. After reading ECC EHP6 master guide, SUM guide, Upgrade guide and recommended SAP notes from service marketplace which is obvious separate guides and notes which I have downloaded on my disk for reference. But I needed something handy for each phase which I can print and stick it to my desk so I have created a master document in which I have created multiple sheets like below :


Master Document :

- High Level Technical Plan - Sharing / Updating this sheet weekly and sending across client steering committee for Project update

- Detail Technical Plan - A pure tech plan sheet mixed of above mentioned guides & SAP Notes

- Planning & Preparation - Checklist before starting SUM tool

- Solman Specific - Technical steps from adding system to LMDB/SMSY till STACK file generation

- Execution & Postwork - Execution phases are actual SUM phases like Initialization, Extraction, Configuration etc., and Postwork steps

- SAPNotes for reference & Monitoring log files path - Details from SAP notes like keyword from note: 1790828, Increase DB process in case of error in Preprocessing phase refer note : 34432.


Below is the example of Planning & Preparation sheet I will try correct and post remaining sheets from above document soon.


Source : SAP ECC 6.0 EHP2 with Oracle 11g on RHEL 6

Target : SAP ECC 6.0 EHP6 with Oracle 11g on RHEL6


1SAP - Kernel upgrade to patch levelUpgrade kernel to 700/353 to avoid errors in Welcome Phase
2SAP - BRTOOLS UpgradeFor 11g it's recommended to use BRTOOLS 740 to avoid errrors in Configuration Phase
3SAP - Invalid temp tablesCheck for invalid temp tables & delete if require
4SAP - Open requests checkCheck for open requests in SE03 & release or delte unwanted requests
5SAP - Update requests checkDelete old / cancelled update requests from SM13
6SAP - Lock entries checkDelete old held locks from SM12
7SAP - Missing index checkCheck for missing indexes in DB02
8SAP - Update DB statistics for allUpdate DB statistics using BRTOOLS
9SAP - Gather all SAP user passwordCheck and update all SAP admin user password in 000 & master client
10SAP - Keyword check1736483 - Use this keyword for SUMSAPNote - 1790828
11SAP - Cehck SPAM versionAtleast SPAM level 50 require for Extraction Phase
12SAP - guides reviewCheck SAP Update, Upgrade, SUM, Master guides and their respective checklist
13SAP - notes reviewCheck SAP Central SUM Notes, Oracle specifics for know problem and solution
14SAP - Customize RFC creationCreate a RFC-Destination & update FINB_TR_DESTSAPNote -  912369
15SAP - check the structural requirementsparameter should be - rdisp/mshost =SID & rdisp/wp_no_vb=3
16SAP - check BG workprocess
17SAP - Install or update SAP Host Agent
18SAP - Backup of tableBackup of table -T512W using report -RPU12W03S
1DB - user checkCheck account of all users in dba_users SAP DB users set to unlock
2DB - user password checkUpdate DB user - SYSTEM password
3DB - user privilage checkcheck dba_sys_privs for SAPSR3
4DB - check missing indexes
5DB - archive status checkSet to NOARCHIVE Mode
1OS - Space check/usr/sap -> should have 50 GB free space
2OS - Free space check in tablespacesCheck using DB02 for sufficient free space for all tablespaces
3OS - UUID Daemon startstart service from root user - (1) service uuidd start (2) chkconfig uuidd on1391070 - Linux UUID solutions
4OS - Directory creationCreate SUM directory under /usr/sap/SID
5OS - Host selection for SUMCopy all software (SUM/EHP) to SID CI host
6OS - Check hardwareCheck for CPU, RAM, Mount points, Freespace
7OS - Check VNC serverCheck for Display variable by login thrugh VNC
8OS - Gather all user/passwordCheck password for sidadm, orasid, root


Thanks & Regards,


Tamas Istenes

Alerts in RZ20

Posted by Tamas Istenes Feb 5, 2014

The CCMS Alert Monitoring Infrastructure consists of three parts:


  • Data Collection
  • Data Storage
  • Data Reporting/Administration


SAP provides an expert tool, the CCMS Alert Monitoring transaction RZ20 as a display transaction to report the monitoring structures
and monitoring data which are stored in the monitoring segments. Alternatively,you can use the Solution Manager to display the monitoring data in a
business-oriented context. If the system identifies a problem an alert will be created.


  In general if you complete an alert manual it means that the user thinks that the problem is solved and because of this the alert can be
completed. If the problem is really solved than with the next run of the data supplier no new alert (YELLOW or RED) will be created but if
the actual problem is not solved a new alert will be created. Now it depends on how you did setup your 3-rd Party monitoring system because
if this system does read all the ACTIVE alerts every 5 minutes than it means that after 5 minutes also the actual status of the alerts also
will be reported in the 3-rd Party monitoring system and in this way you can only use SAP CCMS to manage the alerts.

A GREEN alert means that the data supplier reports that the problem is solved (not the user).


-Working with All-Clears (Green Alerts)




Recommended notes:

414029 -  RZ20: Automatic reorganization of alerts

1055793 - Gray alerts with "(..::)" in SolMan Solution Monitoring

543414 -  RZ20: Alerts stay in status ACTION_REQUIRED

1703934 - Green alerts after monitoring pause

746193 -  RZ20: Generating all-clears ("green alerts")
382769 -  RZ20: Error messages do not generate any Alerts
1462715 - Old alerts are not visible after switching to summer time


GREEN alerts can note used for the node "Shortdumps" because a GREEN  alert is only created after the status of the node is YELLOW or

RED and after this a new message is sent with the rating GREEN and this will create the GREEN alert. For the "Shortdumps" node this will never

happen because only message with YELLOW or RED rating will be sent to this node.


For example you can use it for the OS_Collector State monitoring node becuase when SAPOSCOL id dowm a RED message will be sent and a RED
alert will be created and as soon as SAPOSOL runs again a GREEN message will be send (SAPOSCOL is running) and a GREEN alert will be created.




Operating System
>>>>       State    The OS collector (saposcol) is running, Green...

As usual, this blog is not for geniuses or Basis gurus! Most of the time I like to write for people like me who learns by doing and some time looking at others works.


In this blog, my focus will be on two things:

  1. How to work with the NetWeaver Developer Studio 7.31 (NWDS) for deploying and un-deploying any SAP or third party java component.
  2. How to play with SCA, SDA & jar files where to look for the required class.


...of-course with help of lots of screenshots, fun starts now!


I think I am not re-telling what is present at the link below


SAP NetWeaver Developer Studio 7.1 Overview


SAP has this habbit to take out people from their comfort zone, some time for good and some time for ....... anyway.

It will not be fair to compare SDM and NWDS. Later is much versatile tool, I have seen PI guys working with NWDS instead of their old ways from SXMB_IFR then ESR or IB.


This is just an example, that NWDS is not just for us(Basis). Lets see how we can use this tool:


NWDS can be downloaded from service market place, unzip it and its ready to work. Double click on executable, it will first ask for a directory location, you  can provide the location or let it select the default one, its upto you.


<<If you want to view screenshot clearly then you need to click on each of the screenshot so that they can open in actual size, otherwise some of them are not clearly readable.>>


Here is the first screen. Click on Windows the preferences.


You will get screen like below select SAP AS Java, if you have older version, find something similar to that.

On right side you can find Add button. Click on it, you will get another pop-up window seeking

  1. your java hostname,
  2. Java system instance number like you give in your URL(http://<hostname or IP>:5NN00) here NN is instance number.
  3. Add to Domain: I select from drop down value "Default"


When you click on OK you may be able to view one entry like below for your Java system ID. If you are not able to see any entry, don't worry click OK because sometime I get the entry and sometime I don't see any entry, but in both cases it works as expected.

Now again click on Window -> Show View -> Other


You will get below screen, Select "Deploy View" and click on OK.



Now click on External Deployable Archives, you will see options with radio button on right side.


Selecting the option "Update deployed archives with any version"

By this option you can over-write the java component of present version with any version you want.

(For example with SAP or someone else suggestion you upgraded certain components but it didn't worked as expected so you want to revert it back. Additionally I have used this options to deploy com.sap.aii.af.axisprovider component several times)


Right click on "External Deployable Archives" and click on Add


you can browse to the SCA or SDA files where you have stored them on to your system from where you have started NWDS. You can select more than one component at a time.


After selecting and clicking on Open button we can see those entries below "External Deployable Archives"


Again you can right click on "External Deployable Archives". Now you can see the deploy option, click on the Deploy.


It will prompt for your Java system admin and password, unless you have not selected the option "Store username and password in secure storage"

(Based on the type of your system it could be j2ee_admin or administrator or any other user with similar authorization.)


Personally I prefer to give password manually everytime, so I uncheck the tick like below screenshot. Its your choice.


If everything is fine the deployment will start and you can click on right-bottom to view details of deployment.


including "progress view" from my another deployment just to show.


The time taken varies based on the number of components and their type. When it is finished you can see the details.



  1. File:C:\Users\ahmadi\Desktop\AS1\AJAXRUNTIME07P_7-10008281.SCA



                Location:SAP AG


                Deploy status:Success


  1. File:C:\Users\ahmadi\Desktop\AS1\ENGINEAPI07P_21-10007921.SCA



                Location:SAP AG


                Deploy status:Success


  1. File:C:\Users\ahmadi\Desktop\AS1\FRAMEWORK07P_5-10007877.SCA



                Location:SAP AG


                Deploy status:Success


  1. File:C:\Users\ahmadi\Desktop\AS1\WDRUNTIME07P_18-10007825.SCA



                Location:SAP AG


                Deploy status:Success


  1. File:C:\Users\ahmadi\Desktop\AS1\SERVERCORE07P_66-10007988.SCA



                Location:SAP AG


                Deploy status:Success






Now lets give a quick glance at how to un-deploy any component, though I have not done it my self yet! because there was no requirement, and I need to keep my job going too

Lets get the undeploy View.

Click on Window -> Show View -> Other

You will get below screen, Select "Undeploy View" and click on OK.


As we have seen in earlier discussion we need to put the hostname, instance and domain.


We get a view like below. Check those two groups of radio button. You need to be very sure what you are doing. If I need to undeploy any component and I am not sure if that component has dependency, I will select "If depending stop"


We can click on refresh.


It will prompt for Java Admin User ID and password


based on the type of your system it could be j2ee_admin or administrator or any other user with similar authorization. Now you will be able to see all the installed components in left hand side of Undeploy View.


Select the component or sub-component and right click on that. Select "Add to Undeploy List" by doing that you'll see the component name will get added to right hand side panel along with its detail.


You can add more than one components in the "Undeploy List Panel".

Now you can see the button  ("Undeploy all items in the list") as pointed in below screenshot.

When all set, click on the button to undeploy the component.


In this last section, lets discuss the structure of SCA, SDA and jar file.


Recently I was working with com.sap.aii.af.axisproviderlib.sda file, because there was requirement to deploy some missing components in PI related to Axisprovider. Below is the screenshot.


In your PI System you can get this screen by this URL

http://<PI Hostname>:5<NN>00/XIAxisAdapter/MessageServlet

This will also give you suggestion from where to download missing jar file. Sometime you will not be able to get compatiable jar files, you don't have to find the jar file with exact same name. What is more important is getting the class file in exactly same location as it is being searched by the System.


Lets verify if the jar file is correct file or not. First you will get a zip file, you need to unzip it to get jar file. If you are downloading from net you can directly get jar file. When you find the jar file, you can make a copy of jar file and rename it to .zip file. Now use your installed zip program like winzip or any other program to see where is the desired .class file is located.



In case if you are getting .class file with exactly same name but it is placed in different path then deploying that jar file is not going to help you.

Now even if path and class name matches it does not ensures that after deploying it will resolve issue, compatibility with rest of the dependent component can only be found out after deploying them.

So it is Very Strongly suggested that you should have a backup of .sda file which you deployed earlier, so that in case after deploying the services will not come-up you can re-deploy the old file and get back the services. For any of these action you don't have to restart java.


Next question is how to pack this jar file in existing sda/sca/ear file?

Secret is; all sda, sca, ear, jar files are actually a type of zip file, you can always rename them to zip and use your local zip program on your PC. Locate the directory inside the unzipped directories where you see other jar files, place your new jar file there... and look for provider.xml file in other directory

for example in our case the jar name is commons-net-1.4.1.jar so we will add one extra line in between of others.


In the end, zip everything back and rename it from .zip to .sda, now you are ready to deploy with NWDS.


I am not going in much details because there are already material out there on net and sdn about it. For example read this note to get some idea about it

1028961 - How to prepare axisproviderlib.sda for Adapter Framework

you can also read blog Deploying JDBC drivers in PI 7.1x Systems


After deployment you can actually go and check at OS level. Like in our case this file is external file, so you can goto

/usr/sap/<SID>/DVEBMGS<NN>/j2ee/cluster/bin/ext  (ext means external)

our sda file name is com.sap.aii.af.axisproviderlib.sda

so we will find a directory named com.sap.aii.af.axisproviderlib

inside it as we put all our jars inside lib directory before zipping it back, we can find one lib directory and there we will see all the jars successfully deployed there. If you will redeploy the same .sda file after removing particular jars, then that particular jar will get deleted from OS level as well.


Now in some of your "quests" if you are looking for any class file, you know now that they will be inside some jar files, simple go to the most probable location and give this command, like I am searching for HttpClient.class I will go to /usr/sap/<SID>/DVEBMGS<NN>/j2ee/cluster/bin/ext and execute below command


find . -name "*.jar" -exec grep -Hsli HttpClient.class {} \;



.....By this I am signing off, your comments and suggestions are most appreciated





My other Blogs, if you have time...

What's new in SAP NetWeaver 7.3 - A Basis perspective Part-I

What's new in SAP NetWeaver 7.3 - A Basis perspective Part-II

Bye bye STRUSTSSO2: New Central Certificate Administration NW7.3

Escaping tough moments of SPAM or SAINT

SAP Software Provisioning Manager : with screenshots

Multiple/Bulk transports with tp script for Unix (AIX, Solaris, HP-UX, Linux)

Script for deleting files within a directory structure with different retention days

Holistic Basis View: BusinessObjects BI 4.0 SP 2 Installation & Configuration

How to Rename the Oracle Listener & Change Listener port for SAP


Start/Stop SAP along with your Unix Server Start/Stop

Interrelation: SAP work process, OPS$ mechanism, oracle client & oracle shadow process

Install and configure NetWeaver PI 7.3 Decentralize Adapter part-1

Install and configure NetWeaver PI 7.3 Decentralize Adapter part-2

List of Newly added/converted Dynamic parameter in NetWeaver 7.3

Sunset for ops$ mechanism: No more supported by Oracle & Not Used by SAP


Essential Basis for SAP (ABAP, BW, Functional) Consultants Part-I

Essential Basis for SAP (ABAP, BW, Functional) Consultants Part-II

Essential Basis for SAP (ABAP, BW, Functional) Consultants Part-III

Short time ago I was faced with the issue to transfer my SAP Client Passport certifcates from a Windows 7 installation to Windows 8.1.

After processing the Signle Sign-On Wizard in the SAP Support Portal (in IE11) I received always errors about my active X settings in Internet Explorer.

So after a long time of trying to change my activeX settings i tried to use the IE Developer Tools and found a way to install my passport certificates into Windows 8.1 with Internet Explorer 11.


  1. To open the IE Developer Tools press F12
  2. On left side change to the options "Emulation"
  3. Change the "Documents modus" to 5
  4. Change the "Browser Agent" to "Internet Explorer 7"


(Sorry for the german screenshot)


After reconnecting to http://service.sap.com including the changed browser settings the import Wizard of Windows 8.1 works fine.

Don't forget to reset your emulation Settings!



Dear all,


We need to deploy the MQ libraries on java engine so that messages can be processed from PI/PO sytems to MQ server.

I have taken the reference from the below SAP Notes


1. 747601 - J2EE JMSAdapter: MQSeries libraries

2. 1770304 - PI: How to prepare the com.sap.aii.adapter.lib.sda for deployment



From the SAP Note 747601 , you will get the required libraries information which you need to deploy as per the version of MQ server.



You will need to build aii_af_jmsproviderlib.sda and com.sap.aii.adapter.lib.sda depending on the version of XI adapter.


For XI Adapter 3.0/7.0 , you need to have aii_af_jmsproviderlib.sda file.


For XI Adapter 7.1 above , you need to have com.sap.aii.adapter.lib.sda file.



From where to get the above files :


For version 3.0/7.0 , You will get the aii_af_jmsproviderlib.sda


/usr/sap/<SID>/DVEBMGS<SYSNO>/SDM/root/origin/sap.com/com.sap.aii.af.jmsproviderlib/SAP AG/3.0.0220040608173429.0000/aii_af_jmsproviderlib.sda



For version 7.1 , you will get the com.sap.aii.adapter.lib.sda in SAPXI3RDPARTY08_0-10009499.SCA file.



Preparing com.sap.aii.adapter.lib.sda for deployment :


In our case , the MQ server version is 7.0 , so we have used the below libraries.


1. CL3Export.jar

2. CL3Nonexport.jar

3. com.ibm.mq.headers.jar

4. com.ibm.mq.jar

5. com.ibm.mq.jmqi.jar

6. com.ibm.mq.pcf.jar

7. com.ibm.mqjms.jar

8. connector.jar

9. dhbcore.jar

10. fscontext.jar

11. providerutil.jar

12. rmm.jar


Step 1 :


Rename the SAPXI3RDPARTY08_0-10009499.SCA file to SAPXI#RDPARTY08_0-10009499.ZIP and extract it. You will get the below directories







Step 2 :

Enter into the DEPLOYARCHIVES directory where you can locate the the required .sda files. com.sap.aii.adapter.lib.sda.



Step 3 :


Rename the com.sap.aii.adapter.lib.sda to com.sap.aii.adapter.lib.zip file and extract it







Step 4 :


Extract the zip file com.sap.aii.adapter.lib.zip




Step 5 :


Now goto the directory com.sap.aii.adapter.lib and lib folder you need to put all the jar files as mentioned in the sapnote








Step 6 :


Goto the directory SAPXI3RDPARTY08_0-10009499\DEPLOYARCHIVES\com.sap.aii.adapter.lib\server and open the provider.xml file






Step 7 :


Now edit the provider.xml file as below, we need to add lines <jar-name>lib/CL3Export.jar</jar-name> between the tags <jar></jar>.

Save the provider.xml file.




Step 8 :


Now , zip  the file com.sap.aii.adapter.lib to com.sap.aii.adapter.lib.zip






Step 9 :


Now rename the com.sap.aii.adapter.lib.zip file com.sap.aii.adapter.lib.sda





Step 10 :


Now deploy the file with the help of SDM , JSPM and telnet.




I will update the blog from time to time.

Thanks for reading it.


With Regards

Ashutosh Chaturvedi

Hello Everyone,


I decided to create this short guide on how to analyze the EXPORT_TOO_MUCH_DATA dumps in SAP_COLLECTOR_FOR_PERFMONITOR.


We need the following in order to precisely analyze this kind of dump.

1) Full dump details (You can also find this in ST22).

2) Access to SE16 to check the entries in the SWNCMONI table.


In the dump details you can always see two important sections for this analysis.


The first one is easily found under "AGGTYPE" in the dump details as you can see below.




WQ <<<


This is the profile name which SAP_COLLECTOR_FOR_PERFMONITOR was doing the TOTAL calculation.

There is a strong indication that this profile is the responsible for the dumps.


The second one is found under "I_MONIKEY-PERIODSTRT" as you can see below.



L0 16

V0 20131001 <<<


This is showing us what is the period on which the SAP_COLLECTOR_FOR_PERFMONITOR generated the dump while creating the TOTAL.


For the next steps please refer to the SAP Note 1110822.


1110822 - Workload collector: Reducing the size of aggregates


The SWNC_COLLECTOR_COMPRESSION report should be used in order to compress the data associated to the profiles with more than 15 thousand entries

in the table SWNCMONI.


Data you have collected should be entered as per the below screenshot in SE16, after this you can use the button "Number of Entries" to check how many

entries exist each of the profiles. The profile names are WD, WF, WJ, WM, WO, WP, WQ, VA, VB, VC, VD, VE, VO,VV.




After compressing all the needed profiles run the report SWNC_COLLECTOR_RECOMPRESS one time manually as per the SAP Note 1110822.

In case the dumps are happening to the current month calculation, the effects of the compressions will only appear in the next month and the dump

will disappear in two weeks.


You check once again the number of entries in SWNCMONI table to make sure there is an expected number of entries for each profile (less than 15 thousand entries for each one).


Hope you like it,





Filter Blog

By author:
By date:
By tag: