Skip to Content
avatar image
Former Member

R3trans -d not connecting after HANA DB recovery

Dear HANA Experts, We have BI production server with SID-BIP & BI Quality server with SID-BIQ. HANA databse's SID for BIP system is HAP HANA databse's SID for BIQsystem is HAQ HAP's hostname - ajihanaprd HAQ's hostname - ajihanatst HAP instance number is 00 HAQ instance number is 01 We did HANA DB recovery : We restored HAP's backup on HAQ Recovery was successful without any issue. As per standard step, Now I need to run following command. hdbuserstore -u adm set default : I have tried following combination of above commands, but nothing worked (R3trans -d gives error 0012). Since its bit urgent, so it would be great if you can help me to fix this issue as earliest as possible. On Windows Application Server Host Logged in with user biqadm cd usr/sap/BIQ/hdbclient And executed following commands. Command using HAQ & SYSTEM hdbuserstore -u HAQadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SYSTEM HIThana4us hdbuserstore -u SAPServiceHAQ SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SYSTEM HIThana4us Command using HAQ & system hdbuserstore -u HAQadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 system HIThana4us hdbuserstore -u SAPServiceHAQ SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 system HIThana4us Command using HAQ & SAPBIP hdbuserstore -u HAQadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SAPBIP ajinomoto hdbuserstore -u SAPServiceHAQ SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SAPBIP ajinomoto Command using HAQ & sapbip hdbuserstore -u HAQadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 sapbip ajinomoto hdbuserstore -u SAPServiceHAQ SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 sapbip ajinomoto Command using haq & SYSTEM hdbuserstore -u haqadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SYSTEM HIThana4us hdbuserstore -u SAPServicehaq SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SYSTEM HIThana4us Command using haq & system hdbuserstore -u haqadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 system HIThana4us hdbuserstore -u SAPServicehaq SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 system HIThana4us Command using haq & SAPBIP hdbuserstore -u haqadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SAPBIP ajinomoto hdbuserstore -u SAPServicehaq SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SAPBIP ajinomoto Command using haq & sapbip hdbuserstore -u haqadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 sapbip ajinomoto hdbuserstore -u SAPServicehaq SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 sapbip ajinomoto Command using BIQ & SYSTEM hdbuserstore -u BIQadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SYSTEM HIThana4us hdbuserstore -u SAPServiceBIQ SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SYSTEM HIThana4us Command using BIQ & system hdbuserstore -u BIQadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 system HIThana4us hdbuserstore -u SAPServiceBIQ SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 system HIThana4us Command using BIQ & SAPBIP hdbuserstore -u BIQadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SAPBIP ajinomoto hdbuserstore -u SAPServiceBIQ SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SAPBIP ajinomoto Command using BIQ & sapbip hdbuserstore -u BIQadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 sapbip ajinomoto hdbuserstore -u SAPServiceBIQ SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 sapbip ajinomoto Command using biq & SYSTEM hdbuserstore -u biqadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SYSTEM HIThana4us hdbuserstore -u SAPServicebiq SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SYSTEM HIThana4us Command using biq & system hdbuserstore -u biqadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 system HIThana4us hdbuserstore -u SAPServicebiq SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 system HIThana4us Command using biq & SAPBIP hdbuserstore -u biqadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SAPBIP ajinomoto hdbuserstore -u SAPServicebiq SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 SAPBIP ajinomoto Command using biq & sapbip hdbuserstore -u biqadm SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 sapbip ajinomoto hdbuserstore -u SAPServicebiq SET DEFAULT ajihanatst.sapeuroamerica.ajinomoto.com:30015 sapbip ajinomoto Regards, Sunil Maurya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 29, 2015 at 02:53 PM

    Hi,

    I have fixed the issue.

    Actually there was not an issue, I did the typing mistake while executing the command.

    I did everything right, only mistake was - while executing hdbuserstore command instead of 30115 I typed 30015.

    After I executed the command with 30115 everything worked fine.

    Regards,

    Sunil Maurya

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 28, 2015 at 10:15 AM

    Sorry,

    My message was not properly formatted so attaching it as a text file in proper format.

    Regards,

    Sunil Maurya


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      It seems I executed the commands successfully, but Application server is not able to connect to HANA Database.

      Do we need to execute any script after restoring one HANA DB on to another HANA DB ?

      I mean any command/script for renaming production schema or SID to Quality Schema/SID.

      Regards,

      Sunil Maurya