Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question