When BDC Webpart reports error, what log should we look at?
"An error occurred while retrieving data from
aspnetdb_ExtranetInstance. Administrators, see theserver logfor more
information."
"An error occurred while retrieving data from
aspnetdb_ExtranetInstance. Administrators, see theserver logfor more
information."
Other errors may surface in the WSS logs, but I didn't see anything of use there.
Go to 'Central Administration' -> 'Operations' -> 'Diagnostic Logging' -> 'Event Throttling' , then select 'Business Data' in the dropdown list, select 'None' or 'Error' or any event you want to report to event long, select 'None', 'Verbose' or any event you want to report to trace log; click OK to finalize the selection.
You can use the dropdown list to select other objects to report, but you have to make sure that you click 'OK' each time to finalize the change.
You can also customize the location where you want to keep the trace log. The default location is in "C:\program files\......"