web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / cant remove column fro...
Power Apps
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?

I have the same question (0)
  • Jonathan Manrique Profile Picture
    2,687 on at

    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

     

     

  • TheJaks Profile Picture
    21 on at

    hi - thanks, it's an unmanaged solution.

  • TheJaks Profile Picture
    21 on at

    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?

  • Jonathan Manrique Profile Picture
    2,687 on at

    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.

     

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard