StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » Unable to Configure Business Object in Business Object Mapper

Unable to Configure Business Object in Business Object Mapper

Alan W — Mon, 10 Sep 2007 08:49:15 GMT

Using the DB2 Structure, I am unable to configure a business object using any of the tables in database. I consistently receive the following message:

Error: The fields could not be displayed.

Argument Exception:
Column SQL_DATETIME_SUB does not below to table DataTypes.

Source System.Data

Stack Trace:
at System.Data.DataColumnCollection.Remove(String name)
at IBM.Data.DB2.bn.c[String[]A-0]
at IBM.Data.DB2.bn.b[String A-0, String[]A-1]
at IBM.Data.DB2.DB2Connection.GetSchema(String collectionName, String restrictionValues)
at IBM.Data.DB2.DB2Connection.GetSchema(String collectionName)
at MicroFour.StrataFrame.AddIns.PartialClassBuilderDialog.GetFieldsFromDb2(String DatabaseString TableName, String ConnectionString)
at MicroFour.StrataFrame.AddIns.PartialClassBuilderDialog.BuildFieldsCollection(DTEproject_itemsBO,ProjectItem, Boolean SkipExceptions)
at MicroFour.StrataFrame.AddIns.PartialClassBuilderDialog.PopulateFieldsList(Int32 BOPK);

RE: Unable to Configure Business Object in Business Object Mapper

Trent L. Taylor — Mon, 10 Sep 2007 08:49:15 GMT

Thanks for the additional information, Alan. :) Glad you got it going!

RE: Unable to Configure Business Object in Business Object Mapper

Alan W — Mon, 10 Sep 2007 08:20:26 GMT

Hi All,

Our DBA working with IBM resolved this issue. The fix entailed a fix to IBM code. We can now successfully configure business objects for databases hosted on an IBM Mainframe running version 7.0 of the Db2 database. My thanks to everyone for their help.

AlanW

RE: Unable to Configure Business Object in Business Object Mapper

StrataFrame Team — Thu, 06 Sep 2007 09:12:20 GMT

In fact, when I tried Googling the issue, the only thing that Google returned was this forum post, which obviously wasn't all that helpful :D

RE: Unable to Configure Business Object in Business Object Mapper

StrataFrame Team — Thu, 06 Sep 2007 08:43:28 GMT

Good, because since the error was coming from the DB2 provider, I had no idea what to do other than let you choose a different provider. Glad it's working :)

RE: Unable to Configure Business Object in Business Object Mapper

Trent L. Taylor — Wed, 05 Sep 2007 13:19:18 GMT

Whew....glad to hear it :D

RE: Unable to Configure Business Object in Business Object Mapper

PeterA — Wed, 05 Sep 2007 12:11:48 GMT

[quote][b]Ben Chase (09/05/2007)[/b][hr]OK, I have a test project for you to run so we can maybe figure out why that is failing. It's failing within the DB2Connection.GetSchema() method (you'd think IBM would know how to get the schema from their own database...). So, run the project, click the button on the top to populate the top grid with the installed data providers on your computer, then select the row for the IBM.Data.DB2 provider (that will be the InvariantName), enter the connection string, and click Get Data Types. You should get an error message giving you the exception message that you're getting in the BOMapper.

Then, try the other IBM provider you have installed. Your client should have installed another one that will be a version specific provider, something like IBM.Data.DB2.9.1.2 or whatever zSeries, something. Select that one and repeat the process. If you get the same error, then I don't know what to tell you. If you don't get the error and it populates the grid below with the data types, then I'll have to create a way for you to specify the provider rather than always using the generic provider.

Let me know. Thanks.[/quote]

I gave Alan a hand on this earlier today and it turns out that the particular database that was being connected to was DB2 v7. It's scheduled to be upgraded, but hasn't been yet. I tried to connect to DB2 v8 and DB2 v9 from his machine and everything worked fine.

A Google search turned up that it was a data type that wasn't supported by DB2 UDB CLI. After a quick call to our database team, we learned that the database was v7 and that the data type wasn't supported by that version.

Bottom line is that the SF objects are working correctly as long as you try to connect to the correct version. :D We just weren't aware that there were still v7 databases out there anywhere.

Thanks for all the help!

RE: Unable to Configure Business Object in Business Object Mapper

StrataFrame Team — Wed, 05 Sep 2007 10:07:39 GMT

OK, I have a test project for you to run so we can maybe figure out why that is failing. It's failing within the DB2Connection.GetSchema() method (you'd think IBM would know how to get the schema from their own database...). So, run the project, click the button on the top to populate the top grid with the installed data providers on your computer, then select the row for the IBM.Data.DB2 provider (that will be the InvariantName), enter the connection string, and click Get Data Types. You should get an error message giving you the exception message that you're getting in the BOMapper.

Then, try the other IBM provider you have installed. Your client should have installed another one that will be a version specific provider, something like IBM.Data.DB2.9.1.2 or whatever zSeries, something. Select that one and repeat the process. If you get the same error, then I don't know what to tell you. If you don't get the error and it populates the grid below with the data types, then I'll have to create a way for you to specify the provider rather than always using the generic provider.

Let me know. Thanks.

RE: Unable to Configure Business Object in Business Object Mapper

Alan W — Tue, 04 Sep 2007 12:55:45 GMT

Hi,

Has there been any progress on this issue? This issue pretty much has me blocked from progress with StrataFrame.

Thanks,

AlanW