Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Create new field in CRM RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi, We are trying to create a new field in CRM 4.0. It throws the following error:

    <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman";} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} -->

    >Exception when executing non-query: ALTER TABLE IntegrationBase ADD IntegrationSource int    NULL  Exception: System.Data.SqlClient.SqlException: You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

       at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command)

       at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)

       at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(MetadataHelper helper, IDbCommand sqlCommand)

     

     

     Can any one suggest how to resolve this??

     

    Thank you

    Thursday, October 22, 2009 4:57 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    My guess is that this is a sql issue.  Is your sql server ok?  do you have plenty of free space?  Is this a sql cluster OR do you have replication setup?  If you have replication setup, depending on the replication type it has a lock on the db so you can't create new columns.

    Alex Fagundes - www.PowerObjects.com
    Thursday, October 22, 2009 10:01 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi, please provide more information.

    1. What type of field are you adding? Name ect.
    2. Have you tried to create another field on another entity?
    3. Have you recently made any unsupported modifications to your system, e.g. direct DB manipulation?

    Also where did this error display?

    Thanks,
    Karlo
    Karlo Swart - http://www.ver206.com
    Thursday, October 22, 2009 8:03 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    My guess is that this is a sql issue.  Is your sql server ok?  do you have plenty of free space?  Is this a sql cluster OR do you have replication setup?  If you have replication setup, depending on the replication type it has a lock on the db so you can't create new columns.

    Alex Fagundes - www.PowerObjects.com
    Thursday, October 22, 2009 10:01 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello friends,

    i have the same issue after I have configured my sql server to use transation replication.

    so, transaction replicaation for selected database tables works fine and data replicates from master db to all subscriptions, but if I create any new property in crm, I will receive an error

    ALTER TABLE [AccountExtensionBase] ADD  [new_replica7] nvarchar (100)    NULL   Exception: System.Data.SqlClient.SqlException (0x80131904): You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace)
       at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace)
       at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(ISqlExecutionContext context, IDbCommand sqlCommand)

    I would like to notice that i am able to create new table columns using sql data managment.

    can you help me by provide any usefull information about how can i tackle with described issue, how can i change isolation level for transaction replication sql

    Best regards,

    Tuesday, April 17, 2012 8:53 AM