Connections by Wannes Rams
Couple of things to watch out for when applying CR’s to HCL Connections 
By Wannes Rams | 11/7/23 10:14 AM | Infrastructure - Connections | Added by Wannes Rams
I was updating a couple of Connections environments to CR4 and some of them are using SSO using OIDC and a custom database name for ICEC ( so not ESSAPPS)
Issues configuring the Sharepoint widget for Communities
By Wannes Rams | 4/6/23 11:49 AM | Infrastructure - Connections | Added by Wannes Rams
On a recent deployment of HCL Connections I struggled getting the SharePoint widget to work.
Always get the latest Huddo version in HCL Connections
By Wannes Rams | 1/26/23 3:09 AM | Infrastructure - Connections | Added by Wannes Rams
We have documented how to connect to our version, but that documentation is focused on a manual install of Component pack and connecting to our systems from the start. I want to show how to do it if Boards is already installed and running using the automation scripts. You can obviously follow this guide if you did a manual install and connected to the HCL resources, I am just mentioning some specifics about the HCL automation you can ignore.
Migration issue on opnact when using dbt.jar
By Wannes Rams | 1/10/23 9:59 AM | Infrastructure - Connections | Added by Roberto Boccadoro
While I was migrating a Connections 7 on premises customer to our cloud using the dbt.jar tool, I came across the issue that the OPNACT database did not want to migrate, it threw an error on the OA_NODE table stating that the source table has 38 columns and the target one 37
The column that did not exist on the target was OWNERMEMBERUUID
Now the target database is a fresh cnx7 created database from the cnx7 scripts and the creation script does not contain this column. So I started looking through the database scripts to check what happened to that column over time.
How to perform a db2 redirected restore
By Wannes Rams | 1/10/23 9:58 AM | Infrastructure - Connections | Added by Roberto Boccadoro
Sometimes you need to restore db2 databases on a different machine. For example during on prem to cloud migrations, or when moving database servers during an upgrade for Connections. In most cases some of the paths will be different. The LOGPATH is gonna be your main issue. Goal of this post is to show you how to restore the database and change the LOGPATH setting inside the database you are restoring on the fly.
HCL Connections, external user to internal
By Wannes Rams | 10/14/21 4:54 AM | Infrastructure - Connections | Added by Matteo Bisi
We all got the request before, a user has been created as an external user and needs to become internal, or an external consultant has been hired and needs to be changed.
WARNING! I strongly advise not to change an internal user to an external one. This is a security risk as internal users have access to much content by default and the db2 commands I will provide do not guarantee all will be secured if you perform them in the opposite way. The recommended process here is to delete the user, remove all email address references in your database and recreate a user with a new identifier.
LetsConnect
By Wannes Rams | 3/20/19 2:49 AM | Infrastructure - Connections | Added by Roberto Boccadoro
IBM is running a series of jams to define the future of Connections. These interactive workshops will take place physically and virtually to iterate on the next version of Connections. Business leaders, Community managers, stakeholders, … come and help define the future of the product
How to find a Wiki and all linked pages in the database
By Wannes Rams | 1/29/19 9:42 AM | Infrastructure - Connections | Added by Roberto Boccadoro
I was struggling to find back deleted / unlinked pages for a wiki for one of our users and wanted to visualise a wiki and all associated pages in the database. Thank you Julian Mosen for pointing me in the right direction on the database design. I used the following SQL Query to list the data I wanted
Unable to upgrade IBM Content Navigator to FP5
By Wannes Rams | 12/23/15 2:27 AM | Infrastructure - Connections | Added by Oliver Busse
During a “simple” upgrade of IBM Content Navigator 2.0.3FP2 to FP5 one of my colleagues (Dave) ran into an error even before the installation started.
The error stated that the required version of ICN wasn’t installed on the current system.