SAP NetWeaver Administrator

Create Virtual Transport system in STMS

Himanshu Shrivastava — Thu, 16 May 2013 08:34:58 GMT

Creation of Virtual System in STMS Configuration.

It is Not recommended by SAP and also it is not best practice.

But sometimes it required to release transport request from Quality System where we have make changes and created transport request. It is required when we are unable to check changes in our development sandbox & changes need to be created and checked directly in Quality system.

To do this first you login with your BASIS id in SAP System.

1. Open STMS

2. Select SAP System > Create > Virtual System

3. Fill New Virtual System ID and Description.

4. New created system will be displayed on screen.

5. Return to main screen and Open Transport Route

6. Open in change mode. Open Configuration > Standard Configuration > Development and Production System

7. Assign Development System as current system and Production as Virtual system

8. Route will be created

9. Save the configuration.

10. Distribute and activate configuration

Now you are able to release transport request from Quality system

regards,

Himanshu

Auto-reaction method for automatic mail triggering when system is down

prakaash muthusamy — Thu, 16 May 2013 07:46:03 GMT

In my previous blog, i have explained the procedure for configuring availability monitoring. This blog explains the way to do automatic alert configuration when the status of system goes down in the availability monitoring(system is down)

1.1 Pre-requisites for configuring auto reaction method

Done in 000 client (Monitoring system)
Create a User using T-Code SU01 and do the following configuration
User must have a mail id
In address tab Click the other communication option. Double click [RML- remote mail] and check whether the SID is in upper case. Also check whether the RML client is 000 client.

Fill all other tab also and save.

1.2 Configuring SAPconnect:

Go to transaction SCOT
Double click SMTP

Make the following changes as shown in the screenshot and click ‘set’(enable node in use)

Go to Supported Address Types -> Select Inter Net option and click set button ->Enter ‘ * ’ in address area and click continue

SAPconnect Domain Configuration ( Go to Settiongs -> Default Domain )
Goto SETTINGS – DEFAULT DOMAIN and give the default domain value as KAARTECH.COM

Enter Default Domain Name

Click send jobs button from the menu

Click CREATE JOBS ( BUTTON ) -> Schedule for INT

Enter the Job name, Variant, Address Type, No. Work Process, Period, Start time and Background User
Click Continue

Automatically Background Job Triggered, Simply SAVE it.
SAPconnect created successfully

3.3: Configuring SMTP Service

Transaction SMICM (activating SMTP service)
Click services –> Check whether SMTP service is activated.

NOTE: If the services is not activated create a service throw following steps.

Select Service

Click Service -> Create
Enter Service Port, log type, Alive and Max processing time then Create Service

3.4: Checking the Mail server configuration:

Go to Transaction SBWP
Click new message
Enter recipient NAME and TYPE.
Enter needed details

AUTO REACTION METHOD

(TRIGGERS MAIL AUTOMATICALLY, WHEN SERVER IS DOWN)

1.5: Goto transaction RZ20 –> SAP CCMS monitor template –>Availability and performance overview –> Double click on it.

In PERFORMANCE ATTRIBUTE type set the threshold values as required.
In Methods tab -> Select METHOD ASSIGNMENT push button

Select parameters tab and fill the required details.

Note : Remember to provide the user for which we configure the remote mail at the beginning of the document.

Save and go back to the auto-reaction tab

Now check the process by bringing the server down.

step by step procedure for configuring Availability monitoring

prakaash muthusamy — Sat, 11 May 2013 09:52:58 GMT

SAP CCMS (Computer Center Management System) monitor allows you to monitor the performance of your SAP R/3 System landscape in a centralized manner. It retrieves and reports metrics using SAP’s new centralized monitoring architecture. SAP administrator can monitor all server, components and resources in his R/3 landscape from one single Centralized Server.

1.1 Download the ccmsagent for the satelite system (unicode or non-unicode, database independent) Available with the kernel files. (Version independent, only the latest version available).

1.2 Copy the downloaded ccmagentfile to the satellite system, uncar it (extraction command shown below) and copy the extracted file and past to \usr\sap\PRFCLOG folder.

1.3 Logon to ADMINISTRATIOR user

open command prompt
Go to PRFCLOG location where we copied the extracted files.
Then run “ccmsping –push –n00 –r” command.

1.4 After running the ccmsping command, enter the details of the monitoring system:

SAP System ID : <enter the SID>
Client No : (can also be done in default 000 client)
User : <username>
Language : EN(Default)
KSL-MS hostname : <Hostname or Host system IP>
Load Balance : n
App.server hostname : Hostname or IP(leave it default)
System Number :<Central Instance Number>
Router String :Optional
Trace Level :0(Default)
Pwd from solman :******

For RFC communication purpose, gateway system is needed. Assign the same monitoring system for the gateway connection. Enter the monitoring system details.

1.5: Create an user CSMREG, if not exists.

Procedure for CSMREG user creation

Logon to RZ21 T-Code (Monitoring System)
Select Technical Infrastructure -> Configure Cerntral System -> Create CSMREG user

For RFC communication purpose again we have to provide following user information

User name : CSMREG (User type: “communication”)
Client No :100 (can also be done in default 000 client,provided CSMREG exists)
Language :EN (Default)
<SID>-MS hostname : (Hostname or Host system IP)
Load Balance :n
App.server hostname :Hostname or IP (leave it default)
System Number :00 (Central Instance Number)
Router String :Optional
Trace Level : 0 (Default)
Pwd from csmreg :******

Start type service should be in AUTO mode

Now check the CCMSPING.00 service file in Satellite System (It should be in started mode)

RFC CREATED SUCCEFULLY (chek in SM59 transaction, monitoring system).

1.6 Make an entry of the monitored system in the file(Monitoring System)C:\WINDOWS\system32\drivers\etc\services

Make the entry as 'sapms<SID> 3600/tcp' (SID of monitored sys)

1.7 Go to RZ21 T-Code (Monitoring System)

Select technical infrastructure –> availability monitoring –> configure CCMSPING availability mon.

Configure availability and performance overview as shown above

select Monitoring -> Create System

Enter the SID of the system to be monitored in the small window that opens and press continue, enter the details as shown below

select Copy connection data and options

Finally SAVE the changes and ACTIVATE logon checks.

1.8 : Check whether the newly added system is available for monitoring

Go to Transaction RZ20
SAP CCMS monitoring temp –> Availability and performance overview –> Double click

satellite system available for monitoring. Successfully created.
Check the stats by turning off the SAP Satellite system–status going down to 40%(shown below)

Andy Silvey - The SCNers' Guide To Getting The Most From OSS Messages

Andy Silvey — Thu, 09 May 2013 07:59:07 GMT

following Mike Kerrigan's blog yesterday about frustrations with OSS Messages,
it's high time we share some tips and tricks on working with the OSS system.

Doing my fair share of OSS Messages for Customers where I am engaged has lead
me to develop some tips and tricks and techniques for maximising the response
to OSS Messages.

The goal of this blog is to share those tips and on top of this, furthermore,
request others who have good tips and tricks for OSS Messages to add their gems
and pearls of wisdom in the comments.

I have also included in here (without permission), an items from a SAP
Support CIC Presentation which we were given at one Customer. Hopefully the
good intention and synergy of the content will allow this information to be
published.

Where shall we start, let's start at the very beginning a very good place to start ,

as Julie Andrews said in The Sound Of Music which my daughters keep watching.

Step 1) The Message Priority

When you post an OSS Message you begin with the priority of the message.

Making the right choice in the beginning between LOW, MEDIUM and HIGH

priority, is extremely important.

Where and when to use a MEDIUM or a HIGH ?

I've experienced regularly, that if you open a MEDIUM as a MEDIUM and it is a
straight black or white question you often get a very very fast response and
closure. I guess it's to do with low hanging fruit, we all do tickets and the
low hanging fruit are the easiest and if an OSS Case comes in as a MEDIUM

and with a straight yes or no question it's an easy one to close.

I've experienced getting answers to MEDIUM questions within hours on several

occasions in the last couple of years. So my point is, use the message priority

with care.

Step 2) Selecting Correct Message Component

It can be confusing trying to select the correct or most appropriate Message
Component for your OSS Message.

Quality time invested in choosing the correct Message Component, getting this
right will speed up message processing by reducing the wasted time with the
message ping ponging with the wrong processing Component Team.

How to choose the correct Message Component, or as close as possible to the
correct one ?

Look for OSS Notes which are similar to the issue you are working on, find
and OSS Note similar to the issue you are working on and then in that OSS
Note look for and make a note of the Primary Component of the OSS Note.

Then, use that Primary Component as the Message Component for the OSS

Message.

Here's an example, you have a problem with PDF's generation in HCM through

Portal. Your ADS is the ADS of the Portal. You quickly open a Case to SAP and

put the Message Component as EP something or other. EP something or other

is not the ADS/PDF Team at SAP and therefore, there will be a delay while the

Message Processor from the Portal Component Team at SAP gathers all information

and then concludes this message is for the ADS/PDF Component Team.

How to find the ADS/PDF Component Team, find an OSS Note on ADS and PDF's
similar to your issue, and look at the OSS Note Primary Component and use
that as your Message Component.

Step 3) Entering the Message Details and Information for SAP

When you enter the information for SAP, remember, garbage in, garbage out.

When entering the Message Details, make as much effort as possible to provide
as much information as possible:

Describe the issue in detail

Even provide a word document with screenshots showing all of the

steps required to reproduce the issue and the result

Provide log files

Provide full System Information

Describe the Operating System and Database and their versions

Open the System Connection and put the logon details in the secure

area

Make sure the Contact Details in the Message are correct

telephone number

All of these items, will help speed up the message processing and reduce the
ping ponging, the more effort you make the more you will be rewarded by
faster processing of Message

Step 4) Working With SAP and Supporting The OSS Message

It is a revolution in OSS Message Support that we now get emails when the
Message status changes, this makes tracking the message much easier and
more fluid. Nevertheless, if you have an important message you should keep you
eye on the status of the message.

It is very important to make a qualified judgement of the quality, correctness,
and standard of the replies from SAP as there may be a need to request and
where necessary escalate to get messages moved to the next layer of support.

If you are not happy with the quality of the response from the Message
Processor then call SAP Global Support CIC and discuss with them and also
provide clear feedback in the Message and politely request with justification
that the Message is moved to the next layer of support

Keep attention on Messages by where necessary giving regular calls to SAP
Global Support CIC to request attention to the Message from the Message
Processor

Step 5) Be Polite

Treat people as you would like to be treated

Step 6) When Issues Become More Urgent

(this slide is taken without permission from a SAP presentation, if requested

I will remove it from the blog)

Finally, the icing on the cake is to be a Max Attention Customer. But nonetheless,

from my own experience, yes nothing beats Max Attention, but if you're not

at a Max Attention Customer and you make the right effort then you will get

the highest possibility of efficient message processing.

As already requested, please add your OSS Message Support Tips and Tricks to the
blog comments.

All the best, and remember, have fun with your OSS Messages :-)

Andy.

p.s. Personally I don't agree with using the SCN Platform as an instrument for
complaining about SAP. Personally I see SCN as a positive medium for bringing
out the best and improving in all areas. For me, regarding complaints to SAP,
if there is an issue, there are proper commercial Customer Account channels
which can used to report back to SAP and escalate where necessary.

p.p.s. Note to self - remember to practice what you preach

Install or renew the maintenance certificate in sap router

Pandiyaraj J — Wed, 08 May 2013 10:51:27 GMT

Create or renew the maintenance certificate SAP Router

OS: Microsoft Windows 2003 and 2008

Step1:

Delete the Following files in the respected locations

Delete these 4 files in E:\usr\sap\saprouter

1. certreq
2. cred_V2
3. local.pse
4. srcert

Step2:

Run the following command to generate the PSE file and create the certificate request.

C:\saprouter>sapgenpse get_pse -v -r certreq -p local.pse "CN=kslserver, OU=0000804861, OU=SAProuter, O=SAP, C=DE"

Note:

“C:\saprouter“ is the location of saprouter files.

“CN=kslserver, OU=0000804861, OU=SAProuter, O=SAP, C=DE” in command is the distinguished name of the SAP Router server which is assigned by SAP at the time of server registered. This can be found in server maintenance in service market place.

Step 3:

Copy the text from certificate request which is created by sapgenpse and past ino the following place to get the new certificate.

http://service.sap.com/tcs

You will get a new certificate as follows. Copy from the Beginning to the End of certificate and past in text file.

Step 4:

Importing the certificate request

With this in turn you can install the certificate in your saprouter by calling

sapgenpse import_own_cert -c “c:\routecert.txt” -p local.pse

“c:\routecert.txt” is a file name which has the certificate that copied from SAP Service Marketplace

Step 5:

Creating credentials for router

sapgenpse seclogin -p local.pse -O <user_for _saprouter>

Note: omit -O <user> to make the logged in user to be used for credentials

This will create a file named cred_V2 in the same directory. If not, copy the same file created in

<App drive>:\usr\sap\saprouter

Step 6:

To check the details we applied as shown in the below screenshot.

sapgenpse get_my_name -v -n Issuer

sapgenpse get_my_name -n validity

Shout out for Volunteers for SCN Community Project to Wikify the SCN Community's Favourite SAP Transaction Codes

Andy Silvey — Wed, 24 Apr 2013 08:31:41 GMT

Having watched, 'Good Morning Vietnam', on a flight on Monday, I have to begin this blog with...

Good Morning SCN,

SAP Transaction Codes

Our favourite SAP Transaction Codes

Who's favourite SAP Transaction Codes ?

Functional Consultants favourite SAP Transaction Codes by Function

Functional Consultants favourite SAP Transaction Codes by SAP Component
- ECC, FI, HR, CRM, BI etc

Basis Consultants favourite SAP Transaction Codes by task

Basis Consultants favourite SAP Transaction Codes by SAP Component

Development Consultants favourite SAP Transaction Codes by task

Development Consultants favourite SAP Transaction Codes by SAP Component

As we all know, there are thousands of SAP Transaction Codes, everybody has their
favourite most useful SAP Transaction Codes.

There are disperse and diverse websites all over the Internet containing people's
favourite lists of useful SAP Transactions by function, by task, by component.

There's even a hard copy SAP Press book of SAP Transactions which is great and
I even own a copy but it kind of seems an oxymoron every time I look at it,
because a) it's not easy to search, and b) it doesn't get updated, and c) it's big
and heavy.

Isn't it time, the power of the SCN Community was unleashed to compile a
perpetual work in progress list of everybody's favourite SAP Transactions Codes ?

Imagine the power and usefulness of such a list of SAP Transaction codes,
perpetually maintained and compiled by SCN Community Members, divided and
catagorised by Function, Task, Component, in one list, fast searchable
and available to contribute to and take from by all.

This blog proposes we start a new Wiki, The SCN Wiki of SAP Transaction Codes.

We can agree a skeleton for the Wiki, cataloging and classifying SAP
Transaction Codes by SAP Component and Function - Basis or Functional
or Developer.

We can catalogue something like this:

SAP Component - ECC

Functional SAP Transactions

Tcode xyz - small description & and version validity

Tcode xyz - small description

Basis SAP Transactions

Tcode zyx - small description

Developer SAP Transactions

Tcode qwe - small description

SAP Component - BI

Functional SAP Transactions

Tcode xyz - small description

Basis SAP Transactions

Tcode zyx - small description

Developer SAP Transactions

Tcode qwe - small description

etc

The proposal is one Wiki page, which will then be easier to search and
not require clicking back and forth through layers of catagorisation.

The Wiki will be editable by all.

Together using and unleashing the power of the SCN Community we can
build the world's greatest list of SAP Transaction Codes maintained
in one place on the Internet by the SCN Community and searchable and
editable by all.

How cool is that ? :-)

Please give your feedback if you would like to contribute from the
beginning and have any ideas how to make this SCN SAP Transactions
list even more valuable and useable for the community.

As we all know, Proper Planning and Preparation Prevents P*** Poor
Performance, and keeping this in mind, the first step, is to agree
the structure of the SAP Transaction Codes catalogue, if you have a
better solution to the cataloging structure than the above proposal
give your feedback in the comments here.

The Wiki is here:

The SCN Community's Wiki of SAP Transaction Codes

It is a work in progress.

All the best,

Andy.

Fixing the Windows "side-by-side configuration is incorrect" error #sapadmin

Martin English — Wed, 17 Apr 2013 05:30:30 GMT

Have you ever attempted to run SAP ABAP or JAVA components (or any other application) on a Windows Server and got the following error?

The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail.

A quick answer is that according to Note 684106 - Microsoft runtime DLLs, SAP used different releases of the Visual Studio Compiler for Windows x86 to produce the executables for different releases of SAP. Normally, this would be irrelevant as the appropriate files would be copied on to your system via the SAPINST tool, but in my case I wanted to use my new SAPCAR before I started installing anything

The note provides instructions on where and how to download the appropriate Microsoft Visual C++ Redistributable Package. I have found, depending on your release of Windows and / or Netweaver, that you may need to download the Microsoft Visual C++ 2008 SP1 Redistributable Package and / or Microsoft Visual C++ 2010 SP1 Redistributable Package. I imagine that sooner or later, as SAP migrate to later releases of the Visual Studio Compiler, you may' end up having to download a 2012 Redistributable Package.

To get these files, go to the Microsoft Download Centre and search for Microsoft Visual C++ 2008 Redistributable Package and / or Microsoft Visual C++ 2010 Redistributable Package. There will be separate downloads for IA64 (vcredist_IA64.exe), X64 (vcredist_x64.exe) and X86 (vcredist_x86.exe). Find the appropriate Microsoft Visual C++ 20NN SP1 Redistributable Package and download and execute it.

For a much longer answer on why this is necessary, including some useful links, check out Resolving Side-by-Side Configuration Issues.

SAP Education and Certification as the first level filter for SAP Human Capital candidate selection

Andy Silvey — Tue, 16 Apr 2013 07:36:13 GMT

Standards for Human Capital in SAP Delivery

We work in companies where the development and delivery of near perfect products and
services is governed by industry standards such as Six Sigma.

We work in companies where projects are managed according to certified practices and
methodologies eg Prince, PRiSM, Agile.

We work in companies where the SAP IT systems are installed with quality standards and
approaches, documentation and validation and verification.

We work in companies where the SAP investment can be a significant percentage of the
organisation's profit, where failure of a SAP system can affect profit, where failure
to run a SAP system in a qualified way can cost fines (FDA/Pharma).

We work in companies where pretty much anybody, any Human Capital can come through the
door and run these systems if they can make a strong enough case that they are qualified
to complete the task.

The question of determining the qualification of Human Capital in SAP Delivery is one
which has been around for years and more than ever needs addressing.

In today's world it is more difficult than ever for Hiring Managers, Project Managers,
SAP Delivery Managers to ascertain the quality of resources being presented for roles.
Face to face interviews are less and less, because of circumstances there is not always
enough knowledge on the interviewer side to make the technical and project experience
judgement of a candidate. With the internet and the wealth of information available it
is more easy than ever for potential candidates to fill gaps and recalibrate knowledge
and experience. Interviewers are often interviewing somebody on the other side of the
world. Even in large organisations, it is often people who are not from a SAP background,
the HR Team who are providing the service to the organisation and making the initial filter
of potential candidates.

How to improve this ?

There can be only one way, internationally trusted, internationally validated, minimum
basic standards for SAP Human Capital, that is,

SAP Education and Certification

Our industry needs to standardise measuring SAP Human Capital minimum standards of knowledge
using SAP Education and Certification as the bench mark yard stick.

Using SAP Education and Certification as the minimum bench mark yardstick across the world
will make everybody's lives easier across the whole process of sourcing and delivering
SAP Human Capital.

Admittedly, Certification is not and will never be the only measure of a person's skills and
knowledge, we all know that, but it will provide, a minimum standard with which to filter
candidates making the task of filling roles much easier and creating an accepted level
playing field for SAP Human Capital.

As an example, we all know, there can be good doctors and there can be not so good doctors,
the not so good and the good doctors are all qualified and certified. If they weren't they
cannot be doctors. Would you ever go, or send your children to a doctor who is not certified ?
Big companies do the same with their SAP systems every day, big companies allow uncertified

SAP Human Capital to work on their systems ! Why ?

In practice, how would filtering candidates on certification work ?

First Stage if the Selection Process:

Initial filter of potential candidates - Certified or Not ?

Simple yes of no. Certified candidate goes to the next stage of the selection process,
not certified candidate is disguarded.

Second Stage of the Selection Process:

Candidate's professional experience etc etc

Therefore as can be seen, certification is not the be all and end all, certification is not
the only tool to be used when selection candidates, but, it is the highest level filter,
the first layer of the selection process, the Industry Standard for selection SAP Human Capital.

Anybody who says they are certified by experience, as I too have been an advocate in the past,
if we're so qualified by experience then in a lot of cases, we are able to go to our local
SAP Education Center and pay to sit only the exams we want to sit and not necessarily follow
the whole curriculum, although following the curriculum would be the most productive path as
it would give all certification candidates the full picture from the official SAP perspective.

As I have previously recommended in other discussions on SCN, SAP themselves need to be leading
or as a minimum pushing this direction, SAP can help this goal be reached in may ways, not
least by using their position to:

. Incentivise Customers to have a certain percentage of their SAP Human Capital
certified, perhaps in return for discounted support, because one would have thought
that if Certification is used as the _first layer_ for filtering candidates then
there will be less support calls to SAP from the Human Capital running the
Customer's SAP systems

. Partners are already incentivised to have a certain percentage of certified
consultants, but Customers are not, and balancing and correcting this will be one of the
steps of the strategy implementation

. Running campaigns to promote certification as the SAP Industry standard for hiring
SAP Human Capital

. Leading Customers to resourcing SAP Human Capital using SAP Certification as the
baseline industry standard, this would mean promoting this strategy to Customer's
HR and IT streams

. Leading by example

Such a strategic change will not be overnight, but will gain momentum and critical mass.

Ultimately everybody will benefit from SAP certification as the tool for the first stage
of the selection process of SAP Human Capital, and in the end there will be no reason not

to be educated and certified by SAP.

The final note being, would you send your child to an uncertified doctor ? In the same respect
why are big corporations allowing uncertified people to run their SAP investments ?

I look forward and welcome all feedback to this discussion, it will be an opportunity to openly convert

the nay sayers :-) Inheriting and extending from Highlander, there can be on one _way_, and

that way is certification and until there is some coherent action taken on this subject, lead by SAP,

the question will pop up, and pop up again and again.

All the best,

Andy.

Performance analysis of customized tcode

Ranjith Jacob — Fri, 05 Apr 2013 09:22:28 GMT

This blog gives a small insight into working on performance related issues. There will be many reasons for performance degradation and once such reason is below.

Users complained that tcode ZSDG_VIA was taking 5 to 6 minutes to process data which normally takes around1 minute. Checked sm66 and found the process is accessing table EDIDC. Updated the statistics for table EDIDC from DB20 but still performance was bad.

DB14 logs below

Below is tcode screen. We select variant in Settings tab below and click data. Then switch to Upload tab and click data. This should fetch the total number of errors data in 1 or 2 minutes.

Setup st12 trace and found below sql statement taking long processing time on table EDIDC

Worked with ABAP team and they changed the select query which is used to get the error IDOCs from EDIDC table. Earlier the program was considering all the error IDOCs but now it is consider only the last one month data in EDIDC table.

SQL query before changes done by ABAP team

SQL query after changes done by ABAP team

For performance tuning of SAP system the following standard tools included in the NetWeaver platform can be used.

1. Workload Monitor (ST03N)
2. Tune Buffers Monitor (ST02)
3. Statistical Records (STAD)
4. SQL Trace Analysis (ST05)
5. Workprocess Overview (SM50)
6. Operating System Monitor (ST06)
7. Table Call Statistics (ST10)
8. Database Activity (ST04)
9. Profile Maintenance (RZ10)
10. CCMS Monitoring (RZ20)

