xxxxx is disabled and will not be called. Reason: timeout SNAPSHOT_ID

In HANA Studio I see many following internal alerts

 Internal statistics server problem --- xxx is disabled and will not be called. Reason: timeout SNAPSHOT_ID: <timestamp>

I found below error message in Indexserver trace.

These issues fixed in SAP HANA SPS08 database maintenance version 85.05, Please check the release SAP note 2188592.

If you are in higher version still receiving these alerts then raised a ticket with SAP.

Regards

Satishbabu Gunukula, Oracle ACE

http://www.oracleracexpert.com

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: Unable to load driver manager

When trying to create “Remote source” to Microsoft SQL Server under Smart Data Access (SDA) using HANA received following error

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: Unable to load driver manager 

By looking the error it looks like the driver does not exists or not installed properly.  To find out the driver install or not run below command, if you receive an error then its not installed.

#isql --help
SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: [unixODBC][Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Login failed for user 'hanasdauser'. 

I have followed below steps to install the Drivers

1. Set the environment
# cd /hana/ms-odbc-driver/unixODBC-2.3.0
# export CPPFLAGS=”-DSIZEOF_LONG_INT=8”
# echo $CPPFLAGS
-DSIZEOF_LONG_INT=8

2. Configure
#./configure --prefix=/usr --libdir=/usr/lib64 --sysconfdir=/etc --enable-gui=no --enable-drivers=no --enable-iconv --with-iconv-char-enc=UTF8 --with-iconv-ucode-enc=UTF16LE

3. Run make utility
# make

4. Run make install
# make install

5. Test the driver is installed or not
# isql –help
unixODBC 2.3.0

After installing the driver I was able to create Remote Source in HANA under SDA.

Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Note 1732157 - Collecting support information for SAP HANA.

If you open any ticket with HANA, first they will ask you to collect the dump.

Collecting the dump is very simple in HANA and follows the steps.

1. Open HANA Studio -->  go to ‘Diagnosis files’ --> In ‘Diagnosis Information’ click  'List '
2. Select the dates where you had the issue or you want to collect diagnosis information --> Click “OK”
3. Collecting the diagnosis information will take time and once it finish “Download the Collection”

The dump will be created under below path
/usr/sap/SID/SYS/global/sapcontrol/snapshots

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

SAP DBTech JDBC: [2048]: column store error: search table error

We have received following error when selection data from an reporting application.

[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search table error: [1000002] exception 1000002: ltt/impl/memory.cpp:86 Allocation failed ; $size$=1573119; $name$=ihm; $type$=pool; $inuse_count$=80; $allocated_size$=109062096 exception 1000002: ltt/impl/memory.cpp:86 Allocation failed ; $size$=209664; $name$=temp_aggregates; $type$=pool; $inuse_count$=946; $allocated_size$=58136000 Unable to create extract

Sometimes you will not get complete error message in the application log. It’s always good idea to run the query in HANA studio to get the complete error.

I have ran the same query manually using HANA studio and got the below error

SAP DBTech JDBC: [2048]: column store error: search table error: [9] Memory allocation failed
If you look at the error carefully you should be able to identify that “memory allocation failed”. Normally you will see this error when there is a statement memory limit set for the application user or end user running the query.

I have increased the memory for the user using below command and the issue has been resolved.
ALTER USER <username> SET PARAMETER STATEMENT MEMORY LIMIT = <gb>

You need to identify the optimal value for you environment to avoid these errors.

To reset a statement limit use the SQL statement:
ALTER USER <username> CLEAR PARAMETER STATEMENT MEMORY LIMIT

Note that in order to enable statement memory limit you must enable STATEMENT MEMORY TRACKING IN THE GLOBAL.INI FILE.

The below parameters must be ON.
enable_tracking = on
memory_tracking = on

You should be able to view the memory consumption of a statement in M_EXPENSIVE_STATEMENTS.MEMORY_SIZE.

Regards,
Satishbabu Gunukula, Oracle ACE

What s new in SAP HANA SPS 07?

As everyone knows SAP HANA SPS07 has many new features. Instead I explain each and every feature I am providing the documentation at one place. I highly recommend SAP Documentation first, once you go through below docs, if you read any books you will see the difference.

If you are SAP Basis/Database Admin and planning to take SAP Hana Training, I would strong recommend seeing below Videos before you start your training.
SAP HANA SPS 07 New Features and Videos

If you really want to be an expert I would advise to go thought the SAP documentation and practice.

Please click on below links for documentation

1. What’s new in the SAP HANA platform (Release Notes)
2. Architecture & Landscape
3. Administration & Monitoring
4. SAP HANA UI Integration Services.
5. SAP BI Integration
6. SAP HANA Interactive Education (SHINE)
7. Fulltext Search
8. Fuzzy Search
9. SQLScript
10. Geospatial Processing
11. AFL / Predictive
12. SAP HANA Studio Development Perspective
13. SAP River
14. SAP HANA Smart Data Access
15. Modeling Enhancements
16. Backup & Recovery
17. SAP HANA tailored data center integration
18. SAP HANA Platform Lifecycle Management
19. SAP HANA Extended Application Services (XS) & Content Lifecycle Management
20. Real-Time Data Replication with SAP Landscape Transformation Replication Server
21. Scale-Out, High Availability and Disaster Recovery
22. Driving Innovation with In-Memory Technology

I found few interesting topics on other blogs and sharing the info.

1. What's new in SAP HANA SPS 7 - Monitoring
2. What's new in SAP HANA SPS 7 - Authentication
3. What's new in SAP HANA SPS 7 - SHINE

Here are few tutorial videos posted on YouTube.

* SAP HANA server installation, part 1 - discusses important concepts, what documentation you need to consider, where to download, etc.
* SAP HANA server installation, part 2 - shows the actual installation using the new Lifecycle Manager GUI in interactive mode
* SAP Hana Installation – Server Database Autostart - shows how to configure SAP HANA database to start at system boot
* Installing SAP HANA Studio on Linux & Windows- How to install SAP HANA studio on Linux and Windows

Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

SAP HANA SPS 07 New Features and Videos

SAP HANA SPS07 has many new features. Here I am providing “Product expert session recorded Videos" to make it easy for you to learn.

1. Architecture & Landscape

Driven by customer demand for innovation, a lot of new capabilities had been introduced into SAP HANA over the last three years. Keep pace with the changes and new capabilities introduced, by overseeing the product architecture, scenarios and deployment options which are available with SAP HANA SPS 07.

2. New development language and programming environment

Introducing SAP River, a new development language and programming model for rapidly developing a complete SAP HANA backend application.

3. Modeling Enhancements

This session will provide an overview of the new capabilities and enhancements in SAP HANA Modeling available with SAP HANA SPS 07. 

4. SAP HANA Extended Application Services (XS) & Content Lifecycle Management

This session will discuss new features for “backend” XS and content lifecycle management in SAP HANA SPS 07.


5. SAP HANA UI Integration Services - Overview and What´s New with SPS 07?

SAP HANA UI Integration Services provide the required services and UI patterns to easily create and design single applications or application sites based on HANA native (XS) applications through efficient development tools, standardized services and consistent UI experience. This session will discuss the overview of SAP HANA UI Integration Services and new features delivered in SAP HANA SPS 07.

6. Application Function Library/ Predictive Analysis library

SAP HANA contains native predictive analytics functionality, provided through the framework of the Application Function Library. In particular, the Predictive Analysis Library (PAL) and the Application Function Modeler (AFM) are used to build, train, execute, and leverage predictive models inside SAP HANA. This session will provide an update on the latest features for PAL and AFM in SAP HANA SPS 075. 

7. SQLScript

This session we will cover what’s new in SQLScript in SAP HANA SPS 07. You should able to learn new procedure artifact, the new function wizards, a procedure viewer as well as catalog debugging and a new debugging authorization concept.

8. Text Analysis

This Live Expert session offers the opportunity to learn about the highly anticipated new custom configuration and dictionary support in SAP HANA Studio for text analysis. In pursuit of continuous improvement, greater indexing throughput and deeper, refined language coverage will also be highlighted.

9. HANA Development Tools (Studio & Web IDE)

In this session we will explore the new features in the SAP HANA Development perspective of the SAP HANA Studio as well as the SAP HANA Web-based Development Workbench. See improvements to the overall tooling, workflow, individual editors as well as completely new tools such as the graphical CDS tool.

10. Backup & Recovery and High Availability & Disaster Recovery

Focus of this session is on the new features available for HANA backup and recovery, including extended support for storage snapshots.

11. Real-time data replication

A proven data provisioning concept is a key success factor for most SAP HANA-based applications and scenarios. In the last years SAP Landscape Transformation replication server evolved to a cornerstone in most SAP HANA customer landscapes with real-time replication needs. Connecting SAP and non-SAP software sources, filtering and the transformation of data can be used to achieve outstanding performance with SAP Landscape Transformation replication server and SAP HANA. In this session, you will learn about its newest functions and features for SAP HANA SPS 07 as well as about the development roadmap

Hope this helps, please leave your comments.

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com