Articles

• ETL Job Failing with the error “Batch Entry XX INSERT INTO jivedw_group_stage … was aborted”

  Overview Analytics ETL Jobs have been failing recently. Error in ETL History:  Task: Group : Batch entry XX INSERT INTO jivedw_group_stage (group_id, name, description, creation_ts, modification_ts) V...

• Impact Metrics showing 100% Global Reach for Posts, When not Every Registered User has Seen Those Posts

  Overview Impact Metrics are showing 100% Global Reach on some posts The number of Viewers in Impact Metrics is less than the total registered users in your Jive Community. E.g. Viewers are 100, wherea...

• Analytics Export (DES Explorer) showing MONTH instead of MINUTES in Timestamps

  Overview You have logged into Analytics Export (DES Explorer) as an Admin. When you click “preview” you see timestamps in the first column in the format: yyyy-mm-dd hh:CURRENT MONTH:ss Instead of the ...

• Blog Post Count does not decrease in the Analytics Page after moving the Post out of the Place

  Overview You move a blog post from one group to another, but the Space Analytics on the source group still shows the same count of blog posts as before. This count should have been reduced by 1 since ...

• Impact Metrics Blank and Layout is Transparent - Jive Cloud

  Overview Impact Metrics are shown in an unusual layout (with a transparent background). They are missing most data. You are on Jive Cloud.   Information This was a bug (JVCLD-110676) that was fixed in...

• Filter Out Deleted Departments from Department Interactions Report

  Overview The Department Interactions in Community Analytics report shows interactions of departments that do not exist now but existed earlier. These departments may have been created for testing and ...

• Shares to Places Not Part of Impact Metrics of Videos

  Overview You shared a video with three specific users, and two different places. In Impact Metrics, the Share count is only 3 instead of the expected 5. Impact Metrics is not counting Shares made to p...

• Analytics V2 Export API not Returning Data on User Deactivation Events

  Overview You are expecting to see ACTIVITY_DELETE_USER events in the DES Analytics Export and in the data returned from the Analytics API. You have deactivated a user in Jive (you have not deleted the...

• ETL Job has error “Duplicate key value violates unique constraint” after Switching the Analytics database from Oracle to Postgres

  Overview You recently migrated the Analytics database from Oracle to Postgresql. The nightly sync (ETL) job is failing with the below error: Task: DocumentUserETL : ERROR: duplicate key value violates...

• Impact Metrics Not Visible to Authors of a Discussion

  Overview The user who posted a discussion cannot see Impact Metrics after any user has made a comment/response on the discussion. This does not affect Administrators.   Solution This is a known issue ...