Posts

SAP SystemCopy - Activation of TCI Notes, DigiSIgn Gone Wrong

Backgroud: Source was ECC6 EHP6 / Oracle 11.2 / Windows / Non-Unicode, and TCI and DigiSig and dS/4 RC Note already implemented Target: ECC6 EHP6 / Sybase ASE 16 / Windows / Unicode Issue: Post system copy, ABAP dumps all over the place, SE11, SE38, SNOTE... Related notes: 2750714 - SYNTAX_ERROR: Type "CWBCI_T_ATTR" is unknown 2861287 - Fixing syntax errors caused by missing types And below are the objects needed ABAP Dbugger and activate. cutoff i at CWBNTREASON and after that can use SE11 Domains CWBCIATTR_ID Table Type CWBCI_T_ATTR Table CWBCINSTATTR - x Structure CWBNTKEYTSTAMP Data Element CWBNTREASON -- Table CWB_FILE_NAME Table CWB_SIZE_IN_BYTE Table CWB_NOTE_URL Table CWB_DWNLD_PROC Table CWB_PROC Table CWB_T_NOTE Data Type SCWB_S_NO_PATCHLEVEL Data Type SCWB_T_NO_PATCHLEVEL Table TT_SCWB_PATCH Data Type CWBCI_S_LIFECYCLE_OBJECT Data Type CWBCI_T_LIFECYCLE_OBJECTS Data Type CWBCI_DE_LIFECYCLE_OPERATION Data Type SCWB_OCSCOMPLVL Data Type TT_SCWB_OCSCOMPLVL Data Type N

SUSE Documentation, Guides for SAP Application and SAP HANA Clustering

 Can refer here: https://documentation.suse.com/sbp/all/#redirectmsg or SAP specific: https://documentation.suse.com/sbp/sap/ //alak

BR0253E errno 5: Access is denied. BRTools errors occur when accessing "database" directory

  Env was W2K8 R3 Oracle 11.2.0.3 just updated to brtools PL 42 As per blog: https://abrahambasis.blogspot.com/2019/02/brtools-errors-occur-when-accessing.html Executed  brconnect -u / -c -f check -SFP but still issue, so see te brconnect logs and manually execute cacls cacls <backup directory> /E /T /G <GROUP>:F cacls <backup directory> /E /T /G <USER>:F //alak

Quick Dirty Script for Checking Oracle Data Gurad Gap and Emailing it

 Situation: primary DB: prd_CCC standby DB: prd_WWW file 1: gap-check.bat @echo off cls echo. echo. echo This script checks for Archive Logs at prd_ccc and Applied Logs at prd_www echo. echo Querying prd_ccc (Primary) echo select max(sequence#) "Primary" from v$archived_log where archived='YES';|sqlplus -s / as sysdba echo Querying prd_www (Standby) echo select max(sequence#) "Standby" from v$archived_log where applied='YES';|sqlplus -s / as sysdba echo. DGMGRL / "show configuration" date /t && time /t && hostname && whoami file 2: emailer.ps1 $Username      = "username" $EmailPassword = "password" $today = Get-Date $Username = $Username $EmailTo = "adam@jasabyte.com"  $EmailFrom = "server@jasabyte.com" $Body = Get-Content .\status.log -Raw $Subject = "PRIMARY/STANDBY DB GAP - $today" $SMTPServer = "mail.smtp2go.com"  $SMTPMessage = New-Object System.Net.Mai

SAP Client Copy Error: Errors occurred during export of container object FINB-TR-DERIVATION

 Reference from: https://www.consultoria-sap.com/2010/03/client-copy-derivation-rule-tables-are.html TL;DR - Execute report ABADRCHECK with selected 'DELSTEPS' //alak ==== Client copy is completed with status "Post-Processing Required". There is an error in log for object FINB-TR-DERIVATION: DA300 "No active nametab exists for *some db table*" Name of db table is usually with naming convention: xxyyyysssmmmnnnn (xx - application class, yyyy - strategy ID, sss - system indicator, mmm - client, nnnn - sequence number) These db tables are part of some instance of derivation tool in your system and are used to store Derivation Rule Values. Other terms ABADR, FINB_TR_CC_EXIT, FINB_TR_CC_EXIT_TARGET, DA 300, DA300, CC, SCC9, SCCL, SCC3 Reason and Prerequisites During processing CC there was huge workload into your system. CC processcreates new tables to store copied derivation rules. This is done in parallel asynchronous process. But due to workload into system, t

SAP MAXDB Log Overwrite

  Logon as SIDadm in my case is windows run elevated command prompt Microsoft Windows [Version 10.0.17763.2366] (c) 2018 Microsoft Corporation. All rights reserved. C:\Windows\system32>color f1 C:\Windows\system32>dbmcli -d XYZ -u SUPERDBA,Pass#1 -c db_execute set log auto overwrite on OK C:\Windows\system32>dbmcli -d XYZ -u SUPERDBA,Pass#1 -c sql_execute select automaticoverwrite from loginformation OK END 'YES' C:\Windows\system32> //alak

Guided steps to help enable SNOTE for TCI and Digitally signed SAP Notes

  SAP Note 2836302 brings a report (RCWB_TCI_DIGITSIGN_AUTOMATION) that provides guided steps to help you enable SNOTE for TCI and Digitally signed SAP Notes. This report also guides you with the configuration steps based on your SAP_BASIS release From:  https://blogs.sap.com/2020/07/24/enabling-and-using-snote-for-digitally-signed-sap-notes/ //alak