Problem with mirroring in Control-M Server 6.4

Everything about Control-M Server installation or setup.
Post Reply
User avatar
rich_arredondo
Nouveau
Nouveau
Posts: 16
Joined: 04 Nov 2011 12:00

Problem with mirroring in Control-M Server 6.4

Post by rich_arredondo » 04 Nov 2011 7:45

Hello,

I have been trying to set up my Control-M 6.4 mirroring for a while, and whenever I can do it , I keep receiving the same error almost half a day after enabling the Mirroring:

I got this error from proclog:

1026 00:23:28.18 Primary: Provider Error number: 80004005 Timeout expired
1026 00:23:28.18 COM Error Code = 80004005 ;Code meaning = Unspecified error ;Source = Microsoft OLE DB Provider for SQL Server ;Description = Timeout expired
1026 00:23:28.18 DB_GetDBproc(StructProc=00604FB4) - Failed in (MIRROR)
1026 00:23:28.18 CTM6001 -> DB_GL_mirrordb_mark_nouse: ERROR occured. marking mirror db as unused!!


I am using 2 servers in LAN, Windows 2003 OS with Microsoft SQL Server 2005 Installed.

I also keep getting this type of errors:

0722 18:28:02.57 Failed to open file :'.\TEMP\dbcheck_logspace.out'
1004 15:12:02.57 Failed to open file :'.\TEMP\dbcheck_logspace.out'
0113 19:55:02.56 Failed to open file :'.\TEMP\dbcheck_logspace.out'
1026 11:29:01.81 Failed to open file :'.\TEMP\dbcheck_logspace.out'

Only as a comment, when I perform the mirror between the 2 databases it takes almost 2 hours for the mirror to complete.

I hope you can help me solve this problem or having my database mirroring setup...

2 days after I could enable mirroring, I got this error:

1031 00:41:21.84 Primary: Provider Error number: 80004005 Timeout expired
1031 00:41:21.84 COM Error Code = 80004005 ;Code meaning = Unspecified error ;Source = Microsoft OLE DB Provider for SQL Server ;Description = Timeout expired
1031 00:41:21.84 DB_GetDBproc(StructProc=00604FB4) - Failed in (MIRROR)
1031 00:41:21.85 CTM6001 -> DB_GL_mirrordb_mark_nouse: ERROR occured. marking mirror db as unused!!

I am using Windows 2003 R2 and Microsoft SQL Server 2005.

Thanks.

User avatar
fileal2
Nouveau
Nouveau
Posts: 32
Joined: 25 Sep 2008 12:00

Post by fileal2 » 10 Nov 2011 2:56

Hi,

Is the communication between the primary server and the secondary DB stable? Are they on the same LAN?

If it is not, then you have a problem... if the ping average response time from the two servers is more than 10~12ms, then it's not safe to use this feature.

User avatar
rich_arredondo
Nouveau
Nouveau
Posts: 16
Joined: 04 Nov 2011 12:00

Both servers on same LAN

Post by rich_arredondo » 10 Nov 2011 7:38

They are on the same LAN, the response time betweeen them is less than 1 milisecond, that is because the error sounds really strange to me also.

Both servers are in the same Datacenter.

User avatar
gglau
Nouveau
Nouveau
Posts: 317
Joined: 13 Jun 2007 12:00

Post by gglau » 12 Nov 2011 1:29

I installed CTM in a site earlier this year. It took hours for installation process to build the schema. It turned out that the problem was configuration of SQL server. When just hostname was specified, it took hours to build schema. When hostname and instance was specified, installation completed in minutes.

Your problem sounds similar. Check with your DBA about instance in the SQL server.

User avatar
rich_arredondo
Nouveau
Nouveau
Posts: 16
Joined: 04 Nov 2011 12:00

Standalone

Post by rich_arredondo » 14 Nov 2011 6:36

What about if I have a standalone installation?

Does that apply for that case?


Thanks for your support.

User avatar
CPalacios
Nouveau
Nouveau
Posts: 5
Joined: 24 Mar 2011 12:00

Post by CPalacios » 21 Mar 2014 11:10

Hi Ricardo, How did you solved this issue?
I'm having the same one and I have no idea whats happening here.

Post Reply