DHIS2 2.37 - Cannot see data in Data Visualizer

Hi,

In Data Entry app, I select organization unit, period and enter data. But I cannot see my data in Data Visualizer app. Any additional steps needed? Please advise any documentation or resource so I can try.

Thank you.

Hi

You might want to clear the browser cache first by using the Browser Cache Cleaner app, and it is necessary that the user you are using has the “Data output and analytic” authority to that OU. Please check the user’s settings in the user app.

If you still can’t see the data, please take a screenshot if there’s an error. Open your browser’s developer tools F12 → Select Network tab → if there is a red text, click on it → Screenshot :blush:

Thanks!

I finish this steps.

Buy I cannot see any error, it show nothing in Data Visualizer app when I select data elements, OU and periods.

Thanks.

Hi,
This may not be the case, but remember that data only appears in the visualizer/elsewhere AFTER the analytics table is run, and that is usually at midnight each evening.
You cannot see data in reports or visualizer immediately.
Norah

1 Like

Hi,

May I review my steps, I can see the ’ 2022-02-16 10:32:26 Process failed: Exception during execution’ at the end of execution, where to check what is the error.

In Data Entry app, I select OU, Data Set, Period and enter some data, click Complete

Click here to see error log

In Data Administration app, click Analytics tables update, uncheck all ‘Skip*’ checkboxes, click ‘Start export’

2022-02-16 10:32:19 Analytics table update process started
2022-02-16 10:32:19 Updating resource tables
2022-02-16 10:32:26 Updating tables: DATA_VALUE
2022-02-16 10:32:26 Performing pre-create table work
2022-02-16 10:32:26 Dropping temp tables
2022-02-16 10:32:26 Creating analytics tables
2022-02-16 10:32:26 Populating analytics tables
2022-02-16 10:32:26 Process failed: Exception during execution

Thank you very much.

Thanks @Norah_Stoops!

@nuttapol, would you please take a screenshot of the error log that appear in the Network tab. Before clicking on the button ‘Start Export’ open your browser’s developer tools’ (F12 → Click on Network → For every red line, click on it and then take a screenshot.) We might also even need the Catalina.out log (without the sensitive info) to understand the issue.

Thank you!

Thanks @Norah_Stoops!

Hi @Gassim,

I can see this error attached:

Catalina.out log is located in tomcat\logs folder, filename is catalina-yyyy-mm-dd.log, is that correct?

Thank you.

Hi
@nuttapol , yes for that issue we need the Catalina.out log, thanks!

From Installation docs:

To monitor the behavior of Tomcat the log is the primary source of information. The log can be viewed with the following command:
tail -f tomcat-dhis/logs/catalina.out

It is the file with the extension .out

You’re welcome! (:

1 Like

Hi @Gassim,

Please kindly find part of the catalina.out yesterday (2022-02-17)

catalina.out.2022-02-17.doc (143.7 KB)

It shown about user expiry date and sql grammar error.

Please advise.

Thank you!

Hi @nuttapol,

Thank you for sharing this info! For the SQL error, it has to do with this bug: DHIS2-12210 | Large continuous analytics temporary tables fill the disk space OR this one: DHIS2-12277 | DHIS2 Can’t finish the analytic in version 2.37.1

What release of version dhis2 2.37 are you using? You might be required to update to the latest release

For now, it might help if you have access to the database to drop the table causing this issue and then run analytics tables again:
DROP TABLE analytics_temp_2021;

Hi @Gassim

I test in another computer, DHIS2 version 2.36.6, enter some data.

Note: 2564 and 2565 displayed as year in Thai (I don’t know why not display 2021 and 2022) but in database is 2021 and 2022.

Data Administration > Analytics tables management, click START EXPORT, looks like no error.

When I open the Pivot Table, select data, period (last 12 months), and organization unit, I see no data.

Could I have your advice please if I do something wrong or need any additional action.

Thank you very much.

Thanks for sharing this! For this one would you like to create a jira bug issue in jira.dhis2.org? (I can create one on your behalf if you want.)

Okay, thanks! Are you able to see any error in the Network tab after you click Update? Please open the Network tab then click update and if you see any error there, please take a screenshot.

Thank you again!

A post was split to a new topic: Any additional steps when installing WHO package-COVID Vaccine?

Had to move the post because it is not a continuation of the debugging of the previous issue. Thank you!

Created a Jira Issue for this one: DHIS2-12701 | In Thai calendar: Period not showing properly

It would help a lot if you take a screenshot of the Network tab after you click Update. Thank you!

Hi @Gassim

Please kindly find attached Network tab screenshot after click Update.


Thank you!

It’s interesting you can’t see any update, could you make sure of the following two settings:

  1. The user you are using has ’ Data output and analytic organisation units’ approved for the OUs you are selecting (User Management app)
  2. The metadata has sharing settings is at least ‘can view data’ for the user

I also want to ask if you tried this because you had an error in your Catalina.out log because of the analytics_temp_2021.

Thank you (: