Error creating offline database

S

Simon Parry

Hi

Im trying to create an offline database, this gets almost to the end and
then it stops and gives an error 'Business Contact Manager for outlook could
not complete you last action or actions. Please try again'

the database is approx 1/2GB

i can connect to the remote database ok, i just cant seem to create an
offline version

i have check to make sure the SQL Server(MSSMLBIZ) is running and it is, the
BCM folder has R/W permissions set

i have created a new blank database ok, it just when i want to create an
offline version of the remote db

can any one help,

Simon

below is the log

*************************************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 21 June 2007 14:43:39.
*************************************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).
 
S

Simon Parry

has anyone got an answer to this ?

Simon Parry said:
Hi

Im trying to create an offline database, this gets almost to the end and
then it stops and gives an error 'Business Contact Manager for outlook could
not complete you last action or actions. Please try again'

the database is approx 1/2GB

i can connect to the remote database ok, i just cant seem to create an
offline version

i have check to make sure the SQL Server(MSSMLBIZ) is running and it is, the
BCM folder has R/W permissions set

i have created a new blank database ok, it just when i want to create an
offline version of the remote db

can any one help,

Simon

below is the log

*************************************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 21 June 2007 14:43:39.
*************************************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).
 
R

Raul Thomas

Hi Simon

Try Installing SP 2 SQL Express and then try creating an offline database

Regards

Raul Thomas

Simon Parry said:
has anyone got an answer to this ?

Simon Parry said:
Hi

Im trying to create an offline database, this gets almost to the end and
then it stops and gives an error 'Business Contact Manager for outlook
could
not complete you last action or actions. Please try again'

the database is approx 1/2GB

i can connect to the remote database ok, i just cant seem to create an
offline version

i have check to make sure the SQL Server(MSSMLBIZ) is running and it is,
the
BCM folder has R/W permissions set

i have created a new blank database ok, it just when i want to create an
offline version of the remote db

can any one help,

Simon

below is the log

*************************************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 21 June 2007 14:43:39.
*************************************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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top