Tracker Capture feature has not appear program

Dear @LCaynar,
The issue you are facing here seems to be a different one than I expected.

The above is is just log noise, and can be ignored.

This is a real issue. A table, likely the programstageinstance table, does not have the column “geometry”. It should have been created automatically if missing - and since its not it might indicate that your database does not have Postgis enabled. Can you shut down your application server, then log onto the database and run “CREATE EXTENSION POSTGIS;” - then start the database again?

Best regards,
Markus

1 Like

Dear @Markus,

I logged in my database and then run “CREATE EXTENSION POSTGIS” on query. The message showed “ERROR: could not open extension control file “C:/POSTGR~1/pg10/…/pg10/share/postgresql/extension/postgis.control”: No such file or directory”

1 Like

Dear @LCaynar,
there seems to be a problem with your postgres or postgis installation.
https://postgis.net/install/
Try googling the error message and or reinstalling postgres and postgis.

best regards,
Markus

1 Like

Dear @Markus,

I got your point. I will update you when I resolve it.

Anyway thanks for your prompt supporting. This community is very useful.

Best Regards,
Aynar

1 Like

Dear @LCaynar,
try reinstalling with version 10.6 from here: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
After installing Postgres with this package, you can start a program included called stackbuilder, and this lets you select and install PostGis from “Spatial extensions”.

1 Like

Dear @Markus,

I would like to express deeply thanks for your supporting.

Best Regards,
Aynar

2 Likes

After you get PostGis up and running, you have to follow the steps in this thread to make sure tomcat uses the correct encoding when serving DHIS2:

2 Likes

Dear @Markus,

I am pleased to let you know that I had resolved this issue. Thank.

In addition, I expect that I will face with GIS. The reason that I found missing file dhis-google-auth.json. Any advice to resolve this issue.

Best Regards,
Aynar

1 Like