locked
Invalid Argument when creating an entity! RRS feed

  • Question

  • Hi all,


    I'm getting an error when trying to create a new entity! My system is in test final phase we where developing for 2 month, and now in the final stage of the project we are getting an error when trying to create a new entity! the error only says Invalid Attribute! Does any body knows how to fix this!?

    My server is installed with:

    * windows server 2003

    * Sql server 2008

    * CRM 4.0 With Rollup 1

     
    Can anybody pleaaaaaase help me with this!?
    Monday, January 5, 2009 6:38 PM

Answers

  • I had this problem early on trying to create a new entity as well. For me the problem was I deleted the System Customizer role out of CRM. Apparently that role has to be in the system for the entity to be created. Pretty specific cause with an easy solution. I contacted Microsoft and they sent me over a script with the role to re-import. No problem after that.

    Thursday, January 8, 2009 9:45 PM

All replies

  • What is the error in the event viewer.  Based on your post, I assume you are getting the error after selecting the New Entity button, provide the required details and attempting to save the Entity.

     

    If you are trying to create attributes before saving the Entity, try creating and saving the Entity first.  If that works, then begin adding new attributes.

     

    Monday, January 5, 2009 7:06 PM
  • Hello Donna!

    thanks for your answer!

    that is the most strange thing! i went to to event viewer and there isn't any error message from CRM not even one! Tongue Tied
    the error appears when i press the save button(or the save and close, is indifferent!) saying only "Invalid Argument".

    I've also tried to import a customization from other system with the same requirements and the error is exactly the same, and once again no error in event viwer!

    I've tried all different things, iisreset, reboot crm server, repair CRM installation, restarted CRMassync service but none of this worked! or either put an error on eventviwer

    I've downloaded a tool that audits data transactions and opperations from CRM, and generates log transactions from CRM but the log files are at the office! so, first thing in the moorning I will seek for the error in those files and post here!

    once again thanks for your answer!
    Monday, January 5, 2009 8:02 PM
  •  

    I did experience this error one time when I was working on a test server.  The error was associated with one of the entities that I was attempting to import.  I was able to troubleshoot the issue through the process of elimination by selecting the customization line items that I knew would not cause an issue and then one-by-one selecting those that could be causing problem and importing them.  This allowed me to import all good customizations and identify the one that was causing the problem and not import it.
    Monday, January 5, 2009 9:14 PM
  • Hello Donna, 

    I've managed a log with the operation i tried to execute! ( Creating a new entity from the costumization area) and i geted a big log. with a litle helsp from ctrl+f with key word "failed" i found this ocorences:

    [2009-01-06 10:48:16.9] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread:   21(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error | CrmEventLog.WriteEntry
        at CrmEventLog.WriteEntry(EventLogEntryType eventType, Int64 eventId, Object[] values)
        at AsyncEventLogHelper.LogOrganizationFailure(CrmEventLog eventLog, IOrganizationConfiguration orgConfiguration, Exception exception)
        at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
        at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
        at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
        at WorkloadThrottler.Execute(Int32 totalCapacity)
        at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
        at TimerProcessor.ExecuteTimers(Object data)
        at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
        at ThreadHelper.ThreadStart(Object obj)
    >Failed to write the following event message to the Event Log.
    EventType:Error
    EventId=3221242887
    ContentsSurpriseROCAPP01{08E550A1-9B39-4301-8260-4CC770948DAA}System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParserStateObject.WriteSni()
       at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
       at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
       at Microsoft.Crm.Asynchronous.DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
       at Microsoft.Crm.Asynchronous.QueueDataAccess.SelectEvents(Int32 numberOfEvents)
    The exception information is:
    System.ComponentModel.Win32Exception: Access is denied
       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)
    [2009-01-06 10:48:16.9] Process:CrmAsyncService |Organization:08e550a1-9b39-4301-8260-4cc770948daa |Thread:   21(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Workflow |User: 00000000-0000-0000-0000-000000000000 |Level: Error | AsyncEventLogHelper.LogOrganizationFailure
        at AsyncEventLogHelper.LogOrganizationFailure(CrmEventLog eventLog, IOrganizationConfiguration orgConfiguration, Exception exception)
        at QueueDataAccess.SelectEvents(Int32 numberOfEvents)
        at QueueManager.OnSelectPerOrganization(IOrganizationConfiguration orgConfig, Int32 orgCapacity)
        at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
        at WorkloadThrottler.Execute(Int32 totalCapacity)
        at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
        at TimerProcessor.ExecuteTimers(Object data)
        at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
        at ThreadHelper.ThreadStart(Object obj)
    >Received SQL Exception accessing organization {08E550A1-9B39-4301-8260-4CC770948DAA}. Exception: System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParserStateObject.WriteSni()
       at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
       at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
       at Microsoft.Crm.Asynchronous.DataAccessBase.ExecuteSqlCommandAndProcessRecords(IDbCommand command, RecordProcessor recordProcessor)
       at Microsoft.Crm.Asynchronous.QueueDataAccess.SelectEvents(Int32 numberOfEvents)
    [2009-01-06 10:48:16.9] Process:CrmAsyncService |Organization:08e550a1-9b39-4301-8260-4cc770948daa |Thread:   21(MSCRM:-TimerProcessor.ExecuteTimers) |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose | WorkloadThrottler.TraceWorkloadThrottlingInformation
        at WorkloadThrottler.TraceWorkloadThrottlingInformation(Guid organizationId, Int32 priority, Int32 waitIteration, Int32 orgCapacity, Int32 actualWorkDone)
        at WorkloadThrottler.HandleActiveOrganization(Int32 capacityPerPriority, WorkloadThrottlingInformation orgPollingInfo, Int32 effectiveMinimumPriority)
        at WorkloadThrottler.Execute(Int32 totalCapacity)
        at QueueManager.OnSelectTimerEvent(Object sender, ElapsedEventArgs e)
        at TimerProcessor.ExecuteTimers(Object data)
        at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
        at ThreadHelper.ThreadStart(Object obj)
    >WorkloadThrottlingInformation: OROCAPP01.MSCRMAsyncService.37de2ec1-4849-49fe-91f9-7c107c190718_OnSelect, {08E550A1-9B39-4301-8260-4CC770948DAA}, 0, 0, 2000, 0
    [2009-01-06 10:48:22.9] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread:   22(Crm-Key-generator-thread.) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info | CrmDbConnection.ExecuteReader
        at CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
        at DatabaseService.ExecuteBaseReader(CrmDbConnection connection, IDbCommand command, String[] columns)
        at DatabaseService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions)
        at DatabaseService.RetrieveById(String tableName, Object id, String[] columns)
        at ServerLocatorService.RetrieveForCaching(Table table, Object primaryKey)
        at ServerLocatorService.RetrieveFromCache(Table table, Object primaryKey)
        at ServerLocatorService.RetrieveById(String tableName, Object primaryKey, String[] columns)
        at ServerLocatorService.GetSiteSetting(String settingName)
        at CrmKeyGenerator.ManageKeys()
        at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
        at ThreadHelper.ThreadStart()
    >SELECT Id FROM ServerSettings  WHERE (((Id = '21528906-bc02-4579-be07-30f861ae810e')) ) AND (IsDeleted = 0)
    [2009-01-06 10:48:22.9] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread:   22(Crm-Key-generator-thread.) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Error | DatabaseService.Retrieve
        at DatabaseService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions)
        at DatabaseService.RetrieveById(String tableName, Object id, String[] columns)
        at ServerLocatorService.RetrieveForCaching(Table table, Object primaryKey)
        at ServerLocatorService.RetrieveFromCache(Table table, Object primaryKey)
        at ServerLocatorService.RetrieveById(String tableName, Object primaryKey, String[] columns)
        at ServerLocatorService.GetSiteSetting(String settingName)
        at CrmKeyGenerator.ManageKeys()
        at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
        at ThreadHelper.ThreadStart()
    >Exception when executing query: SELECT Id FROM ServerSettings  WHERE (((Id = '21528906-bc02-4579-be07-30f861ae810e')) ) AND (IsDeleted = 0) Exception: System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParserStateObject.WriteSni()
       at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
       at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
       at Microsoft.Crm.SharedDatabase.DatabaseService.ExecuteBaseReader(CrmDbConnection connection, IDbCommand command, String[] columns)
    [2009-01-06 10:48:22.9] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread:   22(Crm-Key-generator-thread.) |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error | DatabaseService.LogSqlError
        at DatabaseService.LogSqlError(String error)
        at DatabaseService.ExecuteBaseReader(CrmDbConnection connection, IDbCommand command, String[] columns)
        at DatabaseService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions)
        at DatabaseService.RetrieveById(String tableName, Object id, String[] columns)
        at ServerLocatorService.RetrieveForCaching(Table table, Object primaryKey)
        at ServerLocatorService.RetrieveFromCache(Table table, Object primaryKey)
        at ServerLocatorService.RetrieveById(String tableName, Object primaryKey, String[] columns)
        at ServerLocatorService.GetSiteSetting(String settingName)
        at CrmKeyGenerator.ManageKeys()
        at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
        at ThreadHelper.ThreadStart()
    >Failed to write the following event message to the Event Log.
    EventType:Error
    EventId=3221243904
    ContentsTongue Tiedystem.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParserStateObject.WriteSni()
       at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
       at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
       at Microsoft.Crm.SharedDatabase.DatabaseService.ExecuteBaseReader(CrmDbConnection connection, IDbCommand command, String[] columns)
    The exception information is:
    System.Security.SecurityException: Requested registry access is not allowed.
       at Microsoft.Win32.RegistryKey.OpenSubKey(String name, Boolean writable)
       at System.Diagnostics.EventLog.CreateEventSource(EventSourceCreationData sourceData)
       at System.Diagnostics.EventLog.VerifyAndCreateSource(String sourceName, 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)
    The Zone of the assembly that failed was:
    MyComputer
    [2009-01-06 10:48:23.0] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread:   22(Crm-Key-generator-thread.) |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error | CrmEventLog.WriteEntry
        at CrmEventLog.WriteEntry(EventLogEntryType eventType, Int64 eventId, Object[] values)
        at AsyncService.WriteEventLog(EventLogEntryType eventType, Int64 eventLogId, Object[] parameters)
        at AsyncService.OnUnhandledException(Object sender, UnhandledExceptionEventArgs e)
        at DatabaseService.ExecuteBaseReader(CrmDbConnection connection, IDbCommand command, String[] columns)
        at DatabaseService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions)
        at DatabaseService.RetrieveById(String tableName, Object id, String[] columns)
        at ServerLocatorService.RetrieveForCaching(Table table, Object primaryKey)
        at ServerLocatorService.RetrieveFromCache(Table table, Object primaryKey)
        at ServerLocatorService.RetrieveById(String tableName, Object primaryKey, String[] columns)
        at ServerLocatorService.GetSiteSetting(String settingName)
        at CrmKeyGenerator.ManageKeys()
        at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
        at ThreadHelper.ThreadStart()
    >Failed to write the following event message to the Event Log.
    EventType:Error
    EventId=3221242883
    ContentsSurpriseROCAPP01System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParserStateObject.WriteSni()
       at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
       at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
       at Microsoft.Crm.SharedDatabase.DatabaseService.ExecuteBaseReader(CrmDbConnection connection, IDbCommand command, String[] columns)
       at Microsoft.Crm.SharedDatabase.DatabaseService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions)
       at Microsoft.Crm.SharedDatabase.DatabaseService.RetrieveById(String tableName, Object id, String[] columns)
       at Microsoft.Crm.ServerLocatorService.RetrieveForCaching(Table table, Object primaryKey)
       at Microsoft.Crm.ServerLocatorService.RetrieveFromCache(Table table, Object primaryKey)
       at Microsoft.Crm.ServerLocatorService.RetrieveById(String tableName, Object primaryKey, String[] columns)
       at Microsoft.Crm.ServerLocatorService.GetSiteSetting(String settingName)
       at Microsoft.Crm.CrmKeyGenerator.ManageKeys()
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading.ThreadHelper.ThreadStart()
    The exception information is:
    System.ComponentModel.Win32Exception: The interface is unknown
       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)
    [2009-01-06 10:48:23.0] Process:CrmAsyncService |Organization:00000000-0000-0000-0000-000000000000 |Thread:   22(Crm-Key-generator-thread.) |Category: Platform.Async |User: 00000000-0000-0000-0000-000000000000 |Level: Error | AsyncService.OnUnhandledException
        at AsyncService.OnUnhandledException(Object sender, UnhandledExceptionEventArgs e)
        at DatabaseService.ExecuteBaseReader(CrmDbConnection connection, IDbCommand command, String[] columns)
        at DatabaseService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions)
        at DatabaseService.RetrieveById(String tableName, Object id, String[] columns)
        at ServerLocatorService.RetrieveForCaching(Table table, Object primaryKey)
        at ServerLocatorService.RetrieveFromCache(Table table, Object primaryKey)
        at ServerLocatorService.RetrieveById(String tableName, Object primaryKey, String[] columns)
        at ServerLocatorService.GetSiteSetting(String settingName)
        at CrmKeyGenerator.ManageKeys()
        at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
        at ThreadHelper.ThreadStart()
    >Exception while executing async service: MSCRMAsyncService - System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParserStateObject.WriteSni()
       at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
       at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
       at Microsoft.Crm.SharedDatabase.DatabaseService.ExecuteBaseReader(CrmDbConnection connection, IDbCommand command, String[] columns)
       at Microsoft.Crm.SharedDatabase.DatabaseService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions)
       at Microsoft.Crm.SharedDatabase.DatabaseService.RetrieveById(String tableName, Object id, String[] columns)
       at Microsoft.Crm.ServerLocatorService.RetrieveForCaching(Table table, Object primaryKey)
       at Microsoft.Crm.ServerLocatorService.RetrieveFromCache(Table table, Object primaryKey)
       at Microsoft.Crm.ServerLocatorService.RetrieveById(String tableName, Object primaryKey, String[] columns)
       at Microsoft.Crm.ServerLocatorService.GetSiteSetting(String settingName)
       at Microsoft.Crm.CrmKeyGenerator.ManageKeys()
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading.ThreadHelper.ThreadStart()
    # CRM Tracing Version 2.0
    # LocalTime: 2009-01-06 10:50:10.5
    # Categories: *:Verbose
    # CallStackOn: Yes
    # ComputerName: OROCAPP01
    # CRMVersion: 4.0.7333.1219
    # DeploymentType: OnPremise
    # ScaleGroup:
    # ServerRole: AppServer, AsyncService, DiscoveryService, WebService, ApiServer, HelpServer, DeploymentService



    After this i went to event viewer again! and didn't found anything related to CRM... at least in "naked eye".... BUT!! i found two related errors that might be causing this issue! the first pack of errors are related to SQLServer!

    1:
    SQL Server Scheduled Job 'MSCRM_CONFIG.HardDelete' (0xF6B0980A504C1A46A408E39E2F4AA35F) - Status: Failed - Invoked on: 2009-01-06 11:00:00 - Message: The job failed.  Unable to determine if the owner (DOMAIN\Arquiconsult) of job MSCRM_CONFIG.HardDelete has server access (reason: Could not obtain information about Windows NT group/user 'DOMAIN\Arquiconsult', error code 0x5. [SQLSTATE 42000] (Error 15404)).

    2:
    A fatal error occurred during a full-text population and caused the population to be cancelled. Population type is: FULL; database name is OROC_CRM_MSCRM (id: 9); catalog name is ftcat_documentindex_08e550a19b39430182604cc770948daa (id: 5); table name DocumentIndex (id: 1301579675). Fix the errors that are logged in the full-text crawl log. Then, resume the population. The basic Transact-SQL syntax for this is: ALTER FULLTEXT INDEX ON table_name RESUME POPULATION.

    3:
    SQL Server failed to communicate with filter daemon launch service  (Windows error: Windows Error: hr = 0x80070422(failed to retrieve text for this error)). Full-Text filter daemon process failed to start. Full-text search functionality will not be available.


    Full-Text filter daemon process failed to start! the service was disabled on the server, i've already started it but until now, no good news! Sad



    Tuesday, January 6, 2009 11:49 AM
  • Errors like the following imply SQL connectivity problems:

    System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

    In the first instance I'd try restarting SQL Server to see if that makes a difference.
    Tuesday, January 6, 2009 3:25 PM
    Moderator
  • I have experienced the invalid attribute error.  When I had it, it was because I was naming the primary attribute the exact same thing as the name of the entity.  It doesn't like it.

     

    I recommend that you leave the primary attribute with the standard name "name," or some variation of it.

    Wednesday, January 7, 2009 6:21 AM
    Moderator
  • I had this problem early on trying to create a new entity as well. For me the problem was I deleted the System Customizer role out of CRM. Apparently that role has to be in the system for the entity to be created. Pretty specific cause with an easy solution. I contacted Microsoft and they sent me over a script with the role to re-import. No problem after that.

    Thursday, January 8, 2009 9:45 PM
  • Hi all,

    I've been pretty busy in the last few days trying to understand what was wrong here!


    It's being very difficult to understand what is wrong! on Tuesday evening i give up, and I've reinstalled the CRM (twice! it was my fault I've forgotten to reboot the server after uninstall! Embarrassed). I made a backup from <company name>_MSCRM database. with no customizations! after that! I've imported every thing! published it and tested! every thing was just fine even the workflows... yesterday evening(Wednesday) before i leaved the office, i made one other backup ( at this point, i could create entities perfectly!).

    Today in the morning, I've tried again to create a new entity! it's the first thing i make when i arrive to the office, and the last i make before i leave! and today CRM was once again pretty harsh to me! no entity's for you in the morning! Tongue Tied so I've restored my backup and I've tried to create new entities. And everything was fine! Tongue Tied

    Now, with Sleahy message, I might found the issue for this! i sent a list with all the roles that the client need and asked him if he could create them for me! maybe he has deleted it from the system!
    because this issue appears always after he creates the roles! I really hope that this could be the origin of the problem!

    But I've been asking some questions to uncle google about deleting the System Customizer role out of CRM, and this issue only appears referenced has known in version 3.0 i just hope that even my system his 4.0 the problem might be the same... 

    First thing in the mourning will be restore the database that contains the error!  then I'll post here some feedback!


    Cheers
    Mário
    Thursday, January 8, 2009 10:53 PM