Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

cant remove column from view

(0) ShareShare
ReportReport
Posted on by 21

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?

Categories:
  • Jonathan Manrique Profile Picture
    2,678 on at
    Re: cant remove column from view

    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.

     

     

  • TheJaks Profile Picture
    21 on at
    Re: cant remove column from view

    image.pngthis 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?

  • TheJaks Profile Picture
    21 on at
    Re: cant remove column from view

    hi - thanks, it's an unmanaged solution.

  • Jonathan Manrique Profile Picture
    2,678 on at
    Re: cant remove column from view

    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

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 17

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics