New install of BCM 2007 fails to set up Offline Database

[Michael Saucier]

Hello there, I am a long time user of BCM and have about 1900 active contacts
and over 200 active pursuits. I recently moved the database to a central
W2003 box and connect to it over the LAN from several boxes, including 1
laptop. This laptop is running Vista Vista Ultimate from my MSDN
subscription inside a Parallels VM on a MacBook Pro Core 2 Duo with 3 Gigs of
RAM. It is perfect in every way EXCEPT that I can not seem to create the
Offline DB to take this baby on the road. The Offline DB is around a Gig and
looks perfectly normal from the host machine, which is running the same
version of Outllook BCM. The Offline wizard does not offer much clue as to
why it fails, just after 10 minutes of trying it says "unable to complete
last command please try again later."

Can I turn on additional debugging, or is there a network timeout I can
increase or anything else to help me get this solved? Thank You!

 

[Clinton Ford [MSFT]]

Hi Michael,

Make sure that the Network Service account has Read/Write permissions to your BCM folder:
C:\Documents and Settings\<USER>\Local Settings\Application Data\Microsoft\Business Contact Manager

Also, check to be sure that the SQL Server (MSSMLBIZ) service is running.

You might also turn on logging (Outlook | Help | About Business Contact Manager | Enable Logging). Then look for a log file in your
%temp% folder.

Also check the Event Log by clicking "Start | Run" and type eventvwr and click "OK"
--
Visit team blog at http://blogs.msdn.com/bcm
This posting is provided "AS IS" with no warranties, and confers no rights
Hello there, I am a long time user of BCM and have about 1900 active contacts
and over 200 active pursuits. I recently moved the database to a central
W2003 box and connect to it over the LAN from several boxes, including 1
laptop. This laptop is running Vista Vista Ultimate from my MSDN
subscription inside a Parallels VM on a MacBook Pro Core 2 Duo with 3 Gigs of
RAM. It is perfect in every way EXCEPT that I can not seem to create the
Offline DB to take this baby on the road. The Offline DB is around a Gig and
looks perfectly normal from the host machine, which is running the same
version of Outllook BCM. The Offline wizard does not offer much clue as to
why it fails, just after 10 minutes of trying it says "unable to complete
last command please try again later."

Can I turn on additional debugging, or is there a network timeout I can
increase or anything else to help me get this solved? Thank You!

 

[Michael Saucier]

Thanks!

What path is used by Vista? I think that looks like an XP path you gave me.
Best Regards, Michael

 

[Raul]

Hi Michael

The path on a Vista Computer would be

<drive>:\Users\<username>AppData\Local\Microsoft\Business Contact Manager

 

[Michael Saucier]

Here is how it fails form the BCM log:

Initializing sync for sync point 'GoOffline' with producer
'Microsoft.BusinessSolutions.eCRM.DataSync.SqlRecordSetChangeListProducer',
consumer 'Microsoft.BusinessSolutions.eCRM.DataSync.SqlChangeListConsumer'
and conflict resolver '' on Monday, February 19, 2007 12:02:44 PM
*************************************Message-2************************************

Number of entities to synchronize = 61
*************************************Message-3************************************

[Error]Error in synchronizing. Exception details follow
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at
System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject
stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult
asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32
bytesExpected)
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at
System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[]
buffer, TransactionManagerRequestType request, String transactionName,
TransactionManagerIsolationLevel isoLevel, Int32 timeout,
SqlInternalTransaction transaction, TdsParserStateObject stateObj)
at
System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest
transactionRequest, String transactionName, IsolationLevel iso,
SqlInternalTransaction internalTransaction)
at
System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest
transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction
internalTransaction)
at System.Data.SqlClient.SqlInternalTransaction.Rollback()
at System.Data.SqlClient.SqlTransaction.Rollback()
at
Microsoft.BusinessSolutions.eCRM.DataSync.SqlChangeListConsumer.Microsoft.BusinessSolutions.eCRM.DataSync.IChangeListConsumer.ApplyChanges(ChangeList
changes, EventsManager eventsMgr)
at
Microsoft.BusinessSolutions.eCRM.DataSync.SyncManager.Synchronize(SyncPoint
sp, IContext producerContext, IContext consumerContext, SyncLog syncLog).

 

[Mike Vandamme]

I have a similar problem and spending my whole week-end to find a solution.
I was wandering if you have found a solutions ?

Thanks

Mike

Here is how it fails form the BCM log:

Initializing sync for sync point 'GoOffline' with producer
'Microsoft.BusinessSolutions.eCRM.DataSync.SqlRecordSetChangeListProducer',
consumer 'Microsoft.BusinessSolutions.eCRM.DataSync.SqlChangeListConsumer'
and conflict resolver '' on Monday, February 19, 2007 12:02:44 PM.
*************************************Message-2************************************

Number of entities to synchronize = 61.
*************************************Message-3************************************

