locked
Corruption with invoice product entity RRS feed

  • Question

  • Hi, 

     

    i am having a major issue with the Invoice Product entity, i have tried exporting it so that our developers could do some work on it and i get this error: 

     

     <?xml version="1.0" ?> 
    - <error xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
     <displaytitle /> 
     <displaytext /> 
     <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.</description> 
     <file>Not available</file> 
     <line>Not available</line> 
     <details>Exception of type 'System.Web.HttpUnhandledException' was thrown.</details> 
     <requesturl>http://gal-dy01/GaltecSolutionsLTD/_grid/cmds/dlg_exportcustomizations.aspx</requesturl> 
     <pathAndQuery>/GaltecSolutionsLTD/_grid/cmds/dlg_exportcustomizations.aspx</pathAndQuery> 
     <source>XML</source> 
     <stacktrace /> 
     </error>

     

     

    i then attempted to publish the entity and got the standard error: 

     

     

    An error has occurred. 
    
    try this action again. If the problem continues, check Microsoft Dynamics CRM Community for solutions or contact your organisation's Microsoft Dynamics CRM Administrator. Finally, you can contact Microsoft Support.

     

     

    i get that error no matter what i try to do to the entity and it is vital we fix it for future development, does anyone know what could cause this and what i can do to fix it?? 

     

    Tuesday, February 1, 2011 3:31 PM

Answers

  • i have just done a restore of the database from 2 months ago before we made changes and it is working now :) 
    • Marked as answer by s.marks Wednesday, February 2, 2011 4:18 PM
    Wednesday, February 2, 2011 4:18 PM

