No identity type corresponds to Decimal

I have a bunch of Oracle views that are defined with an ID column like this:

 (1+ABS(MOD(dbms_random.random,100000))) as Id

When trying to update the database through the designer I get the following error. This used to work in LS 2.2. Any ideas on what might be going on and how we could fix it?

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.ViewBuilder.AddViewsToModel(Model model, Provider provider, IEnumerable`1 viewNames, IGenerationLog log)

at Mindscape.LightSpeed.Generator.Integration.ViewBuilder.AddViewsToModel(Model model, ILightSpeedDataSource connection, IEnumerable`1 viewNames, 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)

I believe this is fixed in the current nightly builds -- try installing the latest nightly and let us know if you still see the problem.

I did try out the latest nightly build yesterday, but was getting an error also. Slightly different, though..... See below. (FYI. You're right that the Decimal issue appears to have gone away)

The Id is setup like this:

SYS_GUID() as Id

and I get this exception when dragging to the designer.

Exception while processing Server Explorer drag: System.ArgumentException: No identity type corresponds to Blob
Parameter name: generatorType
   at Mindscape.LightSpeed.Generator.Integration.Dsl.Differencing.Utils.ExtractionTypeUtils.GetIdentityType(ModelDataType generatorType, IGenerationLog log)
   at Mindscape.LightSpeed.Generator.Integration.EntityConverter.CopyIdentityType(EntityModel generatorEntity, Entity entity)
   at Mindscape.LightSpeed.Generator.Integration.EntityConverter.PopulateEntities()
   at Mindscape.LightSpeed.Generator.Integration.ViewBuilder.AddViewsToModel(Model model, Provider provider, IEnumerable`1 viewNames, IGenerationLog log)
   at Mindscape.LightSpeed.Generator.Integration.ViewBuilder.AddViewsToModel(Model model, ILightSpeedDataSource connection, IEnumerable`1 viewNames, 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)

Could you post the CREATE TABLE statement for the table in question please?  Thanks!

I changed up the column and table names, but can email you the actual script if you need it. It's a view that returns SYS_GUID() as the id. I've tried setting the entity's identity type property to both guid and string, but get the same error.

create or replace view alpha_v2 as
select SYS_GUID() as Id,
       betaid     ,
       gammaid        ,
       theta          ,
       omegaalpha
from
(
  select
        scu.betaid,
        su.gammaid   ,
        sr.theta     ,
        min(sp.omega) as omegaalpha
  from gamma_v su
  join betagammazeta_v scu
  on   scu.gammaId = su.gammaID
  join
  (
    select Id
    from psi_zeta nu
    union all
    select Id
    from psi_zeta nu
    where Id in
    (
       select deltazetaId
       from psi_zeta
    )
  ) q
  on q.id = scu.zetaID
  join psi_alpha sp
  on   sp.zetaid = q.id
  join psi_epsilon sr
  on   sr.id = sp.epsilonid
  zeta by su.gammaid, betaid, sr.theta
)

Thanks, that's great.  Unfortunately I'm out of the office today and don't have an Oracle database to investigate this, but I'll try to get to it on Monday.

No problem. Thx!

I have located a couple of issues, one with designer handling of IDs of type RAW and one with materialising GUIDs from RAW database columns.  I have committed fixes for these and they will be included in the 4 May nightly build.

Note that LightSpeed still doesn't know what to do with a "blob" ID (and we can't recognise that the "blob" in your case came from the SYS_GUID function and should therefore be mapped to a Guid).  So you will still get a warning when you drag the view on, and LightSpeed will default the identity type to Int32 rather than Guid.  However, if you manually change the identity type to Guid after dragging on the view, then it should work fine.

Please let us know if you still see problems.