SharePoint 2010 error: webpart configured to display type of data that no longer exists in Business Data Connectivity
Running Sharepoint 2010 Site for use as a budgeting tool.
The external content types we created uses BCS to connect to a Sql2008r2 Server to pull content from views on the Finance database.
A recent Software uprade required 'SQL2012' we had no choice but to move the database to a Sql2012 server. This was done successfully and it's been a few weeks now and all went well.
However we ran into some problems changing the Server name for the External System named 'LiveDB' We were getting errors but managed to work through them and finally had it connected and running after editing an unused External System called 'LiveDB2" ONE BIG PROBLEM THOUGH the ECT tabs were open in Sharepoint Designer and to close them we were prompted that unsaved changes existed and faced with having to discard changes or Save Them. We weren't sure what these changes were but didn't want to take a chance that the changes we made to get the BCS and ECT working would be lost. So we save the changes and immediately we opened the Sharepoint site and as soon as we clicked the link that retrieved the External content we got the following error:
Can anyone tell me how I could possibly get this back or what change would cause something like this?. It was working perfectly until I clicked save in SP Designer.
How can I get the external content types back into BCS?
The external content types we created uses BCS to connect to a Sql2008r2 Server to pull content from views on the Finance database.
A recent Software uprade required 'SQL2012' we had no choice but to move the database to a Sql2012 server. This was done successfully and it's been a few weeks now and all went well.
However we ran into some problems changing the Server name for the External System named 'LiveDB' We were getting errors but managed to work through them and finally had it connected and running after editing an unused External System called 'LiveDB2" ONE BIG PROBLEM THOUGH the ECT tabs were open in Sharepoint Designer and to close them we were prompted that unsaved changes existed and faced with having to discard changes or Save Them. We weren't sure what these changes were but didn't want to take a chance that the changes we made to get the BCS and ECT working would be lost. So we save the changes and immediately we opened the Sharepoint site and as soon as we clicked the link that retrieved the External content we got the following error:
This web part is configured to display a type of data that no longer exists in Business Data Connectivity.
Open the tool pane to reconfigure the web part. Administrators, see the server log for more information.
Correlation ID:0d38e495-6e97-4f5f-894b-fece5461e07d Can anyone tell me how I could possibly get this back or what change would cause something like this?. It was working perfectly until I clicked save in SP Designer.
How can I get the external content types back into BCS?
ASKER
First, I want to say thank you to the members who responded to my cry for help with genuine concern, asking intelligent questions, eager to offer suggestions aimed at finding a solution to my problem. Unfortunately, I haven't had much luck finding solutions from any of the support sites I've joined over the last 10 years and I was skeptical that signing up with Experts Exchange would be any different but I did so out of desperation. Then I got tied up following other leads that didn't help and never checked back with EE Eventually, I ended up using some older backups to restore functionality and managed to rebuild the BCS stuff and pull the external content again. So please accept my apology for not following up to update you on whether I still needed help
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
In researching this you can use the correctional ID to find out why the content type isn't connecting:
https://support.office.com/en-ie/article/sharepoint-correlation-id-in-error-messages-what-it-is-and-how-to-use-it-5bf2dba7-43d2-484c-8ef4-e059f76e3efa
https://blogs.technet.microsoft.com/fesiro/2013/11/11/sharepoint-logging-and-troubleshooting-using-ulsviewer/