FAIL: HTTP Error, HTTP/1.1 401 Unauthorized - While stopping HANA DB

 

FAIL: HTTP Error, HTTP/1.1 401 Unauthorized - While stopping HANA DB.

Make sure the file is missing with command "ls -la /tmp/.sapstream5<NR>13"

If missing, then run "HDB proc" and take note of the sapstartsrv process id (PID)

Kill the sapstartsrv with command "kill -2 <PID of sapstartsrv>"

Run again "ls -la /tmp/.sapstream5<NR>13", the file should now be there

Stop the database

Hope this helps!!!

Abraham

S4HANA Data Migration Cockpit – 403 Forbidden Service Cannot be reached

Symptom

Transaction Code - LTMC

Data Migration Cockpit 

Troubleshooting 

Use LTMC  t-code , a web page opens with message a 403 Forbidden Service Cannot be reached

Solution :

Activate the below 3 services in SICF :

1. /sap/bc/webdynpro/sap/DMC_WDA
2. /sap/bc/webdynpro/sap/DMC_WDA_GAF/
3. /sap/bc/webdynpro/sap/DMC_WDA_DATA_MIG

Hope this helps!!!

Abraham

‘sapstartsrv’ service not started

Symptom

‘sapstartsrv’ service not started  after system installation

Troubleshooting 

Check if the service is started on the server:

ps -ef |grep sapstartsrv

On your local HANA Machine execute 

1. /usr/sap/hostctrl/exe/sapcontrol -host <you host> -nr <instance number> -function GetProcessList

2. open a Browser and go to: http://<your host>:5<instancenumber>13/?wsdl

Solution :

If the port is not open open the port 5<instancenumber>13

Hope this helps!!!

Abraham

BRBACKUP error message BR0282E

Symptom

pid = 2884) (1/18/2020 4:31:55 PM) <parameter_file> is added for option "-r".

(pid = 2884) (1/18/2020 4:31:55 PM) nsrsapsv_generate_brexec_from_parm_list(): Set BR_EXEC parm     BR_EXEC = brbackup -m all -t online -d util_file_online -r E:\oracle\GEP\12102\database\tmp_2884.utl -p E:\oracle\GEP\12102\database\initgep.sap -a -sd -d util_file -r E:\oracle\GEP\12102\database\tmp_2884.utl -p E:\oracle\GEP\12102\database\initgep.sap

(pid = 2884) (1/18/2020 4:31:55 PM) calling get_user_handle_nt().

(pid = 2884) (1/18/2020 4:31:55 PM) nsrsapsv started by savegrp as user gepadm.

(pid = 2884) (1/18/2020 4:31:55 PM) OS_USR_PASSWD in NMSAP config file is set to gepadm. Matching.

(pid = 2884) (1/18/2020 4:31:55 PM) success = 0; new_context = 0d.

(pid = 2884) (1/18/2020 4:31:55 PM) spawning process: brbackup.

BR0051I BRBACKUP 7.00 (40)

BR0282E Directory 'X:\oracle\GEP\sapbackup' not found

BR0182E Checking parameter/option 'backup_root_dir' failed

BR0282E Directory 'X:\oracle\GEP\sapreorg' not found

BR0182E Checking parameter/option 'compress_dir' failed

BR0056I End of database backup: bfcycjqh.log 2020-01-18 16.31.55

BR0280I BRBACKUP time stamp: 2020-01-18 16.31.55

BR0054I BRBACKUP terminated with errors

(pid = 2884) (1/18/2020 4:31:55 PM) BRBACKUP exited with error status 2.

(pid = 2884) (1/18/2020 4:31:55 PM) brbackup exited on signal 22 with status 3.

(pid = 2884) (1/18/2020 4:32:20 PM) Backup Failed.

Environment 

SAP : EHP4  ECC 6

Oracle : 12

Kernel : 721

Resolution :

The BR*Tools 7.20 package can be used with all SAP releases that are based on Oracle database 10g or 11g.

The BR*Tools 7.40 package can be used with all SAP releases based on an Oracle 11g or 12c database or higher.

Updated BRTOOLS only 740 as kernel 740 is not compatible with SAP EHP 4 ECC 6 .

Refer Note : 12741

Hope this helps!!!

Abraham

Loading of 'SAPNTAB' import package: ERROR

