Jive -News Stream Not Showing - DB Logon Error after a Data Refresh or Migration – Jive Support

Overview

When copying/moving data from one instance to another, the encrypted passwords stored in the database can also get copied across. This can lead to SQL Exceptions like "invalid username/password; logon denied". This can result in News Streams not getting displayed for users.

Prerequisites

Check that all data has been copied across properly and database tables’ row counts match between source and target instances.

Solution

This issue can occur when data is copied to a target instance that already exists (rather than a new instance). The existing target instance has encryption keys that are different from the ones in the source instance. Because of this, the target instance is not able to decrypt passwords that were encrypted on the source instance (with different encryption keys).

Follow the below steps to resolve the issue:

1. For the Core, EAE, and Analytics services, reset the stored password in the database from encrypted to cleartext.

2. Delete the Crypto folder on the web nodes, so that Jive creates it from scratch.

Located at /usr/local/jive/applications/sbs/home/crypto

Deleting it will reset the encryption keys that are used to save passwords all over the application (DB and config files). This should be performed with extreme caution in Production. Jive will not be able to decrypt any encrypted password saved with the previous encryption keys. This can cause Jive restarts to fail in some circumstances causing a potential outage

3. Restart all Jive services

Testing

News and Activity Streams should be visible and should update for newly added content.

Articles in this section

Jive -News Stream Not Showing - DB Logon Error after a Data Refresh or Migration

Overview

Prerequisites

Solution

Testing

Comments

Still Have Questions?