Reset J2EE_Admin or Administrator Password

If the user ID Administrator or J2EE_ADMIN is locked or the password is forgotten the system can be accessed using the following method:


STEP 1: Enable user "SAP*"

1. Start the Config Tool C:\usr\sap\<SID>\<engine-instance>\j2ee\configtool\configtool.bat
2. Goto cluster-data -> Global server configuration -> services -> com.sap.security.core.ume.service
3. Double-click on the property "ume.superadmin.activated"
4. Set the value to "TRUE"
5. Double-click on the property "ume.superadmin.password"
6. Set the value to the required password
7. Click Save
8. Restart the J2EE engine

STEP 2: Login to NetWeaver as user "SAP*"

1. http://<host>:<port>/useradmin/index.jsp
2. Click User Admin
3. Enter userid SAP* with the password that was set above
4. Search for user to unlock or change the password  (i.e. "Administrator" or "J2EE_Admin")
5. Unlock and/or change password for the required admin user 

STEP 3: Disable "SAP*"

1. Start the Config Tool C:\usr\sap\<SID>\<engine-instance;&gt\j2ee\configtool\configtool.bat
2. Goto cluster-data -> Global server configuration -> services -> com.sap.security.core.ume.service
3. Double-click on the property "ume.superadmin.activated"
4. Set the value to "FALSE"
5. Click Save
6. Restart the J2EE engine

STEP 4: Login as "Administrator" or "J2EE_Admin"

1. Go to http://<host>:<Port>/useradmin/index.jsp
2. Enter appropriate user ID and password
3. When prompted change the password 

BI/BW transactions and information

The following transactions are useful for configuring BW/BI connections

RSMO - Monitor InfoPackages

RSADMIN - Set various parameters in BW, including the user ID responsible for running the jobs

RSA1 - Configure source systems etc in BW/BI system
RSA7 - View delta queue in source system

WE05 - View IDOCs
WE20 - Partner profiles
WE21 - Ports in IDOC processing

The user ID in the source and/or BW system needs the following profiles:
SAP_ALL
SAP_NEW
S_BI-WHM_RFC
S_BI-WX_RFC
S_RS_ALL
(SAP_ALL and SAP_NEW alone are not enough).

Error message:
"No IDocs could be sent to BW using RFC."

Check partner profiles (WE20)  in the source system (message type RSINFO and RSSEND) 

See SAP note 1964223 - No Idocs Arrived from the Source System 

Automate the running of process chains with variants by scheduling the program RSPROCESS appropriately

SAP notes:
150315 - BW-Authorizations for Remote-User in BW and OLTP
1964223 - No Idocs Arrived from the Source System

List local wireless networks

1. Open command prompt
2. Enter following command: netsh wlan show networks bssid

Change TMSADM Password

To change the TMSADM password used in STMS (or Charm):

1. Log on to the transport domain controller in client 000
2. Run SE38
3. Enter program name TMS_UPDATE_PWD_OF_TMSADM
4. Enter a new password
5. Click Execute

You will be required to log into client 000 of all the connected systems

More details:
http://help.sap.com/saphelp_nw73/helpdata/en/e7/c5066e05034f4a9cbcf9c84b513b7b/frameset.htm

Find Table Entry Changes in SAP

Transaction SE16
Table: CDHDR
Search for the user and/or date the change was made
Copy the contents of the 'Object value' field

Transaction SE16
Table: CDPOS
Search for the object value found above

TP Notes

Manually Add Transport To a SAP Import Queue

tp addtobuffer <Transport> <SID> client=<Client no.> pf=<Path to transport profile file .PFL>

Manually Import Transport

tp import <Transport> <SID> client=<Client no.> U<Mode> pf=<Path to transport profile file .PFL>

TP Command Options (Mode)

0 - Overtaker: - Import from the buffer without deleting and set unconditional mode 1 in the buffer to trigger another import.
1 - During export: - Ignore the incorrect status of the command file.
1 - During import: - Ignore the fact that the change request was already imported.
2 - During export: - Do not expand the selection with TADIR brackets.
2 - During import: - Overwrite original objects.
3 - During import: - Overwrite system-dependent objects.
4 - During import: - Ignore invalid component version.
6 - During import: - Overwrite objects in unconfirmed repairs.
8 - During import: - Ignore restrictions based on table classification.
9 - During import: - Ignore the fact that the system is locked for this type of transport.

Unlock SAP User Account / Delete SAP* user in DB2

At command line:

• db2
• connect
• update sapsr3.usr02 set uflag=0 where mandt='<client>' and bname='<username>'
• delete from sapsr3.usr02 where mandt='<client>' and bname='SAP*'

Response should be:
DB20000I  The SQL command completed successfully.

Effect is immediate. No 'commit' required.

(* Assumes the schema is sapsr3)

DB2 Manual Failover

As db2<sid>:
Got to dir /db2/db2<sid>/sqllib
Modify db2nodes.cfg file to show:
0 <servername> 0

As root:
cd /db2/db2_software/adm
./db2set -g DB2SYSTEM=<server name>

As db2<sid>:
db2gcf -u -t 60 -p 0 -i db2<sid>

AIX

Find machine serial number of frame which hosts an LPAR:

Log into the LPAR
prtconf | more

Find SAP System Installation Date

Run SE16
Enter table name TPFHT
Press F8 or click Execute

The generation date should indicate when the profiles were initially created.

AIX C++ Library Version

This is how to find the version of the C++ library files on AIX:

 lslpp -L | grep xlC

Content Server Notes

Check Database Connection

Run transaction DB59
Execute connection tests from all servers

Retrieve Document

Run transaction CV01N
Search for any document
Display document

Check Repository Configuration

Run transaction CSADMIN

SMD Agent Admin URL

To navigate directly to the Solution Manager diagnostic agent administration page in Solution Manager the following URL can be used: http://<server>:<port>/smd/AgentAdmin

SAP Host Agent, SAPOSCOL, SAP Host Control URLs

SAP Host Agent URL:

http://<server name>:5<inst>13/SAPHostAgent/?wsdl

SAP Host Control URL:

http://<server name>:1128/SAPHostControl/?wsdl

SAPOSCOL URL:

http://<server name>:1128/SAPOscol/?wsdl

End points can be queried using Wizdler extension for Chrome

Find executable and process ID from port number

To find out what process/executable is using a port on AIX:



lsof -i :1527

COMMAND      PID   USER   FD   TYPE             DEVICE SIZE/OFF NODE NAME

tnslsnr 11534508 oradep   12u  IPv4 0xf1000e0014b5dbb8      0t0  TCP hdep001a:tl isrv (LISTEN)

ps -ef  |grep 11534508

oradep 11534508        1   0   Feb 04      -  0:09 /oracle/DEP/102_64/bin/tnslsnr LISTENER_DEP -inherit