HANA Plugin

[ANDREAS_JANKOWIAK]

Hi Community,

I've a problem by configuring the HANA plugin in SC 4.1.1. I've setup the plugin and I'm able to quiese the HANA database. When the database is quiesed a HANA Snapshot is created and shown in the backup catalog as a snapshot like backup.  When I unquiese the database the HANA snapshot is deleted.

When I try to perform a backup via SC the database is quiesed, the HANA snapshot is created (listed in Backup catalog), the storage snapshot is created and the database is unquiesed.

Unfortunately the backup entry in the backup catalog disappears when the backup is finished (successfully).

Did I miss something?

Thank you.

Best Regards,

Andreas

[ANDREAS_JANKOWIAK]

Hi,

it seams the HANA plugin is not confirming the storage snapshot in the backup catalog. 

Therefore after deleting the HANA snapshot via "BACKUP DATA DROP SNAPSHOT" the snapshot is gone but also the information in the backup catalog.

Did I miss something?

Best Regards,

Andreas

[ANDREAS_JANKOWIAK]

Anyone?

Thanks

BR,

Andreas

[ssaravan]

Hi Andreas,

Could you please share SnapCreator Agent and Server logs for study?

Regards,

Saravana

[ANDREAS_JANKOWIAK]

Hi Saravana,

thanks for your reply.

Of course I can... is it possible to sent the logs directly to you via email?

Best Regards,

Andreas

[Arora_Kapil]

Hi Andreas,

HANA plug-in will also do cleanup of snapshots from the HANA Backup Catalog as per the Snapshot retention policy set in the Snap Creator config.

If you retain daily 1 snapshot, old backup catalog entries will be deleted when the snapshot is cleaned up as part of retention.

The exisiting snapshots on NetApp storage should in any case exist in the backup catalog if they were created through the HANA plug-in.

Saravana will help you further with this issue. Once he receives the logs and config he will be able to debug the issue for you.

Thanks,

Kapil

[ANDREAS_JANKOWIAK]

 Hi Kapil,

thanks for your reply.

I've a retention of five snapshots and I get the problem even if there is no snapshot on the volume. 

The situation is: 

- HANA snapshot is created, checked via select * from m_snapshots

- I can see an entry in the backup catalog

- Storage Snapshot is created

- HANA snaphot is deleted,  but then the entry in the backup catalog dissapears

- Storage Snapshot is available 

Thanks,

BR,

Andreas

[ssaravan]

Hi Andreas,

Please send config and log files to my email id saravana.s@netapp.com

Regards,

Saravana

[Arora_Kapil]

Hi Andreas,

What is your version of HANA DB?

Kapil

[ANDREAS_JANKOWIAK]

Hi Kapil,

1.00.097.00 but I've the same problem with another system which is on level 1.00.091.00.

I've sent the config and logs to Saravana.

Thanks!

Best Regads,

Andreas

[ssaravan]

Hi Andreas,

Is your SAP HANA SP7 and beyond? 

SAP-HANA catalog is maintained only for SP7 and beyond.

Following is the excerpt from logs specific to UnQuiesce operation (part of Backup)

The following highlighted statement is only executed if SAP SP6 or below is installed.

[2015-06-24 09:39:52,298] INFO: Application Unquiesce for plugin: hana
[2015-06-24 09:40:02,554] INFO: [vmsaplnx21:9090 (4.1.1.1)] (Wed Jun 24 07:39:55 2015) Database unquiesce started.
[2015-06-24 09:40:02,555] INFO: [vmsaplnx21:9090 (4.1.1.1)] (Wed Jun 24 07:39:55 2015) Deleting HANA database snapshot for [TST].
[2015-06-24 09:40:02,555] INFO: [vmsaplnx21:9090 (4.1.1.1)] (Wed Jun 24 07:39:55 2015) Attemting to run [backup data drop snapshot] on [vmsaplnx21].
[2015-06-24 09:40:02,555] DEBUG: [vmsaplnx21:9090 (4.1.1.1)] (Wed Jun 24 07:39:55 2015) Executing SQL sequence:
[2015-06-24 09:40:02,555] DEBUG: [vmsaplnx21:9090 (4.1.1.1)] (Wed Jun 24 07:39:55 2015) backup data drop snapshot
[2015-06-24 09:40:02,555] DEBUG: [vmsaplnx21:9090 (4.1.1.1)] (Wed Jun 24 07:39:59 2015) Command [su - tstadm -c "/hana/shared/TST/hdbclient/hdbsql -i 10 -n vmsaplnx21 -u SCADMIN -p xxxxxxxx -I /tmp/JSEsmYiXh4.sc"] finished with
[2015-06-24 09:40:02,555] DEBUG: [vmsaplnx21:9090 (4.1.1.1)] (Wed Jun 24 07:39:59 2015) exit code: [0]
[2015-06-24 09:40:02,555] DEBUG: [vmsaplnx21:9090 (4.1.1.1)] (Wed Jun 24 07:39:59 2015) stdout: []
[2015-06-24 09:40:02,555] DEBUG: [vmsaplnx21:9090 (4.1.1.1)] (Wed Jun 24 07:39:59 2015) stderr: []

