Many CREATE TABLE errors in the logs when bringing up Web Viewer 12.1

Document ID : KB000039040
Last Modified Date : 27/06/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


These messages may be different for different data bases.

Background:
This setting may have allowed Web Viewer to create the database initially, but is not needed after that.  Usually the database administrator creates the database before the install, however.
Environment:
Tomcat
Web Sphere
Instructions:

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.

Additional Information:
These messages are not fatal and may be ignored.