Link to home
Start Free TrialLog in
Avatar of greenonred
greenonredFlag for United Kingdom of Great Britain and Northern Ireland

asked on

"Business Contact Manager for Outlook could not complete your last action or actions" when making offline copy

Office Business Contact Manager 2007 on Windows XP.  SQL Express 2005 database on a Windows Server 2003 system.  About 3 users of the BCM database.
One user cannot make an offline copy of the database using the BCM client - it gets part way through and comes up with:
"Business Contact Manager for Outlook could not complete your last action or actions. Please try again."

We have removed BCM, re-installed the whole system, put BCM back on and still the problem exists.
Avatar of apache09
apache09
Flag of New Zealand image

Avatar of greenonred

ASKER

It is installed on the desktops; but I'm not sure about on the server.  For other reasons they have Office installed on the server.
Has this worked before and just stopped working?
Or, has this never worked?
Is this a new install?

Do the PC/Users meet the Minimum requirements:

Computer and processor 1 gigahertz (GHz) or faster processor
Memory 512 megabyte (MB) RAM or higher
Hard disk 2 gigabytes (GB); a portion of this disk space will be freed after installation if the original download package is removed from the hard drive.  
Drive CD-ROM or DVD drive
Display 1024x768 or higher resolution monitor
Operating system Microsoft Windows XP with Service Pack (SP) 2, Windows Server 2003 with SP1, or later operating system1
Other Connectivity to Microsoft Exchange Server 2000 or later is required for certain advanced functionality in Outlook 2007.

Mail Merge with Microsoft Office Word or Microsoft Office Publisher requires Word 2007 or Word 2003 and Publisher 2007 or Publisher 2003, respectively. Report exports require Microsoft Office Excel 2007 or Microsoft Excel 2003. Direct document linking features are only supported in the 2007 Office system.

Instant Search requires Microsoft Windows Desktop Search 3.0.

Connectivity to Microsoft Windows Server 2003 with SP1 or later running Microsoft Windows SharePoint Services is required for certain advanced collaboration functionality. Connectivity to Microsoft Office SharePoint Server 2007 is required for certain advanced Outlook functionality.

Internet Explorer 6.0 or later, 32 bit browser only. Internet functionality requires Internet access (fees may apply).
Additional Actual requirements and product functionality may vary based on your system configuration and operating system.
Also, is Exchange Server Being used?
The PC meets the requirements, amply.  I believe it has worked in the past.  There's no Exchange Server being used.
The customer is on holiday so I have to wait until they're back before I can update this post with the resolution.
Still no solution, the BCM log on the client PC shows a server timeout error
We are still stuck with this problem - all help appreciated.
Avatar of janmakovicka
janmakovicka

Please did you solve described problem?
No, it is still an issue.
I spent some time by tracking long files and I think that we'll solve the problem when we solve the following line in SQL Express log file:

Autogrow of file '<DBNAME>Outlook_offline_log' in database '<DBNAME>Outlook_offline'
was cancelled by user or timed out after <TIME IN MY CASE 60434> milliseconds.  Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.

I have to say, that "time of timeout" 60434 in my case exactly fits so I think this is realy the case, the transaction LOG file. When I used

EXEC sp_helpdb <DBNAME>

I have recognized that log transaction file (which is the real reason for time, not database MDF file as it may seem) have these significant propreties for our issue:
SIZE: 10240 KB
MAXSIZE:          Unlimited
FILEGROWTH:          50%  

In fact, when I recieve "Business Contact Manager for Outlook could not complete your last action or actions. Please try again." message from Outlook while creating offline copy, the LOG file has a size about 3GB, so growth by 50% means target size about 4,5GB.

Does anybody know something about SQL Express "4GB limitat" and does it apply also on transaction log files? Can anyone suggest how to "ALTER DATABASE" FILEGROWTH or better way, how to shrink transaction LOG file durning the process of online databases creation?
So, the issue seems to be solved. I did following modifications in BCM offline database:

ALTER DATABASE <BCMNAME>Outlook_offline MODIFY FILE (NAME='<BCMNAME>Outlook_offline_dat', FILEGROWTH=200);
ALTER DATABASE <BCMNAME>Outlook_offline MODIFY FILE (NAME='<BCMNAME>Outlook_offline_log', FILEGROWTH=200);


The database  <BCMNAME>Outlook_offline doesn't exists before you start creation of offline database in Outlook with BCM. You could try these changes immediately after start of this proces when the database is created.
thank you - I'll give it a go.
Either I'm doing it incorrectly, or it didn't work.

I installed the SQL Server Management Studio Express
Started the creation of the offline database.
Executed the two ALTER DATABASE commands as per the suggestion, and they completed successfully.
Left the offline sync to finish and it errored.  The start of the errors in the log file are here below; but the TIMEOUT message is repeated several more times later:

[21:36:14.7785667]BusinessLayer: BCP - Error while BCPing (DoCopyTable) a single table...ContactAdditionalPropertyBag, Error number: -2, Error Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
[E] [21:36:15.0489852]BusinessLayer: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
[E] [21:36:16.9118682]BusinessLayer:    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.SqlBulkCopy.WriteToServerInternal()
   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
   at System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader)
   at Microsoft.BusinessSolutions.eCRM.BusinessLayer.BulkCopy.DoCopyTable(SqlConnection SharedCn, String CommandText, SqlConnection OfflineConnection, SqlTransaction OfflineTran, String TableName)
[E] [21:36:17.6429997]BCMRes: Text:
[E] [21:36:17.6429997]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.
I'm having to work with Microsoft to resolve this as no resolution has been found here.
ASKER CERTIFIED SOLUTION
Avatar of greenonred
greenonred
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial