SAP Line Opener Program – LOP for SAP Remote Access Support

Hello All,

Going through some of my old stuff, i found interesting tool of SAP which is called Line Opener Program, it’s use to open R/3 connection to your SAP system for SAP Remote Access Support, I have collected some details with the help of SAP documentation & Note –

1. What is LOP(Line Opener Program)

Line Opener (LOP) is a standalone program which integrated directly into Solution Manager 7.1 SP13 onwards with below Key features

Key features are:

LOP runs as a program on the ABAP stack of the Solution Manager.
It can be started automatically during system start-up.
It can be scheduled to run as a batch job.

Advantages:

SAP can access a system at customer side faster and even in times (e.g. night times or weekends) when it is difficult to reach contact persons at customer side or in case of serious problems.

Communication costs can be reduced (e.g. when using an ISDN connection) as the network connection is only opened for the time needed.

Customers can allow Semi Automatic Opening on system level for each system.
Every time a service connection is opened, you are informed via email and the action is stored in the log book.

2. How it works

LOP uses https-requests to check periodically whether an opening request for one of your systems exists in SAP Service Marketplace. If an appropriate request is found the LOP opens the corresponding network connection between your SAProuter and SAP.

3. Implementations Steps

To successfully set up and run the Line Opener Program some prerequisites must be fulfilled.

Import SSL Certificate in Solution Manager as per Note – 797124

Create RFC Destination(HTTP Connection to External Server) & assign S user ID in RFC for communication

Configure AI_SC_LINE_OPENER program to run in batch mode

Perform SAO(Semi Automatic Opening) setup in SMP(SAP Market Place) for each system

4. Mail Confirmation – When SAP open connection directly (LOP configured)

5. Challenge

R/3 connection can open directly by SAP but for other connections (HTTP/WTS etc) requires manual intervention

Security team manage credentials for system manually

Background Job should be running continuously & if cancel should schedule again to check for opening connection.

For Detailed Steps please follow below documentation from SAP –

https://support.sap.com/en/tools/connectivity-tools/line-opener.html

https://launchpad.support.sap.com/#/notes/797124

https://support.sap.com/content/dam/support/en_us/library/ssp/tools/connectivity-tools/line-opener-program/lop-documentation.pdf

SAP STANDALONE GATEWAY INSTALLATION & CONFIGURATION

Environment –

SAP Distributed Installation – ASCS, DB & PAS running on separate host

Issue – DB13 Jobs(check DB & Update stats etc) are not running due to distributed installation.

Solution – Requires SAP gateway on DB Host to run the SAPXPG RFC. As per SAP recommendation we requires to install SAP Standalone Gateway with new SID.

SAPSID – SAP System SID

GWSID – Gateway SID

This document is separated with 4 phases – (Unix Installation)

Preparation

1. Identify the DB physical hostname for GW server installation

2. Identify the (SID) of GW server – i.e. – G30, G50 etc

3. Create local Mount Point request for new identified GW SID (if requires or else sapinst will create)
/usr/sap/(GW SID) – 5GB
/sapmnt/(GW SID) – 5 GB

4. Permission for mount point – (gwsid)adm:sapsys (full permission & others read only)

5. Download SWPM & Non Unicode Kernel for GW installation

6. Verify /tmp should have enough space to complete the installation (as SAPINST extract in /tmp by default)

Installation

1. Login via root & run SWPM in putty with command “./sapinst SAPINST_USE_HOSTNAME=db” (Virtual Host Name of DB server, if available or else physical)

2. Type GWSID(G30)

3. SAP Mount Directory – /usr/sap/ (As it will pick automatically new created mount point identified earlier)

4. Master Password for users

5. Provide SAPEXE.SAR & SAPHOSTAGENT.SAR (from Kernel directory)

6. Parameter Summary – Verify Details & Click on Show Details – Select Gateway Instance & Click Revise (if requires)

7. Successful installation will start the Gateway Service in host & Verify the same.

8. Specify Issues Encountered (Verify the installation error logs in /tmp directory & take corrective action.)

Post Installation Steps (Configuration)

1. login to (gwsid)adm & stopsap to stop the gateway server

2. Navigate to /usr/sap/(GWSID)//data & create 2 below files
vi reginfo
vi secinfo
Paste the below contents in 2 files –
TP=* USER=* USER-HOST=* HOST=*

3. Copy below files from SAP exe(kernel) directory to GATEWAY exe(kernel) folder –
sapxpg
libsapnwrfc.so
BR* (all BRTOOLS binaries)

4. Set the below BRTOOLS permission in GATEWAY exe(kernel) folder –
brarchive, brbackup, and brconnect belong to ora(sid) : sapsys and have authorization 4774
brrestore, brrecover, brspace, and brtools belong to (sapdsid)adm : sapsys and have authorization 755

5. Set below parameters in Gateway Instance Profile –
SETENV_04 = PATH=$(DIR_EXECUTABLE):/usr/sap/SAPSID/SYS/exe/run:/oracle/SAPSID/121/bin:%(PATH)
SETENV_06 = ORACLE_SID=SAPSID
SETENV_07 = SAPDATA_HOME=/oracle/SAPSID

(Replace SAPSID to respective SAP system name)

6. Set below parameters in Gateway ENV variable file – Verify SHELL = echo $SHELL & create a copy of existing ENV file & edit the same.
(.sapenv_(hostname).csh or .sapenv_(hostname).sh or .sapenv.sh)

(Replace SAPSID with respective SAP System Name)

setenv SAPDATA_HOME /oracle/SAPSID
setenv ORACLE_SID SAPSID
setenv PATH /oracle/SAPSID/121/bin:$PATH
setenv ORACLE_HOME /oracle/SAPSID/121(oracle version)
setenv USER (sapsid)adm
setenv dbs_ora_schema SAPSR3(schema user)
setenv NLS_LANG AMERICAN_AMERICA.UTF8
setenv DB_SID (SAPSID)
setenv dbs_ora_tnsname (SAPSID)
setenv dbms_type ORA
setenv SAPDATA_HOME /oracle/(SAPSID)
setenv SAPSID (SAPSID)
setenv LD_LIBRARY_PATH /usr/sap//SYS/exe/run:$LD_LIBRARY_PATH

Save the file, Log off & Login & verify the Environment Variables.

7. Start the gateway server by startsap

8. Login into ABAP System – SM59 – TCP/IP – SAPXPG_DBEST_DB(SID)
Program – sapxpg
Target Host – DB Hostname
Gateway Host – DB Hostname
Gateway Service – sapgw(GW instance number)
Save the RFC & Verify the Connection Test

9. DB13 – Choose update optimizer statistics & check DB & run immediately to verify SAPXPG is connecting to DB successfully with correct authorizations.

Troubleshooting

1. Installation Error TST_ERROR while installing the GW service
Generic error – it failed while starting the GW service in respective time frame, please crosscheck all the folders created in /usr/sap/GWSID & try to start the same directly from OS level.
startsap
if GW started successfully then ignore the installation error.”
“SAPXPG RFC Connection Error

2. Error – SAPXPG RFC not working – is SAP gateway started
Please check SAP Gateway should be started & in running status.

3. Error – SAXPG RFC not working – Storage allocation error
Please check whether it’s reading reginfo & secinfo file or restart the GW server

4. Error – SAPXPG RFC not working – Getting Timeout
Please check if you have copied the LIB file in GW exe folder, mentioned in Post Installation Steps”

5. Error – Permission denied to read log file in sapcheck directory
Login via ora(sid) & give 775 permission to respective connection file in sapcheck directory

6. Error – Invalid username / password
Please check the environment variables should be corrected & try to run BRCONNECT from OS level, sometime there will be issue at OPS$ mechanism, verify BRCONNECT from SAP user also.

7. Error – No Valid License Found
Please check the below ENV variable should exists for GW user.
setenv SAPSID (Replace with respective SAP server name)

Please share your comments –

SAP BDLS failing – Syntax Error in Program SAPLRSSTATMAN

Hi All,

During recent System Refresh, we have faced issue in SAP – Global Batch Trace System where BDLS for Logical System Conversion is failing with Syntax Error in table “/BI0/SREQUID”.

According to SAP, this issue is capture on SAP Note – 2133885.

for successful BDLS run (Logical System Conversion), we have implemented above note by SNOTE(no manual steps) on the system & re run BDLS again.

SAP BW Process Chains – Variant does not exists

Hi All,

Recently we have performed BW & SCM system refresh from PRD, once after the post steps Process chains were not working & throwing below error – “Variant does not exists”

To resolve the inconsistencies in post steps, you need to implement SAP note – 1455417

According to note 1455417, execute the report SA38 – RS_FIND_JOBS_WITHOUT_VARIANT in your system. This would remove all the inconsistent job entries & inform the BW team to run the process chains again.


However in some cases if the above report is not able to clean the variant then you need to create Z report given in the SAP note “Z_FIND_JOBS_WITHOUT_VARIANT” & run on the system to clean up the inconsistent entries.

Let me know if this solution helps you.

SAP Mass Changes to Step User of Background Jobs

Hi All,

Recently after the System Refresh activity we have came across the situation where most of the background jobs are failing as step user is not exists in quality/pre prod, multiple users defined hundreds of jobs in the system where some of the jobs requires to be continue on the system & some can be delete.

Manually changing the step user ID of these hundreds of jobs is time taken process & there will be a chance of mistake, for this type of situation there is a good report “SA38 – BTC_MASS_JOB_CHANGE” which can perform this task in a very simple way. This report can perform the Single/Mass job change on the system including owner/step user.

SAP SCC4 & SE06 MONITORING

Hi All,

Recently we have multiple noise regarding client opening/close modification without proper notice/change.

One of my friend has initiated a customize solution for the same by performing some coding on the system as this solution will provide proper audit & can also viewable via Fiori tiles.

Please go through the below URL for more details.

SCC4 & SE06 MONITORING

Share your comments if you like the solution.

Solution Manager 7.2 Upgrade Fast Track Content Activation

Hello All,

Recently One of my friend has published Solution Manager 7.2 Content Activation Blog.

Blog is quite useful as of now all the companies are moving or already moved to Solution Manager 7.2

https://blogs.sap.com/2018/07/10/solman-7.2-upgrade-fast-track-content-activation-enabling-snote-for-tci-and-tci-notes-implementation/

SAP Missing Excel Templates while exporting

Recently we are facing issue while exporting in excel format.

It’s throwing below error.

Solution – Run Report in SA38 – BCALV_BDS_IMPORT_SAP_TEMPLATE in DIALOG mode.

The above report will not ask any input & complete in seconds.

Then try again to export the same contents in excel, you will receive an error first time but next time it will solve & export the contents in excel successfully.

Create Dummy Project for local transport

We have CHARM implemented in our landscape & all the local creation of TR’s are prohibited as per policy. During upgrade of Solution Manager 7.2 it’s asking for perform some change in Shadow System. Change is Shadow System asking TR & which we are not able to save as LOCAL due to CTS enabled.

Alternative Solution for the same is.

Create dummy project in system directly via SA38 – RSWBO_AUX_PROJECT

This new dummy project will visible in system & you can save the local TR & continue with the change or upgrade.