Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

aodn_imas_fluormetry can't run on an empty schema #732

Open
jonescc opened this issue May 21, 2019 · 0 comments
Open

aodn_imas_fluormetry can't run on an empty schema #732

jonescc opened this issue May 21, 2019 · 0 comments

Comments

@jonescc
Copy link
Contributor

jonescc commented May 21, 2019

Get the following exception

Exception in component tPostgresqlInput_1
org.postgresql.util.PSQLException: ERROR: column "i.url" must appear in the GROUP BY clause or be used in an aggregate function
  Position: 273
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
        at aodn_imas_fluorometry.harvestfile_0_1.HarvestFile.tPostgresqlInput_1Process(HarvestFile.java:5690)
        at aodn_imas_fluorometry.harvestfile_0_1.HarvestFile.iNetCDFGlobalAttributes_1Process(HarvestFile.java:5312)
        at aodn_imas_fluorometry.harvestfile_0_1.HarvestFile.iNetCDFInput_1Process(HarvestFile.java:4250)
        at aodn_imas_fluorometry.harvestfile_0_1.HarvestFile.tPostgresqlRow_2Process(HarvestFile.java:1055)
        at aodn_imas_fluorometry.harvestfile_0_1.HarvestFile.tPostgresqlConnection_1Process(HarvestFile.java:931)
        at aodn_imas_fluorometry.harvestfile_0_1.HarvestFile.iIncludeSdiLibraries_1Process(HarvestFile.java:813)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant