Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

May 2019

Category: Applications on HANA

Day/Mo/DateWhatsApp message
Wed May 1[NEW] - SAP HANA Platform 2.0 SPS 04 documentation*
With the release of the SAP HANA Platform 2.0 SPS 04 documentation we have some new guides like:
SAP HANA Configuration Parameter Reference
SAP HANA Performance Guide for Developers
SAP HANA System Replication
Head towards this page to learn more:
https://help.sap.com/viewer/product/SAP_HANA_PLATFORM/2.0.04/en-US
Mon May 6SAP Note2600030 has a comprehensive list of all best practices on how to configure parameters to avoid performance/memory/CPU issues, terminations, corruptions etc. and keep your HANA system runnning efficiently.  Click: https://launchpad.support.sap.com/#/notes/2600030


Category: Hot-News

Day/Mo/DateWhatsApp message
Wed May 1[Hot-News] SAP HANA 2.0 SPS04 is not supported on RHEL 7.5
SPS04 requires SUSE 12.3 or higher and RHEL 7.4 or RHEL 7.6
Refer to SAP Note2235581 before scheduling an upgrade
https://launchpad.support.sap.com/#/notes/2235581


Category: Did You Know?

Day/Mo/DateWhatsApp message
Mon May 6Upgrading HANA to some revision in HANA 2.0? You must check if the upgrade path you intend to follow is supported.
Make sure you refer to SAP Note 1948334 - SAP HANA Database Update Paths for SAP HANA Maintenance Revisions before making any upgrade decisions:
https://launchpad.support.sap.com/#/notes/1948334


Category: Knowledge Repository

Day/Mo/DateWhatsApp message
Tue May 7You can find a comprehensive, regularly updated wiki on #SAPHANA System Replication here:
https://wiki.scn.sap.com/wiki/display/SAPHANA/System+Replication
Thu May 9New help page on Troubleshooting BW on HANA added to the SAP HANA Troubleshooting and Performance Analysis Guide.
Refer to this page for troubleshooting Table Redistribution, Consistency Checks, Query execution modes, Performance issues, Using RSRT, Frequently-used Transaction Codes, and details on more transactions that you can use to troubleshoot BW on HANA issues:
https://help.sap.com/viewer/bed8c14f9f024763b0777aa72b5436f6/2.0.04/en-US/04861b1e6bc64909be67909e429dcd27.html
Tue May 14New Guided Answers tree available on how to reduce the size of the table in SAP System Environment. This is a good reference document for table partitioning in a Business Suite or Business Warehouse environment.
https://gad5158842f.us2.hana.ondemand.com/dtp/viewer/#/tree/2268/actions/29304/?version=current
Thu May 16What do the different parameters in the configuration files actually do? Find out here:
https://help.sap.com/viewer/009e68bc5f3c440cb31823a3ec4bb95b/2.0.04/en-US/e28fbdf1024c40e1a97fca48380aad98.html
Tue May 21You can use procedure SYS.MEASURE_NETWORK_IO to measure the network performance from an HANA perspective, both in scale-out and system replication landscapes It is documented in SAP FAQ Note 2222200
https://launchpad.support.sap.com/#/notes/2222200
Thu May 23Seeing increased memory consumption for a query/overall system? You can trace which allocators are causing this using the steps documented in SAP note#2620830 - How To Activate SAP HANA Memory Allocator Traces
https://launchpad.support.sap.com/#/notes/2620830
Tue May 28SAP's Business tables on HANA are typically large and need to be partitioned appropriately to ensure SQL performance and delta merge operations are not affected. For SAP's recommendation on this process, see SAP note#2418299 - SAP HANA: Partitioning Best Practices / Examples for SAP Tables
https://launchpad.support.sap.com/#/notes/2418299
Thu May 30Have questions regarding HANA network troubleshooting? Refer to SAP note#2081065 - Troubleshooting SAP HANA Network

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

 


April 2019

Category: Applications on HANA

Day/Mo/DateWhatsApp message
Mon Apr 1Are you interested in knowing in #SAPHANA limits and possibilities for resource limitations? SAP Note 2154870 provides an overview of fix and configurable limitations in SAP HANA environments. https://launchpad.support.sap.com/#/notes/2154870
Wed Apr 3Ensure you are running #SAPHANA in line with SAP's Recommendations for your given operating system. For SLES installations review SAP Note 1944799 https://launchpad.support.sap.com/#/notes/1944799 For RHEL installations review SAP Note  2009879 https://launchpad.support.sap.com/#/notes/2009879
Mon Apr 8Curious about SAP SQL Data Warehousing with #SAPHANA? Read this 3 min blog by Klaus-Peter Sauer that gives you an overview, and has a comprehensive list of links for deeper dive into different topics in SQL DWH with HANA: https://blogs.sap.com/2017/12/19/sap-sql-data-warehousing-with-hana/
Wed Apr 10Bookmark the document: SAP BW on #SAPHANA & SAP HANA Smart Data Access https://archive.sap.com/documents/docs/DOC-52945 for links to articles on Configuration, Tips and Tricks, Official Documentation, Consulting notes etc.
Mon Apr 15Using Analysis 2.x with #SAPHANA? You need to bookmark this wiki for how-to, troubleshooting, etc: https://wiki.scn.sap.com/wiki/display/BI/Analysis+2x%3A++Using+SAP+HANA
Wed Apr 17Remember seeing something about a #SAPHANA topic on WhatsApp, but can't find it? A list of messages that have been previously broadcasted out can be found below: https://wiki.scn.sap.com/wiki/display/SAPHANA/SAP+HANA+WhatsApp+Broadcast+History 
Mon Apr 22Looking for a central note that lists all #SAPHANA traces and how to configure them?
Check out 2119087 - How-To: Configuring SAP HANA Traces
https://launchpad.support.sap.com/#/notes/2119087
Won Apr 29[NEW] SAP HANA 2.0 SPS 04 supports Multi-target replication supports the SAP HANA, active/active read-enabled option
https://blogs.sap.com/2019/04/10/new-in-sap-hana-2.0-sps-04-multi-target-replication-supports-the-sap-hana-activeactive-read-enabled-option/


Category: Hot-News

Day/Mo/DateWhatsApp Message
Wed Apr 3[HOT NEWS] #SAPHANA Semi-Automatic Service Line Opener Program: New Java version of the Semi-Automatic Service (LOP) replaces the old application. Since the underlying infrastructure has also undergone changes, it's mandatory to install the new Java app. See details in #SAPHANA Note 2768981 https://launchpad.support.sap.com/#/notes/2768981

 

Category: Did You Know?

Day/Mo/DateWhatsApp Message
Mon Apr 1*Did You Know?*  SAP offers supportability tools that help you troubleshoot issues, diagnose problems, and connect securely when working with Support.
For Diagnostics, Troubleshooting, Connectivity, Software Logistics, Upgrade & Transformation tools #SAPHANA https://support.sap.com/en/tools.html
Mon Apr 8Use procedure SYS.MEASURE_NETWORK_IO to measure the network performance from an #SAPHANA perspective, both in scale-out and system replication landscapes. The procedure is documented in Note 2222200 https://launchpad.support.sap.com/#/notes/2222200


Category: Knowledge Repository

Day/Mo/DateWhatsApp Message
Tue Apr 2Bookmark this link for quick access to #SAPHANA and In-Memory Computing Troubleshooting Wiki Space: https://wiki.scn.sap.com/wiki/display/SAPHANA/SAP+HANA+and+In-Memory+Computing 
Tue Apr 9Support by Product pages have Featured Content, KBA's, Documentation, Guided Answers, and Questions and Blogs for the product chosen. For the Support by Product page of #SAPHANA Platform Edition, navigate to: https://support.sap.com/en/product/support-by-product/01200314690800001945.html
Tue Apr 16Bookmark this Guided Answers tree that helps you troubleshoot the common errors when using Analysis for Office 2.x and connecting to #SAPHANA Views: https://ga.support.sap.com/dtp/viewer/index.html#/tree/804/actions/8830
Tue Apr 23Bookmark this comprehensive wiki for a handy reference on how to set up your #SAPHANA System for #SAPSOLMAN https://wiki.scn.sap.com/wiki/display/TechOps/Prepare+Managed+System+Setup+for+SAP+HANA
Tue Apr 30Subscribe to the #SAPHANA Academy YouTube channel. It features videos and presentations by HANA experts who guide you through understanding and implementing different HANA features and capabilities.  https://www.youtube.com/user/saphanaacademy


March 2019

Category: Applications on HANA

 

Day/Mo/DateWhatsApp Message
fri mar 1Remember seeing something about a HANA topic on WhatsApp, but can't find it? A list of messages that have been previously broadcasted out can be found below:
https://wiki.scn.sap.com/wiki/display/SAPHANA/SAP+HANA+WhatsApp+Broadcast+History 
mon mar 11SAP HANA Support now has a newsletter!
We took into account common issues faced by customers, and frequently accessed knowledge articles, and created this document that was curated by HANA Support engineers.
For more details and link to the newsletter, see this blog:
https://blogs.sap.com/2019/01/27/hana-product-support-newsletter-first-of-its-kind-from-us-to-you-lets-see-what-we-got/

Please do leave your feedback in the comments section so we can keep improving it.
mon mar 25SAP's Business tables on HANA are typically large and need to be partitioned appropriately to ensure SQL performance and delta merge operations are not affected. For SAP's recommendation on this process, see SAP note2418299 - SAP HANA: Partitioning Best Practices / Examples for SAP Tables https://launchpad.support.sap.com/#/notes/2418299


Category: Hot-News

Day/Mo/DateWhatsApp Message
wed mar 6*Hot News* [CVE-2019-0261]
Under certain circumstances, SAP HANA Extended Application Services, advanced model (XS advanced) does not perform authentication checks properly for XS advanced platform and business users.
For details on how to resolve this, see SAP Note2742027 - [CVE-2019-0261] Missing authentication check in SAP HANA Extended Application Services, advanced model
https://launchpad.support.sap.com/#/notes/2742027
wed mar 20*Hot News* Due to a programming error in SAP HANA Cockpit 2, the backup of the root keys may be corrupted. Subsequent import of these backed-up root keys fails.
For details on resolution, see SAP note2750987 - Potential Corruption of Encrypted Root Key Backups When Using SAP HANA Cockpit
https://launchpad.support.sap.com/#/notes/2750987
wed apr 3*HOT NEWS* #SAPHANA Semi-Automatic Service Line Opener Program: New Java version of the Semi-Automatic Service (LOP) replaces the old application. Since the underlying infrastructure has also undergone changes, it's mandatory to install the new Java app. See details in #SAPHANA Note 2768981 https://launchpad.support.sap.com/#/notes/2768981


