Pages

Thursday, April 30, 2020

Clear the SAP GUI Cache


Procedure:

1. GUI --> option --> local data --> history (Clear History).
2. Delete the content of the below file, SAP GUI will automatically create its content again after 
the restart

C:\Users\<USERNAME>\AppData\Local\SAP\SAP GUI\Cache\SAP_Cache_<USERNAME>\Cache1
C:\Users\<USERNAME>\AppData\Local\SAP\SAP GUI\Cache\SAP_Cache_<USERNAME>\Cache2
C:\Users\<USERNAME>\AppData\Local\SAP\SAP GUI\tmp
C:\Users\<USERNAME>\AppData\Local\SAP\SAP GUI\Traces

After doing the above steps restart the SAP GUI. 

How to disable/clear HTTP cache content for SAP JAVA Application Server


Procedure:

There are several ways to clear the cache of the server, the easiest way is to stop all the services
of the application server and including sapstartsrv and run cleanipc or OS command to clear the cache.
If any case you won;t be able to stop and start the application , Please follow the below steps.

1. Open the url http://<hostname>:<port>/sap/admin
2. Login with webadm as user and master password.
3. Goto HTTP Handler --> Server Cache --> Invalidate Cache

or

1. Navigate to /nwa -> Configuration -> Infrastructure -> Java HTTP Provider Configuration
2. Now Clear Cache

Wednesday, April 22, 2020

Update Roles and Aliases fails with error "The update attempt failed with error: Object could not be scheduled within the specified time interval" in BO 4.X


Error :








Procedure:


  • Go to CMC -> Servers
  • Under Service Category, select Core Services
  • Create New Server
  • Under the Select Service, select Authentication Update Scheduling Service
  • Click Next and select the below services: Authentication Update Scheduling Service, Security Query Scheduling Service, Users and Groups Import Scheduling Service
  • Click Next and Create.

Friday, April 17, 2020

S/4 Hana 1809 Installation Part - II


Procedure:


  • Provide the SAPHANADB Schema User password




  • Define the parallel import job and <sid>adm password




  • Provide the PAS and ASCS Instance no. host





  • Choose the secure storage key accordingly to your environment



  • Check the summary of the Installation and monitor the Installation



Check the installation log once the installation is finished.



For the S/4 Hana 1809 Installation Part - II - Link
For HANA System Installation - Link




S/4 Hana 1809 Installation Part - I


Procedure :


  • Start the SWPM and choose the show option 






























  • Run the installer mode typical or custom




  • Enter the SID and Mount directory details




























  • Provide the Database host , SID. Instance no. and SYSTEM User Password



  • Provide the required SAPHOSTAGENT, SAPEXE, SAPEXEDB, IGSEXE and IGSHELPER


  • Select HANA Client Installation Strategy Path





  • Provide the Hana Client Media path



  • Provide S4 HANA Installation Export Media


  • Provide the DBACOCKPIT schema password





For the S/4 Hana 1809 Installation Part - II - Link
For HANA System Installation - Link

Sunday, April 12, 2020

GCC runtime environment on Linux



     Solution :

               SLES

                       Install libstdc++ package


              RHEL
       
                   1.   Install compat-sap-c++ package
                   2.   mkdir /usr/sap/lib
                   3.   ln -s /opt/rh/SAP/lib64/compat-sap-c++.so /usr/sap/lib/libstdc++.so.6
                   4.   Changing the file/directory ownership of /usr/sap/lib to sapadm:sapsys or <sid>adm:sapsys user:group is possible

            Oracle Linux

                   1.   Install compat-sap-c++ package
                   2.   mkdir /usr/sap/lib
                   3.   ln -s /opt/rh/SAP/lib64/compat-sap-c++.so /usr/sap/lib/libstdc++.so.6
                   4.   Changing the file/directory ownership of /usr/sap/lib to sapadm:sapsys or  <sid>adm:sapsys user:group is possible

Manually Upgrade the time zone in Oracle Database 12c


Procedure:


Go the directory path /oracle/<SID>/12201/oracore/zoneinfo, check for the latest time file available .



SQL> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup upgrade;
ORACLE instance started.
Total System Global Area 2885681152 bytes
Fixed Size                  8624840 bytes
Variable Size            1493173560 bytes
Database Buffers         1375731712 bytes
Redo Buffers                8151040 bytes
Database mounted.
Database opened.