Symptom

You are performing an installation or system copy using sapinst on Windows Server with Oracle 10.2 or Oracle 11.

R3load aborts at the import with an error message similar to the one below:

ERROR: 2011-09-28 15:28:29 com.sap.inst.migmon.LoadTask run

Loading of 'SAPNTAB' import package is interrupted with R3load error.

Process 'D:\usr\sap\FWK\SYS\exe\uc\NTAMD64\R3load.exe -i SAPNTAB.cmd -dbcodepage 4103 -l SAPNTAB.log -stop_on_error -loadprocedure fast' exited with return code -1.073.741.819. ('xC0000005 -> Access Violation)

For mode details see 'SAPNTAB.log' file.

Standard error output:

sapparam: sapargv(argc, argv) has not been called!

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

The windows eventlog viewer at the same time shows an entry such as:

Faulting application R3load.exe, version 7200.68.18.18535, time stamp 0x4cbe396a, faulting module OraOCIICUS10.dll, version 0.0.0.0, time stamp 0x44a53e2d, exception code 0xc0000005, fault offset 0x000000000009cc6e, process id 0xd3c, application start time 0x01cc7de280a7e5fe.

Import_monitor_JAVA.log

Loading of 'SAPNTAB' import package: ERROR

Loading of 'SAPSSEXC' import package: ERROR

Loading of 'SAPSPROT' import package: ERROR

SAPNTAB.log

(PRC) INFO: working directory "C:\Program Files\sapinst_instdir\NW711\ORA\INSTALL\STD\AS"

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: SQLFiles.LST not found

(SQL) INFO: Searching for SQL file C:\PI_DUMP\EXPORT\NW_711_INSTALLEXPORT\51036706\DATA_UNITS\EXP3\DB/SQLFiles.LST

(SQL) INFO: C:\PI_DUMP\EXPORT\NW_711_INSTALLEXPORT\51036706\DATA_UNITS\EXP3\DB/SQLFiles.LST not found

(SQL) INFO: Searching for SQL file SDIC.SQL

(SQL) INFO: SDIC.SQL not found

(SQL) INFO: Searching for SQL file C:\PI_DUMP\EXPORT\NW_711_INSTALLEXPORT\51036706\DATA_UNITS\EXP3\DB/ORA/SDIC.SQL

(SQL) INFO: C:\PI_DUMP\EXPORT\NW_711_INSTALLEXPORT\51036706\DATA_UNITS\EXP3\DB/ORA/SDIC.SQL not found

(DB) INFO: SVERS created #20191231132114

Reason and Prerequisites

There is a bug in the Oracle client software delivered with the installation kit.

Solution

Check note # 819829 on how to get and install the latest version of the Oracle Client software.

Merge the TSK file of the R3load package which has failed as described per note # 455195 and restart sapinst or the Migration Monitor from the step which failed.

Hope this helps!!!

Abraham

Symptom

Could not execute 'EXPORT REORG_LOCATIONS_EXPORT AS CSV INTO '/tmp'' SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

Solution

Execute with the same schema user and grant EXPORT in system privilege 

Hope this helps!!!

Abraham

Grant select privilege on table in sys schema

Symptom

SAP DBTech JDBC: [259]: invalid table name: REORG_PLAN_EXPORT: line 1 col 12 (at pos 11)

Could not execute 'CREATE TABLE REORG_PLAN_EXPORT AS (SELECT * FROM SYS.REORG_PLAN_)'

SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

Solution

You need select authorization on schema SYS in order to execute this.

If you want to grant select access on SYS schema then you can grant SAP_INTERNAL_HANA_SUPPORT role to the user

How to check GPFS file systems logs

1.How to check  GPFS file systems logs

1. Go to path /var/ad/ras
2. ls -latr|grep mmfs
3. You will find the below files :

mmfs.log.previous
mmfs.log.latest

2. Start the GPFS file system:

Command :mmsatrtup

3. To identify which nodes in the cluster have daemons up or down, issue:

mmgetstate -L -a

Hope this helps!!!

Abraham

Copy User Variants for Table Controls

Symptom

You want to copy a variant created by 1 user to other users.

Solution 

1. Use program RSTCX_COPY_TCVARIANT.

2. In se38 execute the program .

3. Provide the input details :

Program name : Program name of the t-code in which you want to set the variant

User : User who created the variant

Variant Name: name of the variant to be assigned

For User : List of users to whom variant has to be copied

Hope this helps!!!

Abraham

How do you cancel a running backup in HANA

To cancel a running backup, please use the following 3 SQL statements in HANA studio:

1. Get the backup_id of your running backup:

select BACKUP_ID from "SYS"."M_BACKUP_CATALOG" where entry_type_name = 'complete data backup' and state_name = 'running'  order by sys_start_time desc

2. Cancel the backup

backup cancel <backup_id>

3. Confirm the backup has cancelled

select state_name from "SYS"."M_BACKUP_CATALOG" where backup_id = <backup_id>

4. Check to  make sure there are no running backups still

select * from  "SYS"."M_BACKUP_CATALOG" where STATE_NAME = 'running';

If the backup still exists, you can try to cancel the thread through the commands:

ALTER SYSTEM CANCEL SESSION <Session_ID> ;

ALTER SYSTEM DISCONNECT SESSION <Session_ID> ;

From backend Linux

1. As per the SAP Note 2452735 confirm there are no backup currently running.

select * from "SYS"."M_BACKUP_CATALOG" where STATE_NAME = 'running';

2. Run the ps command to get the listing of zombie hdbbackint processes belonging to the database backup

ps -ef | grep hdbbackint | grep COMPLETE

Sending signal 9 using the "kill" command will destroy the process running on the client. 

kill -9 PID

where PID is the process id of the zombie hdbbackint process. 

You will need to be a root user to execute the kill command

Include authorization profile in a role

Steps how to include a authorization profile in a role.

1. T-code PFCG --->Give Role Name --->Eg: TEST_SAP_ALL
2. Create as single role .

3. Provide a description and Click on Authorization TAB

4. Save Now Yes

5. Click on Change Authorization Data

6.Do not Select template

7.

8.

9.

10.Then you can see the role has complete authorization.

11. Generate the profile using the generate button .

Hope this helps!!!

Abraham

Resource Usage Exceeds Limit ,Resource =Number Buffer

Symptom

Logs in SM21

Resource Usage Exceeds Limit (Resource =Number Buffer,Limit =1000,Curr=1099)

Server Resources are exhausted with high usage ,too many number buffer

Reason and Prerequisites

Current Number Range Buffer exceeded the allocated number 

Check T-code - SM56

Solution

1. Check which objects are having maximum number of entries.

Goto -->Entries

2.  Reset the number range buffer in SM56

Goto--> Number Range Buffer --> Reset

Also a system restart will clear the number range buffer 

Hope this helps!!!

Abraham

SAP HANA STUDIO Installation

Steps to install SAP HANA Studio - Windows

1.       https://launchpad.support.sap.com/#/softwarecenter

2.       Provide S-User Id and Password

3.       Support Packages and Patches à By Alphabetical Index(A-Z)à H àSAP HANA Platform EditionàSAP HANA PLATFORM EDIT 2.0àSAP HANA STUDIO àSAP HANA STUDIO2àSelect the OS àSelect the required SAR File à Download the file

4.       Create a folder in your C drive as HANA Studio and Copy the SAR file in it.

5.       Open Command prompt àSwitch to the HANA Studio Folder

6.       Extract the SAR file using command SAP CAR –xvf <NAME of SAR File>.SAR

This will take few minutes for extracting the files.

Download SAPCAR

7. Click on  hdbsetup.exe

8.Click Next 

9. Click Next

10. Click Install

11.Click Finish

Run SAP HANA STUDIO

1.       Go to Default installation directory à C:\Program Files\sap\hdbstudio

2. Double Click on hdbstudio.exe

3. It will open HANA Studio

4. Open Administration Console

5. Add system

Hope this helps!!!

Abraham

Upgrade BO 4.1 SP5 to BI 4.2 SP5

Update Media Download

SUPPORT PACKAGES AND PATCHES – B -> SBOP BI PLATFORM (ENTERPRISE)  -> SBOP BI PLATFORM 4.2 -> SBOP BI PLATFORM SERVERS 4.2

SUPPORT PACKAGES AND PATCHES – B -> SBOP BI PLATFORM (ENTERPRISE)  -> SBOP BI PLATFORM 4.2 -> SBOP BI PLATFORM CLIENTS 4.2

Upgrade Steps :

1. Stop instances- Server Intelligence and DB

2. Extract the SBOP  BI Platform Server files.

3.Prerequisite Check.

4. Nest starting with the update

5. Click Next,Accept the License Agreement

6. New licensce key message.

7. Provide the CMS and Administrator login Information

8.If you get a message as below , start the server intelligence and DB 

9.

10.

11. 

12.

13.

Hope this helps!!!

Abraham

Generate System info XML is missing

Symptom

Generate System info XML is missing

Reason and Prerequisites

Option SPAM->Utilities->Generate System info XML is missing

Solution

1. Update SPAM/SAINT to the latest version.

2. If incase the issue still exists , proceed as below.

3. SE38 ->Run Report RSLANG20 

4. If this is not successful and the option still is not visible.
5.Start Transaction -SE41
6. Program Name :"SAPMSPAM"
7.Status Field : enter "0100"
8.Click "Display"
9. Click the menu option "User Interface" -> "Activate"  ( or clicke the "Activate" icon)

Hope this helps!!!

Abraham

BI/BOBJ -The system is not configured for this application

Symptom

The system is not configured for this application.If you require configuration contact your system administrator.

Reason and Prerequisites

You have upgraded BI/Business Object system from 4.1 to 4.2

And now you are trying to login to the updated system BI system

Solution

1. Generate the license key for the newer version. (4.2)

2. Login to the CMC using administrator id .

3. Go to Lisence keys.

4. Delete the old license key and add the new key generated from service market place.

Hope this helps!!!

Abraham

No amount authorization For customers/vendors in Company Code :Message no. F5155

Symptom

No amount authorization For customers/vendors in Company Code :Message no. F5155

Solution

1. Go to T-code OLMR ->Authorization Management ->Define Tolerance groups.

2. Check if tolerance group is correctly mapped for each company code or not.

3. Also check if the user is mapped to that tolerance group or not .

OLMR ->Authorization Management ->Assign User Tolerance Group

Hope this helps!!!

Abraham

SUM:MAIN_POSTCLEAN/RUN_RSAIMMERGE_TRANSFER long running

Symptom

In the postprocessing module of an upgrade or an Enhancement Package installation, you notice extreme runtimes of the phase RUN_RSAIMMERGE_TRANSFER.

Reason and Prerequisites

In the phase RUN_RSAIMMERGE_TRANSFER, selects on the table E071 need to be performed.

On some customer databases these selects on the table E071 are very slow.

Solution

1. Recreate the index 1 on the table E071 (defined for the fields PGMID, OBJECT and OBJ_NAME).

2. Refresh the statistics for the table E071.

Alternatively, if creating an additional index is an option:

1. Create an index on the table E071 for the fields TRKORR, PGMID, OBJECT and OBJ_NAME.

2. Refresh the statistics for the table E071.

Repeat the phase RUN_RSAIMMERGE_TRANSFER.

Hope this helps!!!

Abraham

1909524 - "M_PREMA", "V_7BR_PREMA" and "V_T7BRAP" tables error in ACT_TRANS or ACT_UPG phase

Symptom

During upgrade process, the ACT_UPG phase terminates with DDIC ACTIVATION errors "TABLE XXXX was not activated" as per the below error message:

Directory:    <DIR_PUT>/SUM/abap/log
Name:         ACTUPG.ELG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DDIC ACTIVATION ERRORS and RETURN CODE in SAPAAAA731.ABC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


   3 EDT014XActivate dependent table "M_PREMA"
   2WEAD275 Foreign key "M_PREMA"-"BUKRS" (dependency factor "REF" is
   incorrect here)
   2WEAD275 Foreign key "M_PREMA"-"OBRA" (dependency factor "REF" is
   incorrect here)
    1EEDT354 Search field "M_PREMA"-"FILIA" not contained in search help
    attachment
   3 EDT015 Dependent table "M_PREMA" was not activated
   3 EDO525XActivate dependent view "M_PREMA"
   1 EDH202 Check dependent search help "PREMA"
   1 EDH103 Search help "PREMA" is consistent
   3 EMC763 Key field "T7BRAP"-"GRPBR" missing
   2WEMC732 All fields are evaluated as key field
   3 EMC726 View must be created in the database
   3 EDO526 View was activated with warnings"M_PREMA"
    1EEDO519 "Table" "M_PREMA" could not be activated


   3 EDT014XActivate dependent table "V_7BR_PREMA"
   2WEAD275 Foreign key "V_7BR_PREMA"-"BUKRS" (dependency factor "REF" is
   incorrect here)
   2WEAD275 Foreign key "V_7BR_PREMA"-"OBRA" (dependency factor "REF" is
   incorrect here)
    1EEDT354 Search field "V_7BR_PREMA"-"FILIA" not contained in search help
    attachment
   3EDT015 Dependent table "V_7BR_PREMA" was not activated

   3 EDO525XActivate dependent view "V_7BR_PREMA"
   1 EDH202 Check dependent search help "HRPADBRA"
   1 EDH103 Search help "HRPADBRA" is consistent
   3 EMC763 Key field "T7BRAP"-"GRPBR" missing
   2WEMC732 All fields are evaluated as key field
   3 EMC726 View must be created in the database
   3 EDO526 View was activated with warnings"V_7BR_PREMA"
    1EEDO519 "Table" "V_7BR_PREMA" could not be activated

   3 EDT014XActivate dependent table "V_T7BRAP"
   1EEDT354 Search field "V_T7BRAP"-"FILIA" not contained in search help
   attachment
   3 EDT015 Dependent table "V_T7BRAP" was not activated
   3 EDO525XActivate dependent view "V_T7BRAP"
    1EEDO519 "Table" "V_T7BRAP" could not be activated
   1 ETP111 exit code : "8"

Environment

ABAP System, Enhancement Package Installation, Release Upgrade.

Reproducing the Issue

Start SUM tool.
In ACT_UPG phase, the error occurs.
Cause
The root cause of the issue is some fields were removed from the table T7BRAP. This action is delivered by standard packages however this is not reflecting in other objects like M_PREMA.

On the other hand M_PREMA is a Match code object which is obsolete.

Resolution

You can ignore this error and continue with the upgrade only for the specified tables.

Continue the upgrade by choosing the option 'Accept non-severe errors and repeat phase MAIN_SHDRUN/ACT_UPG' in SUM tool.

Hope this helps!!!

Abraham

2596913 - ACT_UPG: indexes for table "J_1BNFE_ACTIVE" have identical fields

Symptom

During upgrade to EHP 7 for ERP 6.0, below errors happen in phase MAIN_SHDRUN/ACT_UPG for Table J_1BNFE_ACTIVE

EDT012XActivate table "J_1BNFE_ACTIVE"
1EEDT509 Indexes "009" and "H33" for table "J_1BNFE_ACTIVE" have identical fields
1EEAD010 "Is valid for following DB systems:" " " " " " "
1EEAD010 "HDB" "(" "SAP HANA Database" ")"
1EEDT509 Indexes "008" and "HBE" for table "J_1BNFE_ACTIVE" have identical fields
1EEAD010 "Is valid for following DB systems:" " " " " " "
1EEAD010 "HDB" "(" "SAP HANA Database" ")"
2WEDT135 Flag: 'Incorrect enhancement category' could not be updated
3 EDT013 Table "J_1BNFE_ACTIVE" was not activated
3 EDT014XActivate dependent table "J_1BNFE_ACTIVE"
3 EDT038 Activation of dependent table "J_1BNFE_ACTIVE" successful
1EEDO519X"Table" "J_1BNFE_ACTIVE" could not be activated

Environment

EHP7 for ERP 6.0

Cause
This is a bug that new version of index still exists despite the deletion request.

Resolution

Refer Note : 

2596913 - ACT_UPG: indexes for table "J_1BNFE_ACTIVE" have identical fields

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

As introduced in below note, you need to manually delete below indexes by SE11 in the shadow instance. After this you can continue the upgrade by repeat the phase from where it stops.

Note 1737650 - EHP7 for SAP ERP 6.0 SP Stacks - Release & Information Note

---------------------------------------------------------------
The ABAP Dictionary activation might fail due to duplicate indexes on table "J_1BNFE_ACTIVE". In that case delete indexes 008 and 009 in ABAP Dictionary and repeat the phase.
---------------------------------------------------------------

Hope this helps!!!

Abraham