Category: Did You Know?

Day/Mo/DateWhatsApp Message
thu mar 21*Did You Know?*  Inadequate parameter settings can be responsible for various severe issues like High Memory Consumption, Bad performance, incorrect results, etc.
For SAP's Parameter Recommendations in SAP HANA Environments, keep SAP note2600030 bookmarked.
https://launchpad.support.sap.com/#/notes/2600030
mon mar 25*Did You Know?*  There are some restrictions and recommendations regarding specific revisions of SAP HANA database for use in SAP S/4HANA.
If you have a migration or upgrade of S/4HANA coming up, bookmark SAP note2655761
https://launchpad.support.sap.com/#/notes/2655761
thu mar 28*Did You Know?*  Resource shortages on SAP HANA occur most commonly in the areas of CPU, RAM, Disk components. A quick overview of the resource utilization of a HANA instance can be found in the corresponding SAP HANA Cockpit (landing page of an instance) or SAP HANA Studio (Administration Overview). For steps on how to do this please follow Guided answers below:

https://ga.support.sap.com/dtp/viewer/#/tree/1884/actions/24336
mon apr 1*Did You Know?*  SAP offers supportability tools that help you troubleshoot issues, diagnose problems, and connect securely when working with Support.
For Diagnostics, Troubleshooting, Connectivity, Software Logistics, Upgrade & Transformation tools #SAPHANA https://support.sap.com/en/tools.html


Category: Knowledge Repository

Day/Mo/DateWhatsApp Message
tue mar 26Bookmark this wiki on SAP HANA Operation with SAP Solution Manager to keep details on prerequisites, installation, monitoring, troubleshooting, EWA, etc. handy:
https://wiki.scn.sap.com/wiki/display/TechOps/Managed+System+Setup+for+SAP+HANA


February 2019

Feb 5SAP Support is always there to help you. To keep running our services smoothly, we need some maintenance downtime too.
Bookmark this note which gives dates of planned maintenance where you will see restricted availability of the SAP Support Systems.
We recommend that you refrain from planning an upgrade or other critical conversion projects on these maintenance dates.
SAP Note63945 - Maintenance schedule for SAP Support Systems
https://launchpad.support.sap.com/#/notes/63945
Feb 6SAP HANA Supports cross-database access with Multitenant Database Containers with some restrictions. For details, see SAP Note 2196359
https://launchpad.support.sap.com/#/notes/2196359
Feb 7Are you having issues with direct database access to objects managed by ABAP Dictionary or AMDP?
There are some restrictions for such access - check SAP Note2511210 for more information.

https://launchpad.support.sap.com/#/notes/2511210
Feb 12This comprehensive wiki helps set up your SAP HANA System for SAP Solution Manager https://wiki.scn.sap.com/wiki/display/TechOps/Prepare+Managed+System+Setup+for+SAP+HANA
Feb 13Does your future maintenance include copying or migration of a SAP HANA Database from Multi-Node system to a Single-Node system?
Bookmark the guide in KBA 2093572 - SAP HANA Migration from Multi-Node to Single-Node

https://launchpad.support.sap.com/#/notes/2093572
Feb 14Controlling HANA's data volume size is an important part of housekeeping.
Check out SAP Note2499913 - How to shrink SAP HANA Data volume size

https://launchpad.support.sap.com/#/notes/2499913 
Feb 19Getting unexpected results during graphic view modeling?
Check out troubleshooting note2618790 - Graphical View Modeling in SAP HANA - How to Avoid Unexpected Results
https://launchpad.support.sap.com/#/notes/2618790
Feb 20See how to capture a MDX statement from the HANA Studio in SAP Note2628528 - How to capture MDX statement from HANA studio
https://launchpad.support.sap.com/#/notes/2628528
Feb 21Working on understanding what is in-memory database, how does it help your business in running advanced analytics, Multi-cloud, on-premises and hybrid deployment options, etc.?
Talk to us!
For details on how, see:
https://www.sap.com/cmp/dg/crm-ya18-bdm-ddi-buh/index.html
Feb 26Seeing increased memory consumption for a query/overall system? You can trace the allocators using these simple steps:
2620830 - How To Activate SAP HANA Memory Allocator Traces
https://launchpad.support.sap.com/#/notes/2620830
Feb 27Opening a support incident in the right component ensures you get to the expert faster. To know the best component for for your issue when opening an incident related to SAP HANA, see this Guided Answer tree:
SAP HANA component guide:
https://ga.support.sap.com/dtp/viewer/index.html#/tree/1826/actions/23674
Feb 28SAP HANA Mini Checks script can help you identify potential critical technical issues affecting your SAP HANA database.
Bookmark SAP KBA1999993 for handy information about HANA Mini Checks and how to address the results.
https://launchpad.support.sap.com/#/notes/1999993


January 2019

1/1/2019Looking for help on resolving -10709 Errors? Check out SAP note 2213725 - How-To: Troubleshooting of -10709 errors
https://launchpad.support.sap.com/#/notes/2213725
2-JanWould you like to know how to analyse a Composite OOM Dump? Check out the link below:
2332170 - How- To: Analyzing SAP HANA composite OOM dump
https://launchpad.support.sap.com/#/notes/2332170
3-JanLearn SAP endorsed best practices for administering and monitoring your SAP HANA database from SAP note 2400024 - How-To: SAP HANA Administration and Monitoring
https://launchpad.support.sap.com/#/notes/2400024
8-JanSAP HANA does in fact support timezones. Improperly maintained timezone tables or settings can lead to errors, incorrect data, or performance impacts related to functions UTCTOLOCAL, LOCALTOUTC, CURRENT_UTCTIMESTAMP, and CURRENT_TIMESTAMP.

See SAP Note 1791342 for more details

https://launchpad.support.sap.com/#/notes/1791342
9-JanInterested in performing cleanup activities within your SAP HANA System ?
SAP HANACleaner (SAP Note 2399996) is a Python tool that can be used for various cleanup tasks.

https://launchpad.support.sap.com/#/notes/2399996
10-JanHave an interesting idea to improve SAP HANA Platform ?
You can submit your idea and file an improvement request following SAP Note 2265872.

https://launchpad.support.sap.com/#/notes/2265872
15-JanIf you wish to verify the installed SAP HANA Revision is compatible with installed SAP HANA Studio versions see SAP Note 2375176. 
https://launchpad.support.sap.com/#/notes/2375176
16-JanYou can see all the parameters and configuration options for #SAPHANA Statistics Server in this note:
2529478 - How-To: Configuring SAP HANA Statistics Server Parameters
https://launchpad.support.sap.com/#/notes/2529478
17-JanTo check if your HANA 1.0 revision is still in maintenance or not, refer SAP Note: 2021789 - SAP HANA 1.0 Revision and Maintenance Strategy
https://launchpad.support.sap.com/#/notes/2021789
22-JanYou can find a comprehensive, regularly updated wiki on SAP HANA System Replication here:
https://wiki.scn.sap.com/wiki/display/SAPHANA/System+Replication
23-JanJoin the Big Data movement with SAP. See how SAP and Hadoop integrate together while leveraging the power of SAP HANA:
https://blogs.sap.com/2017/07/19/bridging-two-worlds-integration-of-sap-and-hadoop-ecosystems/
24-JanExplore information resources that support the different phases of SAP HANA – from planning and installation to operation and security. You’ll also find documentation to help you take full advantage of the platform’s core capabilities and advanced features, including app development, system administration, and modeling:
https://www.sap.com/canada/products/hana/implementation/resources.html
29-JanTroubleshooting performance of CDS views can be tricky. We have an excellent community blog: CDS view performance analysis using PlanViz in HANA studio that teaches you how to do so step-by-step:
https://blogs.sap.com/2017/07/23/my-cds-view-self-study-tutorial-part-14-cds-view-performance-analysis-using-planviz-in-hana-studio/
30-JanHere's a 5 minute read on using Composite Providers with BW on HANA for Efficient data modelling:
https://blogs.sap.com/2014/01/22/composite-providers-with-bw-on-hana-for-efficient-data-modelling/


December 2018

3-DecLearn how to analyze HANA oom dumps step-by-step from this HANA academy video:
https://www.youtube.com/watch?v=XSaezMSuNZ8
4-DecHave questions about external HANA views, and feature availability?
Check out this comprehensive note: 2317197 - External SAP HANA View: Frequently asked questions, feature availability
https://launchpad.support.sap.com/#/notes/2317197
5-DecLooking for a single KBA that has central information about HANA, its features, links to troubleshooting information, support practices, etc? Bookmark SAP KBA2000003 - FAQ: SAP HANA
https://launchpad.support.sap.com/#/notes/2000003
6-DecRunning into HANA Network issues? Here's a comprehensive list of both Lunux and HANA paramters with details on how they affect the system:
SAP note 2382421 - Optimizing the Network Configuration on HANA- and OS-Level
https://launchpad.support.sap.com/#/notes/2382421
10-DecAre you looking for a comprehensive guide on Core Data Services (CDS)?
Check out the official SAP HANA Core Data Services (CDS) Reference
https://help.sap.com/viewer/09b6623836854766b682356393c6c416/2.0.03/en-US
11-DecFor a comprehensive list of all best practices on how to configure parameters to avoid performance/memory/CPU issues, terminations, corruptions etc. and keep your HANA system runnning efficiently, bookmark SAP note 2600030
https://launchpad.support.sap.com/#/notes/2600030
13-DecGrowing size of technical tables can create issues with memory, access RTT, etc.
To see how to manage them, check out SAP note 2388483 - How-To: Data Management for Technical Tables
https://launchpad.support.sap.com/#/notes/2388483
14-DecUsing Solution Manager with SAP HANA? Check out this continuously updated wiki space for EWA content, guides for setup, troubleshooting, RCA, and other content:
SAP HANA Operations with SAP Solution Manager
https://wiki.scn.sap.com/wiki/display/TechOps/SAP+HANA+Operations+with+SAP+Solution+Manager
17-DecSAP offers a Technical Performance Optimization Service(TPO) for HANA. This is an expert service that analyzes the technical configuration, performance and health of the SAP HANA database.
To learn more about this service, check out SAP note 2177604 - FAQ: SAP HANA Technical Performance Optimization Service
https://launchpad.support.sap.com/#/notes/2177604
18-DecLooking for a central note that lists all HANA traces and how to configure them?
Check out 2119087 - How-To: Configuring SAP HANA Traces
https://launchpad.support.sap.com/#/notes/2119087
19-DecDo you want to use HANA's Smart Data Access capabilities on SAP Cloud Platform (SCP)?
You will need to use SDI. For details, check out SAP note 2706507 - HANA SDA support on SAP Cloud Platform
https://launchpad.support.sap.com/#/notes/2706507
20-DecFor comprehensive troubleshooting wiki about HANA System Replication, check out this link:
https://wiki.scn.sap.com/wiki/display/SAPHANA/System+Replication
26-DecThere is an excellent wiki out on SAP HANA Modeling that details what/how-to about HANA modeling, and lists common support issues and steps to resolve them. Check out:
https://wiki.scn.sap.com/wiki/display/SAPHANA/SAP+HANA+Modelling+Guide
27-DecTo do a data preview in one of the intermediate nodes of a calc view, you do not always need to give CREATE ANY and DROP privileges in _SYS_BIC.
Find out how to give more restrictive privileges to users in SAP note 2299622 - Intermediate Data Preview Privileges
https://launchpad.support.sap.com/#/notes/2299622
28-DecTransports in HALM broken after upgrade to HANA 2.0? You are likely running into a documented scenario.
Check out SAP note 2560918 - Broken transport of changes in HALM after source system SID renaming
https://launchpad.support.sap.com/#/notes/2560918


November 2018

5-NovRunning into intermittent issues on HANA?
You can configure HANA to collect traces like runtime dumps, kernel profiler traces, etc. automatically when the issue occurs.
To learn how to set this up, see:
SAP note 2399979 - How-To: Configuring automatic SAP HANA Data Collection with SAP HANASitter https://launchpad.support.sap.com/#/notes/2399979
6-NovLooking for SAP provided best practices for HANA and other SAP Products?
Head towards our SAP Best Practices Explorer:
https://rapid.sap.com/bp/#/browse/a2z
7-NovTo learn how to resolve issues with SAP Web Dispatcher,
Check out SAP note 552286 - Troubleshooting for the SAP Web Dispatcher
https://launchpad.support.sap.com/#/notes/552286
8-NovHANA inaccessible? You can still troubleshoot it. To learn how, check out SAP note 1999020 - How-To: SAP HANA Troubleshooting when Database is no longer accessible https://launchpad.support.sap.com/#/notes/1999020
12-NovFind articles on Data Modeling, Deploy, Run & Operate, and XSA on SAP HANA here:
SAP community for SQL Data Warehousing - landing page:
https://www.sap.com/community/topics/sql-data-warehousing.html
13-NovLearn how to resolve common issues that give the DBSQL_SQL_ERROR:
SAP note 2444230 - Analyzing DBSQL_SQL_ERROR
https://launchpad.support.sap.com/#/notes/2444230
14-NovFind links to documentation and guides for for using HANA Smart Data Access (SDA) with SAP BW on HANA here:
https://archive.sap.com/documents/docs/DOC-52945"
19-NovSAP BW powered by SAP HANA:
Find  presentations, blogs, discussions, and how-to guides, release information, videos, roadmap etc. here:
https://www.sap.com/community/topics/bw-hana-sql-dw.html
20-NovOpenSAP - Upcoming course on Software Development on SAP HANA
With this course, you’ll take a deeper dive on key topics from real world applications and learn about new functionality added in SAP HANA 2.0 SPS 03
https://open.sap.com/courses/hana7
15-NovFind steps to trace, analyze, and find root causes of general issues with Memory, CPU consumption issues, system hanging, application/statement performance, security, replication, etc, on HANA here: SAP HANA Troubleshooting and Performance Analysis Guide.
https://help.sap.com/viewer/bed8c14f9f024763b0777aa72b5436f6/2.0.03/en-US/7d28bc8c4e54413caf2716731494da88.html "
21-NovImplementing SSO using Kerberos into your HANA System?
Check out this blog on Single Sign On (SSO) Configuration For Hana DB Using Kerberos:
https://blogs.sap.com/2018/02/24/single-sign-on-sso-configuration-for-hana-db-using-kerberos/
22-NovAutomate the collection of Kernel Profiler trace for analysis of intermittent performance and/or hanging situations.
This will also help SAP support resolve the issue faster. To learn how to do so, check out
SAP note 2005635 - Periodic scheduling of kernel profiler trace
https://launchpad.support.sap.com/#/notes/2005635
26-NovSending an incident to SAP Support with possible issues in Linux?
 Here's how to collect all the relevant information:
SAP note 618104 - ""sapsysinfo"" - Compiling system information on Linux
https://launchpad.support.sap.com/#/notes/0000618104
27-NovIf your system runs on IBM Power Platform, we recommend you to check this SAP Note regarding potential row store corruptions
(relevant to both HANA 1.0 and 2.0):
SAP note 2577314 - Possible Row Store Inconsistency on IBM Power Platform
https://launchpad.support.sap.com/#/notes/2577314"
28-NovGet an overview of backint for SAP HANA and questions you might have regarding 3rd party backup tools from this blog:
https://blogs.sap.com/2018/08/31/overview-of-backint-for-sap-hana-and-faq-for-3rd-party-backup-tool-support/


October 2018

1-OctHow to analyze ABAP short dumps that are created in the context of the SAP HANA database?

Check out KBA 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANA Environments

https://launchpad.support.sap.com/#/notes/2399990
3-OctNeed more information on a SAP HANA Alert?

Check out KBA  2445867 - How-To: Interpreting and Resolving SAP HANA Alerts

https://launchpad.support.sap.com/#/notes/2445867
8-OctTo understand the output of SQL: ""HANA_Configuration_MiniChecks"" (SAP Note 1969700) which are used very frequently for SAP HANA health checks,

see KBA 1999993 - How-To: Interpreting SAP HANA Mini Check Results

https://launchpad.support.sap.com/#/notes/1999993
10-OctWe have a comprehensive wiki on all resources on CTS+ across different landscapes:

https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=448469096#HANA
15-OctHANA Monitoring Views growing very fast?

See SAP note 2088971 : How-To: Controlling the Amount of Records in SAP HANA Monitoring Views

https://launchpad.support.sap.com/#/notes/2088971
17-OctMoving to SAP HANA?

Check out this blog: Migration to HANA made easy with DMO

https://archive.sap.com/documents/docs/DOC-48742
5-OctYou're using Analysis For Office and want to see what request is sent to HANA.

Check out SAP note 2522193 - How to trace AO request from HANA perspective

https://launchpad.support.sap.com/#/notes/2522193
22-OctUnexpected data issues when using BW?

Use RSRT to see what query is being sent to HANA:

https://wiki.scn.sap.com/wiki/display/BI/RSRT%3A+Display+SQL+BWA+SAP+HANA+Query
29-OctTo teach yourself more about Dynamic Tiering, try this course from OpenSAP:

Introduction to SAP HANA Dynamic Tiering

https://open.sap.com/courses/hsdt1"
12-OctHow to check if a HANA parameter needs to be configured online or offline,

see the steps in SAP note 2530688 - Which HANA parameter needs to be configured online or offline

 https://launchpad.support.sap.com/#/notes/2530688
31-OctLooking for details on extended support for db copy in BR* tools?

Check out SAP note 1003028 - Extended support for database copy in BR*Tools

https://launchpad.support.sap.com/#/notes/1003028
24-OctRunning into issues with SAP Host Agent?

Check out this comprehensive troubleshooting Guide:

https://wiki.scn.sap.com/wiki/display/ATopics/SAP+Host+Agent+Troubleshooting+Guide
19-OctTeach yourself integration, analysis, planning, and lifecycle management of BW on SAP HANA with this OpenSAP course:

SAP Business Warehouse powered by SAP HANA

https://open.sap.com/courses/bwhana1-1
17-OctHANA 1.0 Hotnews:

HotNews are top priority SAP notes highlighting severe issues which require immediate action on customer side.
This information is also helpful with decisions regarding upgrade or GOLIVE

Please check the links below for the HANA 1.0 SPS relevant to you:

SAP HANA DB: SAP HotNews in HANA 1.0 SPS10
Link: https://launchpad.support.sap.com/#/notes/2687693

SAP HANA DB: SAP HotNews in HANA 1.0 SPS11
Link: https://launchpad.support.sap.com/#/notes/2687717

SAP HANA DB: SAP HotNews in HANA 1.0 SPS12
Link: https://launchpad.support.sap.com/#/notes/2687727 
18-OctHANA 2.0 Hotnews:

HotNews are top priority SAP notes highlighting severe issues which require immediate action on customer side.
This information is also helpful with decisions regarding upgrade or GOLIVE

Please check the links below for the HANA 2.0 SPS relevant to you:

SAP HANA DB: SAP HotNews in HANA 2.0 SPS00
Link: https://launchpad.support.sap.com/#/notes/2688419

SAP HANA DB: SAP HotNews in HANA 2.0 SPS01
Link: https://launchpad.support.sap.com/#/notes/2687443

SAP HANA DB: SAP HotNews in HANA 2.0 SPS02
Link: https://launchpad.support.sap.com/#/notes/2663153

SAP HANA DB: SAP HotNews in HANA 2.0 SPS03
Link: https://launchpad.support.sap.com/#/notes/2688515


September 2018

Datemessage
03-Sep

Are you running on an SAP HANA 1.0 database that is already out of maintenance?

To check if you revision is already out of maintenance, refer SAP Note: 2021789 - SAP HANA 1.0 Revision and Maintenance Strategy https://www.wbca.st/s5xREow

We strongly recommend an upgrade to the most recent SAP HANA 1.0 database revision based on SPS12. For more details check SAP Note: 2617548 - Upgrade Recommendation for SAP HANA 1.0 Installations https://www.wbca.st/EpXthPw

04-Sep

The SAP HANA Service is now available, and there have been some questions about how to connect to a HANA database in the cloud from a local SQL client.

 

Review the below blog for some common scenarios you may face when connecting to an SAP HANA Service database.

https://www.wbca.st/ZIiuhzw

05-Sep

Would you like to know more about troubleshooting SAP HANA High CPU Utilisation.

 

