It is currently 30 May 2017 11:09


Post new topic  Reply to topic  [ 6 posts ] 
Author Message
PostPosted: 05 Nov 2011 4:45 
Offline
Nouveau
Nouveau
User avatar

Joined: 04 Nov 2011 9:00
Posts: 16
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.


Top
   
 Post subject:
PostPosted: 10 Nov 2011 11:56 
Offline
Nouveau
Nouveau
User avatar

Joined: 25 Sep 2008 8:00
Posts: 32
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.


Top
   
 Post subject: Both servers on same LAN
PostPosted: 11 Nov 2011 4:38 
Offline
Nouveau
Nouveau
User avatar

Joined: 04 Nov 2011 9:00
Posts: 16
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.


Top
   
 Post subject:
PostPosted: 12 Nov 2011 10:29 
Offline
Nouveau
Nouveau
User avatar

Joined: 13 Jun 2007 8:00
Posts: 317
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.


Top
   
 Post subject: Standalone
PostPosted: 15 Nov 2011 3:36 
Offline
Nouveau
Nouveau
User avatar

Joined: 04 Nov 2011 9:00
Posts: 16
What about if I have a standalone installation?

Does that apply for that case?


Thanks for your support.


Top
   
 Post subject:
PostPosted: 22 Mar 2014 8:10 
Offline
Nouveau
Nouveau
User avatar

Joined: 24 Mar 2011 9:00
Posts: 5
Hi Ricardo, How did you solved this issue?
I'm having the same one and I have no idea whats happening here.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 6 posts ] 

All times are UTC+10:00


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved