Share
Report
155We did a Dev refresh from prod and after that when i create a new n:n relationship, the applications errors out with "SQL server error".
N:N relationship between contact and sts_product. But trace logs shows invalid column name error which is really strange.
Please let me know if there is a way to resolve this :
ManyToManyRelationshipService.Create caught exception: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sts_product1'. Invalid column name 'new_Consultant_Contact'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 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.Metadata.CascadingSprocGenerator.ProcessDelete(Boolean alter) at Microsoft.Crm.Metadata.CascadingSpGenerator.Process(ISqlExecutionContext context) at Microsoft.Crm.Metadata.MetadataHelper.ProcessDatabaseOperations(CounterList listCounters) at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue() at Microsoft.Crm.Metadata.ManyToManyRelationshipService.CreateRelationship(ManyToManyRelationshipCreateInfo manyToManyCreateInfo, MetadataHelper metadataHelper, ExecutionContext context) at Microsoft.Crm.Metadata.ManyToManyRelationshipService.CreateInternal(IRelationshipCreateInfo relationshipCreateInfo, ExecutionContext context, MetadataHelper metadataHelper) at Microsoft.Crm.Metadata.RelationshipServiceBase.CreateNoPrivilegeChecks(IRelationshipCreateInfo relationshipInfo, ExecutionContext context, MetadataHelper metadataHelper) ClientConnectionId:ab396356-bb70-482f-8fd2-0c3b41e6f233 Error Number:207,State:1,Class:16 MSCRM Error Report: -------------------------------------------------------------------------------------------------------- Error: Invalid column name 'sts_product1'. Invalid column name 'new_Consultant_Contact'. Error Number: 0x80044150 Error Message: Generic SQL error. Error Details: Generic SQL error. Source File: Not available Line Number: Not available
*This post is locked for comments
All responses (
Answers (
