Sapdatabase for all sap modules

sapdatabase provides you all sap modules information,latest updates

Sapdatabase for sap education

sapdatabase provides you all sap modules material,interview needs

Sapdatabase for all sap information

Sapdatabase makes you as a sap professional

Sapdatabase for outsourcing and online training

Sapdatabase provides you online training,outsource services for all sap modules in econamic fee

Sapdatabase for sap jobs

Sapdatabase makes job searching for you

Monday, February 27, 2012

difference between jspm & sdm in sap

Differences between jspm & sdm

SDM                                                                                              JSPM
We can deploy or install  patches                                         We can install  patches
We can also uninstall patches                                               we cannot un deploy the patches
It cannot check patch dependency & database consistency  it will check the patch dependency & db                                                  
SDM does not depend on JSPM                                          JSPM backend connect with SDM,with out
                                                                                              sdm we cannot connect jspm
patches can be deployed in any location                              patches can be deployed in trans directory 

what is the use of Visual admin or using visualadmin what tasks you performed

Visual admin:
It is a Dynamic tool 
using visual admin we can install license 
We can start & stop services 
we can stop & start applications ( Not application servers)
we can access visual admin remotely
We can create the users 
We can monitor logon user sessions
We can connect jco connections 
we can export & import the certificates (EX : sso certificates )   
we can deploy services like ear,.rar files 
We can alsp access the offline config-tool editor 
we need to user name & pwd required to logon to visual admin 
P4 port is used to login to visual admin 

Path: usr/sap/sid/DVEBMGS<SNO>/J2ee /admin/go.bat

Oracle errors during sap connections ORA-01017,ORA-01031,0RA,012541,ORA1631,1634,1653,1654,255,2772,12541

0RA-01017: When brarchive/ br backup runs (OSS notes 400241-361641)
Check the following
init ora should have os_authent_prefix ops$,remote _os_authent TRUE
Check if OPS$SIDADM exist & it owns SAPUSER table and it has  SAPCHMAOWNER   and password entered in the table

select* from "OPS$ADM" .SAPUSER;
if there are no entries set the password of SAPCHMAOWNER
brconnect -u system / -f chpass - -o -p
make sure the resource and connect is assigned to OPS$ users. to be able to process brbackup make sure sapdba is assigned as well.

How to assign sapdb & sapoper to system;
Connect as a sys grant sysdba to system;grant sysoper to system
if you cannot login login as sys change the password and re login using orasid ,orapws file =PWDSID.ora password =XXXX entries =100

ORA-01031:insufficient privileges 
during brbackup run.Make sure orasid belongs to dba & oper,sidadm belongs to sapsys,dba & oper as the os level  (oss note 134592) run sapdba_role.sql /as orasid:sqlplus /nolog @sapdba_role.sql SID

ORA-012541 Transnames.ora error 
Check db_domain in init.ora if there is domain defind make sure tnsnames.ora has domains
tnsping sid
R3trans -d

ORA1631/1632 Max Extents reached 
increase extents in SE!4

ORA-1653/1654 Table space over flow 
Using Brtools add data file or resize data file

ORA-255/272 Oraarch full 
Move the file to some other place  or delete old archive files

ORA-12541 listener not start 
 Start Listener manually  

Work process die soon after they start in sap system

Symptoms :
All the work process die right after the instance is started
The sap mmc shows work process with status "ended"
Only one work process shows "Wait".
An ABAP dump saying PXA_NO_MEMORY is generated as soon as a user login.The SAPMMC syslog shows the errors "sap-Basis system;Shared memory for PXA buffer now available"

Cause of errors 
The instance profile contains Misconfigured memory related parameters.Most likely the "abap/buffer size"  instance profile parameter set to high.

How to resolve
Edit the instance system profile at the OS level under usr/sap/<SID>/sys/profile and lower the value assigned to "abap/buffersize" then restart instance.Also important to find out if any other parameters ware changed.If not,The system should start once the adequate memory allocation has been set to the "abap/buffersize"parameter.   

The massage server starts but the dispatcher doesn't start in sap

Symptoms :
The dispatcher shows status "Stopped" in sap mmc
The dev_disp file shows errors
***LOG QOA =>nisertono,service_unknown(sapdp00)(nixxi.c2580)
***ERROR =>DpCommInit :Dpxxdisp.c 7326)

Cause of problem :
The Keyword in the massages above is servicce_unknown followed by the entry name"sapdp00"The dispatcher entry "sapdp00"is missing in the services file ex sapdp00 3200/tcp

How to resolve:
Add the necessary entry in the services file  EX: sapdp00 3200/TCP then Re-start the instance 

users get no logon possible massages in sap

Work processes start but no logins are possible
users get the login screen but user does not log them in instead they they get massage no logon  possible
In The sap mmc the massage server show status stopped.
The Dev_ms  files reports the errors
(Thr 2548) **** error =>Mscommlnit: Ni Buflisten( sapnsTST)
(rc =NIESERV_UNKNOWN) (msxxserv.c 8163)
Thr 2548***ERROR =>Msscomminit(msxxserv.c 1561)
Thr 2548***ERROR =>main:mssint (msxxserv.c 5023)
Thr 2548***ERROR=>logq02 =>msshalt, msstop,(msg server 2900) msxxser.c 5078)

Cause of error:
Work process ware able to start the massage server was not.The reasion is because the "services"file is missing the sap massage port entry. Ex sapmsTST 3600/TCP.

how to resolve 
Edit the services file and add the entry.Then  restart the instance.make sure you specify the appropriate tcp port.ex 3600 for massage server 

Sap does not start at all with no massage server & no dispatcher

The massage server & The dispatcher do not start at all in the SAP MMC
When trying to view the developer traces with in the SAP MMC.The network path not found.
No new developer traces written to disk  in work directory

Cause of problem :
The network Share folders sapmnt & saploc do not exit.That explains the network path not found.massage when attempting to view the developer traces within the sap MMC.

How to resolve problem:
Re create the saploc & sapmnt network folders.Both are created on usr/sap/directory . 

Sunday, February 26, 2012

Create folder permissions and add a permission owner in sap ep portal

1. As EP300.C-## use the Admin Explorer iView under Content Administration
KM Content to navigate to the folder /documents/Public Documents. Create a new folder structure with a main folder called Company and within this a subfolder called Sales Dept. The members of the sales department are allowed to create content in their folder, but not in the Company folder.
2. In the Company folder, assign read permission to the user EP300.E-## and
the group Everyone. When you save the permissions, you will automatically
be assigned the Full Control permission.
3. Navigate to the folder /documents/Public
Documents/Company/Sales Dept. Make the user EP300.E-## a permission owner of the Sales Dept folder. The user EP300.E-## will automatically receive Full Control for this folder.
4. Log in as EP300.E-##. Navigate to the folder /documents/Public Documents/Company. Verify that you cannot create documents in the folder. Then go into the Sales Dept folder and verify that you can create documents in this folder.

Creating and Editing a Text Document in sap enterprises portal

Create a new folder called Content Management Functions. Create a new text
document within this folder. Display the document. Edit the document online.
1. Log onto the portal as EP300.C-## and create a new folder called Content
Management Functions in /documents.
2. Open the folder and create a new text file with some sample text and a
3. Open the text file to display the content.
4. Edit this text file online to add some additional text and verify that the
changes have been made.

How to Creating a Subscription for a Folder in EP portal

Subscribing to a folder you have created yourself.
1. Create a subscription to your folder SAPEP-## so that you will be notified
of any changes and on any events.
2. Change the document you created Test.txt in the SAPEP-## folder.
3. In the UWL you can check to see if you have been notified of the changes
in the document.

Assigning a Role to a User in sap enterprises portal

Assign a role to a portal user and test the navigation and content provided by
that role.
1. Assign the role you just created to your portal end user, SAPEP.E-##.
Note: In productive portal systems, portal roles are typically
assigned user groups. As an exception, in this course, we will assign
a role to an individual portal user.
2. As portal end user SAPEP.E-##, test the new content.

How to Creating Folders in the Portal Catalog in sap enterprise portel

Create a new folder in the Portal Catalog, which will become the base folder
for all content objects created by you.
1. In the Portal Content Studio, navigate to the folder SAPEP, which was
created by your instructor.
2. Create a new folder below the SAPEP folder using the following settings:
Folder Name Group ##
Folder ID group##
Folder ID Prefix
Note: The ID of each portal object must be unique. Since these
folders are created below the same PCD folder, it is important that
you follow the given naming convention (where ## is to be replaced
by your group number).

How to Logging on to the SAP Enterprise Portal

 Log on to the SAP Enterprise Portal.
1. Start up the Web Browser (here the Microsoft Internet Explorer)
2. Enter the URL for the logon page of your SAP Enterprise Portal. The information necessary to do this is provided by your instructor. The URL is comprised in the following way: http(s)://<host name
of portal server>.<domain>:<port>/irj For example this could be
If possible, save this URL as an Internet Explorer favorite.
3. Log on to the SAP Enterprise Portal with the user SAPEP.E-## (## refers
to your group number) and the password welcome.

Saturday, February 25, 2012

SAP Router Configuration step by step interview patron

Before going for Router installation check that for your public IP is open to sap or not.
Check for all the necessary ports. 
3299 is open to Router on SAP SIDE:
If it’s new server provide details to SAP with your <Distingushed Name>" and hostname to SAP for Certificate generation. 

Follow Below steps

1. Create a Userid like ‘ sncadm’
2. Login to the SAP Service Marketplace with the Service Marketplace USERID which is assigned to your installation.
3. Use the latest SAProuter version, which can be downloaded from SAP Service Marketplace (alias /SWDC).
4. Change to the alias /SAPROUTER-SNCADD.
5. Click on “Download Area” > “SAP Cryptographic Software” and select the correct sapcrypto library for your SAProuter "<op-sys>". Save the file to the directory where the SAProuter executable is located.
6. You can get the file car.exe/sapcar.exe, which is necessary to unpack the archive from any Installation Kernel CD. Executing the command SAPCAR -xvf SAPCRYPTO.CAR will unpack the following files: [lib]sapcrypto.[dll|so|sl] sapgenpse[.exe] , ticket
7. Edited the string in the registry under
MyComputer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ saprouter and changed to “under ImagePath.

8. Information as of POINT 6:: Unpacking of SAPCRYPTO archive
c:\usr\sap\saprouter>sapcar -xvf sapcrypto.CAR
Processing archive sapcrypto.CAR...
x Changelog.txt
x Ver555.pl17
x ntintel
x ntintel/sapcrypto.dll
x ntintel/sapgenpse.exe
x ticket

9. Set your environment variable for user (sncadm) SNC_LIB and SECUDIR:

Screenshot provided below.

10. Make an entry on your service file if windows then in etc/hosts/services
If Unix then etc/hosts

Make the same entry in Router and your entire server. ( DEV, QAS, PRD) 

Screenshot provided for reference. 

11. Generate the certificate Request with the command:
sapgenpse get_pse -v -r certreq -p local.pse “<Distinguished Name>”
sapgenpse get_pse -v -r certreq -p local.pse “CN=example, OU=0000123456,
OU=SAProuter, O=SAP, C=DE”
Alternatively use the two commands:
sapgenpse get_pse -v -noreq -p local.pse “<Distinguished Name>”
sapgenpse get_pse -v -onlyreq -r certreq -p local.pse
You will be asked twice for a PIN here. Please choose a PIN and document it, you have to enter it identically both times. Then you will have to enter the same PIN every time you want to use
this PSE.

12. Display the output file "certreq" and with copy&paste (including the BEGIN and END statement) insert the certificate request into the text area of the same form on the SAP Service Marketplace from which you copied the Distinguished Name.

13. In response you will receive the certificate signed by the CA in the Service Marketplace. Copy&paste the text to a new local file named "srcert", which must be created in the same directory as the sapgenpse executable.

14. With this in turn you can install the certificate in your saprouter by calling:
sapgenpse import_own_cert -c srcert -p local.pse

15. Now you will have to create the credentials for the SAProuter with the same program (if you omit -O <user_for_saprouter>, the credentials are created for the logged in user account).
sapgenpse seclogin -p local.pse -O <user_for _saprouter>
Note: The account of the service user should always be entered in full

16. This will create a file called "cred_v2" in the same directory as "local.pse"

17. Check if the certificate has been imported successfully with the following command:
sapgenpse get_my_name -v -n Issuer
The name of the Issuer should be:
CN=SAProuter CA, OU=SAProuter, O=SAP, C=DE

18. If this is not the case, delete the files "cred_v2"and "local.pse" and start over

19. Once done please make confirm from SAP.
20. Also make sure connection saposs in sm59 working fine

Using stopsap.exe to Stop TREX on windows

       1.      Log on with the user <sapsid>adm.
       2.      Open a command prompt by choosing Start  → Programs  → Instance_number  → Tools  → TREX_<instance_number> so that the environment variables are set correctly.
       3.      Switch to the  <TREX_DIR>/exe directory and enter the following:
stopsap.exe name=<SAPSID> nr=TRX<instance_number> SAPDIAHOST =<host>
In the SAPDIAHOST parameter, you specify the host name on which the TREX instance should be stopped.
   stopsap.exe name=ABC nr=TRX77 SAPDIAHOST =p123456

Note(s):  Do not use the Task Manager to stop the SAP service or the individual TREX servers. Otherwise, data can be lost. Affected indexes can be irreparably damaged.
 Certain processing steps, for example, writing an index, cannot be interrupted. Such steps are completed before TREX is stopped. This process can take a while to complete. With large indexes, it can take up to a few hours to stop the TREX servers if lots of documents are currently being indexed.

