Bug in WebMethods OneData MDM 9.5 standard configuration

When you install WebMethods OneData MDM 9.5 using the Software AG installer, 2 database connections will be created by default as shown in the image below:

  1. STG: connection to the Work Area
  2. PRD: connection to the Release Area

The parameters for both connections are by default configured using JNDI. The corresponding full config details can be found in the Tomcat config file <install dir>profilesODEconfigurationtomcatconfcontext.xml. These contain JDBC URL, username, password,… Although the username is specified in the JNDI context in the context.xml file, it is also by default specified in the connection details in OneData as shown in the image below.

The value of the User-ID parameter seems be generated automatically and composed out of the connection prefix you define during the installation in SAG Installer, concatenated with the suffix “_wa” for the work area connection and “_ra” for the release area connection.

Although it seems that this configuration is working fine, this is actually not 100% the case. It turns out that when the value in the User-ID parameter doesn’t correspond with the actual Oracle username (which is very likely), some functionality like the “Schema Update” to create new Objects from existing tables in the Release Area will not work (existing tables are not shown in OneData UI). So in order to avoid potential unexpected behavior in OneData you should update the User-ID parameter after installation to the actual Oracle username (so identical to the username in context.xml).

Another solution is to not use the JNDI config and copy all the configuration details from the context.xml file to the corresponding fields in the Connection Parameters form in OneData.

This problem also seems to occur in OneData 9.0. I haven’t been able yet to verify it in version 9.6. but I couldn’t find any record of this error on Software AG Empower, so the bug probably still exists in version 9.6 also.

Author: Kristof Lievens



Curious to know more about this topic?

Working at i8c

i8c is a system integrator that strives for an informal atmosphere between its employees, who have an average age of approx 30 years old. We invest a lot of effort in the professional development of each individual, through a direct connection between the consultants and the management (no multiple layers of middle management). We are based in Kontich, near Antwerp, but our customers are mainly located in the triangle Ghent-Antwerp-Brussels and belong to the top 500 companies in Belgium (Securex, Electrabel, UCB, etc…).

Quality Assurance

i8c is committed to delivering quality services and providing customer satisfaction. That’s why we invested in the introduction of a Quality Management System, which resulted in our ISO9001:2000 certification. This guarantees that we will meet your expectations, as a reliable, efficient and mature partner for your SOA & integration projects.

i8c - ISO9001-2015

Also worth reading

AWS AppFlow: Streamlining SaaS Integrations with AWS Services

In today’s digital world, organizations are constantly looking for ways to streamline their workflows and improve their data management processes. One of the key challenges that organizations face is integrating their various software as a service (SaaS) applications with their data management systems. This is

Read More »

Apigee Scope Validation using OpenAPI Specification

In API security and management, we often use a lot of different security mechanisms to protect the requested resource behind the API Gateway. One of these mechanisms is the validation of scopes to authorize a client on a specific sub-resource of the API. Most of

Read More »