SAP hana migration upgrades

[Former Member]

Does system replication overwrite upgrades?

When i upgrade original primary and then secondary replicates to primary

Does my xs engine content get over written?

Delivery units versions are overwritten from replication?

Thanks!

Is there a process to gather all the delivery units from a fresh install and add them to a recovered install of same hana version.

Secondary is hana version 100 but recovered from hana version 97 making all the Hana delivery units of version 97

Primary is 97
upgrade primary to 100 Delivery units are version 100
Set primary as streaming replica

Fail over;
What are the New primaries Delivery units versions?

[Former Member · Accepted solution]

Solved all this noise below..

SUSE Linux Server 11 sp3

Hana upgrade from 83 to 101 (dev envirionment); 97 to 101 (production Environment);

Upgrade was successful after fail over to Streaming Replica..

When adding Hana version 101 as Replica of Primary(old replica).  The xsengine Content Folder would be over written; all packages /sap/hana/xs/admin, /sap/hana/xs/wdisp/admin; packages sap/* etc..
All overwritten with Primary (old replica, version 83,97).

I therefore would not get access to cockpit, wdisp, the new XS admin UI features..

I had turned off Statistics server way back during version 83.

When trying to re install Delivery Units after they were overwritten during Streaming Replication
Installation was failing for ZHANA_ADMIN.tgz,
Logs suggested that hana _SYS_STATISTICS schema and table was missing a field, After comparing this DB to a new install DB; the Field did not exist on the table as the logs mentioned.

NOTE 2006652

was of great help re initializing to the embedded statistics server.

After the process of getting statistics server running, I re ran hdbupdrep with --content_directory argument.

/hana/shared/<HANA SYSTEM ID>/global/hdb/install/bin/hdbupdrep

/hana/shared/HDB/global/hdb/install/bin/hdbupdrep /hdbupdrep \

--content_directory=/usr/sap/H2D/SYS/global/hdb/auto_content

This ran successfully and I was able to add ROLE

sap.hana.admin.Administration

to my user and see the /sap/hana/xs/cockpit

Hope this Helps People in the future.

Cheers,

Z

[Former Member]

error Log

Job Details	.
Job ID :	H2D_ImportSeverModels_SYSTEM_1445628642593
Job Type :	Import Delivery Unit
System :	H2D:10.1.1.189:00:SINGLEDB:SYSTEM
Start Time :	Fri Oct 23 19:30:42 UTC 2015
End Time :	Fri Oct 23 19:30:56 UTC 2015
Elapsed Time :	13.603 Seconds
Summary Report	.
Name Type Package Status Description HANA_UI_INTEGRATION_1_SVC.tgz Import Delivery Unit - Success . GET_NAVIGATION_TARGET_DATA Calculation View sap.hana.uis.db Success . Monitoring hdbrole sap.hana.admin.roles Error . Administrator hdbrole sap.hana.admin.roles Error . SysRepAdmin hdbrole sap.hana.admin.cockpit.sysrep.roles Error . Developer hdbrole sap.hana.xs.lm.roles Error . DevelopmentExpert hdbrole sap.hana.xs.lm.roles Error . Administrator hdbrole sap.hana.xs.lm.roles Error . BI_LAUNCHPAD_FIORI hdbrole sap.bi.launchpad Error . BI_LAUNCHPAD_SMB_MODELER hdbrole sap.bi.launchpad Error .
Detailed Report	.
	Delivery Unit Import Selected File:/usr/sap/H2D/SYS/global/hdb/auto_content/HANA_UI_INTEGRATION_1_SVC.tgz Overwrite inactive versions:true Activate Objects:true Bypass validation:true Activation sap.bi.launchpad.BI_LAUNCHPAD_FIORI.hdbrole A transaction rollback may have left the object in an inconsistent state. Runtime 'SqlScript runtime' finished activation of 7 object(s) in 629ms Runtime 'BI-runtime' finished activation of 1 object(s) in 387ms Runtime 'Procedure Runtime' finished activation of 11 object(s) in 368ms Runtime 'View runtime' finished activation of 24 object(s) in 2350ms sap.hana.admin.roles.Administrator.hdbrole insufficient privilege: Not authorized at ptime/query/checker/query_check.cc:3389 Finished activation phase. Starting regeneration phase now. Runtime 'TableImportRuntime' finished activation of 1 object(s) in 57ms Runtime 'sqlproc-runtime' finished activation of 45 object(s) in 3900ms Runtime 'TableType runtime' finished activation of 2 object(s) in 304ms Runtime 'Role runtime' finished activation of 2 object(s) in 2171ms Runtime 'Table runtime' finished activation of 8 object(s) in 208ms Runtime 'Table Function Runtime' finished activation of 2 object(s) in 166ms Runtime 'Text Bundle runtime' finished activation of 3 object(s) in 0ms Runtime 'OData service runtime' finished activation of 10 object(s) in 434ms Runtime 'Schema runtime' finished activation of 1 object(s) in 11ms Runtime 'JavaScript-serverside-runtime' finished activation of 59 object(s) in 254ms Runtime 'XSApp-runtime' finished activation of 6 object(s) in 18ms Runtime 'XSAccess-runtime' finished activation of 12 object(s) in 14ms Runtime 'XSPrivileges-runtime' finished activation of 2 object(s) in 3ms Runtime 'XSConfigRuntime' finished activation of 2 object(s) in 9ms sap.hana.admin.cockpit.sysrep.roles.SysRepAdmin.hdbrole role "sap.hana.admin.roles::Administrator" is unknown Activation is performed with activation mode import. sap.hana.xs.lm.roles.Administrator.hdbrole A transaction rollback may have left the object in an inconsistent state. A transaction rollback may have left the object in an inconsistent state. A transaction rollback may have left the object in an inconsistent state. A transaction rollback may have left the object in an inconsistent state. sap.bi.launchpad.BI_LAUNCHPAD_SMB_MODELER.hdbrole A transaction rollback may have left the object in an inconsistent state. sap.hana.uis.db.GET_NAVIGATION_TARGET_DATA.CALCULATION_VIEW Model deployment started: sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA timestamp: 2015-10-23,19:30:53.260 Removing BIMC records for sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA timestamp: 2015-10-23,19:30:53.263 Removing hierarchy views for sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA timestamp: 2015-10-23,19:30:53.297 Start deployment of script-based calculation view, timestamp: 2015-10-23,19:30:53.460 set schema "UIS" create type "_SYS_BIC"."sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA/proc/tabletype/VAR_OUT" as table ("TENANT_ID" VARCHAR(50), "id" VARCHAR(256), "applicationType" VARCHAR(50), "applicationData" VARCHAR(512), "postParameters" NVARCHAR(5000), "text" NVARCHAR(2000), "applicationAlias" VARCHAR(100), "url" NVARCHAR(5000)) create procedure "_SYS_BIC"."sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA/proc" ( IN IN_TAG NVARCHAR(5000), OUT var_out "_SYS_BIC"."sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA/proc/tabletype/VAR_OUT" ) language sqlscript sql security definer reads sql data as /********* Begin Procedure Script ************/ BEGIN call "UIS"."sap.hana.uis.db/GET_NAVIGATION_URL"(IN_TAG , var_out);END /********* End Procedure Script ************/ End deployment of script-based calculation view, timestamp: 2015-10-23,19:30:53.586 Post deploy processing started: sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA timestamp: 2015-10-23,19:30:53.621 Model deployment ended: sap.hana.uis.db/GET_NAVIGATION_TARGET_DATA timestamp: 2015-10-23,19:30:53.621 Runtime 'Role runtime' finished revalidation of 8 object(s) in 431ms sap.hana.admin.roles.Monitoring.hdbrole "sap.hana.admin.cockpit:GET_URL.__DT_CATALOG_OBJECT__": runtime object not found sap.hana.xs.lm.roles.Developer.hdbrole A transaction rollback may have left the object in an inconsistent state. sap.hana.xs.lm.roles.DevelopmentExpert.hdbrole A transaction rollback may have left the object in an inconsistent state. Runtime 'TableImportRuntime' finished revalidation of 13 object(s) in 549ms

[Former Member]

Replication over wrote my Delivery Units from upgrade.
hana version 97 , upgraded to 100

added server as Streaming Replica..

Failed over.

Primary now does not have ROLE
sap.hana.admin.Administration

Ran

./hdbupdrep --content_directory=/usr/sap/H2D/SYS/global/hdb/auto_content

Is there a way to remove Delivery units and reinstall?
Errors above are repeating an inconsistent state..

Thanks.