Query Execution Error in Pulse Browser for VMware Tanzu GemFire 9.10.4 and above

Products

• VMware Tanzu Gemfire

Issue/Introduction

The following Query Execution error is noticed in the Pulse Browser for VMware Tanzu GemFire versions 9.10.4 and above:

Query could not be executed due to - javautilServiceConfigurationError- comfasterxmljacksondatabindModule- Provider comfasterxmljacksondatatypejodaJodaModule not found

Resolution

This error is due to a dependency issue caused by the product fix GEODE-8447. To be specific, If you have java.time.* types like LocalDateTime, LocalDate, and LocalTime in the query result fields, then you will need to have the jackson-datatype-jsr310 in the runtime classpath to have the proper formatting.

Please note that we don’t ship jackson-datatype-jsr310 because Geode doesn't use java.time.* data types. Therefore, you need to manually add jackson-datatype-jsr310 in the runtime classpath.

Note: If you have Joda DateTime fields, then you also need to include the following dependencies at the runtime:

'com.fasterxml.jackson.datatype:jackson-datatype-joda'
'joda-time:joda-time'