- Timeout error on email attachments
- Posted by Chris Ericoli on September 15th, 2005
Hi,
Our CRM system has been operating without problems for almost a year.
Suddenly, about 3 days ago, we started getting timeouts when attempting to
attach files to emails. It makes no difference how big the attachment is,
or to which email/contact/record etc it is being attached - it still times
out. Today, we now appear to be getting timeouts when saving updated
records, whether they are quotes, contacts, accounts etc.
I'm pretty sure that all updates have been applied to the server (we are
using the web client for front end), and cannot see any errors logged in the
event logs on the server.
More information:
Server is over spec'd DP Xeon with 4Gb RAM on RAID5
All clients are LAN based WinXP SP2
Below is an example of an error message when attempting to save a record:
Microsoft CRM Platform Error Report:
Error Description:
Timeout expired
Error Details:
Details on this error have not been provided by the platform.
Error Number:
0x80040E31
Source File:
Not available
Line Number:
Not available
Date: 09-15-2005
Time: 10:47:38 AM
Type: Platform Error (2)
Server: crm
Query String:
/Activities/Phone/edit.aspx&pId={B7017B88-6700-4335-979C-A46B962AE091}&pType=2&pName=Sheldon%2C%20Paul&part yid={B7017B88-6700-4335-979C-A46B962AE091}&partytype=2&partyname=Sheldon%2C%20P aul&partycode=2&partyaddressused=&contactInfo=02%2 08905%204222
Any help would be GREATLY appreciated.
Cheers
Chris
- Posted by Dan Quinton on September 15th, 2005
Hi Chris
Here's a long shot, how is database space on the CRM SQL box?
Cheers
Dan
"Chris Ericoli" wrote:
- Posted by Chris Ericoli on September 15th, 2005
Hi Dan,
Thanks for responding, I really appreciate it.
I guess I should say that although I've plenty of experience in coding for
..NET and general systems admin, SQL has never been my strong point. When
you say to check the database space, I'm not entirely sure what you mean.
There is ample spare disk space on the server (80+Gb), however I have
noticed that the database files are quite large.
The primary datafile (MSCRM) is just over 2Gb, and the transaction log file
is just over 3Gb. We have approx 5000 accounts and 20000 contacts. There
are a lot of emails with PDF attachments (from our quoting system), so I'm
guessing that the ActivityMimeAttachment table is quite large, but I don't
remember seeing anything about size restrictions.
We are running the full version of SQL2000, and I have checked the database
properties to ensure that there are no restrictions set on the size of these
files.
If you can help any further, I would really appreciate it.
Cheers
Chris
"Dan Quinton" <DanQuinton@discussions.microsoft.com> wrote in message
news:FE025DAA-9C7A-4568-A6C8-092077A9E837@microsoft.com...
- Posted by Dan Quinton on September 16th, 2005
Hi Chris
Yes, that's basically what I meant, disk space and auto size increasing is
on still.
I would check memory usage on IIS (w3wp.exe on Server 2003, Inetmgr.exe
on Server 2000).
Does running an iisreset return the system to a working state for a certain
amount of time? If so, it may be worth monitoring memory. Do you have any
custom processes or applications using IIS etc?
Cheers
Dan
"Chris Ericoli" wrote:
- Posted by Chris Ericoli on September 19th, 2005
Hi Dan,
I'm reposting a new thread, because i've found some more info re this
problem, that may shed light.
CHeers
Chris
"Dan Quinton" <DanQuinton@discussions.microsoft.com> wrote in message
news:4BD2C538-E1D1-4E8A-BC55-7F9C278D0C0A@microsoft.com...