BCM 2007 Can not create Offline Database

[Mark Kolean]

When setting up BCM it works correctly in online mode but when going to setup
the offline database it works for about 10 minutes then errors out with the
error "Outlook could not complete the following action or actions". I have
SQL 2005 Express SP3 installed and found 1 post relating to transaction files
sizes. I have tried this on 4 different laptops all with XP Pro 32bit
connecting to this database. On our personal network I am running BCM 2007
with a Vista Ultimate 64 bit and my offline works fine. Does anyone have any
experience with this problem???

Thanks

Mark

 

[Luther Blissett]

When setting up BCM it works correctly in online mode but when going to setup
the offline database it works for about 10 minutes then errors out with the
error "Outlook could not complete the following action or actions".  I have
SQL 2005 Express SP3 installed and found 1 post relating to transaction files
sizes.  I have tried this on 4 different laptops all with XP Pro 32bit
connecting to this database.  On our personal network I am running BCM 2007
with a Vista Ultimate 64 bit and my offline works fine.  Does anyone have any
experience with this problem???

Thanks

Mark

Turn on BCM logging (In the BCM About dialog).

Reproduce the error, and check the log to see if it has additional
information about the error.

 

[Mark Kolean]

Sure here is the log of what is going on: One thing I didn't mention is that
when I am creating the offline file I am actually VPNing into our network
since this laptop is in a different state and maybe the database is timing
out during the sync. Is there a way to not have the connection time out so
it can work all night to sync would be the next question???


*************************************Message-1************************************

Initializing sync for sync point 'GoOffline' with producer
'Microsoft.BusinessSolutions.eCRM.DataSync.SqlRecordSetChangeListProducer',
consumer 'Microsoft.BusinessSolutions.eCRM.DataSync.SqlChangeListConsumer'
and conflict resolver '' on Thursday, May 28, 2009 4:07:09 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.ReadNetworkPacket()
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, Boolean
isDelegateControlRequest)
at
System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest
transactionRequest, String transactionName, IsolationLevel iso,
SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest)
at
System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest
transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction
internalTransaction, Boolean isDelegateControlRequest)
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).