Thursday, 8 October 2020

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

Tuesday, 21 July 2020

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

Tuesday, 4 February 2020

‘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

Monday, 20 January 2020

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



Thursday, 2 January 2020

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


Tuesday, 10 December 2019

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