greenonred
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.
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.
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.
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?
ASKER
The PC meets the requirements, amply. I believe it has worked in the past. There's no Exchange Server being used.
ASKER
The customer is on holiday so I have to wait until they're back before I can update this post with the resolution.
ASKER
Still no solution, the BCM log on the client PC shows a server timeout error
ASKER
We are still stuck with this problem - all help appreciated.
Please did you solve described problem?
ASKER
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_l og' 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?
Autogrow of file '<DBNAME>Outlook_offline_l
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_of fline_dat' , FILEGROWTH=200);
ALTER DATABASE <BCMNAME>Outlook_offline MODIFY FILE (NAME='<BCMNAME>Outlook_of fline_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.
ALTER DATABASE <BCMNAME>Outlook_offline MODIFY FILE (NAME='<BCMNAME>Outlook_of
ALTER DATABASE <BCMNAME>Outlook_offline MODIFY FILE (NAME='<BCMNAME>Outlook_of
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.
ASKER
thank you - I'll give it a go.
ASKER
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]Business Layer: BCP - Error while BCPing (DoCopyTable) a single table...ContactAdditionalP ropertyBag , 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]Business Layer: 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]Business Layer: at System.Data.SqlClient.SqlC onnection. OnError(Sq lException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlI nternalCon nection.On Error(SqlE xception exception, Boolean breakConnection)
at System.Data.SqlClient.TdsP arser.Thro wException AndWarning (TdsParser StateObjec t stateObj)
at System.Data.SqlClient.TdsP arser.Run( RunBehavio r runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlB ulkCopy.Wr iteToServe rInternal( )
at System.Data.SqlClient.SqlB ulkCopy.Wr iteRowSour ceToServer (Int32 columnCount)
at System.Data.SqlClient.SqlB ulkCopy.Wr iteToServe r(IDataRea der reader)
at Microsoft.BusinessSolution s.eCRM.Bus inessLayer .BulkCopy. DoCopyTabl e(SqlConne ction 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 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]Business
The statement has been terminated.
[E] [21:36:15.0489852]Business
The statement has been terminated.
[E] [21:36:16.9118682]Business
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.SqlB
at System.Data.SqlClient.SqlB
at System.Data.SqlClient.SqlB
at Microsoft.BusinessSolution
[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.
ASKER
I'm having to work with Microsoft to resolve this as no resolution has been found here.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://www.microsoft.com/downloads/details.aspx?FamilyId=9EC51594-992C-4165-A997-25DA01F388F5&displaylang=en