Thought of the day: Plagiarism

Andy Silvey — Thu, 04 Apr 2013 07:52:55 GMT

Thought of the day: Plagiarism

I've always looked at plagiarism as a compliment, that's what people say isn't it.

Plagiarism has been discussed on here a few times, just a couple of years ago
SCN's resident PI guru Michal Krawczyk began putting his name on images in his

blogs, and at the time I commented wondering if that was really necessary.

Michal responded that he had evidence of people copying his blogs and taking

credit as their own work and putting his signature on images would at least mean

he retains some credit for his work, or make it harder for the plagiarists.

There is an interesting blog on the subject here, Anthony Vandewerdt - Plagiarism
and one interesting thought on the subject is that by copying technical material,
if the source gets changed the copy does not and this can then be misleading
for people who follow the copy.

Why to bring this up ?

Finally it has happened to me, I maintain a wiki of my favourite Basis doco, it's
part of my Pay It Forward strategy and on top of this provides me with a personal

cloud storage of my favourite doco in one place and fast to search.

The wiki is here: SAP NetWeaver Basis Administrator's Toolbox...

A friend recently showed me that a copy of the wiki has been spawned, you can find it
if you search on google for:

sapdump basis administrator tools

Ok Michal it's happened to me now and I take it all back :-)

What to think, I still think plagiarism is a compliment, and I am leaning more towards
Anthony's blog, that it's a shame the plagiarist did not link to the source, because
the source is growing on an almost daily basis and the copy is a long time out of date.

On the other hand however, is plagiarism a complement, in the commercial world, there

are patents and copyrights and trademarks to stop the theft and copying of property and

intellectual property.

What to do, I'll contact the plagiarist and ask them to remove the content and replace
it with a link to the source.

What does everybody else think ?

All the best,

Andy.

SAP Inside Track Praha / Prague 2013 - Friday June 7th

Andy Silvey — Wed, 20 Mar 2013 15:53:19 GMT

Introduction

This is the very first grass roots SAP Community event in Czech Republic and with the

goal of bringing SAP professionals primarily from SAP Customers in the Czech Republic

closer together to share information and exchange experiences and ideas in a friendly

informal atmosphere.

The conference language will be (a little) English and (mainly) Czech.

The goal is to make SAP Inside Track Prague a twice yearly event, in summer time and

winter time.

Hopefully this might lead to growth in the SAP Inside Track ‘movement’ in the Czech Republic

and lead to other members of the Czech SAP Community organizing regional Inside Tracks in

other major Czech cities eg, Brno, Ostrava etc.

Date

Friday 7^th June 2013

Registration

Click this link to register: http://meriis.cz/sap-inside-track-prague/

Space is to a certain extent limited so please, add your name to the list early to have the best

chance of a place.

Location

SAP Czech Republic have very kindly agreed to provide conference facilities at their new head

office in:

SAP ČR spol. s.r.o.

BBC BETA,

ulice Vyskočilova 4,

Praha 4.

Agenda

The agenda and focus of the event will be around interesting SAP technologies including not only:

Solution Manager

Hana Cloud Portal

Hana

Mobility

Agenda Overview

Solution Manager Presentation Overview

Prezentuje: Luboš Kalina

Název prezentace: Change management – zkušenosti z praxe, zajímavosti a doporučení

Anotace:

SAP Solution Manager v.7.1 plně vyhovuje náročným požadavkům řízení změn v tak rozsáhlém

prostředí, jakým je ICT Ministerstva vnitra ČR. Implementace a provoz měly a mají své specifické

znaky.

Automatizace rutinních činností nebyla bezbolestná. Nové trendy např. v oblasti mobilních rozhraní

jsou pro nás dalšími výzvami.

Prezentuje: Jiří Zahradníček

Název prezentace: Buďte efektivní při testování v prostředí SAP

Anotace:

Zákazník: „Co budeme testovat?“.
Dodavatel: „Všechno“. Konverzace tohoto typu již není nutná pokud používáte SAP Solution Manager.
Testování „všeho“ vyžaduje enormní úsilí, je finančně náročné a výsledky nejsou adekvátní.
Často stejně není možné otestovat vše. Volba správné strategie a nástroje vyřeší neustálý

nedostatek kapacit pro testování. Důsledné používání SOLMAN šetří peníze při testování.

Prezentuje: Jiří Palát

Název prezentace: Řízení změn v SAP – od plánování po reporting

Anotace:

Provozní změna, malá změna, projekt. Vše s dopadem do prostředí SAP. Jak vývoj nových funkcí,

tak změna konfigurace. Požadavky přicházející z různých stran s různou prioritou s různým dopadem.
A vše je třeba řídit tak, aby nebyla ohrožena dostupnost a odezva produktivních systémů.
Nejlépe pak s vazbou na konkrétní systémy a konkrétní objekty. Teoreticky snadné, v praxi

komplikovanější, ale realizovatelné s podporou SAP Solution Manager.

SAP Hana Cloud Portal Presentation Overview

Presenter SAP Hana Cloud Portal Product Manager, Thomas Hensel

Introduction

SAP HANA Cloud – Overview

SAP HANA Cloud Portal

Overview

Benefits

Scenarios / Use Cases

Demo / Showcases

Key Capabilities

Architecture Overview

Summary / Call for Action

SAP and Mobility Presentation Overview

Části		Obsah
Základní prvky Mobilních řešení SAP		obecný model mobilní architektury
	Mobilní platforma	SUP, Syclo - intro
	Správa zařízení	Afaria - intro
	Mobilní aplikace	intro k hotovým aplikacím
Předdefinované balíčky služeb pro Mobilitu		intro k RDS
	RDS pro Mobilní platformu	hrubý obsah služby = instalace landscape, konektivita na backend, security, vazba na SolMan, konfigurace prostředí - admins, monitoring, development, verifikace
	RDS pro SAP Afaria	hrubý obsah služby …
	RDS pro Mobilní aplikace	hrubý obsah služby …
Aspekty nasazení mobilní architektury		osobní/služební mobil, osobní/firemní data, dostupnost, …
	Specifické vlastnosti mobilních aplikací	široká škála zařízení (velikost, výkon, ...) -> nutnost podpory nebo omezení
	Variabilita řešení s ohledem na stávající landscape	mobilní platforma umožňuje škálování, cloud; je možné realizovat konektivitu na různé systémy, různými kanály, …
	Bezpečnost dat	nutno zajistit - k tomu pomáhá Afaria a existující platforma, která se o některé věci automaticky stará

Cost

Access to the event is free-of-charge because SAP ČR have so kindly agreed to host the event

and provide (light) refreshments [ we'll be paying for our own lunches :-) ] and we are very grateful

to SAP ČR for this cooperation and support.

After the event if enough people are interested the gathering can continue at a local pub at

attendees own cost.

SAP Press

We would like to thank SAP Press for providing books to be raffled and discount codes for

SAP Press websit for attendees.

Contact

If you have any questions you can contact Jiří Zahradníček jiri.zahradnicek@meriis.cz and

Andy Silvey ajsilvey@gmail.com or alternatively leave feedback and questions in the replies to this blog.

Finally, we would like to thank everybody who has blogged with SAP Inside Track How-To guides, those blogs

have been gold for setting this up.

Looking forward to an interesting SAP Inside Track Prague, and on behalf of all of the members of the Team

involved in putting this together and our friends from SAP Czech Republic in Prague, especially,

Mr Daniel Riegel

Mr Jakub Cerny

Ms Lucie Kalinova

all the best, and looking forward to see you on the 7th June,

Team SAP Inside Track Prague.

SAP Software Provisioning Manager : with screenshots

Ishteyaque Ahmad — Wed, 13 Mar 2013 17:59:44 GMT

"Have you heard, now sapinst will not be used. All the installation/system copy/uninstallation will be done through this new "thing" SWPM" -- This is what a friend of mine told me.

We were discussing that the moment we settle down with some tool/version or any module, SAP changes it in such a way that we need to re-learn it all over again, which is certainly not a good feeling!

BUT this is not the case this time... so what is SWPM? it is a Master of Master of Master DVD. You don't have to do anything new, just run the sapinst present in the DVD, and you are going to get these all extra options, no more running around for different DVDs for different versions or modules etc, sometimes SAP does good job too . I have done more than 100 installation+system copy with help of these two DVDs and take my word they are just same good old sapinsts minus some bugs.

For any operating system it has two avatars. One DVD for 7.3 and its EHPs and second DVD for rest of non-7.3s. Lets take a look at the screenshots of these two DVDs so that you can have idea what all is out there.

Note 1806601 - SYB Media list for installations based on NW 7.0 incl. EHPs

Note 1806816 - SYB- Media list for installations based on NW 7.3 incl. EHPs

=====================================================================================================

SAP Software Provisioning Manager (SWPM) for SQL Server from Microsoft

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

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

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

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

OSS1 & RFC connections SAPOSS, SAPNET_RFC, SDCC_OSS

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

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

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

HowTo based on note 903220

Artem Ivashkin — Wed, 13 Mar 2013 14:33:41 GMT

Introduction and warning

Some basis consultants faced with the problem described in note 903220 (Dump CONVT_OVERFLOW), and so did I. Unfortunately, the description of the note is out of date and not applicable for many systems. I have written this post to share my experience that possibly can help you. Bear in mind that this post does not substitute the note and it can be used as a clue to the note. I performed actions mentioned further on Solaris SPARC platform and SAP Solution Manager 7.01 SPS30 (Kernel 7.21) and SAP Host Agent v720.3.81, be careful of using this post for another platform, especially for IBM!

Problem description

Job SAP_COLLECTOR_FOR_PERFMONITOR falls with the status “Canceled”. You see many dumps in ST22 with the following text:

Overflow when converting from "-74188727"

The program "RSHOST2M" was started as a background job.

Job Name....... "SAP_COLLECTOR_FOR_PERFMONITOR"

Job Initiator.. "DDIC"

Job Number..... 10001500

The termination is caused because exception "CX_SY_CONVERSION_OVERFLOW" occurred in procedure "LOG_ON_OSMON" "(FORM)", but it was neither handled locally nor declared in the RAISING clause of its signature.

Using key words from the dump, you have found note 903220, but it is too old for you system and some paths cannot be found.

Let’s get down to business

Logon onto server with user root and change directory to /usr/sap/hostctrl/exe/ , give the command “saposcol -kc” as described in the note.

Download the latest SAP archive with Host Agent for your platform and unpack it.

Remove coll.put file in accordance with the second step of the note.

rm /usr/sap/tmp/coll.put

Then update your Host Agent (Note 1031096) that includes saposcol.

saphostexec -install

Giving the command saposcol –l (step 3 of the note) is unnecessary because it will be started right after Host Agent installation. Check that saposcol is running (ps –ef |grep saposcol)

Go to ABAP-part

Start ST03 tcode. Here you can see that the path from the note is different to the path of your system, i.e. in the note the following path is given:

Goto -> Performance database -> Contents of Database

In fact, the same Content can be found here:

Double-click on the marked point.

Click on the button “Delete RELID” and type “OS”

Confirm deletion

Refresh the list

Set a filter on ID field

The list with the filter must is empty.

Restart SAP_COLLECTOR_FOR_PERFMONITOR job or wait until the scheduled time.

Summary

This post described main procedure based on Note 903220 and many obvious for basis consultant things were ommited (such as “making a backup”, “granding permissions” and so on). If you are not sure about eliminating the dump in your system, post a question on the forum or create an OSS-message.

Deploy .sda Files without JSPM

Simone Pantaleoni — Mon, 11 Mar 2013 08:41:03 GMT

Hi All,

Sometimes happend that you're going to patch the system, or deploying an upgrade... and something critical goes wrong.

You would like to re-deploy the package again, but the system cannot be started again, and neither the JSPM works... so...

This is an alternative way to deploy packages on a SAP system, rather using the JSPM tool:

Loging in to Telnet Administrator from your SAP system on OS level (with your <sidadm> user)
1. Command: telnet localhost 5<SystNumber>08
2. Login with your <j2ee_admin> user

Create a file "deploylist.txt" on your file system and on separate lines enter the full path anf file name of the package which you wish to deploy: SERVERCORE, ENGINEAPI, BASETABLES, J2EEAPPS, J2EEFRMW, etc...
1. Example: /usr/sap/trans/EPS/in/com.sap.aii.af.axisproviderlib.sda
Run Command:deploy list=\<path>\deploylist.txt version_rule=all
System should start the deployment (Java Stack will be rebooted)

SAP Printing made easy with SAPSprint

Jacob P George — Thu, 07 Mar 2013 12:29:36 GMT

I have been never amused before when I configured a Windows Based Generic Printer to an SAP Web Application Server based on NW 7.0 Kernel 720.

The requirement came in from a customer to print to a text file approximately around 50,000 pages where printing was important and not the the style.

Please forgive me with boring introduction I am a naïve writer , Allow me to take you to procedures.

The SAP Notes referred here are

Note 161516 - Printing into a file or anywhere else in NT
Note 894444 - Tool for server-based printing on Windows (SAPSprint)

Step1:

Add a windows printer in the application server (my case I defined the same in the application server host)print to a text file. The screen shot bellow will help

Select a Generic Text Printer with Generic/Text Only option.

In the Printer name please make sure to use a name without spaces , for example "test".

Specify the share option with appropriate location specified. Once finished please configure the port .

Choose the Printer->right Click-> Properties

Click on Port

Add a new Port

Local Port

a new dialogue box will open

create a new text file in your convenient location please and specify the path to text file in the dialogue box.

Click on Close .

Step2:

Install SAPSprint service on the SAP WAS host as per the note 894444

I have followed the Installation section in the note and I have to tell you , the explanations are perfect and it worked like SAP CHARM

The note also gives you complete location of the packages and how to Install.

Once the Installation is complete we can check the new services in Services.msc in the WAS host in running mode.

Step3:

Please log in to your SAP GUI.

Transaction SPAD

Enter a new Printer Test

Device Type as : SAPWIN

Device Class :Standard Printer

Access Methods Print Using SAP Protocol

Host Printer: test(which we have defined in Step 2)

Click on Save and Activate . SAP Printer is ready

This operation would hardly take 15 minute including the SAPSPrint install and download. A Very Happy Experience.

We can perform a validation using the Test printer in SPAD and the output can be verified in the text file.

Hope the procedure was useful and it is really helpful during a new implementation to do a test with Spool Serve/ services to perform a test before

handing it over to end users.

Cheers!

Jacob