Creating Offline Database

Status
Not open for further replies.
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
 
S

Sun Embraser

On Feb 26, 9:29 am, SVGooner <SVGoo...
wrote:
> 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
 
S

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

"Sun Embraser" wrote:


> On Feb 26, 9:29 am, SVGooner <SVGoo...
> wrote:
> > 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
> .
>
 
L

Leonid S. Knyshov // SBS Expert

On 3/3/2010 9:13 AM, SVGooner wrote:
> 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

 
S

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" wrote:


> On 3/3/2010 9:13 AM, SVGooner wrote:
> > 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
>

>

>

> >

>

> .
>
 
L

Leonid S. Knyshov // SBS Expert

On 3/9/2010 5:03 AM, SVGooner wrote:
> 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

 
S

SVGooner

Hi Leonid

Many thanks for your help.

Simon

"Leonid S. Knyshov // SBS Expert" wrote:


> On 3/9/2010 5:03 AM, SVGooner wrote:
> > 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
>

>

>

> >

>

> .
>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
R BCM 2010 error creating offline copy of shared database BCM (Business Contact Manager) 1
N Help creating a VBA macro with conditional formatting to change the font color of all external emails to red Outlook VBA and Custom Forms 5
G Event when creating task from mailitem Outlook VBA and Custom Forms 2
T Outlook creating unwanted tasks in Tasks and Todo from emails Using Outlook 1
Fozzie Bear Outlook 2016 Creating a shared local Contacts folder Using Outlook 2
R Creating a user defined function Outlook VBA and Custom Forms 3
M Creating an RSS Feed **FROM** Outlook 2013 Calendar. Using Outlook 5
O How to prevent CC from showing when creating a new mail? Using Outlook 1
N Creating a button or link to a form in the Organizational Forms Library Outlook VBA and Custom Forms 3
B Creating an email with the list of tasks Outlook VBA and Custom Forms 0
L Creating drafts when I thought I was sending Using Outlook 1
R Would creating a new profile cause Outlook to download all the old mails from the server? Using Outlook 1
A Creating Progress Bar or Status Bar Update Outlook VBA and Custom Forms 0
T Outlook creating a folder named: "Unwanted" Using Outlook 3
M Outlook 2007 Contacts Glitch: Creating a new email Using Outlook 1
Liza Creating a rule in outlook to filter messages Using Outlook 0
A Are categories still recommended for creating local distribution lists? Using Outlook 3
S Creating Email - Selecting Pre-Defined Text Using Outlook 2
D Creating an outlook session from Access vba but run silently. With A specific profile Outlook VBA and Custom Forms 1
M Creating Outlook Appointments from Excel Cells Outlook VBA and Custom Forms 1
N Creating New Profile Using Outlook 0
Y Creating custom appointment request form with multiple mail recipients Outlook VBA and Custom Forms 5
M creating email from contact file = 3 emails in To field Using Outlook 3
P Recover / Extract Rules from standalone PST file creating RWZ file Using Outlook 2
A Creating an outlook rule to forward an email with a specific message Using Outlook 1
I Creating meeting invite with disabled tentative button Outlook VBA and Custom Forms 5
E Creating email templates for organizational use Using Outlook 0
N Creating or changing the main new mail message template in Outlook 2010 Using Outlook 2
D Creating custom view with VBA Outlook VBA and Custom Forms 2
J Outlook creating unwanted rule on its own Using Outlook 1
R Creating a Room Mailbox with Exchange Online Outlook VBA and Custom Forms 0
A Creating a rule on “Deleted items” folder Using Outlook 1
CMG73 Creating templates with predefined subject and CC Using Outlook 1
G Creating Contact Sub Folders Using Outlook 2
Rupert Dragwater creating gmail account in Outlook 2013 Using Outlook 7
nathandavies Creating a Select Case for a directory of folders Outlook VBA and Custom Forms 1
2 creating custom stationery Using Outlook 2
A Help creating macro for conditional formatting settings Using Outlook 8
Fozzie Bear Creating Custom Meeting Form Outlook VBA and Custom Forms 6
U Creating a (This computer only) folder within an IMAP account directory Using Outlook 1
A Creating archive rule on the clients by script/ Outlook VBA and Custom Forms 3
J Creating a URL from a message body excerpt before forwarding Using Outlook 2
B Need Help Creating Email Based on Subject w Address in Body Outlook VBA and Custom Forms 1
A Creating rule to create week folder and transfer mail using alert Using Outlook 3
J Creating an "isolated" shared calendar in Outlook Outlook VBA and Custom Forms 1
L Creating a Task from Email and Attaching Original Email Outlook VBA and Custom Forms 6
S Creating custom rule to move if "NAME" is in body but ignore the phrase "Hi NAME" in the search Using Outlook 2
witzker Outlook bug when creating a user defined contact form? Using Outlook 1
G Creating an Outlook Rule using Internet Header time Using Outlook 1
Wotme Creating a Outlook task in Excel Using Outlook 7

Similar threads

Top