Adding Authorization Objects and Authorizations to a Role

1. Log on to client 100 in the DEV SAP system.
2. Go to transaction PFCG.
3. On the Role Maintenance screen, enter the Role you want to change. Click theChange button.
4. On the Change Role screen, click the Authorizations tab and then click the pencil picture-icon.
5. If you are only adding a start up transaction to the role, skip to step 10. Otherwise, the assumption is that a new authorization object is to be added. On the Change role: Authorizations screen, click the +Manually button.
6. On the Manual selection of authorizations popup, enter the authorizations objects that need to be added (ie S_DEVELOP, S_PROGRAM, etc.) Click the green √ when you are finished.
7. Back on the Change role: Authorizations screen, if all the displayed signal lights are green, skip to step 8. Otherwise, fully expand the lines that are yellow and/or red and supply the necessary information. All signal lights should be green before moving to the next step.
8. On the Change role: Authorizations screen, click the Save picture-icon. You will receive a Data saved confirmation message in the status bar at the bottom of the screen.
9. On the Change role: Authorizations screen, click the red-and-white beach ball picture-icon to generate a profile from the saved role. Reply affirmatively if any confirmation popups. You will receive a Profile(s) created message in the status bar at the bottom of the screen. If you do not need to add any start up transactions to the profile, you may now leave the PFCG transaction.
10. On the Change Role: Authorizations screen, expand the Cross-application Authorization Objects  Authorization Check for Transaction Start  Authorization Check for Transaction Start until you see the Transaction code entry line. Double-click on the entry portion of the Transaction code line.
11. In the Maintain Field Values popup, scroll down the list until you find a blank Fromand To line. Enter the transaction(s) to be added, and click the Save picture-icon when you have finished.
12. On the Change role: Authorizations screen, click the Save picture-icon. You will receive a Data saved confirmation message in the status bar at the bottom of the screen.
13. On the Change role: Authorizations screen, click the red-and-white beach ball picture-icon to generate a profile from the saved role. Reply affirmatively if any confirmation popups. You will receive a Profile(s) created message in the status bar at the bottom of the screen.
14. You may now leave the PFCG transaction.

How to Adding Authorization Objects and or Authorizations to a Profile in sap

1. Log on to the appropriate client in the appropriate SAP system.
2. Go to transaction SU02.
3. In the Manually edit authorization profiles section of the Profile: Initial Screen screen, enter the Profile you want to change. Make sure the Active only □ is checked. Click theCreate work area for profiles button.
4. On the Profile List screen, double-click the profile to be changed.
5. A profile can contain authorization objects only (single profile) or one or more other profiles (collective profile). If the next screen is titled Maintain Profile, this is a single profile, and you should proceed to the next step. If the next screen is titled Collect Profiles, this is a collective profile and you should skip to step 13.
6. On the Maintain Profile screen, you must decide if you need to add a new authorization object and one or more of its authorizations, or add a new authorization to an authorization object already in the profile. If you need to add a new authorization to an authorization object already in the profile, skip to step 7. Otherwise, scroll down the Consisting of authorizations list until you find a blank line. Type the authorization object you need to add and press Enter. You will need to scroll through the list again until you find the authorization object you just added (it is was to find since the Authorization column should still be blank). Once you find the new entry line, use the drop down to fill in the Authorization column. Click on the Save picture-icon.
7. If you need to add another authorization to an authorization object already in the profile list, click on the +Add authorization button.
8. From the Maintain Profiles: Object Classes screen, double-click the Object class of the authorization you are adding.
9. On the Maintain Profiles: List of Authorizations screen, select the authorization you need to add by double-clicking the appropriate line. This will return you to the Maintain Profile screen where you can see that your authorization has been added.
10. On the Maintain Profile screen, click the Save picture-icon. Then click the lit match picture-icon to activate the new profile changes.
11. On the Activate Profile: Execution Screen screen, click on the lit match picture-icon to complete the profile activation process.
12. You may now leave the SU02 transaction.
13. In order the change a profile collection, you must make the changes in one or more of the dependent profiles, save the changes in the dependent profile(s), activate the dependent profile(s), save the collection owner profile, and activate the collection owner profile. On the Collect Profiles screen, double-click on the profile you want to change.
14. You will be taken to the Maintain Profile screen. Perform steps 6 to 11. Then use the white arrow on green picture-icon to go back.
15. On the Collect Profiles screen, click the Save picture-icon. Then click the lit match picture-icon to activate the new profile changes.
16. On the Activate Profile: Execution Screen screen, click on the lit match picture-icon to complete the profile activation process.
17. You may now leave the SU02 transaction.