DHIS2 Community

Dhis2 30 fresh install error: "programstageinstance" not exist

Support - Assistance technique

linxd (晓东林) 10 September 2018 14:11 #1

hi,all

when I install a new fresh dhis2 ver 2.30, startup error:

Caused by: org.postgresql.util.PSQLException: ERROR: relation “programstageinstance” not exist

位置：22

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)

at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)

at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)

at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)

at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)

at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)

at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)

at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:327)

at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:461)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)

… 159 more

···

–
此致

林晓东

莫愁前路无知己，天下谁人不识君。

Lukas_Wijgaart-van_D (Lukas Wijgaart-van Dijk) 10 September 2018 14:25 #2

Hi,
This is a confirmed issue, you can track the progress here: https://jira.dhis2.org/browse/DHIS2-4464

Best regards,

Lukas Wijgaart van Dijk

···

sep. 2018 kl. 16.11 skrev 林晓东 lin_xd@126.com:

hi,all

when I install a new fresh dhis2 ver 2.30, startup error:

Caused by: org.postgresql.util.PSQLException: ERROR: relation “programstageinstance” not exist

位置：22

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)

at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)

at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)

at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)

at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)

at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)

at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)

at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:327)

at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:461)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)

… 159 more

–
此致

林晓东

莫愁前路无知己，天下谁人不识君。

Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

bobj (Bob Jolliffe) 10 September 2018 16:04 #3

I just made a quick comment on that issue.

The workaround is to to create the postgis extension manually in the
database and then restart the application server (tomcat), eg on
ubuntu:

echo "create extension if not exists postgis;" | sudo -u postgres psql dhis

···

On 10 September 2018 at 14:25, Lukas Wijgaart-van Dijk <lukasewvd@gmail.com> wrote:

Hi,
This is a confirmed issue, you can track the progress here:
https://jira.dhis2.org/browse/DHIS2-4464

Best regards,
Lukas Wijgaart van Dijk

10. sep. 2018 kl. 16.11 skrev 林晓东 <lin_xd@126.com>:

hi,all

when I install a new fresh dhis2 ver 2.30, startup error:

Caused by: org.postgresql.util.PSQLException: ERROR: relation
"programstageinstance" not exist
  位置：22
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
        at
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
        at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
        at
org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
        at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
        at
org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
        at
com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:327)
        at
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:461)
        at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)
        ... 159 more

--
此致

   林晓东

莫愁前路无知己，天下谁人不识君。

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp