Sharepoint BDC Error: The title property of entity tblStaff is set to an invalid value
        Posted  
        
            by Christopher Rathermel
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Christopher Rathermel
        
        
        
        Published on 2009-03-13T21:32:55Z
        Indexed on 
            2010/05/11
            22:04 UTC
        
        
        Read the original article
        Hit count: 473
        
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
© Stack Overflow or respective owner