Timeout issues on Sales Orders with many Products

Hi all,
I'm experiencing timeout issues with Sales Orders that have 25-30
products on the Order Detail level.  I haven't found any documentation
on this particular issue.

Has any ever seen this before?

I'm a little loathe to start reindexing the tables, especially
considering the SalesOrderDetail table has less than 300 rows.


-Luke
0
luke
6/30/2004 3:04:42 PM
crm 35858 articles. 1 followers. Follow

0 Replies
606 Views

Similar Articles

[PageSpeed] 42

Reply:

Similar Artilces:

Freeze pane issue
This should be easy but it seems to be confounding me. I am using Excel 2007 and I want to Freeze all row above row 8 (so the always remain visible as I scroll down). I select row 8 and select View and Freeze Panes my only option seems to be to Freeze the Top Row, and that is exactly what it does. What am I missing? When you select row 8, in Freeze panes, you can select the uppermost option, which is Freeze Panes. This freezes all rows above your selected row. Apparently, you selected Freeze Top Row which freezes the topmost visible row. Tyro "Patrick C. Simonds" <ordn...

Printing or formatting issue?
Dear all, Please bear with me on this one, I have posted something similar in the past and thought this issue had been resolved but hasn't!! In Finance we have staff who work on individual worksheets, these are then sent to one person who collates them into one workbook; this is then sent to our Finance MD and PA. The person who sends the workbook can print all sheets out fine on his HP5000n (A4 and A3), however the Finance PA (HP4050) and the MD (HPxxx) cannot, they complain that the formatting is all "off". I can confirm that all these users and those who originally created t...

Single forrest, multiple domain exchange rights issue
Hi All, I have a problem with Exchange 2000 and rights to calendars/inboxes etc. I will explain the situation We had a single forrest single domain structure, with exchange residing in domain A We are now building a new domain (Domain B) in the forrest to copy the users to because we are building a new it structure and we want to start fresh. we COPIED the users to the new domain, ran a script that added the NEW useraccount as full mailbox owner on their own mailbox (which is still in domain A) As of last monday we started to pilot with the new enviroment, the pilotusers can access th...

Outlook XP issue with signature "menu" popping up on mis-spelled words
When Outlook pick up a mis-spelled word or mal-formed grammar, it underlines the spelling in red and grammer in green - this is fine - but when i right-click on the word the signature picker menu pops up, rather than a selection of replacement words. How can I disable this "feature" Please advise Sounds like you're using WordMail as your editor and have typed text inside the automatic signature that Outlook added to the message when you created it. The solution is not to type in the signature. Type above it. I find it useful to include a short separator line (--) as the fi...

Extended CFileDialog & tab order
I`ve designed a CFileDialog extension with four extra edit boxes. May be it makes sense to describe my developing actions: I create a dlg template with a group box on it which has stc32=0x045f id. Also i added the four edit boxes. I afform the dlg class derived from CFileDialog & did the necessary initialization. Now everything works OK, but a problem with Tab order is on. I want to move the focus from one edit to another by Tab key. But it does not work: tab key moves the focus to CFileDialog standard items only. How to fill that bug? Thanks a lot. "Arman Sahakyan" <A...

SSL issue
Have issues with viewing public folders in Exchange 2003 clustere environment. When I try to view public folder properties in exchang system manager, I am unable to get them. I can see the folders i Outlook and navigate them, but cannot do any administrative tasks o the folders (i.e. mail enabling, etc.) I get the following error when try to go in to Public folder in Exchange System manager: The SSL certificate server name is incorrect. ID no: c103b404 Exchange System Manager Has anybody seen this in a clustered environment? I have reviewed the following Technet article and performed the ...

email addressbook name order (last, first)
I'm using stand alone Outlook 2007. When I create a new email then hit "To" and my address book come up all the names are arranged first, last. How do I order them last, first? Thank you Change the sort here: Tools menu > Account Settings > Address Book tab > Highlight Outlook Address Book > Click Change "Dave R" <rezin8@threshold-studio.com> wrote in message news:D14B3FCF-D6F2-453D-8BEC-B398C687ED1F@microsoft.com... > I'm using stand alone Outlook 2007. When I create a new email then hit > "To" and my address book come up...

Dynamic picklist issues
I have created a dynamic picklist (similar situation to the one described here: http://blogs.msdn.com/midatlanticcrm/archive/2005/12/04/499868.aspx). It works, but if the user changes the option in the parent picklist, I want to be able to regenerate and then refilter the child picklist. I.E. If the parent picklist has options A, B and C, and the child picklist has options 1 - 30. If I select A, I want to display options 1 - 10 in the child picklist etc. This worked for the first time I change the parent picklist after loading the form, but after that, my code reads only the items displayed...

Exchange Server Not Available Issue
I have been having trouble recently with Outlook 2002 running on XP Home Edition. Until last weeks blackout in NYC, I was able to connect to my exchange server for my email. Since then, every time I try to connect, I get the message "Your Microsoft Exchange Servier is Not Available". However, if I connect to the exchange server through the internet via the IP address, the server is online and I can get to my mail. Nothing has changed on my machine and the group that supports my exchange server says everything looks ok from there. Others are able to connect to the serve...

Exchange 2000 and Outlook 2003 issue
I am running Exchange Server 2000 for internal email and my web hosting company provides my POP3 for external. If I try to send to both any internal and external address at the same time I get a delivery failure on one of them. Everything worked great until we added this new pc with Outlook 2003. I am also getting this error on the server Application Log 2 errors every 5 min. " Windows cannot access the file gpt.ini for GPO The file must be present at the location <>.(). Group Policy processing aborted." I do not know if this is related or not. Please help. ...

Macro compatibility issue between XP & 2000
A macro was developed in excel XP, no error occurred during the testing, but when the macro was tested in Excel 2000 2 errors occurred. Is there a compatibility problem between Excel XP and Excel 2000, particularly in macros? Error encountered : 1. Wrong Number of Argument or invalid property assignment In Excel 2000, by pressing Ctrl-T (Insert of rows)this message appear by continously append a row. 2. Compile Error in hidden module: this workbook. In Excel 2000, pressing Ctrl-Y (Copy) no copy taken at all. Thank you very much. - jojo Microsoft goes to great lengths (and is us...

many vista general problems
hello, i have a vista home premium 32bit on a laptop, which randomly gets problems: 1.sometimes , the theme becomes from black to gray , yet the themes service seems to work (on the services window) . when restarting the service, it becomes black again. 2.sometimes , the language toolbar becomes floating instead of staying on the system tray . sometimes it just disappears, and sometimes it cannot switch to my second language. 3.from some reason, some programs that ran before cannot run anymore . an example of such a program would be crystal player (free/pro edition) . 4.someti...

Multiple page HTML reports issue
After generating a 15 page report in FRXReport Designer I am able to view the entire report in IE. After the report has been published to Business Portal on the page tabs show at the bottom and the report gives the error: The page cannot be found The page you are looking for might have been removed, had its name changed, or is temporarily unavailable. -------------------------------------------------------------------------------- Please try the following: Make sure that the Web site address displayed in the address bar of your browser is spelled and formatted correctly. If you reached thi...

Filter opportunities by sales stage.
Can I filter opportunities by sales stage? Thank you for pay attention. []'s Vin�cius Pitta Lima de Ara�jo the field you need to use is called stepname -- John O'Donnell Microsoft CRM MVP http://www.microsoft.com/BusinessSolutions/Community/CRMFaqLanding.aspx "Vin�cius Pitta Lima de Ara�jo" <vinipitta@yahoo.com.br> wrote in message news:%23LttoKUiEHA.3928@TK2MSFTNGP11.phx.gbl... > Can I filter opportunities by sales stage? > > Thank you for pay attention. > []'s > Vin�cius Pitta Lima de Ara�jo > > This field are not avaliable on Advan...

POS not opening (Printer issue)
Problem: When I have the HP A794 thermal printer connected and a 2nd printer(Brother Fullpage printer) is connected to the computer store operations POS will not open. I do not have the brother configured inside RMS, it is configured in windows only. When POS does not open I have to close it from task manager. The only way I can get POS to open is to open manager first and then open POS. Any other way will not work. I took the brother printer out of the equation and everything works fine with just the A794 plugged in. The A794 is running on a OPOS driver. Any suggestions ? I am pretty sure i...

Timeout/Out of memory
We have a CRM implementation with an unusually large number of Resource Groups (more than 10,000) as they are used for both skills and geographical breakup. The problem is that CRM's handliong of this is less than ideal in the System User dialog and whenever a user selected the "Resource Groups" related view or "Serivces" related view we get timeouts followed by an Out of Memory exception which kills the w3wp process. I have discovered from the logging that the system queries each group in the system in turn to see if the user is a member or not, one at a time. Not a...

OL2003 Cannot Drag Items from one group to another in order to reduce the number of subject groups
In Outlook XP, you could sort according to groups, and then drag items from one group to another. This was very handy for organizing mail by subject. For example, (when grouped by subject) two "Groups" of items could be combined by dragging one group into the other. Subsequently, the subject line of items in the first group are updated to match the subject line of items in the second group. The result is one group instead of two. If you have many subjects, you can dramatically reduce the number of subject groups by doing this Unfortunately, this cannot be done in Outlook 2003. Does ...

Meeting Invitation Issue
Hello, I am stumped on this one... here is a little background information first. At my workplace we are running Exchange Server 2003. We have a user account setup which shares its mailbox to a group of people. This group of people receives mail and sends it on behalf of this user account. This group of people has changed over the past year, people have left, others have come. Now on to the problem: When a meeting request is sent on behalf of this user, and the attendees accept or decline (and choose to send response) a certain group of people are emailed with the response. I am trying...

Workflow rule - Insert Action
When I create a workflow rule using Insert Action "Create Note" it executes fine, but when I come to view these in Notes, the entry line says these notes are created by me, rather than the record owner. I when open the note it shows the correct title and subject, but in the main notes view it shows my name. So it seems that the Workflow uses the Owner of the Rule (whoever created the rule) as the owner of the entity instance the rule creates. Has anyone come across this before? Am I missing something when setting up the workflow rule? Thanks Kirsten How do you execute...

posting sales batches and financial batches
We use Great Plains ver 7 for our company. When we are posting other's work we have to approve each sales batch in the sales batch entry window and click on post. Then we have to go to Financial Batch entry and find the correct entry and yet again approve and post the entry. Is there any way to do both of these steps at once? Any help would be great. Yes, there is. You need to post by batch and not by transaction in the sales module. You also need to go to posting setup for sales and the type of transaction you are posting and mark the option to "Post Through to GL." The ...

Public folders issue #3
I am running a exchange 2003 environement with outlook 2003 running in cache mode. I recently switched some generic mailboxes into mail enabled public folders. The problme im having is when people send to the new public folders they get undeliverable errors. However when i remove them from cache mode the GAL seems to update and it works fine. How do i correct this issue without removing the entire site off cache mode Hi Newadmin, If you changed the users from Mailboxes to Public folders but maintained the same SMTP address then you will have some problems with the cached clients having t...

How to delete Messages in ascending order
When I highlight a message (Outlook 2010) in the in box to delete and after deletion, I want the cursor to move up to the message above it and not below it. Then reverse the order the messages are in so the newest is at the bottom. heater wrote: > When I highlight a message (Outlook 2010) in the in box to delete and after > deletion, I want the cursor to move up to the message above it and not below > it. That does not accomplish what I want. In Outlook 2003, there was an option under tools that you could click to make it go up instead of down. "Bob I&...

opportunity error in crm 3.0 with sales workflow... help pleas
I have a weird situation with crm 3.0, running on windows server 2003 enterprise SP2. Last week I was directed to make some customizations, and to deactivate the sales process that someone had created in the opportunity section. Well, after this was done, we lost allot of our info in the opportunities. All of the opportunities for a client were then changed to the account owner�s name, instead of the salesman working on the opportunity. We noticed this after someone had pointed out that all of their opportunities with a major client had disappeared. We now need to get it back to where ...

Purchase Order queries
My client would like to be able to create queries that show the original requisition, purchase order number and the status if this item has been received / paid. Ultimatly they would like to see the check number used to pay the item. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in th...

New Install- workflow and deployment manager issues
This is a multi-part message in MIME format. ------=_NextPart_000_00D6_01C50678.232EA9B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello all, I have a new install of CRM 1.2 and am having some issues. Installed on = a SBS 2003 server, sql with sp3a, Install had no issues (beyond normal), but can not get to: a.. The user manager under the Deployment manager. says localhost is = not available b.. The workflow manager using various versions of the url, server = name, ports etc... yes the registry service is = run...