Hello Support,
We noticed that our analytics jobs have been failing for about 5 days now from the system message.
Here are the logs below.
Aggregate data analytics are not affected but event reports no longer run.
Could you kindly assist with this?
We are currently on 2.36.0 but migrated only this morning from 2.33.8.
Here is the file with the logs from the system:
analytics failure log 16JUN2021.docx (20.7 KB)
Thank you.
Ifeanyi
Hi @ifeanyiokoye,
How are you? Thank you for uploading the docx, and it’s always better if you copy the title:
**Message: Exception during execution Cause: java.util.concurrent.ExecutionException: org.springframework.dao.DataIntegrityViolationException: StatementCallback;**
as well as search for the Error message:
**ERROR: invalid input syntax for type bigint: "1.5"; nested exception is org.postgresql.util.PSQLException: ERROR: invalid input syntax for type bigint: "1.5"**
Would you like to create a bug issue in jira.dhis2.org ?