SQL> EXEC DBMS_DST.BEGIN_UPGRADE (27);

PL/SQL procedure successfully completed.

SQL> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup;
ORACLE instance started.

Total System Global Area 2885681152 bytes
Fixed Size                  8624840 bytes
Variable Size            1493173560 bytes
Database Buffers         1375731712 bytes
Redo Buffers                8151040 bytes
Database mounted.
Database opened.

SQL> select version from v$timezone_file;

   VERSION
----------
        27

Suggestion:
Maintain the proper backup of the system before proceeding fore the upgrade.


Saturday, April 11, 2020

SSFS Configuration for Oracle Database for Linux Systems


Concept :

Earlier the connection from the SAP ABAP system worked in such a way that OPS$ connection
was authorized by the OS user to permit access to table OPS$.<SID>ADM.SAPUSER only. It contains the actual database user used for the connection with the encrypted password.

SSFS (Secure Storage File System) will contain the encrypted file store at OS level, to connect to database from SAP ABAP System.

SSFS connections are only applicable for the ABAP system only.


Solution :

1. Create the director under the path /usr/sap/<SID>/SYS/global/security/ with <SID>adm

  • mkdir -p /usr/sap/<SID>/SYS/global/security/rsecssfs/data
  • mkdir -p /usr/sap/<SID>/SYS/global/security/rsecssfs/key


2. Set the environment variable for the <SID>adm user (.sapenv_<hostname>.csh and .sapenv.csh)
  • setenv RSEC_SSFS_DATAPATH  /usr/sap/<SID>/SYS/global/security/rsecssfs/data
  • setenv RSEC_SSFS_KEYPATH  /usr/sap/<SID>/SYS/global/security/rsecssfs/key
  • setenv rsdb_ssfs_connect  1

3. Set the profile parameter (DEFAULT.PFL)
  • rsec/ssfs_datapath = $(DIR_GLOBAL)$(DIR_SEP)security$(DIR_SEP)rsecssfs$(DIR_SEP)data
  • rsec/ssfs_keypath  = $(DIR_GLOBAL)$(DIR_SEP)security$(DIR_SEP)rsecssfs$(DIR_SEP)key
  • rsdb/ssfs_connect = 1

4. Set the SSFS Credential
  • rsecssfx put DB_CONNECT/DEFAULT_DB_USER SAPSR3 -plain
  • rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD <SCHEMA_PASSWORD>

5. Check the R3trans -d
6. Delete the table SAPUSER
                 > sqlplus
                SQL> connect system/<pwd>
                SQL> drop table ops$<sid>adm.sapuser;
7. Delete the REMOTE_AUTH parameter
              > sqlplus
                SQL> connect system/<pwd>
                SQL> alter system reset remote_os_authent scope=spfile;

Oracle SBP fails with error Missing command :fuser


Error :

Log file /oracle/<SID>/122/cfgtoollogs/opatch/opatch<date_time>.log

Prerequisite check "CheckSystemCommandAvailable" failed.
                                    The details are:
                                    Missing command :fuser




Reason :

The cause is that the RPM package 'psmisc' is not installed or not the latest version.

Solution :

Install RPM package 'psmisc' in your Operating System.

Friday, April 10, 2020

Oracle SBP fails Cannot calculate "" as (832368 > 9104508) ? 1 : 0 Missing Command : dc


Error :

While applying Oracle SBP patch getting below error:



Problem :

The cause is that the RPM package 'bc' is not installed or not the latest version.

Solution :

Install RPM package 'bc' in your Operating System.


Thursday, April 9, 2020

RPM package for ADS on RHEL 6 and Oracle Linux 6


Error :

Java Default Trace  error

#2.0_XXXX XX XX XX:XX:XX:XXX#+XXXX#Fatal#com.adobe.document.PDFManipulation#
#BC-SRV-FP#com.adobe~PDFManipulation#C0000A157292008A000000010000752C#8403450000000002##com.adobe.document.PDFManipulation#Guest#0##DB3CC0E3C51111E0A2480000008039FA#db3cc0e3c51111e0a2480000008039fa#db3cc0e3c51111e0a2480000008039fa#0#Thread[RMI/IIOP Worker [3],5,Dedicated_Application_Thread]#Plain##gESHFT gAcroFormHFT gDigSigHFT gPubSecHFT  plugin(s) failed to initialize.#


