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.
Check that all data has been copied across properly and database tables’ row counts match between source and target instances.
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.
3. Restart all Jive services
News and Activity Streams should be visible and should update for newly added content.