Thanks and Regards,

Saravana

[ANDREAS_JANKOWIAK]

Hello,

this is strange... HANA is on level 1.00.097.00 but I've the same problem with another system which is on level 1.00.091.00.

BR,

Andreas

[ssaravan]

Hi Andreas,

Could you please run the below SQL command from HANA-Studio (SQL) and share the output?

select * from m_features

Please execute the command on both HANA Systems and share the result.

Regards,

Saravana

[Arora_Kapil]

Hi Andreas,

I just checked the SAP website and the latest HANA release is SAP HANA DB 1.00.96 (SPS 09)

I am not very sure if you have a SPS 9 system.

Is this SPS0?

Kapil

[ANDREAS_JANKOWIAK]

Hi Saravana,

of course ;o) 

System TST:

COMPONENT_NAME;FEATURE_NAME;FEATURE_VERSION
BACKUP RECOVERY;SPLIT DATA BACKUP;1
BACKUP RECOVERY;SYNTAX;6
CALCENGINE;ADHOC CALCSCENARIO;2
CALCENGINE;BW UNIT CONVERSION;3
CALCENGINE;ERP CURRENCY CONVERSION;3
CALCENGINE;ERP UNIT CONVERSION;2
CALCENGINE;FACTORY CALENDAR;1
CALCENGINE;VERSION;1
CATALOG;QUOTED ROLE NAME;1
CDS;API;3
CDS;COMPILER BUILD ID;145.200
CDS;COMPILER MAJOR VERSION;1
CDS;COMPILER MINOR VERSION;2
CLEARTRACES;EXPENSIVESTATEMENT;1
CLEARTRACES;ROWSTOREREORG;1
CLEARTRACES;RTEDUMP;1
CLEARTRACES;TRACEPROFILE;1
CLEARTRACES;UNLOAD;1
EXPENSIVE STATEMENTS TRACE;CONFIGURATION LAYOUT;1
FULLTEXTINDEX;TOKEN_SEPARATORS;1
IMPORTEXPORT;IMPORT AT LOCATION;1
IMPORTEXPORT;NO CONTROL FILE;1
IMPORTEXPORT;NO DEPENDENCIES;1
IMPORTEXPORT;RENAME SCHEMA;1
IMPORTEXPORT;SCAN PATH;1
KERNEL PROFILER;M_KERNEL_PROFILER;1
LICENSING;MEASUREMENT;2
METADATA;TABLE CLASSIFICATION;1
MODEL DEPLOYMENT;SERVER DEPLOYMENT;2
PARTITIONING;ADD RANGE LEVEL;2
PARTITIONING;ALTER PARTITIONING COLUMNS;2
PARTITIONING;RANGE_RESTRICTION;1
PERFTRACE;QUOTED NAMES;1
REPOSITORY;API;18
REPOSITORY;EXPORT ARCHIVE FORMAT;15
REPOSITORY;FUNCTION ACTIVATION DDL;1
REPOSITORY;PROCEDURE ACTIVATION DDL;1
REPOSITORY;PROCEDURE TEMPLATE ACTIVATIONXML;1
SECURITY;ANALYTIC PRIVILEGES;3
SECURITY;AUDIT TRAIL TYPE;2
SECURITY;PASSWORD POLICY;1
SECURITY;PRIVILEGES;2
SECURITY;SAML AUTHENTICATION;1
SECURITY;STATIC PROCEDURE DEPENDENCIES;1
SECURITY;STATIC VIEW DEPENDENCIES;1
SECURITY;TRACE ADMIN;2
SECURITY;USER PROPERTIES;3
SECURITY;X509 AUTHENTICATION;1
SERVICES;THREAD ACTIVE FILTER;2
SMART DATA ACCESS;ADMINISTRATION;40
SPATIAL;SHAPEFILE IMPORT;1
SQL;AUDIT POLICY;8
SQL;CONVERSION FUNCTION;2
SQL;FUZZY SEARCH;5
SQL;GRAMMAR;4
SQL;HINT;1
SQL;LOAD HISTORY;1
SQL;MULTIDB;1
SQL;PLAN VISUALIZER;12
SQL;TRIGGER;1
SQL;UNLOAD PRIORITY;1
SYS.DEBUG;ATTACH TO SQL SESSION;3
SYS.DEBUG;BACKTRACE;1
SYS.DEBUG;BREAK;1
SYS.DEBUG;FULL DEBUG MODE;2
SYS.DEBUG;GET STATUS;2
SYS.DEBUG;INIT DEBUGGING SESSION;4
SYS.DEBUG;LLANG BREAKPOINTS;1
SYS.DEBUG;SQL SCRIPT BREAKPOINTS;1
SYS.DEBUG;TABLE ACCESS;1
SYS.DEBUG;TERMINATION OF DEBUGGING SESSION;1
SYS.DEBUG;VERSION;3
SYSTEMPROCEDURE;BW_F_FACT_TABLE_COMPRESSION;4
SYSTEMPROCEDURE;GET_FULL_SYSTEM_INFO_DUMP;1.017
SYSTEMPROCEDURE;TREXVIADBSLWITHPARAMETER;1
SYSTEMPROCEDURE;UPDATE_LANDSCAPE_CONFIGURATION;2
UNIFIED TABLE;L2D;1
XS;DEBUGGER;1

Other System:

COMPONENT_NAME;FEATURE_NAME;FEATURE_VERSION
BACKUP RECOVERY;SPLIT DATA BACKUP;1
BACKUP RECOVERY;SYNTAX;6
CALCENGINE;ADHOC CALCSCENARIO;2
CALCENGINE;BW UNIT CONVERSION;3
CALCENGINE;ERP CURRENCY CONVERSION;3
CALCENGINE;ERP UNIT CONVERSION;2
CALCENGINE;FACTORY CALENDAR;1
CALCENGINE;VERSION;0
CATALOG;QUOTED ROLE NAME;1
CDS;API;3
CDS;COMPILER BUILD ID;144.600
CDS;COMPILER MAJOR VERSION;1
CDS;COMPILER MINOR VERSION;2
CLEARTRACES;EXPENSIVESTATEMENT;1
CLEARTRACES;ROWSTOREREORG;1
CLEARTRACES;RTEDUMP;1
CLEARTRACES;TRACEPROFILE;1
CLEARTRACES;UNLOAD;1
EXPENSIVE STATEMENTS TRACE;CONFIGURATION LAYOUT;1
FULLTEXTINDEX;TOKEN_SEPARATORS;1
IMPORTEXPORT;IMPORT AT LOCATION;1
IMPORTEXPORT;NO CONTROL FILE;1
IMPORTEXPORT;NO DEPENDENCIES;1
IMPORTEXPORT;RENAME SCHEMA;1
IMPORTEXPORT;SCAN PATH;1
KERNEL PROFILER;M_KERNEL_PROFILER;1
METADATA;TABLE CLASSIFICATION;1
MODEL DEPLOYMENT;SERVER DEPLOYMENT;2
PARTITIONING;ADD RANGE LEVEL;2
PARTITIONING;ALTER PARTITIONING COLUMNS;2
PARTITIONING;RANGE_RESTRICTION;1
PERFTRACE;QUOTED NAMES;1
RDL;COMPILER MAJOR VERSION;3
RDL;COMPILER MINOR VERSION;0
RDL;COMPILER PATCH VERSION;0
RDL;PARSER VERSION;8.000.000
REPOSITORY;API;18
REPOSITORY;EXPORT ARCHIVE FORMAT;15
REPOSITORY;FUNCTION ACTIVATION DDL;1
REPOSITORY;PROCEDURE ACTIVATION DDL;1
REPOSITORY;PROCEDURE TEMPLATE ACTIVATIONXML;1
SECURITY;ANALYTIC PRIVILEGES;3
SECURITY;AUDIT TRAIL TYPE;2
SECURITY;PASSWORD POLICY;1
SECURITY;PRIVILEGES;2
SECURITY;SAML AUTHENTICATION;1
SECURITY;STATIC PROCEDURE DEPENDENCIES;1
SECURITY;STATIC VIEW DEPENDENCIES;1
SECURITY;TRACE ADMIN;2
SECURITY;USER PROPERTIES;3
SECURITY;X509 AUTHENTICATION;1
SERVICES;THREAD ACTIVE FILTER;2
SMART DATA ACCESS;ADMINISTRATION;40
SPATIAL;SHAPEFILE IMPORT;1
SQL;AUDIT POLICY;8
SQL;CONVERSION FUNCTION;2
SQL;FUZZY SEARCH;5
SQL;GRAMMAR;4
SQL;HINT;1
SQL;LOAD HISTORY;1
SQL;MULTIDB;1
SQL;PLAN VISUALIZER;12
SQL;TRIGGER;1
SQL;UNLOAD PRIORITY;1
SYS.DEBUG;ATTACH TO SQL SESSION;3
SYS.DEBUG;BACKTRACE;1
SYS.DEBUG;BREAK;1
SYS.DEBUG;FULL DEBUG MODE;2
SYS.DEBUG;GET STATUS;2
SYS.DEBUG;INIT DEBUGGING SESSION;4
SYS.DEBUG;LLANG BREAKPOINTS;1
SYS.DEBUG;SQL SCRIPT BREAKPOINTS;1
SYS.DEBUG;TABLE ACCESS;1
SYS.DEBUG;TERMINATION OF DEBUGGING SESSION;1
SYS.DEBUG;VERSION;3
SYSTEMPROCEDURE;BW_F_FACT_TABLE_COMPRESSION;4
SYSTEMPROCEDURE;GET_FULL_SYSTEM_INFO_DUMP;1.017
SYSTEMPROCEDURE;TREXVIADBSLWITHPARAMETER;1
SYSTEMPROCEDURE;UPDATE_LANDSCAPE_CONFIGURATION;2
UNIFIED TABLE;L2D;1
XS;DEBUGGER;1

[ANDREAS_JANKOWIAK]

Hi,

the latest patch is:

IMDB_SERVER100_97_0-10009569.SAR Revision 97 (SPS9) for HANA DB 1.00    from 18.06.2015

BR,

Andreas