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]

On May 25, 7:09 am, Mark Kolean <MarkKol...
wrote:
> 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).

"Luther Blissett" wrote:


> On May 25, 7:09 am, Mark Kolean <MarkKol...
> wrote:
> > 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.
>