DKS configuration

[#1]

Hi SAP,

We are requesting your support to clarify the steps for integrating our BODS 4.3 development environment application, identified as DKS, into the FOCUSED RUN monitoring system.

We are requesting your support to confirm the correctness of each of the activities we will perform in the BODS 4.3 development environment, specifically on the server (IP_ADDRESS), where the application resides on Windows Server DIGITS Standard. We require your confirmation that the indicated action is correct; otherwise, please inform us what modifications or changes are necessary for its proper implementation.

Prerequisites

The sapadm administration account must be part of the administrators group on the Windows server.

At the operating system level, add the IPs and hostname of the server where SAP FOCUSED RUN resides to the /etc/hosts file.

This information was provided by the FOCUSED RUN administrator.

IP_ADDRESS HOST
IP_ADDRESS HOST
IP_ADDRESS HOST
IP_ADDRESS HOST

Where

Server: HOST

IP: IP_ADDRESS

Puerto: DIGITS

Usuario: NAME

SAP HOST AGENT

According to note DIGITS - SAP Host Agent Outside Discovery ComputerSystem configuration, the SAP Host Agent version should be SAP Host Agent 7.22 PL 69 introduces the required-local parameter and DIGITS - SAP Host Agent 7.22 PL69.

This is the same version that is installed on this server.

C:\Program Files\SAP\hostctrl\exe\convertoscolfilter.exe: 722 (EX3), patch DIGITS, changelist DIGITS, NTAMD64, opt (EX3) (Oct 10 DIGITS, 10:07:26)

C:\Program Files\SAP\hostctrl\exe\sapcimc.exe: 722 (EX3), patch DIGITS, changelist DIGITS, NTAMD64, opt (EX3) (Oct 10 DIGITS, 10:07:26)

**********************************************************

--------------------

SAPHOSTAGENT information

--------------------

kernel release                722

kernel make variant           722_EX3_REL

compiled on                   NT 6.2 DIGITS  x86 MS VC++ 19.29 for NTAMD64

compiled for                  64 BIT

compilation mode              Non-Unicode

compile time                  Oct 10 DIGITS 07:08:51

patch number                  69

latest change number          DIGITS

---------------------

supported environment

---------------------

operating system

Windows NT 5.1

Windows NT 5.2

Windows NT 6.0

Windows NT 6.1

Windows NT 6.2

Windows NT 6.3

Windows NT 10.0

C:\Program Files\SAP\hostctrl\exe>hostname

HOST

C:\Program Files\SAP\hostctrl\exe>

Would these be the necessary prerequisites to be able to integrate with SAP FOCUSED RUN?

According to note DIGITS - AC Tool release NOTE for supported products such as Data Services 4.X, BOE 4.X, BOE embedded Tomcat (Web Tier), Tomcat7, Tomcat8, it is suggested to use the AC Tool (AutoConfigure Tool) for preparing the managed system configuration of different products.

Download and unzip actool_mini.zip attached and follow the instructions in file readme.txt

Before running the run_actool.bat script, should the instructions in point 2 be followed for our SAP Data Services 4.3 application?

2. maintain products.xml and boe.properties and/or ds.properties

BOE:

maintain boe.properties for all empty varaibles and adapt UNIX type folders

DS or IS:

copy conf/products_miniboe.xml to conf/products.xml

maintain ds.properties for all varaibles <***>.

This part does not apply because it is a Windows operating system.

For UNIX only:

maintain boe.properties 2 varaibles (note the 2 space around '=' is required)

boe.home = <***>

jvmmond.install.path = <***>

This section must be completed for our application.

BOE Tomcat:

copy conf/products_tomcat.xml to conf/products.xml

copy boe_tomcat_mini.propertie to boe.properties

maintain boe.properties for all varaibles <***> and adapt folder for UNIX/Windows.

To execute the following instruction, where can we obtain the TomcatSLDDataSupplierWEB.war file and isagent-zip-rtv-108.0.0.zip, which are not in the actool_mini folder?

copy TomcatSLDDataSupplierWEB.war and isagent-zip-rtv-108.0.0.zip to folder downloads/.

If 108.0.0 is not the latest version, you need to adapt boe.properties wily.agent.version

See download/readme.txt on where to find above file.

download/readme.txt

For BOE Tomcat SolMan setup, copy here:

Introscope IS (isagent-zip-rtv-108.0.0.zip) from SMP

TomcatSLDDataSupplierWEB (sap.com~TomcatSLDDataSupplierWEB.war) from SAP note DIGITS

According to note DIGITS, the file TomcatSLDDataSupplier_260624.zip was downloaded and its contents are:

C:\Users\jdominguez25\Downloads\TomcatSLDDataSupplier_260624>dir

 El volumen de la unidad C es OSDisk

 El número de serie del volumen es: DIGITS-DIGITS

 Directorio de C:\Users\jdominguez25\Downloads\TomcatSLDDataSupplier_260624

16/07/DIGITS  11:00 p. m.    <DIR>          .

16/07/DIGITS  11:00 p. m.    <DIR>          ..

16/07/DIGITS  11:00 p. m.         1,397,737 sap.com~TomcatSLDDataSupplier.war

               1 archivos      1,397,737 bytes

According to the Apache_Tomcat_SLD-DS_Overview.pdf document attached to note DIGITS, the SAP metadata XML file should be located in the TomcatSLDDataSupplier_260624 folder, but as we have observed before, only the .war file sap.com~TomcatSLDDataSupplier.war exists.

• SLD Data Supplier can automatically discover and report deployed application to SLD. To be found by the SLD-DS application has to be delivered with a SAP “metadata” XML file which describes software component(s) implemented by the application.
• SAP metadata XML file has to be in the META-INF folder of the application’s WAR file.
• The structure of meta-data file reflects the PPMS model.

By checking the actual_mini\actool_mini\conf\ppms folder, we can find the file SAP_metadata.xml.

Is this the file referred to in the Apache_Tomcat_SLD-DS_Overview.pdf document?

C:\Users\jdominguez25\Downloads\actool_mini\actool_mini\conf\ppms>dir /s

 El volumen de la unidad C es OSDisk

 El número de serie del volumen es: DIGITS-DIGITS

 Directorio de C:\Users\jdominguez25\Downloads\actool_mini\actool_mini\conf\ppms

02/07/DIGITS  10:31 p. m.    <DIR>          .

02/07/DIGITS  10:31 p. m.    <DIR>          ..

02/07/DIGITS  10:31 p. m.    <DIR>          boe_webapp

02/07/DIGITS  10:31 p. m.    <DIR>          dswsbobje

02/07/DIGITS  10:31 p. m.            16,894 ppms_SBOPEnterpriseXI40.xml

02/07/DIGITS  10:31 p. m.               764 ppms_SBOPPAServerXI40.xml

               2 archivos         17,658 bytes

 Directorio de C:\Users\jdominguez25\Downloads\actool_mini\actool_mini\conf\ppms\boe_webapp

02/07/DIGITS  10:31 p. m.    <DIR>          .

02/07/DIGITS  10:31 p. m.    <DIR>          ..

02/07/DIGITS  10:31 p. m.             1,153 SAP_metadata.xml

               1 archivos          1,153 bytes

 Directorio de C:\Users\jdominguez25\Downloads\actool_mini\actool_mini\conf\ppms\dswsbobje

02/07/DIGITS  10:31 p. m.    <DIR>          .

02/07/DIGITS  10:31 p. m.    <DIR>          ..

02/07/DIGITS  10:31 p. m.             1,064 SAP_metadata.xml

               1 archivos          1,064 bytes

     Total de archivos en la lista:

In the document Apache_Tomcat_SLD-DS_20250601.pdf, section 3.1, Install SLDREG – executable,

What would be the criteria for creating the .CFG and .KEY files?

To configure SLDREG create appropriate .CFG and .KEY files to be used to establish a connection to

the SLD. The path to the SLDREG executable and to the .CFG files have to be specified in the SLD –DS

configuration properties file like follows.

By the way,    Are SLDREG_PATH and SLDREG_CONFIG_FILE_PATH environment variables that must be created at the operating system level?

SLDREG_PATH=/usr/sap/hostcontrol/exe/sldreg

SLDREG_CONFIG_FILE_PATH= /tmp/sld.cfg

In point 3.3.1 Configuration of the SLD-DS, what parameters should we include in the sldDataSupplier.properties.template or sldDataSupplier.properties file? Initially, it would be those that appear by default.

What would be the criteria for defining the parameters for BODS 4.3?

In the file actol_mini\readme.txt in point 3.

C:\Users\jdominguez25\Downloads\actool_mini\actool_mini>

3. run ACTool by

Windows: run_actool.bat

Y en ACTool User Guide-2.pdf en punto 5.8

5.8 Run ACTool with Interactive User Input

For all steps, you need to run ACTool as root user or sudo on UNIX, or as the administrator role in Windows.

Windows run_actool.bat.

The next step is to run run_actool.bat, but upon reviewing the script, we find some instructions (in black) related to configuring and restarting Data Services. This raises the question: Did the application configuration change, requiring a restart?

Is confirmation required to determine if the configuration changed and a restart is necessary to request permission from the client or application owner?

@echo off

setlocal enabledelayedexpansion

if exist downloads\sap.com-TomcatSLDDataSupplierWEB-*.war (

if NOT exist downloads\sap.com~TomcatSLDDataSupplierWEB.war (

              cd downloads

              rename sap.com-TomcatSLDDataSupplierWEB-*.war sap.com~TomcatSLDDataSupplierWEB.war

              cd ..

)

)

reg query "HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Installer\PERSON_NAME" /v path  |findstr path >./tmp.txt

if errorlevel 1 (

reg query "HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Installer\LTS" /v path  |findstr path >./tmp.txt

)

set /p myvar= < tmp.txt

echo %myvar:~22%>tmp.txt

set /p BOEDIR= < tmp.txt

del tmp.txt

rem set BOEDIR=C:\Program Files (x86)\SAP BusinessObjects

if NOT "%BOEDIR%" == "" (

rem call cpbosdk.bat "%BOEDIR%"

set "CESDK=%BOEDIR%\SAP BusinessObjects Enterprise XI 4.0\java\lib\cesdk.jar"

)

type conf\ds.properties |findstr /b ds\.service\.name >tmp.txt

set /p myvar= < tmp.txt

echo %myvar:~18%>tmp.txt

set /p DS_SERVICE_NAME= < tmp.txt

del tmp.txt

rem echo DS_SERVICE_NAME=%DS_SERVICE_NAME%

type conf\ds.properties |findstr /b ds\.restart >tmp.txt

set /p myvar= < tmp.txt

echo %myvar:~13%>tmp.txt

set /p DS_RESTART= < tmp.txt

del tmp.txt

rem echo DS_RESTART='%DS_RESTART%'

type conf\boe.properties |findstr /b cms\.ssl >tmp.txt

set /p myvar= < tmp.txt

echo %myvar:~10%>tmp.txt

set /p CMSSSL= < tmp.txt

del tmp.txt

set BOEJVMBIN=%BOEDIR%\SAP BusinessObjects Enterprise XI 4.0\win64_x64\sapjvm\bin

if NOT exist "%BOEJVMBIN%\java.exe" (set BOEJVMBIN=C:\Windows\System32)

rem For Standalone Tomcat, uncomment below line and adapt your JDK

rem set BOEJVMBIN=C:\jdk1.7.0_25\bin

set BOEJVMBIN2=%BOEDIR%\Analytics\win64_x64\sapjvm\bin

echo %BOEJVMBIN2%>tmp.txt

if NOT exist "%BOEJVMBIN%\java.exe" (set /p BOEJVMBIN= < tmp.txt)

del tmp.txt

if NOT exist "%BOEJVMBIN%\java.exe" (echo no JVM found, please set this variable BOEJVMBIN manually! && GOTO:eof)

echo using JVM=%BOEJVMBIN%

set myvar=

rem for /r %%i In (AutoConfigure_lib\*.jar sap_actool*.jar) DO set myvar=!myvar!%%i;

for /r %%i In (sap_actool*.jar) DO set myvar=!myvar!%%i;

rem echo %myvar%

set CLASSPATH=.;%myvar%

rem set JAVA_OPT=-Xrunjdwp:transport=dt_socket,address=DIGITS,server=y,suspend=n

set JAVA_OPT=%JAVA_OPT% -Dtracelog.logdir=logs -Dtracelog.configfile=BO_trace.ini -Dtracelog.name=ac

set JAVA_OPT=%JAVA_OPT% -Djava.library.path="%BOEDIR%\SAP BusinessObjects Enterprise XI 4.0\win64_x64"

rem echo JAVA_OPT=%JAVA_OPT%

rem below for CMS SSL

if "%CMSSSL%" == "true" (

set JAVA_OPT=%JAVA_OPT% -Dbusinessobjects.orb.oci.protocol=ssl -DcertDir="%BOEDIR%\SSL" -DtrustedCert=cacert.der -DsslCert=servercert.der -DsslKey=server.key -Dpassphrase=passphrase.txt -Dpsecert=cert.pse

)

if NOT "%CESDK%" == "" (

set "CLASSPATH=%CLASSPATH%;%CESDK%"

echo Using unique BOSDK lib:"%CESDK%"

)

rem echo CLASSPATH=%CLASSPATH%

"%BOEJVMBIN%\java" %JAVA_OPT% com.sap.ac.entry.ConsoleModeLauncher %*

if "%DS_RESTART%" == "true" (

if NOT "%DS_SERVICE_NAME%" == "" (

sc stop %DS_SERVICE_NAME%

sc start %DS_SERVICE_NAME%

)

)

We need your support to address these questions or concerns so we can make the necessary changes to integrate this development environment into FOCUSED RUN's monitoring system.

If you believe we should change the order of the steps or activities to be performed, please also confirm, as we need to integrate the quality assurance and production environments into FOCUSED RUN's monitoring system.

Best regards.

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Please refer to guide:
https://support.sap.com/en/alm/sap-focused-run/expert-portal/frun-supported-products/frun-setup-ds.h...