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