Christian Sparre

So, I have created a new definition using the newly released Business Data Catalog Definition Editor, but it does not show up in the list when trying to add it to a Business Data list. It just says "There are no Business Data Types loaded in the Catalog".

I recived no errors when importing it and I have all the right permissions set up for it.

What could be causing this I have another definition file created with another tool, and that works just fine.

--

Christian



Re: SharePoint - Business Data Catalog There are no Business Data Types loaded in the Catalog in the Business Data type picker

Dagur

I get the exact same error! I have no idea why





Re: SharePoint - Business Data Catalog There are no Business Data Types loaded in the Catalog in the Business Data type picker

dev_rr

Looked through some previous errors of the same type that mentioned correcting permissions on Applications and Entities but that does not seem to be the case.

Import and export went smoothly but I'm still getting the same error:

There are no business Data Types in the Catalog.

Any ideas appreciated





Re: SharePoint - Business Data Catalog There are no Business Data Types loaded in the Catalog in the Business Data type picker

DaPhotoGuy

Same problem here. I'll let you know if I figure anything out.



Re: SharePoint - Business Data Catalog There are no Business Data Types loaded in the Catalog in the Business Data type picker

Nick Swan

I'm pretty sure this is because the Microsoft tool does not generate a Finder method for you, which is the method executed by the BDC List Web Part. Because none of your entities have this method, they do not show up to be selected.

Nick






Re: SharePoint - Business Data Catalog There are no Business Data Types loaded in the Catalog in the Business Data type picker

sparrez

That might be the case Nick, but I also seems that I have some troubles with permissions, anyway I have now successfully been able to add en entity to my list. Although I'm running into other problems now, more on that in another post later..

Thanks





Re: SharePoint - Business Data Catalog There are no Business Data Types loaded in the Catalog in the Business Data type picker

ragmeister

i still have the same problem (error: there are no business data types loaded in the catalog). still cannot figure it out. can you please let me know what did you do to be able to add an entity to a business data list

thanks a lot.





Re: SharePoint - Business Data Catalog There are no Business Data Types loaded in the Catalog in the Business Data type picker

Dagur

anyone figured this out yet





Re: SharePoint - Business Data Catalog There are no Business Data Types loaded in the Catalog in the Business Data type picker

sparrez

No, not really. But I have it working now using a Webservice, which was a part of a solution for a nother problem I seemed to face. The database that I needed data from have some chars in some of the fields. I does not use DbNull values in empty fields but another char. That char made SharePoint freak and throw exceptions at me, so I created a Webservice to filter out the faulty chars.

That's how I made it work for this specific solution, but a real fix would be nice.





Re: SharePoint - Business Data Catalog There are no Business Data Types loaded in the Catalog in the Business Data type picker

jcrowder

I've been playing around with this quite a bit and it looks like Nick is correct. The Microsoft tool does not generate the "Finder" method. It creates a "SpecificFinder" and the "IdEnumerator" methods only. If the Finder method is missing, the Business Data Type picker will not find BDC application.

In my case, I created the missing Finder method by doing the following:

  1. Create a new method.. rename "Method0" to something useful. Typically I name my SpecificFinder method something like "Find_XXX" and my Finder method "Find_XXXs"
  2. Change the RdbCommandText property of the new method to be the SQL Select statement that returns multiple records. Typically it's the same SQL Select statement you use for your SpecificFinder method but you don't include a Where clause.
  3. Create a new parameter (of type "Return") for the newly created method. Since the Tool already creates a Return parameter for the SpecificFinder, just copy these properties for your Finder method parameter.
  4. Create a new Method Instance. Choose "Finder" for the Method Instance Type, and choose the "Reader" (for me, it was the root node) as the Return TypeDescriptor.




Re: SharePoint - Business Data Catalog There are no Business Data Types loaded in the Catalog in the Business Data type picker

SteveLittlefair

This will work, but if you're having issues with creating application definition files why not just download BDC Meta Man

It has several advantages over the Microsoft tool, not least that it generates the Finder method for you...

I seriously recommend it, I've been using it for some time now, it's saved loads of time. Looks like it could've saved you guys the best part of a week too looking at this thread's start date...

Steve





Re: SharePoint - Business Data Catalog There are no Business Data Types loaded in the Catalog in the Business Data type picker

jcrowder

The problem I have with BDC Meta Man is that it's not free. The so-called "free developer version" seems to be just a really long trial. My version says it will expire in 118 days. Also, the developer version does not let you open application definition files, so you better be sure you get your settings right before you close the app! Also, the BDC Meta Man does not let you create "SQL String" methods, so you cannot create custom queries methods.

The Microsoft tool, while buggy, allows you to open application definition files, and seems to be pretty feature complete. Best of all, it's really free!





Re: SharePoint - Business Data Catalog There are no Business Data Types loaded in the Catalog in the Business Data type picker

Ron Grzywacz

I was running into this error, and then realized I had done something silly. I realized I had created two SSPs, and I was importing the BDC definition into the first SSP. All my web applications were being hosted by the second SSP.When I changed the web apps to run under SSP1, everything worked as expected.

I used the following article as a guide to learn the tool. (I'm not sure if you have to check both foreign key boxes. The directions say to do just one, but the picture shows two. It worked ok when I checked both)

http://msdn2.microsoft.com/en-us/library/bb736296.aspx





Re: SharePoint - Business Data Catalog There are no Business Data Types loaded in the Catalog in the Business Data type picker

DeChrist

I concur with Nick and jcrowder, that the BDC Definition Editor does not generate a "Finder" method for SQL based Business Data.

To be able to determine if you are running into exactly this problem (i.e. not another like a permissions problem) follow these steps:
1) Open the Windows Event Viewer
2) Select the "Application" category
3) Look for an Error of ID 5699
4) The details of this error should look like this:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Business Data
Event ID: 5699
Date: DD/MM/2007
Time: HH:MMTongue TiedS
User: N/A
Computer: [[SERVER-NAME]]
Description:
A Metadata Exception was constructed in App Domain '/LM/W3SVC/1899309449/Root-1-128350978947019294'. The full exception text is: MethodInstance could not be found using criteria 'MethodInstanceType=Finder'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

5) You can then apply the workaround suggested by jcrowder






Re: SharePoint - Business Data Catalog There are no Business Data Types loaded in the Catalog in the Business Data type picker

Michael Evanchik

im sorry, this hole thing is a nightmare. i have been programming for 10 years and im still lost. I just want to do select field from table and i have to go through all this entityes, instances, finders, I MEAN COME ONNN

what do microsoft employees smoke on a daily basis

Even after somehow getting an app def file to import

i still see

There are no Business Data Types loaded in the Catalog in the Business Data

FORMAT c: