[Discovery] Error when creating new snapshot (9.1.401.0 Java stack with MySQL)

[Discovery] Error when creating new snapshot (9.1.401.0 Java stack with MySQL)

  
Forge Component
(37)
Published on 19 Jun (7 days ago) by Francisco Menezes
37 votes
Published on 19 Jun (7 days ago) by Francisco Menezes
When creating new snapshot the following error occurs:

I've reinstalled Discovery after some problems.

Error in advanced query InsertModuleEffort in SnapShot_Create in SnapShot in DiscoveryProbe (INSERT INTO {ModuleEffort} ({ModuleEffort}.[SnapShotId],{ModuleEffort}.[ModuleDefId],{ModuleEffort}.[Effort])  select @SnapShotId ,moduledefid, SUM(hourtotal) effort   from   (  select instant, user_id, moduledefid, ops * 1.0 / sum(ops) over  (partition by user_id,@TruncateHourPrefix  instant @TruncateHourSuffix) hourtotal,   ops, sum(ops) over  (partition by user_id,@TruncateHourPrefix  instant @TruncateHourSuffix ) opsHour  from    (      SELECT [USER_ID],coalesce(esp.id,ext.id) moduledefid,COUNT(1) ops, @TruncateHourPrefix  [datetime] @TruncateHourSuffix   instant      FROM {Developer_Operation} op      LEFT JOIN {ModuleDef} esp ON esp.eSpaceId=op.ESPACE_ID      LEFT JOIN {ModuleDef} ext ON ext.ExtensionId=op.EXTENSION_ID            WHERE op.DATETIME    > @StartDate AND op.OPERATION_TYPE<5            group by USER_ID, coalesce(esp.id,ext.id),@TruncateHourPrefix  [datetime] @TruncateHourSuffix     ) t  ) t2  group by moduledefid    ): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(partition by user_id,trunc(  instant ,'HH')) hourtotal,   ops, sum(ops) over  (' at line 1
Never mind. Discovery is still not suitable for MySQL. There is an old thread of Martijn Habraken with a possible fix. I am going to get an OML from that thread...
Hi Peter,

In fact Discovery has only been developped and tested for Oracle and SQL :(