All replies

  • Can you try enabling tracing on the CRM server, attempt the action again, and then examine the trace logs for a more detailed error message?

    Enabling tracing in CRM 4.0: http://support.microsoft.com/kb/907490


    Neil Benson, CRM Addict and MVP at Customery Ltd. You can reach me on LinkedIn or Twitter. Join over 10,000 other CRM professionals on the Microsoft Dynamics CRM group on LinkedIn.

    Tuesday, February 1, 2011 4:19 PM
    Moderator
  • # CRM Tracing Version 2.0
    # LocalTime: 2011-02-02 09:14:54.2
    # Categories: 
    # CallStackOn: No
    # ComputerName: GAL-DY01
    # CRMVersion: 4.0.7333.3135
    # DeploymentType: OnPremise
    # ScaleGroup: 
    # ServerRole: AppServer, AsyncService, DiscoveryService, WebService, ApiServer, HelpServer, DeploymentService

    [2011-02-02 09:14:54.2] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:    9(MSCRM:-NotificationManager.NotificationWatcherThreadProc) |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error | NotificationManager.NotificationWatcherThreadProc
    at NotificationManager.NotificationWatcherThreadProc()
    at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
    at ThreadHelper.ThreadStart()
    >ThreadAbort Exception in NotificationWatcherThreadProc Thread was being aborted.
    [2011-02-02 09:14:54.2] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:    9(MSCRM:-NotificationManager.NotificationWatcherThreadProc) |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ExecutionContext.Run
    >NotificationWatcherThreadProc Stopped. 
    # CRM Tracing Version 2.0
    # LocalTime: 2011-02-02 09:22:00.7
    # Categories: 
    # CallStackOn: No
    # ComputerName: GAL-DY01
    # CRMVersion: 4.0.7333.3135
    # DeploymentType: OnPremise
    # ScaleGroup: 
    # ServerRole: AppServer, AsyncService, DiscoveryService, WebService, ApiServer, HelpServer, DeploymentService

    [2011-02-02 09:22:00.7] Process: w3wp |Organization:da554600-cfa6-459d-afc5-50614abf3379 |Thread:    6 |Category: Exception |User: 43ee242c-f10d-e011-b21e-005056870026 |Level: Error | CrmPerformanceCounterFactory.LoadCounters
    at CrmPerformanceCounterFactory.LoadCounters(PerformanceCounterLoadSetting settings, String component)
    at SyncPerformanceCounters.Initialize()
    at SyncPerformanceCounters.Increment(String perfCounterName)
    at SyncPerformanceCounters.Increment(Int32 subscriptionType)
    at SubscriptionClientsService.PrepareOutlookSync(Guid clientId, Int32 handlingType, ExecutionContext context)
    at RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
    at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
    at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at LogicalMethodInfo.Invoke(Object target, Object[] values)
    at InternalOperationPlugin.Execute(IPluginExecutionContext context)
    at PluginStep.Execute(PipelineExecutionContext context)
    at Pipeline.Execute(PipelineExecutionContext context)
    at MessageProcessor.Execute(PipelineExecutionContext context)
    at InternalMessageDispatcher.Execute(PipelineExecutionContext context)
    at ExternalMessageDispatcher.Execute(String messageName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, PropertyBag fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
    at RequestBase.Process(Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
    at RequestBase.Process(CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
    at CrmServiceInternal.Execute(RequestBase request, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
    at CrmService.Execute(Request request)
    at RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
    at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
    at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at LogicalMethodInfo.Invoke(Object target, Object[] values)
    at WebServiceHandler.Invoke()
    at WebServiceHandler.CoreProcessRequest()
    at SyncSessionlessHandler.ProcessRequest(HttpContext context)
    at CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
    at ApplicationStepManager.ResumeSteps(Exception error)
    at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
    at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
    at HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
    at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
    >Failed to write the following event message to the Event Log.
    EventType:Information
    EventId=17189
    Contents:OutlookSync
    The exception information is:
    System.InvalidOperationException: Cannot open log for source 'MSCRMPerfCounters'. You may not have write access. ---> System.ComponentModel.Win32Exception: Access is denied
       --- End of inner exception stack trace ---
       at System.Diagnostics.EventLog.OpenForWrite(String currentMachineName)
       at System.Diagnostics.EventLog.InternalWriteEvent(UInt32 eventID, UInt16 category, EventLogEntryType type, String[] strings, Byte[] rawData, String currentMachineName)
       at System.Diagnostics.EventLog.WriteEvent(EventInstance instance, Byte[] data, Object[] values)
       at Microsoft.Crm.CrmEventLog.WriteEntry(EventLogEntryType eventType, Int64 eventId, Boolean traceFailure, Object[] values)
    [2011-02-02 09:29:04.0] Process: w3wp |Organization:da554600-cfa6-459d-afc5-50614abf3379 |Thread:    3 |Category: Platform |User: 07901f3b-ee3e-4786-a7d2-f3cd26e88e71 |Level: Error | MessageProcessor.Execute
    >MessageProcessor fail to process message 'ExportCompressed' for 'none'.
    [2011-02-02 09:29:04.0] Process: w3wp |Organization:da554600-cfa6-459d-afc5-50614abf3379 |Thread:    3 |Category: Platform.Sdk |User: 07901f3b-ee3e-4786-a7d2-f3cd26e88e71 |Level: Error | InProcessCrmService.Execute
    >non-plugin non- CrmException detected - report will be sent to Watson:
    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NullReferenceException: Object reference not set to an instance of an object.
       at Microsoft.Crm.ObjectModel.OrganizationUIService.LabelLoaderAllLanguages.LoadMetadataLabel(Int32 entityType, String attributeName, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.OrganizationUIService.LabelLoader.LoadCellLabel(Guid cellObjectId, String cellObjectColumnName, Int32 objectType, String attributeName, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.OrganizationUIService.InsertFormLabels(IBusinessEntity entity, ILabelLoader labelLoader, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.OrganizationUIService.RetrieveMultipleWithAllLanguages(EntityExpression entityExpression, ExecutionContext context)
       at Microsoft.Crm.Metadata.OrganizationUIHelper.RetrieveInProductionHelper(Int32 objectTypeCode, ExecutionContext context)
       at Microsoft.Crm.Tools.ImportExportPublish.FormXmlHandler.ExportItem(XmlDocument importDocument)
       at Microsoft.Crm.Tools.ImportExportPublish.ExportHandler.Export(XmlDocument XDoc)
       at Microsoft.Crm.Tools.ImportExportPublish.ExportHandler.Export(XmlDocument XDoc)
       at Microsoft.Crm.Tools.ImportExportPublish.RootExportHandler.RunExport(String[] ExportEntities, String[] ExportRoles, String[] ExportWorkflows, ExportMask Mask)
       at Microsoft.Crm.Tools.ImportExportPublish.ExportXml.RunExport(String xmlArgs, XmlDocument& ExportDoc)
       at Microsoft.Crm.WebServices.ExportXmlService.ExportCompressed(String entities, String embeddedFileName, ExecutionContext context)
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
       at Microsoft.Crm.Extensibility.InternalOperationPlugin.Execute(IPluginExecutionContext context)
       at Microsoft.Crm.Extensibility.PluginStep.Execute(PipelineExecutionContext context)
       at Microsoft.Crm.Extensibility.Pipeline.Execute(PipelineExecutionContext context)
       at Microsoft.Crm.Extensibility.MessageProcessor.Execute(PipelineExecutionContext context)
       at Microsoft.Crm.Extensibility.InternalMessageDispatcher.Execute(PipelineExecutionContext context)
       at Microsoft.Crm.Extensibility.ExternalMessageDispatcher.Execute(String messageName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, PropertyBag fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
       at Microsoft.Crm.Sdk.RequestBase.Process(Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
       at Microsoft.Crm.Sdk.RequestBase.Process(CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
       at Microsoft.Crm.Sdk.CrmServiceInternal.Execute(RequestBase request, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
       at Microsoft.Crm.Sdk.InProcessCrmService.Execute(Object request)
    [2011-02-02 09:29:04.7] Process: w3wp |Organization:da554600-cfa6-459d-afc5-50614abf3379 |Thread:    3 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ErrorInformation.LogError
    >MSCRM Error Report:
    --------------------------------------------------------------------------------------------------------
    Error: Exception of type 'System.Web.HttpUnhandledException' was thrown.

    Error Message: 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.

    Error Details: Exception of type 'System.Web.HttpUnhandledException' was thrown.

    Source File: Not available

    Line Number: Not available

    Request URL: http://gal-dy01/GaltecSolutionsLTD/_grid/cmds/dlg_exportcustomizations.aspx

    Stack Trace Info: [NullReferenceException: Object reference not set to an instance of an object.]
       at Microsoft.Crm.ObjectModel.OrganizationUIService.LabelLoaderAllLanguages.LoadMetadataLabel(Int32 entityType, String attributeName, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.OrganizationUIService.LabelLoader.LoadCellLabel(Guid cellObjectId, String cellObjectColumnName, Int32 objectType, String attributeName, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.OrganizationUIService.InsertFormLabels(IBusinessEntity entity, ILabelLoader labelLoader, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.OrganizationUIService.RetrieveMultipleWithAllLanguages(EntityExpression entityExpression, ExecutionContext context)
       at Microsoft.Crm.Metadata.OrganizationUIHelper.RetrieveInProductionHelper(Int32 objectTypeCode, ExecutionContext context)
       at Microsoft.Crm.Tools.ImportExportPublish.FormXmlHandler.ExportItem(XmlDocument importDocument)
       at Microsoft.Crm.Tools.ImportExportPublish.ExportHandler.Export(XmlDocument XDoc)
       at Microsoft.Crm.Tools.ImportExportPublish.ExportHandler.Export(XmlDocument XDoc)
       at Microsoft.Crm.Tools.ImportExportPublish.RootExportHandler.RunExport(String[] ExportEntities, String[] ExportRoles, String[] ExportWorkflows, ExportMask Mask)
       at Microsoft.Crm.Tools.ImportExportPublish.ExportXml.RunExport(String xmlArgs, XmlDocument& ExportDoc)
       at Microsoft.Crm.WebServices.ExportXmlService.ExportCompressed(String entities, String embeddedFileName, ExecutionContext context)

    [TargetInvocationException: Exception has been thrown by the target of an invocation.]
       at Microsoft.Crm.Application.Utility.Util.RaiseXMLError(Exception exception)
       at Microsoft.Crm.Dialogs.ExportCustomizationsPage.ConfigureForm()
       at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    [HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown.]
       at System.Web.UI.Page.HandleError(Exception e)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest()
       at System.Web.UI.Page.ProcessRequest(HttpContext context)
       at ASP.galtecsolutionsltd__grid_cmds_dlg_exportcustomizations_aspx.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)


    Wednesday, February 2, 2011 9:31 AM
  • Also guys this is the error i get when i try to delete an attribute

     

     

    [2011-02-02 15:26:47.3] Process: w3wp |Organization:da554600-cfa6-459d-afc5-50614abf3379 |Thread:  3 |Category: Platform.Metadata |User: 00000000-0000-0000-0000-000000000000 |Level: Error | AttributeService.GetUsageInfo
    >AttributeService.GetUsageInfo caught exception: System.NullReferenceException: Object reference not set to an instance of an object.
      at Microsoft.Crm.ObjectModel.OrganizationUIService.LabelLoaderAllLanguages.LoadMetadataLabel(Int32 entityType, String attributeName, ExecutionContext context)
      at Microsoft.Crm.ObjectModel.OrganizationUIService.LabelLoader.LoadCellLabel(Guid cellObjectId, String cellObjectColumnName, Int32 objectType, String attributeName, ExecutionContext context)
      at Microsoft.Crm.ObjectModel.OrganizationUIService.InsertFormLabels(IBusinessEntity entity, ILabelLoader labelLoader, ExecutionContext context)
      at Microsoft.Crm.ObjectModel.OrganizationUIService.RetrieveMultipleWithAllLanguages(EntityExpression entityExpression, ExecutionContext context)
      at Microsoft.Crm.Metadata.OrganizationUIHelper.RetrieveInProductionHelper(Int32 objectTypeCode, ExecutionContext context)
      at Microsoft.Crm.Metadata.UsageHelper.CheckForms(Guid attributeId, DynamicMetadataCache mdCache, ExecutionContext context)
      at Microsoft.Crm.Metadata.UsageHelper.GetAttributeUsageInfo(Guid attributeId, Guid relationshipId, DynamicMetadataCache mdCache, ExecutionContext context)
      at Microsoft.Crm.Metadata.AttributeService.GetUsageInfo(Guid attributeId, ExecutionContext context)
    [2011-02-02 15:26:47.3] Process: w3wp |Organization:da554600-cfa6-459d-afc5-50614abf3379 |Thread:  3 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ErrorInformation.LogError
    >MSCRM Error Report:
    --------------------------------------------------------------------------------------------------------
    Error: Object reference not set to an instance of an object.
    
    Error Message: Object reference not set to an instance of an object.
    
    Source File: Not available
    
    Line Number: Not available
    
    Request URL: http://gal-dy01/GaltecSolutionsLTD/AppWebServices/SystemCustomization.asmx
    
    Stack Trace Info: [NullReferenceException: Object reference not set to an instance of an object.]
      at Microsoft.Crm.ObjectModel.OrganizationUIService.LabelLoaderAllLanguages.LoadMetadataLabel(Int32 entityType, String attributeName, ExecutionContext context)
      at Microsoft.Crm.ObjectModel.OrganizationUIService.LabelLoader.LoadCellLabel(Guid cellObjectId, String cellObjectColumnName, Int32 objectType, String attributeName, ExecutionContext context)
      at Microsoft.Crm.ObjectModel.OrganizationUIService.InsertFormLabels(IBusinessEntity entity, ILabelLoader labelLoader, ExecutionContext context)
      at Microsoft.Crm.ObjectModel.OrganizationUIService.RetrieveMultipleWithAllLanguages(EntityExpression entityExpression, ExecutionContext context)
      at Microsoft.Crm.Metadata.OrganizationUIHelper.RetrieveInProductionHelper(Int32 objectTypeCode, ExecutionContext context)
      at Microsoft.Crm.Metadata.UsageHelper.CheckForms(Guid attributeId, DynamicMetadataCache mdCache, ExecutionContext context)
      at Microsoft.Crm.Metadata.UsageHelper.GetAttributeUsageInfo(Guid attributeId, Guid relationshipId, DynamicMetadataCache mdCache, ExecutionContext context)
      at Microsoft.Crm.Metadata.AttributeService.GetUsageInfo(Guid attributeId, ExecutionContext context)
      at Microsoft.Crm.Metadata.AttributeService.GetUsageInfo(Guid attributeId)
      at Microsoft.Crm.Application.WebServices.SystemCustomization.AttributeDelete.Execute(IUser user, Guid attributeId)
      at Microsoft.Crm.Application.WebServices.SystemCustomization.SystemCustomization.DeleteAttribute(Guid attributeId)
    

    Wednesday, February 2, 2011 3:31 PM
  • i have just done a restore of the database from 2 months ago before we made changes and it is working now :) 
    • Marked as answer by s.marks Wednesday, February 2, 2011 4:18 PM
    Wednesday, February 2, 2011 4:18 PM
  • I've just had to fix a problem with very similar symptoms.

    Have a look at this post http://msdynamics4you.blogspot.com/2009/07/cannot-deletepublish-changes-in.html it helped me a lot.

    In my case customisations for one entity (Contacts) had been exported from one system and imported into another that did not include all the relationships with other entities (in my case a custom one - Grades).  I didn't do the import/export so I'm not sure exactly how it happened (I would have expected some warning/error on import/publish?).  I labourously searched through the FormXML for "datafieldname=" and checked that each attribute referenced existed for the contact entity in CRM.  Unfortunately this system had been heavily customised by the end-user and there were a lot of fields...  Eventually I found that the lookup to the Grades entity was missing.

    Actually I noticed that I could have seen this when customising the form in CRM if I'd had sharper eyes (Label but no blue box round the control itself) - hopefully that will help someone else!

    Fixing it was simple in my case - exporting and importing Contacts and Grades together from one system to another.

    Regards, Simon

     


    Simon Hetzel Microsoft Dynamics CRM Consultancy Microsoft Server/Infrastructure Architecture http://uk.linkedin.com/in/simonhetzel
    Wednesday, June 22, 2011 4:57 PM