hi all
Strange error in dataverse- I am simpy trying to delete a column from a view, before deleting it later - it's the final dependency. However, after removing the column, pressing save or save and publish is throwing up an error "your view could not be saved. Try again later" . Unmanaged solution.
I switched to the classic view and that also threw up an error, but I could download the log:
System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: Exception output:: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'EntityLogicalName'.
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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrit... (Fault Detail is equal to Exception details:
ErrorCode: 0x80040216
Message: Exception output:: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'EntityLogicalName'.
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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolea...).
it means nothing to me, but EntityLogicalName is not one of my columns. Any ideas?
Hi @TheJaks
Because of the last thing you said, I recommend you open a ticket, it may be for some field that you can't find that possibly wasn't in dataverse for team, because in the end it doesn't tell you which field is missing.
The other thing you can do is try saving it with another name and do the same process to see what happens, the view may have been corrupted in the migration.
this is the error I get in the classic mode, no error in new mode.
It turns out I cannot change or remove any view of any table.
I've just upgraded from dataverse for teams to dataverse so could this be a table rights issue I wonder?
hi - thanks, it's an unmanaged solution.
Hi @TheJaks
IF you are in a managed solution you will not be able to delete the column, you must do it in an unmanaged solution
mmbr1606
22
Super User 2025 Season 1
stampcoin
17
ankit_singhal
11
Super User 2025 Season 1