[Error]Error in synchronizing. Exception details follow
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at
System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject
stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult
asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32
bytesExpected)
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at
System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[]
buffer, TransactionManagerRequestType request, String transactionName,
TransactionManagerIsolationLevel isoLevel, Int32 timeout,
SqlInternalTransaction transaction, TdsParserStateObject stateObj)
at
System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest
transactionRequest, String transactionName, IsolationLevel iso,
SqlInternalTransaction internalTransaction)
at
System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest
transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction
internalTransaction)
at System.Data.SqlClient.SqlInternalTransaction.Rollback()
at System.Data.SqlClient.SqlTransaction.Rollback()
at
Microsoft.BusinessSolutions.eCRM.DataSync.SqlChangeListConsumer.Microsoft.BusinessSolutions.eCRM.DataSync.IChangeListConsumer.ApplyChanges(ChangeList
changes, EventsManager eventsMgr)
at
Microsoft.BusinessSolutions.eCRM.DataSync.SyncManager.Synchronize(SyncPoint
sp, IContext producerContext, IContext consumerContext, SyncLog syncLog).
--
Michael Saucier

Hi Michael

The path on a Vista Computer would be

<drive>:\Users\<username>AppData\Local\Microsoft\Business Contact Manager

 

[Michael Saucier]

I am sorry to report that my "solution" to this one was drastic, I just
reformattted the parallels partition with XP! I could not spend more time,
but I imagine this has something to do with file permissions that will simply
get "worked out" over time as the use case becomes more mainstream.
--
Michael Saucier

I have a similar problem and spending my whole week-end to find a solution.
I was wandering if you have found a solutions ?

Thanks

Mike

Here is how it fails form the BCM log:

Initializing sync for sync point 'GoOffline' with producer
'Microsoft.BusinessSolutions.eCRM.DataSync.SqlRecordSetChangeListProducer',
consumer 'Microsoft.BusinessSolutions.eCRM.DataSync.SqlChangeListConsumer'
and conflict resolver '' on Monday, February 19, 2007 12:02:44 PM.
*************************************Message-2************************************

Number of entities to synchronize = 61.
*************************************Message-3************************************

[Error]Error in synchronizing. Exception details follow
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at
System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject
stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult
asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32
bytesExpected)
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at
System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[]
buffer, TransactionManagerRequestType request, String transactionName,
TransactionManagerIsolationLevel isoLevel, Int32 timeout,
SqlInternalTransaction transaction, TdsParserStateObject stateObj)
at
System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest
transactionRequest, String transactionName, IsolationLevel iso,
SqlInternalTransaction internalTransaction)
at
System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest
transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction
internalTransaction)
at System.Data.SqlClient.SqlInternalTransaction.Rollback()
at System.Data.SqlClient.SqlTransaction.Rollback()
at
Microsoft.BusinessSolutions.eCRM.DataSync.SqlChangeListConsumer.Microsoft.BusinessSolutions.eCRM.DataSync.IChangeListConsumer.ApplyChanges(ChangeList
changes, EventsManager eventsMgr)
at
Microsoft.BusinessSolutions.eCRM.DataSync.SyncManager.Synchronize(SyncPoint
sp, IContext producerContext, IContext consumerContext, SyncLog syncLog).
--
Michael Saucier

Hi Michael

The path on a Vista Computer would be

<drive>:\Users\<username>AppData\Local\Microsoft\Business Contact Manager

--
Regards

Raul Thomas

message Thanks!

What path is used by Vista? I think that looks like an XP path you gave
me.
Best Regards, Michael
--
Michael Saucier



:

Hi Michael,

Make sure that the Network Service account has Read/Write permissions to
your BCM folder:
C:\Documents and Settings\<USER>\Local Settings\Application
Data\Microsoft\Business Contact Manager

Also, check to be sure that the SQL Server (MSSMLBIZ) service is running.

You might also turn on logging (Outlook | Help | About Business Contact
Manager | Enable Logging). Then look for a log file in your
%temp% folder.

Also check the Event Log by clicking "Start | Run" and type eventvwr and
click "OK"
--
Visit team blog at http://blogs.msdn.com/bcm
This posting is provided "AS IS" with no warranties, and confers no
rights
message
Hello there, I am a long time user of BCM and have about 1900 active
contacts
and over 200 active pursuits. I recently moved the database to a central
W2003 box and connect to it over the LAN from several boxes, including 1
laptop. This laptop is running Vista Vista Ultimate from my MSDN
subscription inside a Parallels VM on a MacBook Pro Core 2 Duo with 3
Gigs of
RAM. It is perfect in every way EXCEPT that I can not seem to create the
Offline DB to take this baby on the road. The Offline DB is around a Gig
and
looks perfectly normal from the host machine, which is running the same
version of Outllook BCM. The Offline wizard does not offer much clue as
to
why it fails, just after 10 minutes of trying it says "unable to complete
last command please try again later."

Can I turn on additional debugging, or is there a network timeout I can
increase or anything else to help me get this solved? Thank You!