search cancel

Web Viewer 12.1 Many CREATE TABLE 2714 or Error Code 30000 In Tomcat Log

book

Article ID: 39040

calendar_today

Updated On:

Products

Output Management Web Viewer

Issue/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

Internal Exception: java.sql.SQLException: Table/View 'ROLE_SUBSCRIPTION' already exists in Schema 'APP'.

Error Code: 30000

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.

Cause

CREATE TABLE privileges Set to 1 for Yes

Environment

Tomcat
Web Sphere

Resolution

These error message do not mean anything is wrong.

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]

Enter 0

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.