SRM 5 Installation:there is already an object named dr_table_catalog

[CianoKuraz]

Hi i get this error on installing the SRM5 Recovery Site,during the  "create tables procedure of the installation process":

odbc error 42S01 there is already an object named dr_table_catalog.

The server is Windows2008 R2 and the database is MSSQL 2008 R2 (both on SRM compatibility matrix) ,i've experienced the same issue on a MSSQL 2005.

i've created 2 DB(forrecovery site and primary site), SRM_R and SRM_P on the same MSSQL instance (is for testing pourpose obviously), and the fun part is that the primary site installation worked great.

any tips?

thx

[mal_michael · Accepted solution]

Hi,

You need separate database server for each SRM instance.

Michael.

[CianoKuraz]

thx

worked fine

[CianoKuraz]

Hi,

after installing the SRM service stops, after the timeout period..

on the logs i've found;

--> * The host certificate chain is not complete."

2011-10-25T14:06:48.542+02:00 [05336 info 'Default'] CoreDump: Writing minidump

2011-10-25T14:07:11.558+02:00 [05336 panic 'Default']

-->

--> Panic: Timed out while waiting for 'DrServiceInstance' (900 seconds)

--> Backtrace:

--> backtrace[00] rip 0110a9ed (no symbol)

--> backtrace[01] rip 0105aa84 (no symbol)

--> backtrace[02] rip 0105aff7 (no symbol)

--> backtrace[03] rip 01126429 (no symbol)

--> backtrace[04] rip 011264dd (no symbol)

--> backtrace[05] rip 0f9a8b2a (no symbol)

--> backtrace[06] rip 0f9a9364 (no symbol)

--> backtrace[07] rip 0f968936 (no symbol)

--> backtrace[08] rip 0f976ef1 (no symbol)

--> backtrace[09] rip 0f94be92 (no symbol)

--> backtrace[10] rip 0f9acc61 (no symbol)

--> backtrace[11] rip 0f9a9bd8 (no symbol)

--> backtrace[12] rip 0f94be92 (no symbol)

--> backtrace[13] rip 0f94be92 (no symbol)

--> backtrace[14] rip 010e2426 (no symbol)

--> backtrace[15] rip 0111ebc1 (no symbol)

--> backtrace[16] rip 01022772 (no symbol)

--> backtrace[17] rip 0111dd5c (no symbol)

--> backtrace[18] rip 0111eef2 (no symbol)

--> backtrace[19] rip 01022772 (no symbol)

--> backtrace[20] rip 01118183 (no symbol)

--> backtrace[21] rip 72b03433 (no symbol)

--> backtrace[22] rip 72b034c7 (no symbol)

--> backtrace[23] rip 76b33677 (no symbol)

--> backtrace[24] rip 77449f02 (no symbol)

--> backtrace[25] rip 77449ed5 (no symbol)

-->

i've increased the timeout from 300 to 900 as suggested in a KB article, but with no luck.

On the DB site all tables are created.

On vc vlient i get the error:

Connection Error: Lost connection t oSRM server  ipofserver:8095

The server 'ipofserver' could not interpret the client's requests. (Remote server error:(503) Server not available.)

any idea?

[play007]

Did you ever get your issue resolved?

I am getting it too.

[CianoKuraz]

Yes i've solved it by using FQDN on each field requested,

The important thing is to use always or the IP Address or the FQDN..

for me worked

[play007]

Hi Alan,

Thank You for your quick respond.

I keep on getting timeout when I click on Site Recovery from vCenter.

After I clear all the error message, I got the following screen, which I am not sure if this looks right or not because I am trying doing a site connection.

Screenshot below…

Thanks,

Pheng

[CianoKuraz]

this is really strange, just a blank screen.

tomorrow morning at work, i'll review my documentation about SRM 5 setup and let you know.

Can you post some logs?

The parining is working? are u able to pair sites?

[play007]

Hi Alan,

I am new with SRM, but I could not find a way to do pairing between the two site.

I have not install the SRA. I will try to find the log and post it on the site.

Do you know where and which log you need? TIA.

Thanks,

Pheng

[play007]

Hi Alan,

  Here is the SRM log.

I don't see the "Configure Connection" to do the site paring.

That is why I don't think the view that I have for SRM is correct, something is missing.

Thanks,

Pheng

[CianoKuraz]

You don't need the SRA for now,

The on the summary page you should see a list of tasks, very strange that is blank,

i'll check tommorrw morning at work

[CianoKuraz]

have you changed the vCenter default certificate?

during the SRM installation, you selected to autogenerate the certificate?

[play007]

I usually ignore this, but I think I did.

Every time I connect to Site Recovery, it ask me to install the certificate again.

Anyway to verify?

In addition, sometimes, when I change my vSphere client from Site Recovery to Host and VM and switch back to Site Recovery, I get “Lost connection to SRM server IP:8095”.

Thanks.

[play007]

Alan,

  I have figured it out.  I can pair the site now.  Thanks.

Thanks.

[CianoKuraz]

Hi

sorry i was really busy today,

glad to hear that now all is ok.

Don't hesitate if you need more help on SRM. 8expecially with Vsphere Replication

And if you find my answer helpfull please rate it

[Teovmy]

I have the samen problem when performing the install. What is exacly ment by 'You need separate database server for each SRM instance'

I created a database installed SRM and linked it to this database.

[OrangeP7]

I'm out of the office until Thursday 13th September. If your message is urgent please call Alan on 07717 756500, or email it@jetsetflights.co.uk othwerwise I will get back to you when I return. Thanks

[djanne]

The problem in my case was I missed this line in the installation guide: "The SRM database schema must have the same name as the database user account."

When I renamed the schema to the same name as the user it worked.