The ETL process throws errors and analytics does not work as expected. Several errors can be found in the logs, one of which is ORA-00933.
ETL runs and sends this query to Oracle:
SELECT id, name, status, filename, creation_ts
ORDER BY creation_ts DESC LIMIT ?
Which throws this error:
2019-01-29 09:25:11,325 [http-nio-127.0.0.1-9001-exec-10] [1:admin:REGULAR] ERROR com.jivesoftware.community.analytics.action.SetupAnalyticsAction - Exception retrieving csv reports: PreparedStatementCallback; bad SQL grammar [SELECT id, name, status, filename, creation_ts FROM jivedw_reportscsv ORDER BY creation_ts DESC LIMIT ?]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
This article provides information on the resolution of the issue.
This section provides the affected environment, the root cause, and the related Jira tickets for this issue.
- Jive Hosted
- Jive On-Premise
The query that Jive sends uses a LIMIT clause that is not supported in Oracle.
Reference Jira tickets
This error has been resolved in Jive version 9.0.6.