Business Data Item Error

Question

Hi
i'm working on bdc, i create an ADF file to connect to my sql server database and fetch some data, then add Business Data List to display my lob data, it works correctly, but when i add Business Data Item webPart to my page and connect Business Data List to that , i got this error :

An unhandled exception has occurred:There was an error in the callback.

i think my adf file is correct, but i don't know where does my problem, can anybody help me ?
thanks

---

this is my Signature

Answer 1

Hi,

Have you tried to manually select an item when you configure the business data item web part?  If you're also having a problem with this, there is most likely a problem with your specific finder. 

A couple suggestions that can help you troubleshoot.  1) You can turn on verbose log settings for the Business Data category.  You can then review the output in your logs folder (by default located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS).  2) If you're using SQL server as your back end database, you can perform a trace using SQL Profiler.  This will let you inspect the call that BDC is making to your database server.

I hope this helps.

---

Randy - http://sharepointhawaii.com/randywilliams

Answer 2

Many Thanks Randy

Have you tried to manually select an item when you configure the business data item web part?

How can i do this ?


You can turn on verbose log settings for the Business Data category

How can i do this ? (i tried to view logs, but it very hard to read and i didn't take a result)


If you're using SQL server as your back end database, you can perform a trace using SQL Profiler.  This will let you inspect the call that BDC is making to your database server

You mean i can trace commands which bdc sends to sql server ?

Thanks Again

---

this is my Signature

Answer 3

Hi,
As you said that the BDC entity works absolutely fine with Business Data List that means your adf file is right for listing(more than one record) bdc data. But the problem is with the Bussiness Data Item because for this the ADF file is not having any details or required information by which this particular web part can be configured. I think you need to check the ADF file again.

---

Manish Patil http://patilmanishrao.wordpress.com Posting is provided "AS IS" with no warranties, and confers no rights.

Answer 4

Hi,

The Business Data List uses the 'Finder Method' where the Business Data Item will be using the 'Specfic Finder Method' , it sounds like you have an issues with the Specific Finder Method.

If possible please can you post your Application Definition File and we will try and see what we can come up with as a solution

Regards,

Phill

---

BDC Meta Man Web Edition - Out Now

Answer 5

Hi,

The Business Data List uses the 'Finder Method' where the Business Data Item will be using the 'Specfic Finder Method' , it sounds like you have an issues with the Specific Finder Method.

If possible please can you post your Application Definition File and we will try and see what we can come up with as a solution

Regards,

Phill

---

BDC Meta Man Web Edition - Out Now

Hi Phill
you can download it via this link.
thanks

---

this is my Signature

Answer 6

Any help ?

---

this is my Signature

Answer 7

Hi Hamed,

I can see two things.

1. Your identifier is a Guid which often causes issues... change its type to System.String
2. You do not have a Specific Finder method which is used by the BDC Item Picker

I would sincerely recommend using a tool such as BDC Meta Man (created by the company I work for, Lightning Tools - www.lightningtools.com ) there is a free developer version which you can use to generate your Application Definition File. Do this and you can see which methods are created.

Best Regards,

Phill

---

BDC Meta Man Web Edition - Out Now

Answer 8

Thanks Phill
i've used bdc meta man and get correct result.
best regards

---

this is my Signature