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.


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.