SAP MAXDB : Export/Import through Loader utility

MAXDB Provides a powerful tool to perform Export/Import through Loader utility which is very useful in case of Heterogeneous System Copy.

There are some limitations to use Loadercli via command line as it require same versions on source & target to perform Export/Import.

If you are using different OS on source & target then Loadercli is not a good option as it’s very difficult to keep same versions on both side.

Loadercli will perform the same action smoothly as it works with MAXDB Studio where you can connect the both source & target DB’s & use same loadercli to perform export/import in the DB. You can export the entire SCHEMA or Tables from source & import the same in Target SCHEMA.

Loader requires SQL login to respective SCHEMA for export/import. You can do a SQL login by Right Click on DB & then SAPUSER SCHEMA name is visible. Expand the SAPUSER schema & right click on Schema or Tables —- select export. it will ask you some options & export the entire contents on your local PC.

The same loadercli can use for importing in Target Schema, do a SQL login in Target Schema, select SAPUSER schema & click on schema — Right Click & Import. Give the correct location & it will show the exported contents & you can select the options as requires & perform the import.

SAP official documentation –
https://maxdb.sap.com/doc/7_7/71/33b900661747cdad48a08b01aa06b2/content.htm

I will share the screenshots of export/import in next post for more clarification.

SAP HANA 2.0 Cockpit Installation and Configuration

Recently for testing purpose, I have installed SAP HANA 2.0 Cockpit on my Google Cloud Virtual Machine by following the below steps –

SAP HANA 2.0 Cockpit InstallationSAP HANA 2.0 Cockpit Installation

SAP HANA Cockpit install with the HANA DB which also requires by default mount point – /hana/shared

However i have also summarised the below steps which are useful for a newbie to install the same –

1. Download SAP HANA Cockpit 2.0 from SAP Support Portal
2. SAP HANA Cockpit come with SAP HANA DB & can be install on separate system
3. UNCAR the SAR file of SAP HANA Cockpit & Install with ./hdblcm command
4. Default Port for SAP HANA Cockpit – 51029
5. Default Port for SAP HANA XSA – 330 – i.e. – 39630
6. Default Instance Number for SAP HANA Cockpit – 96
7. Default first time user login in HANA Cockpit – COCKPIT_ADMIN with Master Password (Created during installation)
8. SAP HANA Cockpit installation use default installation directory – /hana/shared

Note – Default Installation Directory can be change by adding extra parameter while running ./hdblcm

However when i ran ./hdblcm, i got the below error as SIGNATURE.SMF file is missing in the installation directory.

File ‘SIGNATURE.SMF’ cannot be found in the SAP HANA Database installation kit. To include the signature when extracting the installation kit from a .SAR archive, use the SAPCAR option: -manifest SIGNATURE.SMF You can ignore this error and continue with the execution by passing the ignore option ‘check_signature_file’ to hdblcm, started as root. See SAP note 2078425, section ‘How to prepare SAP HANA packages for installation or update’ for instructions how to prepare packages for update or implications of ignoring this error.

Then i followed the above given SAP Note & ignore the file by passing the below command –

./hdblcm -sh –ignore=check_signature_file

Above is the workaround, I would suggest to extract the SIGNATURE.SMF file as per SAP Note & run the installation.

Once I have successfully installed the SAP HANA Cockpit, installer given me below 2 URL to access the same.

Launch SAP HANA cockpit by opening https://hanabox1.us-east1-b.c.hana-273005:51027
Launch SAP HANA cockpit manager by opening https://hanabox1.us-east1-b.c.hana-273005.internal:51029

However as I am running the Cockpit in Google Cloud VM with Public IP, i want to access the same from outside world & I changed the above hostname with Google Public IP but still page is not opening & throwing the error – “Can’t reach the Page”

I tried by both ports – SAP HANA Cockpit & XSA URL but both are failing.

While digging into more in the system I have identified that there is an change requires in XSCONTROLLER.INI file on below location –