If so then check out https://www.wbca.st/QSgFPkw

 06-Sep

Having trouble activating a CDS view?

 

This note has a comprehensive list of possible causes and resolutions: SAP Note 2421686 - CDS view(DDL SQL View) cannot be activated with RUTDDLSACT

 

https://www.wbca.st/z33Svnw

 10-Sep

Would you like to know more about how to manage Technical Tables in your HAN Database?

 

Check out SAP Note 2388483 - How-To: Data Management for Technical Tables

 

https://www.wbca.st/MLOFbzw

 11-Sep Have questions regarding HANA network troubleshooting? 

 

Refer to: 2081065 - Troubleshooting SAP HANA Network

 

https://www.wbca.st/yHhY8nw

 12-Sep

Would you like more information on when to implement which revision type and version of an SAP HANA Revision, depending on your specific scenario?

 

Then check out 2021789 - SAP HANA 1.0 Revision and Maintenance Strategy

 

https://www.wbca.st/xn7KI8w

 13-Sep How to find official configuration documents for SAP Solution Manager (solman_setup, maintenance planning guide; master guide etc)

 

 https://www.wbca.st/v8WDrPw

 17-Sep

Looking for information on how to terminate sessions in HANA?

 

Check out: 2092196 - How-To: Terminating Sessions in SAP HANA

 

https://www.wbca.st/alA39xw  

 18-Sep SAP HANA 2.0 Support Package Stack (SPS) 02 Database Maintenance Revision 24.05 of SAP HANA Platform Edition is now available externally for download in SP/Patch download area on SAP Service Marketplace.

 

 Please see SAP Note 2660349 - SAP HANA 2.0 SPS 02 Database Maintenance Revision 024.05

 

https://www.wbca.st/BttjSew  

 19-Sep You want to migrate your existing SAP ABAP system to the SAP HANA database.

 

Check out this blog: https://www.wbca.st/iyYAGdw

 24-Sep

Have concerns related to potential physical corruption in HANA?

 

You can use the hdbpersdiag tool, for more details check out: SAP Note 2272121 - How-To: Analyzing Physical Corruptions with the SAP HANA Persistence Diagnosis Tool (hdbpersdiag)

 

https://www.wbca.st/5CXpBIw  

 25-Sep

What are SAPInit and SAPStartSrv? How do they interact with the OS?

 

Check out this excellent blog: https://www.wbca.st/3XDPc9w

 26-Sep

SAP Support by Product: Product Page for SAP HANA platform edition Find HANA Hotnews, Important Security notes, Top HANA notes, Tool and Tutorials, and other related documents, guides, and pages here:

 

 https://www.wbca.st/leezjLw

27-Sep Do you want to learn more about configuring SSO for SAP HANA Cockpit? Check out this link: https://www.wbca.st/FOTfCCw 

August 2018

DateMessage
 01-Aug Need to contact SAP Support for incident processing speed-up requests, technical/non-technical information? Contact CIC through any of our channels:

560499 - Customer Interaction Center: Hotline - Email - Chat

www.wbca.st/CqlE9Bw

06-Aug 

Another one to bookmark for troubleshooting performance issues.

Check out this link 'Troubleshooting HANA Performance issues' => www.wbca.st/jmStN7w

 07-Aug

SAP HANA 2.0 Support Package Stack (SPS) 03 Database Revision 031 of SAP HANA Platform Edition is now available externally for download in SP/Patch download area on SAP Service Marketplace.

Check out SAP Note 2628197 - SAP HANA 2.0 SPS 03 Database Revision 031.00 for more details : www.wbca.st/sAbi1ow

 
08-Aug  Understand how to administer and troubleshoot SAP Host Agent with this excellent wiki:

www.wbca.st/Olhw9sw

 09-Aug Learn how to troubleshoot and analyze ABAP dumps related to HANA in this blog post => www.wbca.st/vuYawBw
 13-Aug

Join this free openSAP course to get an initial introduction to SAP HANA Data Management Suite, which was announced at SAPPHIRE NOW in June 2018.

This course runs from July 31, 2018 to August 22, 2018! So hurry! => : www.wbca.st/ruZj2Xw

 
14-Aug Are you interested in learning about back up and recovery options for the SAP HANA Cockpit? Learn more in this wiki link => www.wbca.st/NlIXkDw 
 15-Aug

How to Analyze BW Queries in TCODE RSRT

www.wbca.st/Gx6ur0w

 
 16-Aug

Want to know more about how to use Core Data Services (CDS) to build design-time persistance models in SAP HANA Extended Application Services? 

Checkout out this guide -> SAP HANA Core Data Services (CDS) Reference guide:

www.wbca.st/yvFia4w

 
 20-Aug

Introducing the 'SAP HANA Troubleshooting' Guided Answers Tree, a Master Guide that has resources and links to all HANA related issues

Check it out here => www.wbca.st/KsYdlvw

 
 21-Aug

The BW on HANA Documentation and Troubleshooting Wiki page has several FAQs and useful resources on analyzing and troubleshooting common issues in BW on HANA.

Bookmark this link => www.wbca.st/xbH3C5w

 
 22-Aug

Learn how to consume Calculation Views from XS Advanced via Information Access in this blog post:

www.wbca.st/gZBUDsw

 
 23-Aug

Would you like to know more about System Replication and related scenarios? This wiki page has a lot of useful resources including SAP Notes, KBAs and important trace files to be recorded.

www.wbca.st/n0zWgMw

 
 27-Aug

Do you want to open an incident with SAP Support for a HANA Database issue, but you are unsure of exactly which component to route to?

Take a look at this guided answers which can help you to choose the right HANA component => www.wbca.st/0a2N6Aw

 
 28-Aug

SAP Note 1969700 provides a set of SQL statements that you can execute to monitor your HANA System. You can find these SQL statements in the attachments section of this SAP Note with useful output examples to facilite your analysis.

See: www.wbca.st/cyemK2w

 
30-Aug  Learn more about good HANA modeling practices in this blog post:

https://www.wbca.st/bO2srBw

 

 

 

July 2018

DateMessage
02-Jul

Looking for support for your brownfield implementation?

SAP Enterprise Support Academy has provisioned a conversion model for companies who choose to modernize their IT landscape, while still keeping the original nuts and bolts of their machine in place.

Find out what the SAP Enterprise Support Academy is doing to support SAP Enterprise Support customers.

www.wbca.st/07Sg5Uw

04-JulInterested in managing workload and resources in HANA? Check out SAP Knowledge Base Article: 2222250 - FAQ: SAP HANA Workload Management -> www.wbca.st/eikPjxw
06-Jul

SAP S/4HANA Implementation from Scratch in Six Phases!

Did you know the SAP Enterprise Support Academy provides Expert Guided implementations (EGIs) that support and guide you through your SAP S/4HANA adoption project?

www.wbca.st/ZPvNTqw

 09-Jul

Are you performing a recovery and want to ensure backups are not damaged?

Check out the tool mentioned in 1873247 - Checking recoverability with hdbbackupdiag --check

www.wbca.st/9rIYLqw

 11-Jul

Another great link to bookmark -> The SAP Hana Reference for SAP Basis Administrators

www.wbca.st/c8mbwow

 13-Jul

Having disruptions in System Replication?

Refer to: www.wbca.st/MEzTALw

 16-Jul Here are some widely common understandings about SAP HANA that is not completely true. Bookmark this link for your references.

Knowledge Base Article 2100010 - SAP HANA: Popular Misconceptions => www.wbca.st/qskITPw

18-Jul 

How to check the integrity of backups and if they are still consistent?

Refer to tool: 1869119 - Checking backups with ""hdbbackupcheck"" -> www.wbca.st/N5LUX5w

20-Jul  Seeing increased memory consumption for a query/overall system? You can trace the allocators using these simple steps:

2620830 - How To Activate SAP HANA Memory Allocator Traces

www.wbca.st/AryRi8w

23-Jul  Understand and Troubleshoot BW Query Performance and Memory Consumption (wiki) www.wbca.st/eQTEZtw
 25-Jul

Are you experiencing issues with your SAP HANA instance at a hardware or operating system level?

Learn more about troubleshooting hardware / OS issues and top SAP Notes to help guide you.

-> www.wbca.st/Djb1nFw

 
27-Jul 

This guided answers specifies situations where HANA Services are no longer reachable and methods to troubleshoot such situations.

Find out more by clicking the link -> www.wbca.st/ghqsyGw

 30-Jul How to check the SAP BW Query push down to SAP HANA? Check the link:  www.wbca.st/3owl2tw
 31-Jul

HOT NEWS: Check out the "SAP S/4HANA Sourcing and Procurement" WhatsApp Channel. Subscribe using the link below.

www.wbca.st/oxsd4Vw

June 2018

DateMessage
01-Jun

The following KBA can help you analyze Out Of Memory situations. Check:

1984422 - How-To: Analyzing SAP HANA Out-of-memory (OOM) Dumps

www.wbca.st/xyiXIkw

04-Jun

Learn more about connected Data and SAP HANA Graph and usecases by enrolling for this free openSAP Course "Analyzing Connected Data with SAP HANA Graph"" by Markus Fath that starts on June 20.

Details can be found on this link -> www.wbca.st/MhuA8tw

05-Jun

HOT NEWS: Introducing the new "SAP S/4HANA Finance" WhatsApp Channel. Subscribe using the link below.

www.wbca.st/gyXtmbw

 Please help us understand our audience better by taking our short 5 question survey This will help guide what information we deliver to you via WhatsApp so we can serve you better and enhance our Next-Generation Support Experience.   If you have any feedback or suggestions, please let us know! We will review all of your valuable input to improve your Product Support experience.

Take the 30-second survey here -> www.wbca.st/QFR7Bmw

06-Jun  

Here is a good KBA to clarify questions and doubts about administration using HANA Studio:

2073112 - FAQ: SAP HANA Studio

www.wbca.st/PFnKuaw

07-Jun 

Here is a good KBA to clarify questions and doubts about administration using HANA Studio:

2073112 - FAQ: SAP HANA Studio

www.wbca.st/ux2RDCw

 08-Jun

Interested in learning more about the Product Support Resources that are available to you? Join the SAP Community call to learn how to best  work with Product Support using Chat, Schedule and Expert and more.

Registration link www.wbca.st/lOb8Hww

11-Jun  HANA has a new Execution Engine starting 2.0 SPS02. Find out more here:

2570371 - FAQ: SAP HANA Execution Engine (HEX)

www.wbca.st/0UoN2Iw

 12-Jun

HOT NEWS: Introducing the new "SAP Enterprise Performance Management" WhatsApp Channel. Subscribe using the link below.

www.wbca.st/cqxQhWw

 
  Learn more about connected Data and SAP HANA Graph and usecases by enrolling for this free openSAP Course ""Analyzing Connected Data with SAP HANA Graph"" by Markus Fath that starts on June 20.

Details can be found on this link -> www.wbca.st/V54KOJw

 13-Jun HANA 2.0 SPS03 now allows Multitarget System Replication, i.e. you  can replicate data changes to more than one secondary system. Details in the Administration Guide:

www.wbca.st/MeXIkiw

14-Jun 

HANA showing seemingly incorrect data? See the list of all possible scenarios and root-causes here:

SAP note 2222121 - SAP HANA Wrong Result Sets

www.wbca.st/rdWO1Bw

 15-Jun

Understand HANA FDA (Fast Data Access) and its impact on your system:

SAP Note 2399993 - FAQ: SAP HANA Fast Data Access (FDA)

www.wbca.st/xUSnjWw

 18-Jun Learn more about the Support available to you as an SAP Customer by joining one of our upcoming webinars www.wbca.st/0kPNjUw
 

HANA 2.0 SPS03 now allows Multitarget System Replication, i.e. you  can replicate data changes to more than one secondary system. Details in the Administration Guide:

www.wbca.st/6b7qnlw

 19-Jun

All official documents to help you install, update, administer, and use HANA can be found here:

www.wbca.st/N1rxVUw

20-Jun 

Understand and troubleshoot BWA Query Performance issues:

SAP note 1681396 - Query Performance

www.wbca.st/Uo9Evdw

 21-Jun

Do you want to know more about the HANA Cockpit Security Model, Users & Permissions. Check out this article which provides an overview of the SAP HANA Cockpit Security Model.

-> www.wbca.st/OfntLEw

 25-Jun

Known issues while configuring HANA HA/DR with vIPMover.py:

Check out SAP Note 2615046 - Usage of subprocess/popen2 not allowed in invoked python coding

www.wbca.st/hXmTwSw

 26-Jun

Become a Certified HANA Developer from openSAP courses.

The Prepare for Your SAP HANA Certification - Development Associate course is now running.

 Click on the link to learn more -> : www.wbca.st/vRk3OVw

 27-Jun

HANA has a new Execution Engine starting 2.0 SPS02. Find out more here:

2570371 - FAQ: SAP HANA Execution Engine (HEX)

www.wbca.st/RCapYxw

May 2018

DateMessage
01-May

Learn more about the services and ports on HANA, the parameters involved and tracing information

See SAP KBA 2477204 - FAQ: SAP HANA Services and Ports => www.wbca.st/5c1OHw

02-May

Getting -10709 errors? Take a look at the useful KBA that can help you!

KBA 2213725 - How-To: Troubleshooting of -10709 errors

Click here -> www.wbca.st/CHaY36w

03-May

Would you like to know how to create a Full System Info Dump Via HANA Cockpit

Use our Guided Answers Solution:

www.wbca.st/km1xS0w

 04-May

 Are you interested in learning more about Dynamic Tiering in SAP HANA?

A brand new openSAP Course is starting May 15, 2018 that effectively teaches about implementing SAP HANA Dynamic Tiering to scale your SAP HANA System.

For more details and enrolment -> www.wbca.st/c0xyckw

 07-May

SAP HANA Cockpit 2.0 - SP 06 (version 2.6.5) is now available !

Learn More about it in the Release Note -> www.wbca.st/p3aPwgw

What's New in the SAP HANA Cockpit 2.0 -> www.wbca.st/nZaEyzw

 08-May

Resource shortages on SAP HANA occur most commonly in the areas of CPU, RAM, Disk components. A quick overview of the resource utilization of a HANA instance can be found in the corresponding SAP HANA Cockpit (landing page of an instance) or SAP HANA Studio (Administration Overview).

For steps on how to do this please follow Guided answers below:

www.wbca.st/Yu3qX3w

 09-May

Learn how to configure High Availability for SAP HANA Cockpit using System Replication

More information can be found in this link -> www.wbca.st/f2YAavw

 10-May Now Available: New SMS notifications for SAP ONE Support Launchpad. Read how easy it is to activate this new notification at www.wbca.st/Amgt8iw
 14-May

Want to learn more about troubleshooting Performance issues in SAP HANA?

Check this guided answers tree which has several performance scenarios -> www.wbca.st/QPDyvBw

 15-MayAre you interested in learning more about integrating HANA and Hadoop ecosystems - Read this Blog: www.wbca.st/vmu131w
16-May Here is a post you have to bookmark!

A comprehensive list of most Frequently Asked Questions for SAP HANA providing a quick reference on how to configure, optimise and troubleshoot issues in your SAP HANA Database.

Add this link to your bookmarks -> www.wbca.st/EJY8Zsw

21-May 

Great News!

SAP HANA Database Maintenance Revision 122.16 of SAP HANA platform software Support Package Stack (SPS) 12 is now available externally for download in SP/Patch download area on SAP Service Marketplace.

Please check the SAP Note 2594622 - SAP HANA 1.0 SPS 12 Database Maintenance Revision 122.16. => www.wbca.st/WmmyVjw

 22-MayDo you have questions about SAP HANA Parameters? Check out this FAQ KBA:

2186744 - FAQ: SAP HANA Parameters

www.wbca.st/sEdbw9w

 23-May

You are interested in details about inverted individual indexes in SAP HANA environments.Please refer the KBA:

2600076 - FAQ: SAP HANA Inverted Individual Indexes

www.wbca.st/b0xR4kw 

 24-May

Understanding HDI containers:

Blog: www.wbca.st/wD3wQ9w Developer Guide: www.wbca.st/E21DrGw 

 28-May

You are looking for more information, an example of common issues and links to relevant documentation for table distribution and partitioning for SAP HANA,

Visit the SAP Community Wiki

www.wbca.st/lFbUfTw

 
 29-May

What to do when a SAP HANA Service restarts or crashes? What information do I have to provide to SAP HANA Support? Have a look at:

2177064 - FAQ: SAP HANA Service Restarts and Crashes

www.wbca.st/TzrWIww

 
 30-May

If you think that the startup time of your HANA system is too long, refer to the following KBA:

2222217 - How-To: Troubleshooting SAP HANA Startup Times

www.wbca.st/J3HzgRw 

 31-MayDoubts about indexes in HANA? Check KBA:

2160391 - FAQ: SAP HANA Indexes

www.wbca.st/87ztzMw


April 2018

DateMessage
04-Apr

You have System Replicaiton enabled and is running.
Want to check if the log shipping is in Sync between primary system and secondary system?
 2517805 - How to check if HANA System Replication is in Sync or not =>   www.wbca.st/cKqTuw

05-Apr

Check out this wiki page which talks about analysing performance problems which are system wide on HANA.

Click here -> www.wbca.st/d1jF2w

06-Apr

The SAP HANA Academy offers free video tutorials about SAP HANA on YouTube. In this blog, you will find the most recent blog posts listed.

Check this link -> www.wbca.st/qrl8cw

 

09-Apr

Do you want to know more about HANA Savepoints?

See KBA: 2100009 - FAQ: SAP HANA Savepoints

www.wbca.st/Y1x4vw

 

10-Apr

New Course Alert!

Enroll in the new openSAP course 'Introduction to SAP HANA Dynamic Tiering' : www.wbca.st/B7pLiw .

All you need to sign up is a valid email address and you can learn from anywhere in the world, at any time.

 

11-Apr

New subscriber to SAP HANA WhatsApp channel?

You can see all the broadcasted messages since the launch of this channel in the link below!

Click here to access the wiki page:  www.wbca.st/x3igfw

 

12-Apr

Learn how to troubleshoot issues when the HANA Database is no longer accessible by using the brand new Guided Answers tool.

Click on this link -> www.wbca.st/Tn5fzw

 

16-Apr

You wish to access the How-To Guides and Whitepapers for the topic of SAP HANA High Availaibility.

KBA 2407186 - How-To Guides & Whitepapers For SAP HANA High Availability Click on: www.wbca.st/1u7Low

 

17-Apr

Do you want to know more about HANA Clients?

See KBA: 2393013 - FAQ: SAP HANA Clients

www.wbca.st/CEpa6w

 

18-Apr

Do you want to know more about the network settings in HANA?

See KBA: 2222200 - FAQ: SAP HANA Network

www.wbca.st/dWvBZw

 

19-Apr

Learn more about table partitioning on SAP HANA environments

Check out SAP KBA - 2044468 - FAQ: SAP HANA Partitioning => www.wbca.st/tBrotw

Also, this wiki discusses the common problems and solutions faced during partitioning
www.wbca.st/t6vaew

 

23-Apr

Does your SAP HANA return a result that seems to be wrong?

KBA 2222121 - SAP HANA Wrong Result Sets is a handy reference for you to check if the results differ from your expectation although they are not actually wrong.

Click here to check it out! www.wbca.st/zRpDcw

24-Apr

Are you interested in analyzing ABAP Short Dumps in SAP HANA Environments?

Check SAP KBA: 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANA Environments

Click here to know more: www.wbca.st/kd4afw

 

25-Apr

Quite often there are situations when the database is not available and/or is hung.
 
 SAP Knowledge Base Article 1999020 - How-To: SAP HANA Troubleshooting when Database is no longer accessible talks about analyzing these situations and troubleshooting them.
 
 www.wbca.st/L77J0w

 

26-Apr

Several SAP HANA hardware partners offer a storage-level replication solution, which delivers a backup of the volumes or file-system to a remote, networked storage system.

Check below note for certified vendor list.
SAP Note 1755396 Released DT solutions for SAP HANA with disk replication -> www.wbca.st/Nboc7w

30-Apr

How-to: SAP Hana User Self-Service Configuration

www.wbca.st/T4mO9w

www.wbca.st/PJgu4w

March 2018

DateMessage
05-Mar

Do you want to know how to troubleshoot HANA Service Availability issues?

Check out the new Guided Answers - Troubleshooting SAP HANA Service Availability Issues

Click here -> www.wbca.st/WYc9lw

06-MarHave you experienced a failed recovery due to a HDBDAMON process not stopping?

Then check out SAP Note 1944052 - Recovery failed due to hdbdaemon process not able to stop

https://launchpad.support.sap.com/#/notes/1944052
07-Mar

Do you know how to troubleshoot errors like "insufficient privilege" or "not authorized" ?

Check out Note 1809199 - SAP HANA DB: Debugging user authorization errors

Click here -> https://launchpad.support.sap.com/#/notes/1809199

08-Mar

Have you encountered HANA Secondary Database not Starting after Enabling System Replication?

Check out the Guided Answer - HANA Secondary Database not Starting after Enabling System Replication

Click here -> https://ga.support.sap.com/dtp/viewer/#/tree/196/actions/1425

09-Mar

Do you want to know how to troubleshoot Transactional Problems in HANA?

Check out the new Guided Answers - Troubleshooting Transactional Problems in SAP HANA!

Click here -> www.wbca.st/KYxcnw

12-Mar

What should you do when you experience high memory consumption on your HANA system?

Check out the new Guided Answers - How to troubleshoot HANA High Memory Consumption

Check it out here -> www.wbca.st/61sJEw

13-Mar

For steps on how to perform some Housekeeping of the Backup Catalog in HANA, please see KBA: 2096851

Click on : www.wbca.st/7ZN1lw

14-Mar

How do I enable SQL Trace in HANA?

Check out KBA 2031647 - How to enable SQL Trace in SAP HANA Studio

www.wbca.st/qNnK8w

15-Mar

How should you trobubleshoot Resource Utilization Issues?

Check out the new Guided Answers - Troubleshooting Resource Utilization Issues in SAP HANA

Click here -> www.wbca.st/U8Mz0w

19-Mar

How do you generate a Runtime Dump when SAP Support asks for it?

Check out the new Guided Answers - How to generate a runtime dump

Click here -> www.wbca.st/BaQwbw

20-Mar

You wish to access the How-To Guides and Whitepapers for the topic of SAP HANA High Availaibility.

2407186 - How-To Guides & Whitepapers For SAP HANA High Availability

Click on: www.wbca.st/MPztxw

21-Mar

SAP Note 2600030 (“Parameter Recommendations in SAP HANA Environments”) is now available to list parameter recommendations in SAP HANA environments.

Click here -> www.wbca.st/mZZxNw

It complements the parameter check command (SQL: “HANA_Configuration_Parameters”, SAP Note 1969700) and the parameter reference (SAP Note 2036111) with an overview of general parameter recommendations. On top of SAP HANA parameters it also provides suggestions for database related SAP ABAP parameters and refers to SAP Notes with operating system parameter recommendations.


Note 1969700 - SQL Statement Collection for SAP HANA
www.wbca.st/P2Icow

Note 2036111 - Configuration parameters for the SAP HANA system
www.wbca.st/7Hi6yw

21-Mar

Hot News! WhatsApp page is now available on the Support Portal. Bookmark this page and sign up for other new channels: www.wbca.st/ImJRXw

 

23-Mar

Are you interested in troubleshooting SAP HANA Information Access (InA) Service component widely used in analytical applications such as SAP BusinessObjects Analysis, edition for Microsoft Office ?

Check the link to know more about the different traces that can be enabled Performance, Incorrect Results and other issues => www.wbca.st/w1Mgqw

26-Mar

Do you observe high resident memory usage? You might not have to worry!

Check out KBA 2081473 - HANA Resident Memory : High Memory Usage

www.wbca.st/4SdWww ..

 

27-Mar

Did you know 65% of incidents submitted through Schedule an Expert are solved in one session? Find more details at www.wbca.st/PSudpw

 

27-Mar

How do I perform System Replication for HANA?

Check out the Guided Answer - How To Perform System Replication for SAP HANA

Click here -> www.wbca.st/tYtEYw

 

28-Mar

SAP HANA 2.0 Support Package Stack (SPS) 01 Database Maintenance Revision 12.04 of SAP HANA Platform Edition is now available externally for download in SP/Patch download area on SAP Service Marketplace.

Please see SAP Note  2544464 - SAP HANA 2.0 SPS 01 Database Maintenance Revision 012.04
www.wbca.st/LpCrkw


If you upgrade from a lower SAP HANA SPS it is recommended to update ALL other components (Studio, Modeler, DB Clients, DBSL, SLT, DS, ...) to at least the minimal version of SAP HANA 2.0 SPS 01.
Please see also the SAP Notes:
   2380229 - SAP HANA Platform 2.0 – Central Note
 www.wbca.st/KfVRUw
 
  2404375 - SAP HANA Platform 2.0 SPS 01 Release Note
 www.wbca.st/PyD7rw

 


February 2018

DateMessage
06-Feb

Do you want know how to troubleshoot issues caused after upgrading your HANA instance?

Learn more about this using the Guided Answer:

www.wbca.st/O33kAw

06-Feb

Want to know how to troubleshoot Smart Data Access (SDA) Configuration?

Click here to access our Guided Answers Tree for troubleshooting SDA Configuration
=> www.wbca.st/fXXwIw

13-Feb

You want to distribute the tables of a BW system according to SAP recommendations using landscape redistribution.
This Guided Answers Tree will take you through the steps on how to do this.

www.wbca.st/2atZUw

13-Feb

Want to learn about HANA System Replication?

1999880 - FAQ: SAP HANA System Replication

www.wbca.st/B2qQ5w

14-Feb

Have you ever seen an alert in HANA Studio such as:
Alert Name : Restarted services
Details : ... was restarted at .

If so, please have a look at KBA:
2509816 - SAP HANA: false alert about restarted service
www.wbca.st/VqXO9w

And make sure that the parameters are set according to SAP Note:
2382421 - Optimizing the Network Configuration on HANA- and OS-Level
www.wbca.st/DknXNw ..

14-Feb

This is an interesting SAP Note regarding ""Statement Routing"" in HANA, check it out:

2079372 - SAP HANA - Statement Routing

www.wbca.st/DNuPxw ..

15-Feb

Want to know how you can troubleshoot SAML Single Sign-On Authentication to your applications such as Business Objects BI Platform and XS Applications?

Click here to access a brand new way of troubleshooting, the SAP Guided Answers Tree => www.wbca.st/tAKW5w

15-Feb

Do you have questions about the HANA backups encryption? Check out this note:

2444090 - FAQ: SAP HANA Backup Encryption

www.wbca.st/FFhjFw

19-Feb

Want to know how you can troubleshoot HANA High CPU Utilization -
Click here to access a brand new way of troubleshooting, the SAP Guided Answers Tree
=> www.wbca.st/F2W8ew

19-Feb

You have System Replicaiton enabled and is running.
Wanted to check if the log shipping is in Sync between primary system and secondary system
2517805 - How to check if HANA System Replication is in Sync or not www.wbca.st/FAD94w

20-Feb

Are you interested in analyzing ABAP Short Dumps in SAP HANA Environments?

Check SAP KBA: 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANA Environments

Click here to know more: www.wbca.st/YeMD2w

20-Feb

Want to determine required restoration files for your system?

1705945 - Determining required restoration files

www.wbca.st/o5Ax3w

21-Feb

Want to know how to analyse performance issues ?
System or transaction performance is a critical factor for in-memory databases.
This Guided Answers Tree is will help to guide you through the basic analysis steps to be taken in a case of performance degradation.

www.wbca.st/77ReIw

21-Feb

SAP HANA Database Maintenance Revision 122.15 of SAP HANA platform software Support Package Stack (SPS) 12 is now available externally for download in SP/Patch download area on SAP Service Marketplace.
Please check the SAP Note 2569594 - SAP HANA 1.0 SPS 12 Database Maintenance Revision 122.15.
www.wbca.st/n6UvUw

If you upgrade from a lower SAP HANA SPS it is recommended to update ALL other components (Studio, Modeler, DB Clients, DBSL, SLT, DS, ...) to at least the minimal version of SAP HANA SPS 12.
Please check also the SAP Note 2298750 - SAP HANA Platform SPS 12 Release Note.
www.wbca.st/tU6DWw ..

22-Feb

What do you do when an error occurred while using 'Analysis for Microsoft Excel' or 'Analysis for Microsoft PowerPoint'?

Check out the KBA below to view the SAP Analysis log files.
-> www.wbca.st/ER16Sw

22-Feb

Want to know more about HANA Database and storage snapshots?

2039883 - FAQ: SAP HANA database and storage snapshots

www.wbca.st/jyaiPw

26-Feb

Have you ever wished to visualise an SQL statement for troubleshooting or other reasons ?

If so, please have a look at KBA : 2073964 - Create & Export PlanViz in HANA Studio
www.wbca.st/hAyNmw

27-Feb

Sap Note 2031547 provides an Overview of SAP-certified 3rd party backup tools and associated support process

2031547 - Overview of SAP-certified 3rd party backup tools and associated support process

www.wbca.st/j0o41w

January 2018

Posted DateBroadcasted Message
10-JanSAP Note 2573880 (“FAQ: SAP HANA Full System Info Dumps”) is now available to answer popular questions related to SAP HANA full system info dumps. Currently the following questions are addressed:

1. What is SAP HANA full system info dump?
2. Which information would I find in full system info dump as of SAP HANA 1.0?
3. What information is provided within the topology.txt file?
4. Which additional information is available on SAP HANA 2.0 full system info dump?
5. What is missing in full system info dump collected from SAP HANA 2.0 system?
6. Is it possible to look at different KPI's only from the full system info dump?
7. Is it possible to collect full system dump from SystemDB and all Tenants of a MDC system in one step?

Click here -> https://launchpad.support.sap.com/#/notes/2573880 
12-JanDo you want know how to troubleshoot issues caused after upgrading your HANA instance?

Learn more about this using the Guided Answer:

https://ga.support.sap.com/dtp/viewer/#/tree/23/actions/460
15-JanEver wonder what you can do to analyze high CPU situations?


KBA 2100040 - FAQ: SAP HANA CPU can help you out!


Click here: https://launchpad.support.sap.com/#/notes/2100040
17-JanHave you experienced long running log backups?

2063454 - Long running log backups contains useful info on what you can do if backup is running for quite some time.

Check here-> https://launchpad.support.sap.com/#/notes/2063454
19-JanIs your HANA network settings configured per SAP's recommendations?

SAP Note 2382421 - Optimizing the Network Configuration on HANA- and OS-Level, contains important network parameter recommendations for both operating system and SAP HANA.

Check it out -> https://launchpad.support.sap.com/#/notes/2382421
22-JanDo you know what types of traces and information you should provide to SAP HANA Support for a quicker processing? We have included the information we need from our customers in SAP Note 1758890 - SAP HANA: Information needed by Product/Development Support to ensure smooth processing and help you resolve your issue as soon as we can.

Click on the link below to read it!
https://launchpad.support.sap.com/#/notes/1758890  
24-JanAre you interested in a pro-active SAP HANA Consistency Check, or do you face symptoms that indicate inconsistencies?

Note 1977584 - Technical Consistency Checks for SAP HANA Databases, covers options to check for technical SAP HANA inconsistencies.
 
Click the link to see the note! https://launchpad.support.sap.com/#/notes/1977584
26-JanSAP HANA 2.0 Support Package Stack (SPS) 02 Database Revision 23 of SAP HANA Platform Edition is now available externally for download in SP/Patch download area on SAP Service Marketplace.

Please see SAP Note 2567797 - SAP HANA 2.0 SPS 02 Database Revision 023 (https://launchpad.support.sap.com/#/notes/2567797)

If you upgrade from a lower SAP HANA SPS it is recommended to update ALL other components (Studio, Modeler, DB Clients, DBSL, SLT, DS, ...) to at least the minimal version of SAP HANA 2.0 SPS 02.
29-JanWant to learn about Delta Merges?

KBA ""2057046 - FAQ: SAP HANA Delta Merges"" offers a lot of information on Delta Merges

Click here-> https://launchpad.support.sap.com/#/notes/2057046
Posted DateBroadcasted Message
4-DecIs your HANA system already secure? Read the new blog by our support engineer and see how you can ensure you have a secure connection on HANA!

Server-side SSL configuration on HANA for inter-node communication and System Replication using openSSL,  
https://blogs.sap.com/2017/12/01/server-side-ssl-configuration-on-hana-for-inter-node-communication-and-system-replication-using-openssl/
6-DecAre you using System Replication? Are you seeing a parameter mismatch alert?

This KBA can help! 2129939 - How to adjust parameters mismatch for system replication 

Click here to read more -> https://launchpad.support.sap.com/#/notes/2129939
8-DecAre you interested in analyzing ABAP Short Dumps in SAP HANA Environments?

Check SAP KBA: 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANA Environments

Click here to know more: https://launchpad.support.sap.com/#/notes/2399990
11-DecAre you interested in troubleshooting SAP HANA Information Access (InA) Service component widely used in analytical applications such as SAP BusinessObjects Analysis, edition for Microsoft Office ?

Check the link to know more about the different traces that can be enabled Performance, Incorrect Results and other issues => https://launchpad.support.sap.com/#/notes/2242449
15-DecTo ensure recoverability of the SAP HANA database, you want to check if the required data and log backups are present and undamaged.
Please see SAP Note 1873247 on checking recoverability with hdbbackupdiag --check.

Click on : https://launchpad.support.sap.com/#/notes/1873247
18-DecSAP HANA 2.0 Support Package Stack (SPS) 01 Database Maintenance Revision 12.03 of SAP HANA Platform Edition is now available externally for download in SP/Patch download area on SAP Service Marketplace.

Please see SAP Note 2557386 - SAP HANA 2.0 SPS 01 Database Revision 12.03
https://launchpad.support.sap.com/#/notes/2557386

If you upgrade from a lower SAP HANA SPS it is recommended to update ALL other components (Studio, Modeler, DB Clients, DBSL, SLT, DS, ...) to at least the minimal version of SAP HANA 2.0 SPS 01
20-DecDid you know .... SAP HANACleaner (SAP Note 2399996) is now also able to automatically create optimizer statistics for Smart Data Access (SDA) tables without statistics

Click here to access it -> https://launchpad.support.sap.com/#/notes/2399996
22-DecSAP HANA Database Maintenance Revision 122.14 of SAP HANA platform software Support Package Stack (SPS) 12 is now available externally for download in SP/Patch download area on SAP Service Marketplace.

Please check the SAP Note 2537514 - SAP HANA 1.0 SPS 12 Database Maintenance Revision 122.14.
https://launchpad.support.sap.com/#/notes/2537514

If you upgrade from a lower SAP HANA SPS it is recommended to update ALL other components (Studio, Modeler, DB Clients, DBSL, SLT, DS, ...) to at least the minimal version of SAP HANA SPS 12.
25-DecFor steps on how to perform some housekeeping of the Backup Catalog in HANA, please see KBA 2096851.

Click on : https://launchpad.support.sap.com/#/notes/2096851
27-DecWant to know how you can troubleshoot SAML Single Sign-On Authentication to your applications such as Business Objects BI Platform and XS Applications? 

Click here to access a brand new way of troubleshooting, the SAP Guided Answers Tree  =>  https://launchpad.support.sap.com/#/notes/2420354
Posted DateBroadcasted Message
1-NovDo you think your technical tables are too large?



Check KBA 2388483 - How-To: Data Management for Technical Tables



Click here for more info: https://launchpad.support.sap.com/#/notes/2388483
3-NovCheck SAP Note 2235581 for the updated matrix about the supported SLES and RHEL Versions for HANA 1.0 and HANA 2.0.



Major news are:

- RHEL 7.3 supported on x86 CPUs for HANA 2.0 and for HANA 1.0.

- RHEL 7.3 supported on IBM Power server but for HANA 2.0 only.

- SUSE Linux Enterprise Server is supported.



More info! https://launchpad.support.sap.com/#/notes/2235581
6-NovYou are operating a SAP HANA database with SAP HANA system replication and you want to know in which situations a takeover to the secondary site is advisable.      

2063657 - SAP HANA System Replication Takeover Decision Guideline  
https://launchpad.support.sap.com/#/notes/2063657
8-NovDo you think you can improve your system performance by optimizing some SQL Statements?

KBA 2000002 - FAQ: SAP HANA SQL Optimization will help you achieve it!

Click on: https://launchpad.support.sap.com/#/notes/2000002
10-NovDo you want to switch operation mode in HANA system replication environment?   

2500677 - How to switch operation mode in HANA system replication environment   
https://launchpad.support.sap.com/#/notes/2500677
13-NovGet your knowledge about table partitioning improved!

KBA "2044468 - FAQ: SAP HANA Partitioning" may resolve your doubts.

Click on https://launchpad.support.sap.com/#/notes/2044468
15-NovDid you know SAP HANA 1.0 SPS 12 Database Revision 13 is now available?

Click on the link to read more! https://launchpad.support.sap.com/#/notes/2298750
17-NovAre you interested in analyzing ABAP Short Dumps in SAP HANA Environments?

Check SAP KBA 2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANA Environments

Click here to know more: https://launchpad.support.sap.com/#/notes/2399990
20-NovTo ensure that the SAP HANA database can be recovered, you want to check the correctness of backups.
Please see SAP Note 1869119 on how you can do this with "hdbbackupcheck".

Click on : https://launchpad.support.sap.com/#/notes/1869119
22-NovTo protect your data against data loss usually there is a backup strategy in place where - during normal database operation - the payload (the actual data) stored in the data area and log area is saved to data and log backups at different locations.

SAP Note 2165547 provides answers to frequently asked questions about backup and recovery of an SAP HANA database for which an SAP HANA System Replication scenario is configured.

Click on : https://launchpad.support.sap.com/#/notes/2165547
24-NovTo ensure recoverability of the SAP HANA database, you want to check if the required data and log backups are present and undamaged.

Please see SAP Note 1873247 on checking recoverability with hdbbackupdiag --check.

Click here: https://launchpad.support.sap.com/#/notes/1873247
27-NovAre you running on a multi-host system ? If so, you may run in to this error while performing recovery :
"Recovery failed in nameserver startup: convert topology failed, mismatch: 1" . 

This issue is down to a topology mismatch and is discussed within KBA 1905462.

Click on : https://launchpad.support.sap.com/#/notes/1905462
29-NovDue to a SAP HANA bug the heap allocator Pool/RowEngine/QueryExecution can grow unexpectedly in the context of analytic privileges.

SAP Note 1999997 was extended accordingly
Click here: https://launchpad.support.sap.com/#/notes/1999997

 

 

 

Posted DateBroadcasted Message
Oct 6

"Does your SAP HANA return a result that seems to be wrong?

KBA 2222121 - SAP HANA Wrong Result Sets is a handy reference for you to check if the results differ from your expectation although they are not actually wrong.

Click here to check it out! https://apps.support.sap.com/sap/support/knowledge/preview/en/2222121 "

Oct 9

"Starting with SAP HANA 2.00.020 the consistency check via CHECK_TABLE_CONSISTENCY was extended in terms of fulltext indexes and unique constraints.

New checks are now documented in SAP Note 1977584 (https://launchpad.support.sap.com/#/notes/1977584)"

Oct 11

"
Simplify your landscape with SAP Solution Manager 7.2 on SAP HANA: TREX is no longer required for customers running SAP Solution Manager 7.2 on SAP HANA. SAP Notes 2400327 and 2397249 eliminate the need for a TREX installation by enabling Enterprise Search also for SAP Knowledge Base Articles.

Click on the link for more info! http://bit.ly/2wN1YeS"

Oct 13

"Are you interested in the available traces in SAP HANA database environments?

KBA 2119087 - How-To: Configuring SAP HANA Traces, provides all the configurations for the all the traces, and is updated periodically.  

For example, SAP HANA Studio JDBC trace just recently got added!

Click here to check it out! https://apps.support.sap.com/sap/support/knowledge/preview/en/2119087"

Oct 16

"SAP Note 2535286 was created for an issue that can result in wrong results when doing a LEFT OUTER JOIN with non-equi join conditions.

Please click the link for more info. https://launchpad.support.sap.com/#/notes/2535286"

Oct 18

"Are you interested in scheduling regular SAP HANA cleanup activities automatically?

Click here for more info -> https://apps.support.sap.com/sap/support/knowledge/preview/en/2399996"

Oct 20

"SAP Note 2498587 describes the possibility of inconsistent object types in metadata views OBJECTS vs. OBJECT_DEPENDENCIES. SQL: “HANA_Configuration_MiniChecks” (SAP Note 1999993) was extended with check ID 2140 (“Inconsistencies of metadata and dependencies”)

Click on the link for more info. https://launchpad.support.sap.com/#/notes/2498587 "

Oct 23

"Starting with SAP HANA 2.0 SPS 02 it is possible to limit the overall runtime of the CHECK_TABLE_CONSISTENCY check with a parameter.

SAP Note 2116157 was extended with related information: indexserver.ini -> [table_consistency_check] -> max_duration

Click here to read more! https://apps.support.sap.com/sap/support/knowledge/preview/en/2116157"

Oct 25

"Are you experiencing hanging situations? It may be possible that threads are waiting for certain locks.

KBA 1999998 - FAQ: SAP HANA Lock Analysis, just got added a lot of new information to help you troubleshoot your system.

Click here! https://apps.support.sap.com/sap/support/knowledge/preview/en/1999998"

Oct 27

"SAP Notes 2536154 was created for an issue that can result in wrong results (or terminations) with currency conversion and MDC in context of a calculation view.

Check out the link to see if you can take actions.
https://launchpad.support.sap.com/#/notes/2536154 "

Posted DateBroadcasted Message
Sep 04Enrollment has just opened for a new free CST openSAP course, Managing ABAP Systems on SAP NetWeaver, brought to you by SAP Product Support! 

The course starts from September 12 and will run over a three-week period.

Click here to access course -> https://open.sap.com/courses/cst1?tracking_user=4ijgCYzUZ1o9zBetlVwBRO&tracking_type=news&tracking_id=5Ztyj8OKxCIHy8upj9zDvS
Sep 06Want to learn more about performance traces?

SAP Note 2520774 - FAQ: SAP HANA Performance Trace, is now available to discuss details about the SAP HANA performance trace.
 
Check it out here -> https://apps.support.sap.com/sap/support/knowledge/preview/en/2520774
Sep 08Do you want to make sure that the tables of a BW/4HANA system are partitioned correctly and in-line with SAP recommendation?

Note 2334091 - BW/4HANA: Table Placement and Landscape Redistribution, is useful for you.

Click here to access the note -> https://launchpad.support.sap.com/#/notes/2334091
Sep 11Did you know SAP HANA 1.0 SPS 12 Database Revision 122.12 is now available?

Upgrade your system to utilize the latest features and enhancements!

Click on the link to read more! https://launchpad.support.sap.com/#/notes/2507876
Sep 13Want to sharpen your knowledge on SAP HANA?

SAP Training offers an extensive list of courses that can empower you to become a HANA expert!

Check out the course listings here -> https://blogs.sap.com/2017/08/30/sap-hana-courses-are-now-available/
Sep 15Is your SAP HANA communication secure?

To provide you better understanding on how to establish secure communication on your SAP HANA, new KBA 2487639 - HANA Basic How-To Series - HANA and SSL - MASTER KBA is available now!

Check it out here -> https://apps.support.sap.com/sap/support/knowledge/preview/en/2487639
Sep 18Wonder what were the top 10 viewed Notes in August?

Take a look at the Top 10 Viewed Notes in August 2017 here  -> https://wiki.scn.sap.com/wiki/display/SAPHANA/Top+10+Viewed+SAP+HANA+Notes+in+August+2017
Sep 20Great news!

SAP Note 2477204 - FAQ: SAP HANA Services and Ports, is now available to answer popular questions related to SAP HANA services and ports.

Check it out here -> https://apps.support.sap.com/sap/support/knowledge/preview/en/2477204 
Sep 22Wonder what were the top 10 viewed KBAs in August?

Take a look at the Top 10 Viewed KBAs in August 2017 here  -> https://wiki.scn.sap.com/wiki/display/SAPHANA/Top+10+Viewed+SAP+HANA+KBAs+August+2017
Sep 25Are your BW tables consistent ?
  
Since NW 7.30, SAP BW coding delivers report RSDU_TABLE_CONSISTENCY that checks the consistency of table properties on SAP HANA with certain needs and restrictions defined by the SAP BW application. The report can analyze only tables of BW objects which are activated and consistent within their BW metadata.
  
Refer to SAP Note 1937062 - Usage of RSDU_TABLE_CONSISTENCY for more info!

Link -> https://launchpad.support.sap.com/#/notes/1937062
Sep 27What types of traces and information should you provide to SAP HANA Support for a quicker processing?

We have included the information we need from our customers in SAP Note 1758890 - SAP HANA: Information needed by Product/Development Support to ensure smooth processing and help you resolve your issue as soon as we can.

Click on the link below to read it!
https://launchpad.support.sap.com/#/notes/1758890  

August 2017
Posted DateBroadcasted Message
Aug 02

Are you receiving alerts that log volume is reaching full?
Is your secondary or tertiary DB hanging?

This KBA can help you out! 2409471 - SAP HANA Log Volume Full on Secondary or Tertiary Site with System Replication

Take a look here -> www.wbca.st/zWGp6w⁠⁠⁠⁠

Aug 04

Getting -10709 errors? Take a look at the useful KBA that can help you!

KBA 2213725 - How-To: Troubleshooting of -10709 errors

Click here -> www.wbca.st/IuXEqw

Aug 08

Wonder what were the top 10 viewed Notes in July?

Take a look at the Top 10 Viewed Notes in July 2017 here -> www.wbca.st/6ZWFsw

Aug 10

Are you getting errors like ""Insufficient privileges"" on generated BW external HANA views?

KBA 2390443 - BW external HANA views and authorizations can help you out!

Click here -> www.wbca.st/8YG0Sw

Aug 14

Want to learn more about SAP HANA Administration?

'Introduction to SAP HANA Administration' is a free online openSAP course that's a necessity for all SAP HANA Administrators to make their lives simple! This course has been created for all SAP HANA administrators: database, system, or basis admins.

You can sign up for the course here -> www.wbca.st/0ntJ1w

Aug 16

Wonder what were the top 10 viewed KBAs in July?

Take a look at the Top 10 Viewed KBAs in July 2017 here -> www.wbca.st/zTqjDw

Aug 18

Is your SAP HANA Row Store memory a lot bigger than actual data size in row store?

You may need to perform a Row Store Reorganization. Check out Note 1813245 below to see how!

www.wbca.st/fhBBxw

Aug 21

Please help us understand our audience better by taking our short 5 question survey
This will help guide what information we deliver to you via WhatsApp so we can better serve you.

If you have any feedback or suggestions, please let us know!
We will review all of your valuable input to improve your Product Support experience.

Take the 30-second survey here -> www.wbca.st/SMNDrw

Aug 23

Do you often receive SAP HANA alerts?

SAP HANA triggers alerts in HANA Studio when it needs your attention.

Bookmark this handy link to see what each alert means and how you could resolve them -> www.wbca.st/qhkKxw

Aug 25

Did you know SAP HANA 2.0 SPS 2 Database Revision 20 is now available?

Click on the link to read more! www.wbca.st/AyBKBw

Aug 29

What can you do when SAP HANA DB is no longer accessible?

KBA 1999020 - How-To: SAP HANA Troubleshooting when Database is no longer accessible, tells you a couple of things that you can do!

Click here to read more -> www.wbca.st/ZAl5Mw



July 2017
Posted DateBroadcasted Message

Jul 05

Did you know that you can now automaize conditioned capturing of specific SAP HANA information (ex. Triggering a runtime dump to be collected when a significant amount of threads is blocked) ?

KBA 2399979 - How-To: Configuring automatic SAP HANA Data Collection with SAP HANASitter will tell you how.
Click on the link below and set it up!
www.wbca.st/rzggaw

Jul 07

Have you used our new SAP Help Portal for SAP HANA Platform? It contains all the useful guides like Administration guides, Security guides, Server Installation & Update guides, and more.

You can search through all the guides directly on the portal! Give it a try!
Click here: www.wbca.st/HCjatw

Jul 10

Do you know what types of traces and information you should provide to SAP HANA Support for a quicker processing?

We have included the information we need from our customers in SAP Note 1758890 - SAP HANA: Information needed by Product/Development Support, to ensure smooth processing and help you resolve your issue as soon as we can!

Click on the link below to read it!
www.wbca.st/Ysd70w

Jul 12

Take a look at the Top 10 Viewed SAP Notes in June 2017!

Click here: www.wbca.st/KiDSCw

Jul 14

Did you know you that can configure workload management in SAP HANA to balance and stabilize the workload, and further stabilize the system?

See KBA 2222250 - FAQ: SAP HANA Workload Management for more information. Click on the link below to read more!
www.wbca.st/HfPORw

Jul 17

Are you interested in a pro-active SAP HANA Consistency Check, or do you face symptoms that indicate inconsistencies?

Note 1977584 - Technical Consistency Checks for SAP HANA Databases, covers options to check for technical SAP HANA inconsistencies.

Click the link to see the note! www.wbca.st/jSrz2w

Jul 19

Wonder what were the top 10 viewed KBAs in June?

Take a look at the Top 10 Viewed KBAs in June 2017 here -> www.wbca.st/hLXHRw

Jul 24

Are you interested in scheduling regular SAP HANA cleanup activities automatically?

Click here for more info -> www.wbca.st/njpciw

Jul 26

Do you have SAP Landscape Transformation (SLT) Replication Server related issues? Click on the wiki below for useful info that can help you out!

www.wbca.st/INbhVw

Jul 28

Did you know SAP HANA SPS 12 Database Maintence Revision 11 is now available?

Click on the link to read more here: www.wbca.st/wbRnmw


June 2017
Posted DateBroadcasted Message

Jun 21

Do you often receive SAP HANA alerts? SAP HANA triggers Alerts in HANA Studio when it needs your attention. Bookmark on this link to see what each alert means and how you could resolve them. https://apps.support.sap.com/sap/support/knowledge/preview/en/2445867

Jun 23

Did you know SAP HANA SPS 12 Database Maintence Revision 122.10 is now available? Click on the link to read more here: https://launchpad.support.sap.com/#/notes/2475609

Jun 26

Expert Chat is available for SAP HANA incidents! Learn more about Expert Chat and how to start a live chat session with an expert engineer for fast support here: https://apps.support.sap.com/sap/support/knowledge/preview/en/2213344

Jun 28

Have you seen the master FAQ KBA for general advice on SAP HANA? Click on the link to find out more! https://apps.support.sap.com/sap/support/knowledge/preview/en/2000003

Jun 30

So you want to configure Single Sign-On (SSO) for your SAP HANA Landscape? Here are the top 7 guides and resources you must know about! Bookmark this link: www.wbca.st/Lku3mw