Forum Stats

  • 3,872,818 Users
  • 2,266,479 Discussions
  • 7,911,329 Comments

Discussions

not a group by

Cezary-Oracle
Cezary-Oracle Member Posts: 158
edited Apr 29, 2016 5:25AM in Discoverer

Hi,

Discoverer 11.

We have some discoverer reports which run perfectly for some users and for others we get exception

"not a group by" exception.

We examined generated SQL and for some user it is wrong.

It has addtiional elements.

Correct version:

FROM STATYSTYKI.STAT_JEDN_ORG_MV o100238,

      ZSIP.ZSIP_V_PODZIAL_ADM_DSC o100326,

      ZSIP.ZSIP_V_SEWIK_DANE_ZDARZ_DSC o115503,

      ZSIP.ZSIP_V_SEWIK_UCZESTNICY_DSC o115512

Wrong version:

FROM STATYSTYKI.STAT_JEDN_ORG_MV o100238,

      ZSIP.ZSIP_V_PODZIAL_ADM_DSC o100326,

      ZSIP.ZSIP_V_SEWIK_DANE_ZDARZ_DSC o115503,

      ZSIP.ZSIP_V_SEWIK_UCZESTNICY_DSC o115512,

    ( SELECT o100238.KWP_BIURA AS as101173_102632_OLD_2, MAX(o100238.SORTOWANIE) AS as101173_102632_OLD FROM STATYSTYKI.STAT_JEDN_ORG_MV o100238  GROUP BY o100238.KWP_BIURA)

We don't do any changes. We are just logged on diffrent user.

How is it possible ?

Regards,

Cezary

This discussion has been closed.