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

[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

[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,

the latest patch is:

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

BR,

Andreas 

[ssaravan]

Hi Andreas,

My bad. You are using SnapCreator 4.1P1. 

You need to upgrade atleast to 4.1.1 to use catalog feature of HANA.

Thanks and Regards,

Saravana

[ANDREAS_JANKOWIAK]

Hi Saravana,

thanks! Oh my fault, SC Server is running with 4.1.1 but agent with 4.1 P1. 

I've update now the agent to 4.1.1, but now I get another error:

[2015-06-24 13:25:15,556] INFO: Application Quiesce for plugin : hana
[2015-06-24 13:25:20,790] INFO: [:9090 (4.1.1.1)] HANA application quiesce operation started.
[2015-06-24 13:25:20,790] ERROR: [:9090 (4.1.1.1)] * -10104: Invalid value for KEY (SCADMIN)
[2015-06-24 13:25:20,790] ERROR: [:9090 (4.1.1.1)] [hdb-00008] Running command on HANA node failed.[userstore key: SCADMIN, sid: TST]
[2015-06-24 13:25:20,790] ERROR: [1:9090(4.1.1.1)] SCF-00037: Application quiesce for plug-in [hana] failed with error [] and exit code [1], Exiting!
[2015-06-24 13:25:20,792] DEBUG: Workflow : quiesce_OnFailure started with workflow id : 194

The Key SCADMIN is valid.

Do you have an idea?

BR,

Andreas

[ssaravan]

Hi Andreas,

Are you able to connect successfully via hdbsql using this key? 

Also, it is good chech with newly created key (SnapCreator config also to be updated accordingly).

Let us know.

Regards,

Saravana

[Arora_Kapil · Accepted solution]

The user that created the key and the user that is running SC Agent should be the same.

Kapil

[ANDREAS_JANKOWIAK]

Hello,

now it is working ;o)) 

After creating the Key with user root like stated in the HANA plugin documentation "The userstore key is configured with the OS root user"...   it runs very well.

Test restore was successfull 😉 

Thanks again for your help!

Best Regards,

Andreas