Troubleshooting with Simple Installation

If you encounter an issue while installing TIBCO MDM with PostgreSQL, you may resolve the issues by completing the common troubleshooting procedures.

Troubleshooting with Simple Installation
Issue Description Solution
Database specific error The following exception is displayed in $MQ_HOME/log/elink.log: Unable to get managed connection for java:jboss/eCMDataSource

The exception may get display due to the following reasons:

  • PostgreSQL is not running.
  • PostgreSQL initialization failed.
  • MDM database schema does not exist.
To resolve this error, perform the following steps:

Execute pg_start.bat/.sh and pg_stop.bat/.sh to start and stop PostgreSQL Server. The files are located at $MQ_HOME/db/postgreSQL/install.

Execute pg_init.bat/.sh to initialize the PostgreSQL database instance. The files are located at $MQ_HOME/bin/pgsql.

Perform the following tasks:

  • Create the missing tablespace directories:

    $MQ_HOME/bin/pgsql/tablespaces/velodbdata $MQ_HOME/bin/pgsql/tablespaces/velodbindx

    Ensure that the logged in user is the owner and has full permission to access these directories.

  • Execute install.bat from $MQ_HOME/db/postgreSQL/install and type the following:

    $MQ_HOME/bin/pgsql localhost 5432 postgres USERNAME "" mdmuser mdmpassword

    Where USERNAME is the logged-in user name.

    $MQ_HOME/bin/pgsql/tablespaces/velodbdata $MQ_HOME/bin/pgsql/tablespaces/velodbindx dev dev

    Verify if the MDM schema exists by starting the PostgreSQL Administration console.

The pgAdmin4 tool Error When you run pgAdmin4.exe from $MQ_HOME\bin\pgsql\pgAdmin4\bin, the black page is displayed.

The issue occurs on Windows 2008 R2 and PostgreSQL combination.

Install PgAdmin 4 Client standalone.