Bahmni Dhis 2 Integration Error.

dmukungi · September 29, 2020, 5:51am

After following the steps outlined https://bahmni.atlassian.net/wiki/spaces/BAH/pages/116694133/Bahmni±+DHIS2+Integration I’m getting the following errors in my bahmni 0.92 instance. Any help on this @buvaneswariarun @pratibhasagar

Here is my error log

khobatha · January 25, 2021, 3:36am

Hello David,

Sorry I don’t have the solution - I am just glad to see that you managed to install the module in a 0.92 vagrant-based Bahmni instance. Which installation guide are you using? I am following this one and I am not succeding. The installation package is not openable and yum complains that it’s not a valid rpm.

Did you end up finding a solution to the errors?

Best regards

Khobatha Setetemela National University of Lesotho

dmukungi · January 28, 2021, 6:21pm

Hello @khobatha

Yes i was able to set up the module. I also noticed there is an issue with the installation package but you can sort that out by building the package from this link and then follow these steps.

khobatha · January 28, 2021, 7:13pm

Hello @dmukungi

Thank you much for the response - highly appreciated.

I eventually managed to install the package by building it from scratch.

I then followed the configuration steps on the link you shared.

However, when I attempt to load the module, it fails with a “Down for maintenance” error message. I have restarted the service several times and checked my configuration settings multiple times to no avail. I even removed the package and re-installed and re-configured but it still doesn’t load the module home page as I see it did for you.

I am attaching (please see below) the following screenshot for your information:

Maintenance error screen
dhis-integration.yml
extension.json

May I kindly ask you to show me your similar settings?

dmukungi · January 29, 2021, 5:24am

@khobatha

Please share the complete error log in “cd /var/log/dhis-integration”. Also, Please check the path to your repors url (In your dhis-intergration.yml) again you might have missed something on that.

Other considerations:

Make sure that you have the “dhis-integration.jar” and not “dhis-integration-1.0-SNAPSHOT.jar” in your " /opt/dhis-integration/bin/" folder. For some reasons it doesn’t work with the Snapshot.
Make sure that you are using a secure URL to access the dhis2-module. i.e a valid ssl.

Let me know also if you have already created the root folders i.e “/dhis-integration-data” and “/dhis-integration/”

Thanks.

khobatha · January 29, 2021, 10:44am

Hello @dmukungi

Thanks again.

I have done as your advised but I am still not succeeding. Infact, I autoremoved the package and started everything from scratch but it still lands at the same problem (maintenance page).

I am sorry to overwhelm you with many screenshots. Please see a picture of my configuration in the attached screenshots:

I have confirmed that I have a “dhis-integration.jar” in the bin folder
I am using secure URLs to access the dhis2-module
I have attempted to make sure my settings in the .yml file are correct
I have checked the httpd server log files and they suggest that the service is not available (please see attached screenshot)

I am not sure what I am missing.

NB: -My instance is in vagrant -I am using Bahmni v0.92 -The host OS is Ubuntu 18.04

Thank you in advance.

khobatha · February 1, 2021, 9:39am

@dmukungi:

I hope you are well.

Did you have to manually deploy the dhis-integration webapp in the root folder (/dhis-integration) or it was automatically deployed during installation? That is, copy the web page files into the folder? I manually copied the web pages from the repo into the root folder and this way, the service’s web UI loads successfully (see screenshot below) but quickly logs out with a “not authenticated” error message.
I am testing the service on a local instance that lacks a valid ssl certificate. However, all the URLs I am using to access the external DHIS2 server are https. Do you think this could be part of the problem?

Kind regards

khobatha · February 5, 2021, 1:56am

Hello @amolsatvix @akhilmalhotra1 @ajeenckya

May I kindly request your comment on this?

Thank you in advance.

Khobatha

National University of Lesotho (NUL)

angshuonline · February 5, 2021, 7:23am

@khobatha if you are using the Possible addon, maybe @sanjayap or @laxman would be better to answer this. I think @amolsatvix has also used the same.

khobatha · February 5, 2021, 2:11pm

@angshuonline Thank you.

@amolsatvix - please see below as you advised:

I am including the DHIS2 log as well for reference

laxman · February 18, 2021, 11:15am

I think this may be due to lack of privilege, user should have appropriate privilege set. @utsavdeshar can suggest you more on this.

khobatha · February 19, 2021, 1:13pm

Hello @dmukungi - how did you get past this error? I am struggling to resolve it.

Thank you in advance.

gsluthra · February 22, 2021, 10:52am

I haven’t setup this module myself, but looking at your httpd logs, it seems your use of “localhost.localdomain” aren’t being resolved correctly. Maybe you can change the dhis-integration.yml configs to use “192.168.33.53” (your local machine IP) to try.

Please check the urls mentioned in dhis-integration.yml are all actually accessible from the machine running this service (maybe use curl, or telnet, etc to validate).

dmukungi · February 22, 2021, 12:10pm

@khobatha you may need to use a secure domain name to send the data to your dhis2-instance. Please make sure that both the server and your instance are secured.

Also please share the content on the dhis-integration.yml (hide the passwords).

khobatha · February 23, 2021, 5:04am

@dmukungi @gsluthra Thank you. Highly appreciate your help.

Update:

Both the DHIS2 server and my instance are secured. The server uses a standard ssl certificate and my instance uses a self-signed certificate.
The domain resolution issues were addressed. Plugin is now able to make connection to Bahmni services.

I have attached the following for your reference:

screenshot showing nature of the error ( MissingFormatArgumentException: looks exactly like what you once reported here)
dhis-integration.yml
dhis.log

NB: It seems like a formatting issue to me. Makes me think it has something to do with the incompatibility of calendars. My local instance is using the standard Gregorian calendar and the dhis-integration plugin is pre-built to use the Nepali calendar.

Thank you in advance.

gsluthra · February 23, 2021, 1:10pm

In your case there is some DB exception that is occuring, but the code is throwing a String.format( ) %s exception on this line (DatabaseDriver.java: 112):

github.com

Possiblehealth/dhis2-integration/blob/d0d201c1963a59e5fa3aa2d0f079edb2bce7b945/src/main/java/com/possible/dhis2int/db/DatabaseDriver.java#L112


      
          			ps.setInt(3, year);
          			resultSet = ps.executeQuery();
          			JSONObject jsonObject = new JSONObject();
          			while (resultSet.next()) {
          				jsonObject.put("status", resultSet.getString(5));
          				jsonObject.put("comment", resultSet.getString(6));
          				jsonObject.put("response", resultSet.getString(7));
          			}
          			log = jsonObject.toString(INDENT_FACTOR);
          		} catch (SQLException e) {
          			throw new DHISIntegratorException(String.format(Messages.SQL_EXECUTION_EXCEPTION), e);
          		} catch (JSONException e) {
          			throw new DHISIntegratorException(String.format(Messages.SQL_EXECUTION_EXCEPTION), e);
          		} finally {
          			if (connection != null) {
          				try {
          					connection.close();
          				} catch (SQLException ignored) {
          				}
          			}
          		}

If you see this line, the code on it is incorrect - because the format method bracket has been closed before the exception string was passed, and therefore format() method is throwing an error:

throw new DHISIntegratorException(String.format(Messages.SQL_EXECUTION_EXCEPTION), e);

This exception will get thrown (format error) ANY TIME someone has a DB exception, and the original exception won’t be visible.

I would request you to modify this line of code with this:

e.printStackTrace();
throw new DHISIntegratorException ("DB Exception occurred "+ e.getMessage(), e);

Rebuild the jar, and redeploy. Then you should be able to see the DB exception which is actually being caused.

Note: I think Possible team should also fix this minor bug because it will help people in future in debugging the issue when a DB exception arises. This error exists in next line of code also. Wherever String.format has been called with %s without a supporting parameter.

See: Java String format() method - javatpoint

khobatha · March 1, 2021, 4:33am

@gsluthra - Thank you very much. I tried your fix and it worked like magic! The Missing FormatArgumentException was resolved.

khobatha · March 2, 2021, 4:07am

May I kindly request help with the following?

Background:

I have configured the Bahmni-DHIS2 plugin on a local vagrant based instance on a windows host (Kindly see attached application.yml file)
I have configured the plugin to load the test Bahmni programs reports that I would like to sync to DHIS2

Issues:

According to this installation link, I expect the Bahmni-DHIS2 UI to display a “Submit to DHIS” button for each of the programs to be mapped
However, this is not the case with my installation (Kindly see attached screenshot)
The logfile shows no noticeable issues, the plugin loads well and waits in the “getQueryLog”

@dmukungi @gsluthra @laxman

laxman · March 4, 2021, 9:03am

Hi, This may be due to privilege issue, can you check with right privilege for reporting?

khobatha · March 4, 2021, 10:56am

Hi @laxman - Thank you. I just checked: I am using a “superman” account with the following privileges. I still can’t commit anything to DHIS2 and the log file does not show any error messages.

Screenshot (19)