Skip to Content
avatar image
Former Member

HANA2.0 SP2 enable Replication error

Dear All,

When I enable replication on the Primary HANA system, a prerequisite check about the backup is done in the hdbnsutil tool, but when i finished the hana backup and run the following command on my primary hana node:

hdbnsutil -sr_enable --name= HAD1

it raise the following error message:

system replication prerequisite check failed, exception 3000302, backup has not yet been executed on primary system, please backup primary system.

but really i did the Complete Data Backup with Destination Type as File.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 06, 2017 at 10:56 AM

    Im guessing your problem is documented here 2550634 - After upgrade to HANA 2.0 it is not possible to set up system replication

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 16, 2017 at 02:18 PM

    Hello

    Very good note '2550634' but I have exactly the same issue and not able to solve this. Thought I was about to fix this with the note. I really must have missed out on somehting. I have installed (Not upgraded) a new HANA installation 2.0 SP02 rev. 20. I can only connect via HANA studio with the option "Single Container". I have tried every changing in HANA studio as note '2550634' suggests but I get "Cannot access system on host". Again - works fine if I connect in mode "single container".

    I am also trying:

    hdbnsutil -sr_enable --name=[hostname]
    checking for active nameserver ...
    nameserver is active, proceeding ...
    error: system replication prerequisite check failed;exception 3000302: Backup has not yet been executed on primary system! Please backup primary system.

    Please advise

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      Can you explain further what it is you are trying to connect to?

      You say "I can only connect via HANA studio with the option "Single Container" - Are you trying to connect to your secondary system via studio or the primary?

      Please explain with greater detail (screenshots) of what you are trying to do?.

      Thanks,

      Michael

  • avatar image
    Former Member
    Nov 21, 2017 at 08:43 AM

    Hello Michael

    FIrst of all, thanks for answering. I will here provide background and screenshots.

    Background:

    First I have installed HANA 2.0 SP02 with "./hdblcm and option "server with no additional options". My primary system is installed on server 'sbhandb1630' and the SID is D21 and the Systemnr is: 21

    Second, I have installed in the same way HANA 2.0 SP02 with "./hdblcm and option "server with no additional options" on host 'sbhandb9721' and this is to be the secondary system.

    Third, I add my systems in HANA Studio as follows:

    I add in the same way the secodary system on sbhandb9721

    .Then at last, I try to enable system replication in HANA Studio as follows:

    I was very happy to find the sapnote suggesting to add the system not as Single container in HANA studio but that seems not to be possible I am afraid. I am getting very worried I have done something completley wrong here so please advise. Highly appreciated :)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 29, 2017 at 02:46 PM

    Issue solved! We needed to open up port: 3[InstanceNr]13 in the firewall between our hana database server and our Windows Management server (wehere we are running HANA Studio from). Then we were able to add the DB as the note 2550634 says (Mutliple container)

    Add comment
    10|10000 characters needed characters exceeded