/usr/sap/SID/SYS/global/hdb/custom/config

Make a copy of xscontroller.ini & change the below 2 parameter by giving your PUBLIC IP –

default_domain = PUBLIC IP
api_url = https://PUBLIC IP:39630

save the file & restart the HANA instance.

Please Note – I am using Dynamic Public IP so whenever I shut down & start the Google Cloud VM, it change the Public IP & I need to update the same again.

Once it’s start successfully, wait for sometime & check the XSA URL

https://PUBLIC IP:39630

Voila… Page is now opening & now you can login to HANA Cockpit & Manage your HANA DB’s.

SAP HANA Cockpit XSA
Page

Let me know if you find this useful.

SAP ADS Rendering Issue

Recently we have discovered that after configuration of ADS service in SAP Netweaver 7.40, we are facing rendering error while running report (SA38) – FP_CHECK_DESTINATION_SERVICE

We verified the configuration by going through multiple available SAP blogs but didn’t find the resolution of rendering error.

As per SAP note rendering errors occurs due to SAP Interactive forms credentials but we are not using the same & we have not configured any interactive forms but still it’s throwing errors.

By going through the multiple SAP Note, we have discovered that this issue is related to missing SUSE OS libraries which need to install & then restart the Java System or else restart the Adobe Document Service.

Helpful SAP Notes –

2215355 – Complementary analysis for ADS termination
2029940 – IFbA: Required additional RPM package for ADS on Linux

SAP Business Objects 4.1 SP07 Installation Error

Hello All,

During an Installation of SAP Business Objects 4.1 SP07 with DB2 11.1 Database, we have encountered an error after giving CMS DB & Port & click on Continue –

Database access error. Reason Loading shared object failed. First tried to load library db2 and failed because of error: [db2: cannot open shared object file: No such file or directory]. Second tried to load library libdb2.so and failed because of error: [/usr/lib64/libxml2.so.2: symbol gzopen64, version ZLIB_1.2.3.3 not defined in file libz.so.1 with link time reference]. (FWB 00090)

As this error is misleading where SAP suggest to perform some steps at DB2 level for SAP note search for BO 4.1 but in our case this error is something related to Library files which are missing in Installation Folder.

We found the solution in SAP BO 4.2 SAP notes which are listed below –

https://launchpad.support.sap.com/#/notes/2694951
https://launchpad.support.sap.com/#/notes/2689156

As per SAP Note – 2689156 – BI 4.2 SP05 installation failed with DB2 11.1 on Linux 7.3&7.4

Workaround:

Download the 3 files libxml2.so, libxml2.so.2, libxml2.so.2.9.5 from the attachments.
Place these 3 copied lib files in the dunit folder of the downloaded setup files of SBOP BI PLATFORM SERVER.
ex: BusinessObjectsServer/dunit/platform.services.cms.cpp.dbcheck-4.0-core-64. (So that we have both the compatible versions of libxml2.so and its dependents libz.so files in DU directory.)
Run the install setup.sh, It should smoothly proceed with the installation after replacing.

The above solution works like CHARM in our case & we have successfully installed BO 4.1 SP7.

I believe this post helps.

Microsoft Azure Administrator – AZ 103 Certified

I have cleared AZ 103 certification in Jan 2020 successfully & this will help us to understand the functionality of Azure.
There are lot of topics which need to cover for AZ103 Exam. I have gone through Udemy Course as well.
However Microsoft announced that from Mar 2020 , AZ103 will replace to AZ104.

some different topics which requires attention:

What is Azure Policy
Azure Subscription
Azure Baseline Resource
Azure Storage
Storage Explorer
Redundant Storage
blob storage
azure backup
power shell – AZVM
virtual networks – subnet
route table
express route
Network Security Groups
conditional access
AD identity protection
access review
azure AD connect
create custom role (power shell & CLI)
Network performance monitor
network watch – https://azurecitadel.com/infra/vdc/lab4/

Some LABS –
https://www.microsoft.com/handsonlabs/selfpacedlabs/details/SP-AZ100059
https://www.microsoft.com/handsonlabs/selfpacedlabs/details/AZ00034
https://www.microsoft.com/handsonlabs/selfpacedlabs/details/SP-AZ100002

OpenDX course – Very useful
https://openedx.microsoft.com/courses/course-v1:Microsoft+AZ-103.1+2019_T2/course/

you can find the good information here –

New AZ-104 Exam Replaces AZ-103 – What We Know!

SAP: Expiring CA’s Certificates

Recently we have seen that some standard CA’s certificates (Entrust, Telekom) are expiring from our landscape & that certificates are not even use in any functionality.

There is an standard SAP note, which explain whether you need to renew the same or not.

2776722 – Expiring CA’s certificates

if you want to renew the same then there is an website mentioned in this note & SAP clearly mentioned below –

The updated certificates must be acquired from the CA’s and must be downloaded from their official website, it is the customer’s responsibility to align with the vendor to download the correct certificate(s).

SAP: Warning – JAVA Code Cache is Full

Recently in Java – dev_serverx log file,we have seen multiple warning occurred as below –

J : [140083218769664] 01:32:31 ***Warning: Code cache is full: Try increasing the code cache size using -XX:ReservedCodeCacheSize=…
J : [140083218769664] 01:32:31 ***Warning: JIT stopped
J : [140083218769664] 01:32:31 ***Warning: JIT restarted

There is an Standard SAP note which is describing this situation & providing the multiple solutions –

2579836 – AS Java system has performance problem – FCAException – Best practices and tuning recommendations

Point No. 4 – Increase the code cache size to 1024 MB.

As per SAP, we need to increase the parameter ReservedCodeCacheSize to 1024M value but currently this parameter is not set in our system. it’s using the default 250M (Code Cache Size) value.

For Verification of the present code cache size & usage follow the below note –

2632653 – How to check present Code cache usage on SAP JVM

In my case, I am not able see Code Cache size via graphical tool then we use jvmmon tool to dump the code cache as below –

The SAP JVM Monitoring Tool jvmmon can be used to obtain the present value of the code cache. Steps are:
> Start the jvmmon
> Connect to the PID
> dump jit info
The output is written into the std_server file in the work directory. Click here for more information on the SAP JVM Monitoring Tool: jvmmon.

we did set this parameter in config tool as defined in SAP note & restart the whole cluster including DB & observe the performance of the system. it’s since more then a week, we didn’t see this Warning any more in dev_serverX log file.

Will wait for another month & see if this situation reoccurs & will update with next resolution.

SAP: JAVA System Performance Issue

Hello All,

Recently we have faced issue in our SAP Process Orchestration system where all DB connections were getting occupied after starting in few minutes.

We have identified the cause of this issue where 1 of our channel is sending thousands of messages to third party & due to delay in acknowledgment, it’s consumed all the DB process & system get hung.

We found that after even restart of application servers, DB connections were not getting destroyed automatically even though there enough DB connections are free at DB side. The issue is lying under application layer & below error is occurring Default Trace –

Exception of type com.sap.sql.log.OpenSQLException caught: No connection to data source SAPDB available. All 100 pooled connections are in use and 40 connection requests are currently waiting. The connection pool size might need to be adjusted..

Default DB Pool size = 100

There is an standard SAP note where SAP is suggesting to increase the value from 100 to 250 of respective parameter in Config Tool & restart the system. we tried the same but after restart 250 connections completely occupied & same issue was occurring.

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

PO team identified the channel & stop the channel temporarily to avoid the issue & system back to Normal. They have cleared the stuck message & restart the channel after some time.

Now from BASIS side our responsibility is to Monitor the DB connections to avoid the hanging situation. we found below URL to monitor the DB connections & also destroy the same if requires.

http:// hostname:port number/OpenSQLMonitors

The above URL is just like ST04 of any ABAP system & it’s very useful to monitor your critical SAP JAVA system regularly to avoid any unscheduled downtime.