My Oracle Support Banner

Error: SQLSyntaxErrorException: ORA-00942: table or view does not exist while configuring the Clover Services with "-Dclover_config_file" paramter. (Doc ID 2671660.1)

Last updated on MAY 20, 2020

Applies to:

Oracle Endeca Information Discovery Integrator - Version 3.2.0 and later
Information in this document applies to any platform.

Symptoms

ISSUE STATEMENT

After configuring the clover services with "-Dclover_config_file" paramter its throwing an below error while restarting the clover server.

ERROR 

endeca_clover_domain.log:- 


STEPS TO REPLICATE

The issue can be reproduced at will with the following steps:

1. Configure the clover config file parameter :

   JAVA_OPTIONS="${JAVA_OPTIONS} -Dclover_config_file=<installtion path>/oracle/middleware/user_projects/domains/endeca_clover_domain/cloverServer.properties"

2. Contents of the cloverServer.properties file:

    license.file=<installation path>/oracle/middleware/user_projects/applications/endeca_clover_domain/license.dat

   quartz.driverDelegateClass=org.quartz.impl.jdbcjobstore.WebLogicDelegate

   datasource.type=JNDI

   datasource.jndiName=JNDI_NAME

   hibernate.dialect=org.hibernate.dialect.Oracle10gDialect

3. Restart the clover server.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.