Overview 

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 
      FROM jivedw_reportscsv 
      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.

Information 

This section provides the affected environment, the root cause, and the related Jira tickets for this issue.

Environment 

• Jive Hosted
• Jive On-Premise

Root Cause

The query that Jive sends uses a LIMIT clause that is not supported in Oracle.

Reference Jira tickets

• JVHOPLE-3020
• JVHOPST-343

Back to top

Process

This error has been resolved in Jive version 9.0.6.

Back to top