Articles

• Tracking (via SQL) Changes to a Document or Blog Post

  Overview This article provides information on tracking changes to a document or a blog post in Jive using SQL query.  Prerequisites The information provided in this article applies to Jive Hosted and ...

• The jivestatuslevelpntsum Table is Causing Database Deadlocks

  Overview The application database frequently encounters deadlock issues, with the following query constantly appearing in the database logs: UPDATE jiveStatusLevelPntSum ps, (SELECT userID, sum( point...

• Finding the Details of the Moved Document

  Overview The customer requested information about a document that was moved, specifically who move it. This article provides information about getting the details of the document movement. Information...

• Row-Level SQL Deadlocks on JiveTaskQueue and JiveAcclaim Tables

  Overview It is possible to encounter sporadic/unpredictable row-level SQL deadlocks on JiveTaskQueue and JiveAcclaim tables. Examples of statements that entered deadlock are: UPDATE JiveTaskQueue SET ...

• Jive Supported Operating Systems (On-Premise)

  Overview Jive is supported on several different host OSs (Red Hat, CentOS, SUSE Linux). This article details the versions of each that are currently supported.   Information  Supported Operating Syste...

• Oracle Database Best Practices

  Overview For best results and to optimize the features of the Jive installation, configure and maintain the Oracle database based on the vendor's requirements and apply these Jive best practices. Info...

• Microsoft SQL Server Database Recommendations

  Overview For best results and to optimize the features of the Jive installation, configure and maintain the Microsoft SQL Server database based on the vendor's requirements and apply these Jive best p...

• MySQL Database Best Practices

    Overview For best results and to optimize the features of the Jive installation, configure and maintain the MySQL database based on the vendor's requirements and apply these Jive best practices.   I...

• Finding Database Schemas in Jive

  Overview The database schema of a system is the architecture described in a formal language as supported by a database management system. This article will guide you in finding the Jive Database schem...

• Recommender Service SQL Tables

  Overview This article provides a view of the EAE database tables that the Recommender service uses the most. This information is usually helpful in troubleshooting issues related to data such as data ...