JDBC storage plugin failed because query had errors

1

JDBC storage plugin failed because query had errors. I was too quick to post and deleted it.

2

@h4nneke, does that mean the query is working now?

3

No unfortunaty i got the JDBC error again. It happens when I try to aggregate the outcome of a window aggregation in another window aggregation.

4

This is an example:

select min (RANK_PER_DAG) OVER (PARTITION BY STUDENTNUMMER,OPLEIDING,COLLEGEJAAR ORDER BY HSIH_ID DESC) RANK_OVERALL
from
(select STUDENTNUMMER,OPLEIDING,COLLEGEJAAR,MUTATIE_DATUM,HSIH_ID, RANK () OVER (PARTITION BY STUDENTNUMMER,OPLEIDING,COLLEGEJAAR,MUTATIE_DATUM ORDER BY HSIH_ID DESC) RANK_PER_DAG
from ost_h_s_inschrijfhist where collegejaar>2017)