[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
(36)
Published on 3 Aug by Francisco Menezes
36 votes
Published on 3 Aug 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 :(