Many Database errors in the catalina.out log or Websphere log when bringing up CA Output Management Web Viewer 12.1

Document ID : KB000039040
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction:
When running the configtool, if you chose Yes for 

[Does this account have CREATE TABLE privileges Enter 1 for Yes and 0 for No]

Then Web Viewer will try to create the database table every time it comes up generating pages of error messages like these:

Call: CREATE TABLE LDirectory (DIRID INTEGER NOT NULL, DNAME VARCHAR(255) NOT NULL UNIQUE, LDAPPORT VARCHAR(255) NULL, MODIFIEDTIME NUMERIC(19) NULL, LDAPPREPEND VARCHAR(255) NULL, LDAPAPPEND VARCHAR(255) NULL, DDESC VARCHAR(255) NULL, PROPERTIES VARCHAR(255) NULL, LDAPSERVER VARCHAR(255) NULL, PRIMARY KEY (DIRID))

..............

[EL Warning]: 2016-11-01 07:56:06.058--ServerSession(661780277)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.1.v20100817-r8050): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: <database server name>.jdbc.SQLServerException: There is already an object named 'AUDITLOG' in the database.
Error Code: 2714

This setting allowed Web Viewer to create the database initially, but is not needed after that.

Workaround:

These messages may be ignored.  

 Resolution:

Running the configtool again and changing this parameter to 0 will stop these error messages:

[Does this account have CREATE TABLE privileges Enter 1 for Yes and 0 for No]

Recycle the application server after changing this parameter to pick up the new value.