How to test FTP Connection on SAP GUI

One of the ways to test the connection of FTP in SAP GUI with FTP server.

1) Execute TCODE: SA38 and enter the program name: RSFTP002

2) Enter the FTP username, password, IP, FTP command to be execute and the RFC connection. Click the "Execute" button.

3) Example of the connection details.

Others:

1) Default RFC connection for FTP

2) Ports require for the FTP connection (ex: used for firewall policies/rules)

*NN = instance number 

(DEV instance number:38 port use: 3338, QAS instance number:68 port use: 3368 etc).

How to Reset "ddic" Password with SAP*

Scenario:

You have forgotten the ddic password on client:000 during patch activity and do not have any other login to reset the password.

The solution is to use the default "SAP*" user to reset the password

Steps:

1) Login to any other client -> execute TCODE: RZ10 -> change the parameter: "login/no_automatic_user_sapstar =0"  (this is to allow "SAP*" to access the system)

2) Save and activate the profile

3) Restart the SAP services

4) Now login into the client:000 with user: "SAP*" and password: "pass"-> execute TCODE: SU01 -> Reset the "ddic" password

5) Repeat the same step as step 1 and 2 by changing the "login/no_automatic_user_sapstar =1" (to disable "SAP*" access to system)

6) Restart the SAP services

7) System is secure and "SAP*" no longer acessible

Others:
1) SQL command to check whether "SAP*" exist in table: USR02

2) SQL Command to show schema used

How To Change SAP Router Configuration File - Adding New Port

Scenario: 
SAP Global team unable to remote access your Solution Manager and require additional port to be configure on the SAP router configuration file.

Steps:

1) SAP Support team having problem to remote access the Solution Manager page (HTTP Access) for further remote support.

2) Initial finding shown the connection is ok.

3) Further finding shown, additional port required to be configure on the SAP router for HTTP access.

4) Sample of the configuration settings required.

5) To perform any changes on the SAP router configuration file, stop the SAProuter service.

6) Locate the "saprouttab" file (ex: c:/usr/sap/saprouter) and add the required ports.

7) Once the "saprouttab" changes complete, restart the "SAProuter" services.

8) SAP Global team should be able to remote access the page by now.

Authorization: Resolve Asset Report That Not Showing Any Data

Scenario: Users unable to view certain finance reports.

Example: TCODE: S_ALR_87011963

No data to be display for the particular report

System trace on the missing authorization (TCODE: SU53), OBJ "A_A_VIEW" required attention.

System trace on the missing authorization (TCODE: ST01)

Default full authorization already been assigned to the object "A_A_VIEW" but insufficient for the report to be shown.

SNOTE on such incident (141876).

Solution:

Ensure the correct authorization been configure for the 4 objects as recommended by SNOTE.

1) OBJ: A_S_ANLKL

2) OBJ: A_S_WERK

3) OBJ: A_S_GSBER

4) OBJ: A_S_KOSTL

5) Once the correct value been configured, the report displaying the data successfully.

Administration: How To Delete Spool Request In Queue That Causing ABAP Runtime Error

Sample of the errors:

1) ABAP runtime error (TCODE: ST22) 

2) List of error that caused by spool request

3) Details of the error

Solution:

1) Execute TCODE: SE38 -> Enter "RSPO0041" -> click the execute button to run the program

2) Click the execute button with all the default value

3) Wait until the delete spool process complete

4) TCODE: SM50 showing the deletion process is running

5) Once deletion complete, execute TCODE: SQ01 to ensure all the spool request been clear completely

6) Sample of spool request before deletion

7) All the previous spool request been remove

Solution Manager: EarlyWatch Alert - Fix for Common Timeout Error on Remote System

Scenario
Encounter timeout error on remote system that caused by the data collection of EarlyWatch Alert.

Relevant SAP Note
1247198 - /SDF.RSORADLD_NEW timeout
984955 - Timeout with selection of V$-Views
838725 - Oracle dictionary statistics and system statistics

Error found on the remote system
1) Sample error from "ST22"

2) Double click to view the details

3) To further investigate the error with "ST11" and locate the trace log that within the time range of the error occur

4) Double click to view the details and search for the activities that occur on the specific time frame

Solution:
1) Prerequisite to ensure the BRTools version: SAP BRTools Release 7.00 Build 15 onwards.

2) To check the BRTools version and update it if required

3) Execute BRCONNECT command to create Oracle dictionary statistics - BRCONNECT internally calls the two procedures GATHER_DICTIONARY_STATS and GATHER_FIXEC_OBJECTS_STATS.

Login with user: ORA<SID> and execute the command below and wait until it complete. It will take couple of minutes depends on the system resources. (brconnect -u / -c -f stats -t oradict_stats)

4) Monitor the process with OS command: "top" with another putty session

5)  Creating Oracle system statistics (NOWORKLOAD) using BRCONNECT
     (brconnect -u / -c -f stats -t system_stats)

6) Creating Oracle system statistics (WORKLOAD) using BRCONNECT
    (brconnect -u / -c -f stats -t system_stats -i <minutes>) - example of 1 minutes

7) That's all, observe the task next cycle or day to determine the error been resolve.