Sharepoint BDC Error: The title property of entity tblStaff is set to an invalid value
- by Christopher Rathermel
I am just starting to create our Business Data Catalog(s) for our practice management system and I am running into an issue w/ our staff table.
Background:
I am using Business Data Catalog Definition Editor to create my ADF.
I am using the RevertToSelf Authentication Mode.
I have tried a few other tables and they seem to work just fine thus far.. only issue is w/ the staff table.
If I removed all the columns for the staff entity except the ID and a few columns for the name it actually works. So it has a problem w/ one of my columns in tblStaff.
I receive this error even when I set up an ADF w/ just this one entity. So w/ no associations..
When attempting to view the record: http://servername/ssp/admin/Content/tblstaff.aspx?StaffID={0} w/ {0} replaced w/ an actual staff ID I get the following error:
The title property of entity tblStaff is set to an invalid value.
Things I have tried:
I noticed that I do have a column in my staff table called "Title" and removed it from ADF w/ no luck... Same error..
I tried to use bdc meta man to create my ADF and I got the same error...
Any ideas?
Chris