Hi,
I'm trying to work with the AdventureWorks sample database SQL 2005
version and BDC in MOSS 2007. The application is correctly defined in
MOSS, using the sample XML application definition file for
AdventureWorks SQL2000 version. When I try to retrieve data from the
web part, I get an error message stating "An error occurred while
retrieving data from AdventureWorksSQL2005. Administrators, see the
server log for more information". First question - Which server log
(MOSS, SQL, others)
Also, in the Event Viewer of the server, I found this entry:
Could not run query/stored proceedure 'SELECT ProductID, Name,
ProductNumber, ListPrice FROM Product WHERE (ProductID >=
@MinProductID) AND (ProductID <= @MaxProductID) AND (Name LIKE @Name)
AND (ProductNumber LIKE @ProductNumber)' using 'Data
Source=OFFICE2007;Initial Catalog=AdventureWorks;Integrated
Security=SSPI;Pooling=false;Persist Security Info=false;' in App
Domain '/LM/W3SVC/858119008/Root-1-128152197026259408'. The full
exception text is: Invalid object name 'Product'.
It seems to me that one or many elements of the SQL2005 version of the
AdventureWorks database is not similar to the SQL2000 version, from
which the sample XML application file has been based on.
Anyone has similar problem
Thanks in advance
BDC and AdventureWorks SQL 2005 Version
swingme
How can I get the AdventureWorksDWSQL2005.xml from MSDN I tried searching for it on google but had no luck.
Thanks
Robert
71M
It is in "Microsoft Office SharePoint Server 2007 SDK" . The file should be OSS2007SDK.EXE
There may also be other sources where the AdventureWorksDWSQL2005.xml resides as I have multiple copies on my machine and I don't remember where I got it. It may also be named AdventureWorksDW2005.xml
Jassim Rahma
1. Regarding where to look for error message, please check out my response at 'When BDC Webpart reports error, what log should we look at '
2. It looks like you are trying to use Definition file for SQL 2000 version of AdventureWorks on a SQL 2005 AdventureWorks database. Their schema are different therefore the error. The database on SQL 2005 I used is called 'AdventureWorksDW' and the Definition file I used is called 'AdventureWorksDWSQL2005.xml'. You need to get these two files from MSDN. There is a file that I downloaded that includes 'AdventureWorks2000', 'AdventureWorksDWSQL2005', 'AmazonWebService', 'Pubs' and 'BDCAWDW'. They proved to be very helpful in understanding how Definition file works but I think Microsoft should have done a better job in providing documentation. From this forum I can see many people are suffering for lack of information, including myself.
OPH
The SDK documentation is a bit disjointed and the sample is for the AdventureWorksDW (Dataware house sample database).
If you look at your SQL installation you will have tables like "Production.Product". Two options work against the AdventureWorks2005DW sample db or create a new BDC definition for the AdventureWorks 2005 database. BDCMetaMan will help here (although you need the licensed product to do the associations).
Andrew