This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi all people, first of all Happy 2010. Then my problem: I installed the new version of LightSpeed (3.0 free version), but when I tra to drag an Oracle (10g) table from the Server Explorer (C# VS2008) the Output displays this message:
Exception while processing Server Explorer drag: System.ArgumentException: No identity type corresponds to Decimal Parameter name: generatorType at Mindscape.LightSpeed.Generator.Integration.Dsl.Differencing.Utils.ExtractionTypeUtils.GetIdentityType(ModelDataType generatorType) at Mindscape.LightSpeed.Generator.Integration.EntityConverter.CopyIdentityType(EntityModel generatorEntity, Entity entity) at Mindscape.LightSpeed.Generator.Integration.EntityConverter.PopulateEntities() at Mindscape.LightSpeed.Generator.Integration.EntityBuilder.AddTablesToModel(Model model, ILightSpeedDataSource connection, IEnumerable`1 tableNames, IGenerationLog log) at Mindscape.LightSpeed.Generator.Integration.DiagramDragDropHandler.<>c__DisplayClass4.<OnDragDrop>b__3(DragObject dragObject, IGenerationLog log) at Mindscape.LightSpeed.Generator.Integration.ServerExplorer.IfIsServerExplorerDrag(DragEventArgs e, DragAction action) and the table isn't designed onto the model surface. Could you, please, explain me what happens and how to solve the problem? Thanks in advance for your help CreF |
|
|
Hi CreF, It looks like your identity column is set up with a non-zero scale, i.e. it is designed to accept fractional IDs rather than just integers. LightSpeed doesn't support fractional IDs. If you have control over the database and don't need fractional IDs, change the scale to 0 (or the data type to INTEGER). If you don't need fractional IDs, but can't change the database, let us know and we'll see if we can convert this to a warning instead. For the time being, however, you'll need to create the entity by hand (by dragging on an Entity object from the Toolbox). If you do need fractional IDs, unfortunately LightSpeed can't handle this at the moment. |
|
|
Hi Ivan, despite to different user id I'm still CreF. At least, the company I work for as internal solution developer (Swiss Life Funds AG in Switzerland) just purchased the commercial version of LightSpeed. So... First of all: the DB is a legacy DB. We don't have any chance to change the table settings. We can create tables, views, procedures, etc just only on the staging area schema of the DB, but unfortunately we can't do anything on the core schema. So we should need a solution to this problem... Thanks in advance for your help and effort Francesco |
|
|
Hi, Firstly I'm just glad I sell my software on a try before you buy basis. Anyhow I too have been picked on my dBs design with Identity Columns and choose to stick with the detault Martin Fowler KeyTable method. Seeing "We don't have any chance to change the table settings." any chance of a workaround with trigger to remedy the proble? |
|
|
I've updated the designer so that it will now treat Decimal identity columns as if they were Int32. The designer will issue a warning when performing this conversion. This change will be included in nightly builds dated 26 Feb 2010 and above, available from about 1500 GMT. Unfortunately, I don't have an Oracle database where I am at the moment, so I've not been able to verify the behaviour against a live database. I have committed the change anyway because it seems to be urgent for you, but you should treat the change as experimental. Please report any problems or errors. In particular, as previously noted, if your database is actually using the fractional part of the Decimal as part of the identity, you *will* run into problems. You don't say whether that's the case: if it is, let us know and we'll see what we can do. |
|
|
Hi Ivan, thanks for your effort. Sorry for the delay in answering, I've been tremendously busy... I'll try the solution and i'll let you know. Thanks in advance Francesco P.S. At the moment I have another "heavy" problem with LightSpeed... |
|