SharePoint 2010 Search against External Content Types: results gives 404 errors

Hi community!

I want to discuss a technical issue I am experiencing but perhaps  there is wider one.

Say I want to allow my users to search against All sites (projects) and also the data held against those projects in SQLServer@ stored procs, views, tables in the form of Enterprise Content Types (ECTS).   So so 1) how do you configure search (center) to make this easy for the users to enter queries and 2) how to format the data displayed so they can both access relevant  site content or links to entity data in the ECT?

This leads me to my specific intractable problem:

I have configured BCS search as per the technet article ( the one with products and productsandDescription Ects)

• External content crawl yields > 2000 items
• Entity read and readitem operations generated in SPD 2010 by connecting the store procs held in SQLserver.
• create profile page for the entity (see below)

Go to search center and enter a project number ( in my case) and I do get some bcs data back but in the form that needs to be converted in the profile page for that entity. I click on a link and get a 404 error. However, when I pass the project number to my profile page as in http://intranet.client/SearchCenter/_bdc/test/Project_1.aspx?projectNo=???????? everything looks good.

Hence, I think it’s the way the search results are getting displayed in that it is not formatting the links for the profile page. Maybe I need a custom scope that directs BCS searches to profile site root. I wish I knew?

Thanks

Daniel