shell in a jar

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 Debugger and activate. cutoff is at CWBNTREASON and after that can use SE11 Actuvate using SE84: Domains CWBCIATTR_ID STricture IMP_TEST_CORR_INSTRUCTION Table CWBCINSTATTR - x Table Type CWBCI_T_ATTR Structure CWBNTKEYTSTAMP Data Element CWBNTREASON -- beyond this, can remove all breakpoints and use SE11 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_O...

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

  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

 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...

 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...

  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

  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

  Requirement : An SAP server, with a single Productive client shared by multiple company codes. Each CoCode would have their own domain (FQDN), and any email send out, for example PO to vendors, are to be sent using each individual CoCode SMTP mail server. Solution Steps: 1. Configure multiple SMTP nodes in Tx SCOT, limiting each node with a Sender Group 2. Set different Sender Group (CDG) parameters for each user of each CoCode (Tx SU01 > Parameters) 3. Test using SCOT's Routing Test feature 4. Profit Detail Step: Logon to SAP system and configure multiple SMTP Node, can use  Continue with SCOT Wizard. Once you get multiple Nodes (as per below screenshot), double click any of them,  In this example, we double click on the "SECOND" node. And then click on "Set" button for the address type you want to configure (that would most probably be for INT type) And click the Pencil icon for setting the Sender Group Here we can set based on FQDN or any string. We are ...

 Refer to SAP note 1592575 - Recreating Secstore.properties and secstore.key for 7.00/7.01/7.02 J2EE Netweaver systems Download the attachments. BEWARE: THE POWERPOINT CONTAINS INCORRECT SYNTAX. BEWARE: THE LAST COMMAND IN THE TXT FILE HAS A TYPO. the steps in that note might not directly rrelfectted here. but these steps are valid. Exmaple of executions as below: # java -classpath tc_sec_secstorefs.jar:exception.jar:iaik_jce.jar:logging.jar com.sap.security.core.server.secstorefs.SecStoreFS create -s ECD -f Sec.properties -k sec.key -enc -p Password1 SAP Secure Store in the File System - Copyright (c) 2003 SAP AG Store with encryption and a key phrase created. # java -classpath tc_sec_secstorefs.jar:exception.jar:iaik_jce.jar:logging.jar com.sap.security.core.server.secstorefs.SecStoreFS insert -s ECD -f Sec.properties -k sec.key admin/user/ECD SAPSR3DB SAP Secure Store in the File System - Copyright (c) 2003 SAP AG Key/value pair inserted. # java -classpath tc_sec_secstorefs...

  create trigger logon_denied_to_alert after servererror on database declare message varchar2(4000); begin select 'ip='||sys_context('userenv','ip_address')||',host='||sys_context('userenv','host')||',osuser='||SYS_CONTEXT ('USERENV', 'OS_USER') into message from dual; IF (ora_is_servererror(1017)) THEN message := to_char(sysdate,'Dy Mon dd HH24:MI:SS YYYY') || ' logon denied for ' || message; sys.dbms_system.ksdwrt(2,message); end if; end; / === And to view where the trace file is: G:\oracle\diag\rdbms\syp\syp\trace>sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 14 12:09:14 2020 Copyright (c) 1982, 2017, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> show parameter background NAME                   ...

 Software Units or Usage Types or the new name Product Instance All same thing, but different names. Example in NW JAVA - ADS or EP Core or Enterpriuse Portal Go To URL: http://fqdn:port/utl/SLDInstancesDetailedInfo.jsp Old URL:  http://<host>:<http_port>/utl/UsageTypesInfo Some side reference:  1793486 - Installing additional usage types in existing SAP systems using SUM //alak

  Just my own notes: Ref: 2573790 - Installation, Support and Availability of the SAP NetWeaver RFC Library 7.50 2573953 - Compiling and Linking RFC Programs with the SAP NetWeaver RFC SDK 7.50 Compiling: cd demo/ clang++ -std=c++11 -DSAPwithUNICODE -I../include -c -o sflightClient.o sflightClient.c clang++ -o sflightClient sflightClient.o ../lib/libsapnwrfc.dylib ../lib/libsapucum.dylib And running it: awes0me@Niks-MacBook-Pro demo % ./sflightClient /H/saprouter.com/S/3299/H/172.16.10.71 00 BPINST Welcome1 100 EN Logging in...  ...done Caching DDIC metadata...  ...done Please select an Airline: AA     American Airlines AB     Air Berlin AC     Air Canada AF     Air France AZ     Alitalia BA     British Airways CO     Continental Airlines DL     Delta Airlines FJ     Air Pacific JL     Japan Airlines LH    ...

 Had some issue in compiling node-rfc on MacOS 10.15.6 Haven't had that sorted out But at least i have my SAP NW RFC SDK installed correctly on my Mac.. VERY useful info from: https://github.com/SAP/node-rfc/issues/143 https://github.com/SAP/node-rfc/issues/140 Snippets: As a workaround you can: Replace modified nwrfcsdk libs, with SAP original libs, in /usr/local/nwrfcsdk folder Fix  sapnwrfc.node  @rpaths to @loader_paths: $ cd lib \b inding $ install_name_tool -change @rpath/libsapnwrfc.dylib @loader_path/libsapnwrfc.dylib sapnwrfc.node $ install_name_tool -change @rpath/libsapucum.dylib @loader_path/libsapucum.dylib sapnwrfc.node To verify: $ otool -L sapnwrfc.node (py380) master ✱ sapnwrfc.node: @rpath/sapnwrfc.node (compatibility version 0.0.0, current version 0.0.0) @loader_path/libsapnwrfc.dylib (compatibility version 0.0.0, current version 0.0.0) @loader_path/...

Had this issue where certain apps calls internal hostnames or internal FQDN when clicking or spawning webdynpro URL or any calling of internally hosted attachment. To change this setting, general steps as below: Check the app is using which local Alias - is it LOCAL or S4PS or S4FIn or whatever Check in /UI2/V_ALIASMAP / /UI2/V_ALIASCAT that alis is mapped to which alias. Check in SM59 under HTTP Connections to ABAP System if let say the Alias name is LOCAL, so there should be three LOCAL_xx created, which are: LOCAL_HTTP LOCAL_HTTPS LOCAL_HTTPT SO change for each of this, to the correct FQDN or hostname Hope this helps someone. //alak

Some usef=ul commands: route print - the initial part of the output shows the nwtrok interface indexes and middle part show the NICs metrix and gateway priority netsh int ipv4 show interfaces - shows list of NICs with MTUm, index and Metric,. Powershell: Get-WMIObject Win32_networkadapter | Select-Object Name, AdapterType, InterfaceIndex | Format-List Shows index of network cards Powershell:  Get-NetIpInterface Get info of Index, MTU and Mteric of all NICs SAP related Notes: 1568249 - How to Change Network adapter priority in Windows 1841151 - Windows Server 2012 (and higher) - different NIC order 2109662 - Windows returns wrong IP address as source IP SAP on VMware related: 2161991 - VMware vSphere configuration guidelines //alak

Had a case where i need to sync up /hana/data dn /hana/log to a whole new disk.. i used rsync, but f-up the permission part.. so here's a note to myself rsync -rlptgoDHAX <source-dir> <target-dir> You want the -p flag: -p, --perms preserve permissions I tend to always use the -a flag, which is an aggregation of -p and several other useful ones: -a, --archive archive mode; equals -rlptgoD (no -H,-A,-X) -H, --hard-links Preserve hard links -A, --acls This option causes rsync to update the destination ACLs to be the same as the source ACLs. The option also implies --perms. The source and destination systems must have compatible ACL entries for this option to work properly. See the --fake-super option for a way to backup and restore ACLs that are not compatible. -X, --xattrs This option causes rsync to update the destination extended attributes to be the same as the source ones. For systems that suppor...

SOme examples i got from Twitterr: .container {     display: grid     place-iitems: center } {      display: block;      margin: auto; } {      display: flex;      justify-content: center;      align-items: center; } {      width: 50%;      margin: 0 25%; } {      text-align: center; } {      position: absolute;      top: 50%;      left: 50%;      transform: translate(-50%, -50%); } {     margin-left: auto;     margin-righ: auto;     width: 960px; /*example*/ } //alak

A VB script, i forgot where i got it. === '****************************************************************** ' naam: Cleanup.vbs ' function: ' - Cleanup old files depending on the age of x days ' - Check for file extension ' - Possible to recurse in subfolders ' - For clustered drives, will check first if the drive exists on that server ' author: SDR '****************************************************************** Option Explicit Dim wshShell Dim FilePath, Retention, FileFilter, FilterExt, SubFilter Dim fso, Folder, DriveLetter Set wshShell = wscript.createobject( "wscript.shell" ) Set fso = CreateObject( "Scripting.FileSystemObject" ) '******************************************************************* ' Fill in below variables ' ex. ' FilePath = "D:\BACKUP" ' Retention = 2 ' note: Retention is in days ' If you need to filter by extention...

User administration page in Solution Manager. Solution Manager has a lot of scenarios and use cases, and all of them require different roles/authorizations to be used. We can find the template users in this administration page, together with their use-case, so we can activate and use the correct roles for the different scenario’s: http://solman.customer.local:port/sap/bc/webdynpro/sap/wd_sise_centralusermgmt?SCENARIO=X&sap-language=EN# Below screenshot is from Solution manager 7.2 FP 09 Kudos Stijn de Regge //alak

1. Shutdown both HANA DB and S/4HANA Applications in S4H.customer.local 2. As user root, backup the /etc/ntp.conf file in S4H.customer.local 3. Run the ntpdate -u command to update the machine clock.    e.g.: ntpdate -u 192.11.111.22 4. Open the /etc/ntp.conf file and add the NTP server: 192.11.111.22. Add the line below:    server 192.11.111.22  mode 5 prefer 5. Restart the NTP Daemon using the command (as user root):     systemctl restart ntpd 6. Check the clock settings 7. Check the status of the ntpd daemon     systemctl status ntpd 7. Restart both HANA DB and S/4HANA Applications in S4H.customer.local Kudos to Alvin Domanico and Dormal Benoit /alak