Data Visualization error "Could not extract ResultSet"

Support - Assistance technique
1

Hello community,
I am running 2.40.0.1. I get this error when I try to save a pivot table in data visualization.

image
image1195×504 16.2 KB

image
image934×586 13 KB

Below is the log output on the server:

WARN  2023-07-21T09:32:57,236 Monitoring request failed, status code: null (DefaultMonitoringService.java [taskScheduler-14])
org.springframework.web.client.HttpClientErrorException$Conflict: 409 Conflict: "{"status":"ERROR","httpStatus":"CONFLICT","httpStatusCode":409,"statusCode":409,"message":"System identifier must be specified"}"
	at org.springframework.web.client.HttpClientErrorException.create(HttpClientErrorException.java:125) ~[spring-web-5.3.25.jar:5.3.25]
	at org.springframework.web.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:168) ~[spring-web-5.3.25.jar:5.3.25]
	at org.springframework.web.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:122) ~[spring-web-5.3.25.jar:5.3.25]
	at org.springframework.web.client.ResponseErrorHandler.handleError(ResponseErrorHandler.java:63) ~[spring-web-5.3.25.jar:5.3.25]
	at org.springframework.web.client.RestTemplate.handleResponse(RestTemplate.java:825) ~[spring-web-5.3.25.jar:5.3.25]
	at org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:783) ~[spring-web-5.3.25.jar:5.3.25]
	at org.springframework.web.client.RestTemplate.execute(RestTemplate.java:717) ~[spring-web-5.3.25.jar:5.3.25]
	at org.springframework.web.client.RestTemplate.postForEntity(RestTemplate.java:474) ~[spring-web-5.3.25.jar:5.3.25]
	at org.hisp.dhis.dxf2.monitoring.DefaultMonitoringService.pushMonitoringInfo(DefaultMonitoringService.java:136) ~[dhis-service-dxf2-2.40.0.1.jar:?]
	at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) [spring-context-5.3.25.jar:5.3.25]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305) [?:?]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305) [?:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
	at java.lang.Thread.run(Thread.java:829) [?:?]

What could be the issue?

  • Andrew
2

Hi @Andrew_Kabala

This message is related to the server configuration. There could be network issues or maybe the configuration. In this case, it’s probably important to know more about the system configuration. One thing to try is to clear server cache and run maintenance using the Data Administration app → Maintenance → clear Application cache and reload apps. After that please check again using the Guest mode in your browser ( Browse Chrome as a guest - Computer - Google Chrome Help).

Finally, if that doesn’t solve the issue, is it possible we get the complete catalina.out log (without sensitive info)?

Thanks!

3

Hi @Gassim,
The solution was to create a dummy dataset with dummy data (for only one dummy data element) for all future time periods, i.e., if the period was weekly, I would create weekly dummy data for all 52 weeks. This fixed the error.

Regards,
Andrew

1 Like
5

Hi All,
Just a note for others experiencing this - I’ve noted that if you don’t have analytics period boundaries in a Program Indicator you will get this error in the newer versions of data visualizer. Adding an analytics period boundary will resolve the issue.

https://dhis2.atlassian.net/browse/DHIS2-16180

1 Like