Creating Offline Database

[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

 

[Sun Embraser]

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/2007/04/25/how-to-share-a-business-...

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(TdsParserStateObje­ct
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.PollDBForChange­s(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

Hi Simon,
From the "timeout expired" error message, it is obvious that it took
longer time to complete a full offline database sync than BCM had time
for it.
This normally happens when:
1. Your database size is very large and you are creating the offline
database for the first time, and
2. Your network transfer speed is slow, thus it takes a lot longer to
do a full database sync than it had time for

I am making two suggestions:
1. You only need to do this for the first time -- that is, you
actually head in to the office and create an offline database while
using ethernet connection. Once it successfully creates an offline
version, all future syncs will be incremental changes, and hopefully
that's not too much if you sync frequently enough
2. If it is nearly impossible for you to head in, perhaps you can work
with the people in the office to temporarily reduce the database
size... (this is not ideal and may require a lot of manual labor. I
hope to hear better solutions from other readers of this newsgroup).
The idea is to have your co-worker who is in the office to Backup or
Export the database, manually remove some data to reduce the database
size, wait for you to successfully create your first offline database,
then Restore the database back and have you syn for the incremental
changes. Please note that I have not done this before but in theory
this should work. I would prefer you try my first suggestion if at
all possible.

I am all ears and hope to hear some better ways to solve this problem.
John

 

[SVGooner]

Hi John

Thanks for the reply. I agree with your diagnosis of the problem.

The first solution had occured to me. Unfortunately I am in London and the
server is in Houston but I will do this next time I visit the office if I
cannot find another solution in the mean time.

The second solution is a possibility. I will talk to my colleagues about
backing up the database and then reducing its size to allow me to synchronise
with it and then restore the original. However I suppose I may have a
similar problem synchronising with the restored database.

Thanks for the suggestions and I will let you know if your suggestion works
or I find another solution.

Kind Regards Simon
--
Simon

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/2007/04/25/how-to-share-a-business-...

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(TdsParserStateObje­ct
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.PollDBForChange­s(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

Hi Simon,
From the "timeout expired" error message, it is obvious that it took
longer time to complete a full offline database sync than BCM had time
for it.
This normally happens when:
1. Your database size is very large and you are creating the offline
database for the first time, and
2. Your network transfer speed is slow, thus it takes a lot longer to
do a full database sync than it had time for

I am making two suggestions:
1. You only need to do this for the first time -- that is, you
actually head in to the office and create an offline database while
using ethernet connection. Once it successfully creates an offline
version, all future syncs will be incremental changes, and hopefully
that's not too much if you sync frequently enough
2. If it is nearly impossible for you to head in, perhaps you can work
with the people in the office to temporarily reduce the database
size... (this is not ideal and may require a lot of manual labor. I
hope to hear better solutions from other readers of this newsgroup).
The idea is to have your co-worker who is in the office to Backup or
Export the database, manually remove some data to reduce the database
size, wait for you to successfully create your first offline database,
then Restore the database back and have you syn for the incremental
changes. Please note that I have not done this before but in theory
this should work. I would prefer you try my first suggestion if at
all possible.

I am all ears and hope to hear some better ways to solve this problem.
John
.

 

[Leonid S. Knyshov // SBS Expert]

Hi John

Thanks for the reply. I agree with your diagnosis of the problem.

The first solution had occured to me. Unfortunately I am in London and the
server is in Houston but I will do this next time I visit the office if I
cannot find another solution in the mean time.

The second solution is a possibility. I will talk to my colleagues about
backing up the database and then reducing its size to allow me to synchronise
with it and then restore the original. However I suppose I may have a
similar problem synchronising with the restored database.

Thanks for the suggestions and I will let you know if your suggestion works
or I find another solution.

Kind Regards Simon

I am going to give an out of the box solution.

Login remotely to a desktop and build a virtual machine at that office.
You can use Virtual PC or Vmware. Synchronize the VM using the local
network. Download the VM to London. Launch the VM locally. Synchronize
to this VM from your London workstation. Decommission VM.

How is that for creativity?
--
Leonid S. Knyshov
Crashproof Solutions
510-282-1008
Twitter: @wiseleo
http://crashproofsolutions.com
Microsoft Small Business Specialist
Please vote "helpful" if I helped you

 

[SVGooner]

Hi Leonid

Thanks for your suggestion which is creative. I would prefer a simpler
solution such as some way of changing the timeout settings which seem to
cause the problem but perhaps there is no simple solution to this problem
except creating the offline database in the office which I will do next time
I am there.

In the meantime I have to live with using BCM over a VPN connection which is
painfully slow.

Simon

 

[Leonid S. Knyshov // SBS Expert]

Hi Leonid

Thanks for your suggestion which is creative. I would prefer a simpler
solution such as some way of changing the timeout settings which seem to
cause the problem but perhaps there is no simple solution to this problem
except creating the offline database in the office which I will do next time
I am there.

In the meantime I have to live with using BCM over a VPN connection which is
painfully slow.

Simon

I'll look into SQL replication timeout settings.

Remind me if I don't post about it over the next few days.
--
Leonid S. Knyshov
Crashproof Solutions
510-282-1008
Twitter: @wiseleo
http://crashproofsolutions.com
Microsoft Small Business Specialist
Please vote "helpful" if I helped you

 

[SVGooner]

Hi Leonid

Many thanks for your help.
--
Simon

I'll look into SQL replication timeout settings.

Remind me if I don't post about it over the next few days.
--
Leonid S. Knyshov
Crashproof Solutions
510-282-1008
Twitter: @wiseleo
http://crashproofsolutions.com
Microsoft Small Business Specialist
Please vote "helpful" if I helped you
.