Column not being imported into Lightspeed

Hello -

I am using Lightspeed 4 to connect to an Oracle database that I have no control over. Programming in .NET 4.0 using C#.

There are 3 tables containing the same field, called EPLANT_ID. It's not a foreign key of any kind, it's an integer that helps the wizards that wrote the management app distinguish between parts and orders for one Enterprise Plant (eplant) from those associated with another, all stored in the same database. Like I said, I have no control over the app or the database.

The RMA table has the EPLANTID field, and LS imports it as EplantId. The Orders table has the EPLANTID field, and LS imports it as EplantId. The ARINVT table (don't ask) has the EPLANT_ID field, and LS imports nothing. Totally ignores it.

I am attaching the model for your perusal, but I'm not sure how much good it will do you. Please advise how I can get the field to show up in all 3 tables of interest, so I can keep the good folks at our plant in England, where we are deploying this next month, from messing with the wrong stuff. And vice versa, of course. :)

Thanks! Dave Newman

If you manually add a column for this (setting the column name to EPLANT_ID) does that solve things? And assuming it does, does it show up in the dialog as a difference when re-syncing with the database?

It sounds like for some reason the column is not being picked up when we query the schema for columns for that table. Is it possible for you to post a create table statement for that table and one of the ones which it does correctly pick up the column from?

Jeremy

I got part of this done today in between fires, I should be able to get more done tomorrow. Thanks for the response!

Dave

Jeremy -

Below are responses to your requests, thank you!

If you manually add a column for this (setting the column name to EPLANT_ID) does that solve things? Yes, it seems to work now

And assuming it does, does it show up in the dialog as a difference when re-syncing with the database? No it does not, it seems to be happy with the manually added column

It sounds like for some reason the column is not being picked up when we query the schema for columns for that table. Is it possible for you to post a create table statement for that table and one of the ones which it does correctly pick up the column from? Yes, see attached

Any word on this yet? I'm uncomfortable running a LS model with manually-entered code changes...

Thanks, Dave

Hi Dave,

Could you re-upload the Order table script? It appears to be for the ARINVT table (the scripts are identical between the two zip files).

Thanks!
Jeremy

Sorry for the delay. I somehow got the idea I had already done this...

Jeremy, can you have a look at this? I really don't like manually editing the model.cs file, every time I move an arrow 2 pixels I have to manually add those same changes again...

Thanks, Dave

Hi Dave,

Sorry for the delay, I have been away from the office for a couple of days. I have had a look into this today but I currently cannot reproduce this locally based on that schema you provided, all columns are being picked up correctly for me when I add those tables.

Unfortunately without being able to reproduce this locally I cannot really do much more as we rely on the information being provided by the Oracle provider to determine the columns that are present and it appears for some unknown reason for you its missing that one column on that particular table but for me when using the same schema its not. If there is anything else you can provide which might be able to help in reproducing this please send it through.

To help with the on-going workaround, I would suggest you add the field/property definition to a partial class to avoid running into the code generation issue you mentioned above.

Jeremy