Problem :

ADS requires additional RPM packages.


Solution :

Install the below packages in EL 6 and OL6

          autoconf-2.63-5.1.el6.noarch.rpm

          automake-1.11.1-1.2.el6.noarch.rpm
          cyrus-sasl-lib-2.1.23-8.el6.i686.rpm
          expat-2.0.1-9.1.el6.i686.rpm
          fontconfig-2.8.0-3.el6.i686.rpm
          freetype-2.3.11-5.el6.i686.rpm
          glibc-2.12-1.7.el6.i686.rpm
          keyutils-libs-1.4-1.el6.i686.rpm
          krb5-libs-1.8.2-3.el6.i686.rpm
          libcom_err-1.41.12-3.el6.i686.rpm
          libgcc-4.4.4-13.el6.i686.rpm
          libidn-1.18-2.el6.i686.rpm
          libidn-devel-1.18-2.el6.i686.rpm
          libselinux-2.0.94-2.el6.i686.rpm
          libssh2-1.2.2-7.el6.i686.rpm
          libX11-1.3-2.el6.i686.rpm
          libXau-1.0.5-1.el6.i686.rpm
          libxcb-1.5-1.el6.i686.rpm
          nspr-4.8.6-1.el6.i686.rpm
          nss-3.12.7-2.0.1.el6.i686.rpm
          nss-softokn-3.12.7-1.1.el6.i686.rpm
          nss-softokn-freebl-3.12.7-1.1.el6.i686.rpm
          nss-util-3.12.7-1.el6.i686.rpm
          openldap-2.4.19-15.el6.i686.rpm
          openssl-1.0.0-4.el6.i686.rpm
          transfig-3.2.5-9.el6.x86_64.rpm

          zlib-1.2.3-25.el6.i686.rpm


Suggestion:

Both x86_64 and i686 packages are required for the ADS.

CORBA Connection to XML Form Module failed, please verify the binaries


Error :

For RHEL 7 and Oracle Linux 7

Default Trace Error -


#2.0#XXXX XX XX XX:XX:XX:XXX#+XX#Error#com.adobe.document.XMLFormService#BC-SRV-FP#com.adobe~XMLFormService#C000C0A80F030093000000020000385C#5084450000000005#com.adobe/AdobeDocumentServices#com.adobe.document.XMLFormService#deploy_service#13##E3D9B4599B2D11E4BE8D0000004D9522#e3d9b4599b2d11e4be8d0000004d9522#e3d9b4599b2d11e4be8d0000004d9522#0#Thread[XMLForm.exe Error Reader,5,Dedicated_Application_Thread]#Plain##Service XMLFormService: Native process (PID=0) /usr/sap/<SID>/<Instance>/j2ee/os_libs/adssap/XMLFormService/bin/XMLForm.exe terminated abnormally with error code 126#CORBA Connection to XML Form Module failed, please verify the binaries are deployed to the os_libs director

You may be running on a non-supported platform.



Reason :

Missing OS packages  required for ADS


Solution:

Follow the link

OS package for ADS on RHEL 7 and Oracle Linux 7


Adobe Document Services OS packages for the RHEL 7 and Oracle Linux 7

autoconf-2.63-5.1.el6.noarch
automake-1.11.1-4.el6.noarch
cyrus-sasl-2.1.26-17.el7.x86_64
expat-2.1.0-8.el7.x86_64
fontconfig-2.10.95-7.el7.x86_64
freetype-2.4.11-9.el7.x86_64
glibc-2.17-55.el7_0.1.i686
glibc-devel-2.17-55.el7_0.1.i686
keyutils-libs-1.5.8-3.el7.x86_64
krb5-libs-1.11.3-49.el7.x86_64
libcom_err-1.42.9-4.el7.x86_64
libgcc-4.8.2-16.2.el7_0.i686
libidn-1.28-3.el7.x86_64
libidn-devel-1.28-3.el7.x86_64
libselinux-2.2.2-6.el7.x86_64
libssh2-1.4.3-8.el7.x86_64
libX11-1.6.0-2.1.el7.i686
libXau-1.0.8-2.1.el7.i686
libxcb-1.9-5.el7.i686
nspr-4.10.6-1.el7_0.x86_64
nss-3.16.2.3-2.el7_0.x86_64
nss-softokn-3.16.2.3-1.el7_0.x86_64
nss-softokn-freebl-3.16.2.3-1.el7_0.i686
nss-util-3.16.2.3-1.el7_0.x86_64
openldap-2.4.39-3.el7.x86_64
openssl-1.0.1e-34.el7_0.6.x86_64
transfig-3.2.5-9.el6.x86_64
zlib-1.2.7-13.el7.x86_64


