asked on

MS CRM 3.0: Unable to add products to opportunities.

We are about to roll out MS CRM 3.0 to around 25 users but I've hit a snag. No users are able to add opportunity products to an existing opportunity. When trying to save a selected product we recieve the following error message:

Record Is Unavailable
The record that you are requesting is currently unavailable. Either the record was not found or you do not have sufficient security permissions to view it.

It doesn't matter who owns the opportunity or who the user is (even Admin) and the security permissions look good. We have a test system set up on a Virtual Machine with an identical user/permissions setup and it works fine there. I'm guessing this may be a database issue.

We have a Microsoft CRM 3.0 Server running on MS Server 2003 R2 with Update Rollup 2 installed. The SQL Database is sitting on a seperate MS SQL 2000 server.

Can anyone help?

tdoull

ASKER

After having turned "DevErrors" on I have this more detailed message which hasn't helped me at all:

Microsoft CRM Unhandled Error Details:
Server Error in '/' Application.
--------------------------------------------------------------------------------

<description>The specified object was not found.</description>
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: <description>The specified object was not found.</description>

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[COMException (0x80040217): <description>The specified object was not found.</description>]
Microsoft.Crm.Platform.ComProxy.CRMOpportunityProductClass.Create(CUserAuth& Caller, String OpportunityProductXml) +0
Microsoft.Crm.Application.Platform.OpportunityProduct.InternalCreate(String xml) +31
Microsoft.Crm.Application.Platform.Entity.Create() +109
Microsoft.Crm.Application.Forms.AppForm.RaiseDataEvent(FormEventId eventId) +408
Microsoft.Crm.Application.Forms.EndUserForm.Initialize(Entity entity) +57
Microsoft.Crm.Application.Forms.CustomizableForm.Execute(Entity entity, String formId, String formType) +83
Microsoft.Crm.Application.Forms.CustomizableForm.Execute(Entity entity) +13
Microsoft.Crm.Web.SFA.OpportunityProductDetailPage.ConfigureForm() +197
Microsoft.Crm.Application.Controls.AppPage.OnPreRender(EventArgs e) +30
System.Web.UI.Control.PreRenderRecursiveInternal() +62
System.Web.UI.Page.ProcessRequestMain() +1499

cmhunty

Hi

I've been having the same problem. The reason for this error is that the GUID that you've specified apparently doesn't exist. The issue I'm having is that it clearly does! I'm investigating further now and will let you know if I get to the bottom of this.

Chris

cmhunty

Hi

My error came from using the SDK. Turned out that one of my lookups was referencing a GUID that no longer exists. The GUID for the object did still exist and this is what I was checking. I would suggest that somehow your database base become corrupt and that it's trying to update a record where the lookup doesn't exist any longer. What happens if you copy the test database on to live server - do you get the same error then?

Chris

tdoull

ASKER

Using the test database everything worked fine. It's not a database problem though, it was a problem with some customisation added by our consultants. In the "Opportunity Product" Form there was some OnChange code in the properties of the Product field. This code directly used the UoMID to automatically populate the Unit field. It turns out that the UoMID was incorrect (for the live database) and doesnt reference anything in the table relevant. I corrected this and now everything works perfectly. :)

Thanks for the help and I hope this helps you with your problem too.

ASKER CERTIFIED SOLUTION

Computer101

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial