All articles

Documentum – xPlore not able to deploy “dsearch.war”

Recently at a customer, I faced a new issue I didn’t see before on the xPlore Dsearch component. Basically, the processes appeared to be starting and the “dsearchadmin.war” was deployed properly but it always failed for the “dsearch.war” upon startup(…)

db-crawler, a database search utility for Documentum

Working with Documentum is often a frustrating experience, and one of the main causes is the lack of meaningful error messages. Be it an encouragment to the administrator or developer to refer to the official knowledge base or a gap(…)

Power BI – Active Directory data integration

Introduction This documentation explains how to integrate Active Directory data in a Power BI report. It explains also how to link this data with another data source. To illustrate the method, we will integrate Active Directory Computer data and link(…)

In which schema do temporary tables go in PostgreSQL?

As you might know, you can create temporary tables, views and sequences in PostgreSQL. Temporary means, that the temporary table, view or sequence will be dropped when you either end your session or you transaction. When the drop will happen(…)

Contained Availability Groups error

During my testing about the new SQL Server 2022 feature Contained Availability group I faced an issue during the creation of the system databases on the secondary instance. I used the wizard to create a new Contained Availability Group and(…)

Changing Fusion Middleware Forms and Reports repository database

I have been requested to migrate the Fusion Middleware repository database from one Linux server to a new one. Here are the steps followed to successfully do this. In the following of this document, the Fusion Middleware repository created using(…)

Get SQL Server database size with PowerShell

Introduction For various reasons, following the evolution of the data size of databases is interesting for a dba or for the application team. Most of the time, this is something built-in for monitoring tools – convenient to follow the evolution(…)

WebLogic Licence Compliance and Out of Memory Errors

Recently, at a customer site, I faced an issue of WebLogic Admin server which crashes because it reached Java Virtual Machine (JVM) limit. Xms and Xmx were set to 1Gb. Expected behavior is that Node Manager detects it and restart(…)

Reminder about SSMS

As you know, since SQL Server 2016, SQL Server Management Studio is not anymore part of the SQL Server ISO files and needs to be downloaded independently. If you want to have a complete list of all SSMS versions please(…)

Major PostgreSQL version upgrade in a Patroni cluster

Introduction One of my customer recently asked me to upgrade its PostgreSQL instance from version 9.6 to version 14.3. The infrastructure is composed of 4 servers : – DB02-04 – Ubuntu 20.04 – supporting PostgreSQL, Patroni, HAProxy and etcd–(…)