Suggestion :Both x86_84 and i686 packages are mandatory to install for Adobe Document Services

OS Pre-requisite Check on RHEL 6.X, 7.X for SAP Installation


  • Check the Created Mount Points

                 $ df -h


  • Check Hostname
                $ hostname -s

  • Check Full Qualified Domain Name
                $ hostname -f

  • Update the Linux Kernel Parameter
                 To do this append the following lines to /etc/sysctl.conf  (For EL6)

                      # SAP settings

                      kernel.msgmni=1024
                      kernel.sem=1250 256000 100 1024
                      vm.max_map_count=2000000
                      vm.swappiness=1



                To do this append the following lines to /etc/sysctl.d/sap.conf  (For EL7)

                       # SAP settings (For EL7)

                      kernel.sem=1250 256000 100 1024

                      vm.max_map_count=2000000
                      
                     

                 Note : Run the command "sysctl -p" to activate the modified kernel parameters.

  • Install the OS Software Package for SAP Application Server (EL6 and EL7)

                   libuuid-2.17.2-12.24.el6.x86_64 or Latest
                   uuidd-2.17.2-12.24.el6.x86_64 or Latest
                   libstdc++-4.4.7-17.el6.x86_64 or Latest
                   libstdc++-devel-4.4.7-17.el6.x86_64 or Latest
                   gcc-4.4.7-17.el6.x86_64 or Latest
                   glibc-2.17.2-12.24.el6.x86_64 or Latest
                   xorg-x11-apps-7.7-6.el6.x86_64 or Latest
                   compat-sap-c++-6 6.3.1 x86_64 or Latest
                   gcc-c++-4.4.7-23.el6.x86_64 or Latest
                   compat-libstdc++-33-3.2.3-69.el6.x86_64 or Latest

  • Update the user and group limit
                   To do this append the following lines to /etc/security/limits.conf  (For EL6)

                  @sapsys           hard              nofile             32800
                  @sapsys           soft               nofile             32800

                   To do this append the following lines to /etc/security/limits.d/90.nproc.conf

                  @sapsys          soft              nproc            unlimited



                  To do this append the following lines to /etc/security/limits.d/99-sap.conf  (For EL7)

                  @sapsys           hard              nofile             32800
                  @sapsys           soft               nofile             32800
                @sapsys           soft              nproc            unlimited


Suggestion

Do not installation separate JAVA jdk/jre on SAP JAVA Application Server.
Always reboot the system after completing the pre-requisite.
Do not forgot to add swap space as per the SAP guidelines before starting the OS pre-requisite.
Always use the latest Software Provisioning Manager (SWPM) version for the installation.
Hostname should not be more than 13 characters.


Note : These pre-requisite are related to SAP Application Server only for the  pre-requisite related to database please visit the Page


Tuesday, April 7, 2020

Move table from one tablespace to another using BRTOOLS


Procedure :

BR*Tools main menu

 1 = Instance management
 2 - Space management
 3 - Segment management
 4 - Backup and database copy
 5 - Restore and recovery
 6 - Check and verification
 7 - Database statistics
 8 - Additional functions
 9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2020-04-07 08:43:07
BR0663I Your choice: '3'

BR0280I BRTOOLS time stamp: 2020-04-07 08:43:07
BR0656I Choice menu 7 - please make a selection
-------------------------------------------------------------------------------
Database segment management

 1 = Reorganize tables
 2 - Rebuild indexes
 3 - Export tables
 4 - Import tables
 5 - Alter tables
 6 - Alter indexes
 7 - Additional segment functions
 8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
1
BR0280I BRTOOLS time stamp: 2020-04-07 08:43:13
BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2020-04-07 08:43:13
BR0657I Input menu 91 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for reorganization of tables

 1 - BRSPACE profile (profile) ...... [initLDD.sap]
 2 - Database user/password (user) .. [/]
 3 ~ Reorganization action (action) . []
 4 ~ Tablespace names (tablespace) .. []
 5 ~ Table owner (owner) ............ []
 6 ~ Table names (table) ............ []
 7 ~ Table partitions (tabpart) ..... []
 8 - Confirmation mode (confirm) .... [yes]
 9 - Extended output (output) ....... [no]
10 - Scrolling line count (scroll) .. [20]
11 - Message language (language) .... [E]
12 - BRSPACE command line (command) . [-p initLDD.sap -s 20 -l E -f tbreorg]

Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
6
BR0280I BRTOOLS time stamp: 2020-04-07 08:43:22
BR0663I Your choice: '6'
BR0681I Enter string value for "table" []:
TTREE_FLNK
BR0280I BRTOOLS time stamp: 2020-04-07 08:43:37
BR0683I New value for "table": 'TTREE_FLNK'

BR0280I BRTOOLS time stamp: 2020-04-07 08:43:37
BR0657I Input menu 91 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for reorganization of tables

 1 - BRSPACE profile (profile) ...... [initLDD.sap]
 2 - Database user/password (user) .. [/]
 3 ~ Reorganization action (action) . []
 4 ~ Tablespace names (tablespace) .. []
 5 ~ Table owner (owner) ............ []
 6 ~ Table names (table) ............ [TTREE_FLNK]
 7 ~ Table partitions (tabpart) ..... []
 8 - Confirmation mode (confirm) .... [yes]
 9 - Extended output (output) ....... [no]
10 - Scrolling line count (scroll) .. [20]
11 - Message language (language) .... [E]
12 - BRSPACE command line (command) . [-p initLDD.sap -s 20 -l E -f tbreorg -t "TTREE_FLNK"]

Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0657I Input menu 353 - please enter/check input values
-------------------------------------------------------------------------------
Options for reorganization of tables: SAPSR3.TTREE_FLNK (degree 1)

 1 * Reorganization action (action) ............ [reorg]
 2 - Reorganization mode (mode) ................ [online]
 3 - Create DDL statements (ddl) ............... [yes]
 4 ~ New destination tablespace (newts) ........ []
 5 ~ Separate index tablespace (indts) ......... []
 6 - Parallel threads (parallel) ............... [1]
 7 ~ Table/index parallel degree (degree) ...... []
 8 ~ Category of initial extent size (initial) . []
 9 ~ Sort by fields of index (sortind) ......... []
10 # Index for IOT conversion (iotind) ......... [FIRST]
11 - Compression action (compress) ............. [none]
12 # LOB compression degree (lobcompr) ......... [medium]
13 # Index compression method (indcompr) ....... []

Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
BR0280I BRSPACE time stamp: 2020-04-05 22:10:08
BR0663I Your choice: '4'
BR0681I Enter string value for "newts" []:
BR0280I BRSPACE time stamp: 2020-04-05 22:10:13
BR0683I New value for "newts": 'PSAPSR3740X'

BR0280I BRSPACE time stamp: 2020-04-05 22:10:13
BR0657I Input menu 353 - please enter/check input values
-------------------------------------------------------------------------------
Options for reorganization of tables: SAPSR3.TTREE_FLNK (degree 1)

 1 * Reorganization action (action) ............ [reorg]
 2 - Reorganization mode (mode) ................ [online]
 3 - Create DDL statements (ddl) ............... [yes]
 4 ~ New destination tablespace (newts) ........ [PSAPSR3740X]
 5 ~ Separate index tablespace (indts) ......... []
 6 - Parallel threads (parallel) ............... [1]
 7 ~ Table/index parallel degree (degree) ...... []
 8 ~ Category of initial extent size (initial) . []
 9 ~ Sort by fields of index (sortind) ......... []
10 # Index for IOT conversion (iotind) ......... [FIRST]
11 - Compression action (compress) ............. [none]
12 # LOB compression degree (lobcompr) ......... [medium]
13 # Index compression method (indcompr) ....... []

Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
BR0280I BRSPACE time stamp: 2020-04-05 22:10:14
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2020-04-05 22:10:14
BR1108I Checking tables for reorganization...

BR0280I BRSPACE time stamp: 2020-04-05 22:10:14
BR1112I Number of tables selected/skipLDD for reorganization: 1/0

BR0280I BRSPACE time stamp: 2020-04-05 22:10:14
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
BR0280I BRSPACE time stamp: 2020-04-05 22:10:16
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0370I Directory /oracle/LDD/sapreorg/sfdmwqwt created

BR0280I BRSPACE time stamp: 2020-04-05 22:10:16
BR1101I Starting 'online' table reorganization...
BR0280I BRSPACE time stamp: 2020-04-05 22:10:16
BR1124I Starting 'online' reorganization of table SAPSR3.TTREE_FLNK ...
BR0280I BRSPACE time stamp: 2020-04-05 22:10:17
BR1105I Table SAPSR3.TTREE_FLNK reorganized successfully

BR0280I BRSPACE time stamp: 2020-04-05 22:10:17
BR1141I 1 of 1 table processed - 3373 of 3373 rows done
BR0204I Percentage done: 100.00%, estimated end time: 22:10
BR0001I **************************************************

BR0280I BRSPACE time stamp: 2020-04-05 22:10:17
BR1102I Number of tables reorganized successfully: 1

BR1142I Tables with the longest duration of reorganization for owner SAPSR3

  Pos. Owner    Table                                 Rows  Duration
                                                              [m:s]
    1  SAPSR3   TTREE_FLNK                            3373     0:01

BR0280I BRSPACE time stamp: 2020-04-05 22:10:17
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
BR0280I BRSPACE time stamp: 2020-04-05 22:10:33
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2020-04-05 22:10:33
BR1022I Number of tables processed: 1
BR1003I BRSPACE function 'tbreorg' completed

BR1008I End of BRSPACE processing: sfdmwqwt.tbr 2020-04-05 22:10:33
BR0280I BRSPACE time stamp: 2020-04-05 22:10:33
BR1005I BRSPACE completed successfully

Suggestion :
Always have full successfully backup of the system.
Make sure table your moving should have appropriate TABART association.

Saturday, April 4, 2020

ORA-01012: not logged on for SAP System


Symptom :

While starting the database you may get the error ORA-01012 not logged on



Solution:

This error usually occur because of  orphaned shared memory segment with user oracle or ora<sid>.

In order to resolve the issue run the command ipcs or sysresv

To remove the these shared segement use command ipcrm -m <shmid>

Example :
ipcrm -m 1690043378

Suggestion:
Do not run this command when system is up and running that may lead to crash your database.





Friday, April 3, 2020

How To Enable \ Disable the Authentication Type Dropdown field in Fiorified BI Launchpad page


Procedure:

  1. On a default Tomcat installation, navigate to the FioriBI.properties file in the default directory of the Web application:
    • Default location: <Installation Directory>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\warfiles\webapps\BOE\WEB-INF\config\default
  2. Make a copy of the FioriBI.properties file and place it in the custom directory of the Web application:
    • Custom Location: <Installation Directory>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\warfiles\webapps\BOE\WEB-INF\config\custom
  3. Modify FioriBI.properties to enable the authentication drop down:
    • Find authentication.visible=false and change to authentication.visible=true
  4. Save the FioriBI.properties file

Note:

  • In BI 4.2 SP4, the properties file is called Bing.properties



Suggestion:


  • Installation directory path may differ in linux system <installdir>\sap_bobj\...
  • Shutdown the Tomcat before making changes.
  • Always clear the client system browser cache after the successful restart of the tomcat.

How To Enable \ Disable the Authentication Type Dropdown field in BI Launchpad


Procedure :


  • Navigate to the default BOE webapp directory in Tomcat (i.e. <installdir>\SAP BusinessObjects\Tomcat<version>\webapps\BOE\WEB-INF\config\default)
  • Copy the BIlaunchpad.properties to the custom directory (i.e. <installdir>\SAP BusinessObjects\Tomcat<version>\webapps\BOE\WEB-INF\config\custom)
  • Find the authentication.visible=false parameterChange the value to authentication.visible=true (Set this to false to disable the authentication field).
  • Save the changes to the modified file
  • Restart Tomcat for the changes to take effect
  • Repeat 1-6 on all Tomcats in the environment
  • Copy the BIlaunchpad.properties file to <installdir>\SAP BusinessObjects Enterprise XI 4.0\warfiles\webapps\BOE\WEB-INF\config\custom to retain the change through upgrades



Suggestion:
  • Installation directory path may differ in linux system <installdir>\sap_bobj\...
  • Shutdown the Tomcat before making changes.
  • Always clear the client system browser cache after the successful restart of the tomcat.