S
SVGooner
Hi
I hope you can help.
I am using Business Contact Manager 2007 with Outlook 2007 (and SqlServer
2005). I have the latest updates (SP2).
I am having a problem creating an offline database for synchronisation with
our remote database. I can connect to the remote database but when I try to
go offline, the process fails when "applying changes" to the offline database.
This problems has been described by a number of people in the blog below.
http://blogs.msdn.com/bcm/archive/2...a-business-contact-manager-2007-database.aspx
bcm_user describes it in his post on Dec 20th, 2007.
Wpcbcm mentions the same problem on Jan 15th, 2008
Bcmteam (Sateesh) asked them to send an email to this address for further
instructions.
Rob Coulstock also described the problem in detail in his post on Dec 3rd
2007.
The problem seems to be due to a timeout error.
Here is the first error in the BCM log:
"[E] [14:49:55.5415605]BCMRes: Timeout expired. The timeout period elapsed
prior to completion of the operation or the server is not responding.
The statement has been terminated.
[E] [14:49:55.5435606]BCMRes: at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at
Microsoft.BusinessSolutions.eCRM.BusinessLayer.BcmDataStore.PollDBForChanges(Boolean
doBlock, Boolean autoSwitchToOffline) [E] [14:49:55.5445607]BCMRes: Text:
[E] [14:49:55.5445607]BCMRes: Message:Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
[V] [14:49:56.0515897]BusinessLayer: Polling failed: This action cannot be
completed because Business Contact Manager cannot access the database.
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
The statement has been terminated."
This error or a similar one appears a number of times in the log file.
I would appreciate any suggestions you have on how to work around this
problem as the remote database is very remote so I can't go into the office
and do the initial setup.
Thanks Simon
I hope you can help.
I am using Business Contact Manager 2007 with Outlook 2007 (and SqlServer
2005). I have the latest updates (SP2).
I am having a problem creating an offline database for synchronisation with
our remote database. I can connect to the remote database but when I try to
go offline, the process fails when "applying changes" to the offline database.
This problems has been described by a number of people in the blog below.
http://blogs.msdn.com/bcm/archive/2...a-business-contact-manager-2007-database.aspx
bcm_user describes it in his post on Dec 20th, 2007.
Wpcbcm mentions the same problem on Jan 15th, 2008
Bcmteam (Sateesh) asked them to send an email to this address for further
instructions.
Rob Coulstock also described the problem in detail in his post on Dec 3rd
2007.
The problem seems to be due to a timeout error.
Here is the first error in the BCM log:
"[E] [14:49:55.5415605]BCMRes: Timeout expired. The timeout period elapsed
prior to completion of the operation or the server is not responding.
The statement has been terminated.
[E] [14:49:55.5435606]BCMRes: at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at
Microsoft.BusinessSolutions.eCRM.BusinessLayer.BcmDataStore.PollDBForChanges(Boolean
doBlock, Boolean autoSwitchToOffline) [E] [14:49:55.5445607]BCMRes: Text:
[E] [14:49:55.5445607]BCMRes: Message:Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
[V] [14:49:56.0515897]BusinessLayer: Polling failed: This action cannot be
completed because Business Contact Manager cannot access the database.
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
The statement has been terminated."
This error or a similar one appears a number of times in the log file.
I would appreciate any suggestions you have on how to work around this
problem as the remote database is very remote so I can't go into the office
and do the initial setup.
Thanks Simon