Posts

Showing posts from 2011

HOW TO SAP - Check IGS services in portal

Image
Open this link http://server:40XX80/Where XX is the instance numberYou will see this result:

SAP HOW TO GRC Add CUA SYSTEM

Image
CUA system must also be maintain in front end GRC - not just back end  ABAP CUA system.





Login to GRC systemGo Configuration > CUA System
Create (system is your child while CUA system is the parent)


Save


HOW TO SAP - GRC creating connectors

Image
Connector in GRC like ABAP RFC. Connector is used to connect front end GRC to the backend ABAP system.




Open GRC CUP > Configuration > Connectors > Create Connectors
Fill in the details
Now you may test the connection
If successful, you will see below

HOW TO SAP - PFCG TRANSPORT BUTTON DISABLE

Image
PFCG transport button has been greyed out or disable

Tcode SHD0Enter the follow
Button is invisible due to this variant. Deactived this variant and transport button is now visible again

How to SAP - SNC settings on Front End

Image
SAP Logon > Right Click any entries > PropertiesNetwork Tab > Check Activate Secure Network CommunicationSNC Name > p:SAPServiceSID@domain.comOK


HOW TO SAP - ACTIVITY MONITOR FOR MS SQL 2008 R2

Image
Right click on root node > Activity Monitor
It will take sometime to load on slower system

HOW TO SAP - Schedule liveCache Log backup every 720 minutes

Image
OS level > Run MaxDB

Connect to your database
Instance > Backup > Backup Wizard

Active/Deactive Automatic Log Backup > Next

Create a log backup every 720mins. You may create a new device/file if needed. Click Next when complete

Click On

Activated


How to SAP - liveCache log full

Image
Livecache is not responding due to log full. Tcode LCA03 and other liveCache could not be executed.



Tcode LC10 > You notice error was Log Full

Login to OS Level
Open MaxDB

Connect your database

Perform log backup > Instance > Backup > Backup Wizard

Next

Select Log Backup > Next

Enter name for the backup.
Type in the folder which you want to save the  log file.
LCQ_LOG is the backup file name.

Click Start and wait. It will auto shrink the log file once backup completed.

HOW TO SAP - Change "Upload Enabled" parameter from the PutServlet to false.

Image
Visual AdminServices > configuration adapter > configurations > cluster_data > server > presistent > servlet_jsp
Edit global-web.xmlDownload it to you local machineEdit the xml file and locate "upload enable" and change parameter from true to false
Save the xml file and upload backRestart SAP

HOW TO SAP - Upload Protected Area requires a username and password

Image
You get below error message when login to portal even though SSO has been configured
Visual Admin > Services > Configuration Adapter > cluster_data > server > cfg > services > Click Edit

Select PropertySheet com.sap.security.core.ume.service
Edit ume.logon.security.relax_domain.level. Change value from 1 to 2

Restart SAP

ST01 return codes

ST01 return codes



0 Auth check passed
1 No auth
2 Too many parameters for auth check
3 Object not contained in user buffer
4 No profile contained in user buffer
6 Authorization check incorrect
7,8,9 Invalid user buffer

HOW TO SAP - MASS UNLOCK USER WITH SQL COMMAND

Unlock support team :     
update sid.USR02 set UFLAG=0 where MANDT='110' and BNAME in
('DDIC',
 'SAP*',
 'ALEREMOTE',
 'WF-BATCH',
 'TMSADM',
 'ITOUSER',
 'SAPCPIC',
 'SAPJSF',
 'J2EE_ADMIN',
 'J2EE_GUEST',
 'SAP ADMIN'
)         



OR you may unlock all user with
Unlock user :     
update sid.USR02 set UFLAG=0 where MANDT='110'

HOW TO MASS LOCK USER with SQL COMMAND

Execute this SQL command update SID.USR02 set UFLAG=64 where MANDT='110' and BNAME != 'SAP*';    Explain : UFLAG=64 means lockBNAME !='SAP*' means lock everyone except SAP*
Alternately, try the below SQL command:
use HRS UPDATE [hrs].[USR02] SET UFLAG = '64' WHERE (UFLAG = '0')  AND NOT (BNAME like 'SAP%' OR BNAME = 'DDIC' OR BNAME = 'TMSADM'           OR BNAME like 'J2EE%' OR BNAME like 'SLD%' OR BNAME = 'JCO_DATA'          OR BNAME = 'BASIS_ADMIN')

HOW TO SAP - SAPCAR all *.car files

First search for sapcar.exe. Its usually located at \usr\sap\sid\dvebmgs00\exeCopy the sapcar.exe to the folder where you saved all the *.sar files.Start > Run > cmd > browser to the folder with *.sar filesExecute SAPPCAR -xvf  ".sar"Without " " it will not work.

HOW TO SAP - command to login to sap system

Start > Runsapgui <server> <instance>Example : sapgui r3dev 00

HOW TO SAP - RUN BDLSS (new)

Image
After client copy, you have to perform BDLSS

http://help.sap.com/saphelp_nw04/helpdata/EN/33/c823dbaea911d6b29500508b6b8a93/content.htm





Tcode BDLSS > Start

Enter the Source client and target client (newly created client)

Execute

HOW TO SAP - Change text on main SAPGui logon screen

Image
Note 205487 - Own text on SAPGui logon




Tcode SE61Document Class > General TextCreateNow enter test and save document as "ZLOGIN_SCREEN_INFO"

HOW TO SAP - Tables to find Tcode and Programs

To find tcode, use table TSTCTo find program, user table TRDIR or TRDIRT

Selamat Berpuasa to all Muslim friends!

HOW TO SAP - Register Access KEY for Object Activation.

Image
Access Key to modify Enhancement Point in Include Object-LMR1MF0L


If ABAP did not provide more information, then follow step 3.
SE38 > LMR1MF0L > Copy program > Display source code.Save Now

Once display, press edit.
You will see your needed details on screen.
Now go service market place > Key and Request > SSCR Keys > Register object
Enter the details from the above screen:

Basis release *    
PgmID *    
Object name * 


HOW TO UPGRADE GRC 5.3 JAVA AND ABAP SUPPORT PACK

Image
For GRC 5.3 SP 15 upgrade, below is the list you have to follow

Java SP15Java SP16
3/15/20116/16/20114.6cVIRSANHSP16SP17VIRSAHRSP14SP15620VIRSANHSP16SP17VIRSAHRSP14SP15640VIRSANHSP16SP17VIRSAHRSP14SP15700VIRSANHSP16SP17VIRSAHRSP14SP15710VIRSANHSP10SP11VIRSAHRN/AN/A
HOW TO STEPS:
First download the JAVA SAP from:

SAP Solutions for Governance, Risk, and Compliance > SAP GRC Access Control > SAP GRC ACCESS CONTROL (again) > SAP GRC ACCESS CONTROL 5.3 > Entry by Component > JAVA-Components

Download ABAP SP from :

SAP Solutions for Governance, Risk, and Compliance > SAP GRC Access Control > SAP GRC ACCESS CONTROL (again) > SAP GRC ACCESS CONTROL 5.3 > Entry by Component > RTA on SAP BASIS 7.00 System

Now upgrade Java Support Pack first.

Saved all the JAVA SP files in trans\eps\in

Login with sidadm and execute JSPM




Click Business Packages




Next



Start

HOW TO SAP - STMS TRANSPORT NOT RUNNING

After server migration, new QA servers cannot perform transport even after
Scheduling new RDDIMPDP

SM50 shows all BTC job is waiting.

SDN search and found this issue http://forums.sdn.sap.com/thread.jspa?threadID=331960
Execute SM61 > Click Job-Servergruppen > Assignment of new server. 

SM37 job RDDIMPDP completed.

HOW TO SAP - CHECK ACTIVE MS SQL TRANSACTION

Image
Log files grow and unable to shrink even after backup.





Launch MS SQL Server Mananagement Studio
Execute SQL command > DBCC OPENTRAN
You will get below result. You notice the SPID is 76


Go > Management > Activity Monitor

Now you find your SPID running

Just right click and kill the SPID. It might take more then 1 hour before the process is killed/rollback

HOW TO CHECK LIST OF USER FROM TABLE USB02

In MS SQL Server Management studioExecute SELECT BNAME FROM hrs.USR02 WHERE MANDT='310';

HOW TO CHECK SIZE OF A CLIENT Note 118823 - CC-ADMIN: Size of a client

SAP NOTE 118823 - CC-ADMIN: Size of a clientSymptom
To be able to schedule client copies and also for system planning, the size of clients or tables in a client is required.

Reason and Prerequisites
In productive environments some tables can become very large. This is important both for performance planning and for system planning.
Solution
For local client copies or remote copies you can carry out a tablespace analysis in the log after a test run. This analysis estimates the memory space required. For the latest information refer to Note 35415.

Depending on the release, typical Customizing clients have the following sizes:
           3.0: approx. 150 - 200 MB
3.1: approx. 200 - 250 MB
4.0: approx. 350 - 400 MB
4.5: approx. 450 - 500 MB
4.6: approx. 150 - 1500 MB *
     * depending on the components of mySAP.com applied
Production clients with application data can of course be considerably larger.

The following reports shall help you to estimate the memory requirements of a client. Howe…

HOW TO SAP - STMS Extra Other request add is disable (greyed out)

Image
There is a request in the queue for which "Target Client" is not specified. Delete that request of specify the target client which "clt" is empty or in red. Now try again.