Endeca ecastore exists - Failed to create database eacstore while running Initialise Services


Caused by: java.sql.SQLException: Failed to create database '/u01/app/endeca/PlatformServices/workspace/state/eacstore', see the next exception for details.
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
    ... 54 more
Caused by: java.sql.SQLException: The database directory '/u01/app/endeca/PlatformServices/workspace/state/eacstore' exists. However, it does not contain the expected 'service.properties' file. Perhaps Derby was brought down in the middle of creating this database. You may want to delete this directory and try creating the database again.
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
    at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
    ... 51 more
Caused by: ERROR XBM0A: The database directory '/u01/app/endeca/PlatformServices/workspace/state/eacstore' exists. However, it does not contain the expected 'service.properties' file. Perhaps Derby was brought down in the middle of creating this database. You may want to delete this directory and try creating the database again.
    at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
    at org.apache.derby.impl.services.monitor.StorageFactoryService.vetService(Unknown Source)
    at org.apache.derby.impl.services.monitor.StorageFactoryService.access$600(Unknown Source)
    at org.apache.derby.impl.services.monitor.StorageFactoryService$9.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.apache.derby.impl.services.monitor.StorageFactoryService.createServiceRoot(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(Unknown Source)
    at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Unknown Source)


Solution

If you get the exception like above,then navigate to the folder /endeca/PlatformServices/workspace/state , take a backup of the folder eacstore,then delete the folder eacstore,once the folder is deleted,
stop the Platform Service (shutdown.sh - /endeca/PlatformServices/6.1.3/tools/server/bin),then
start the Platform Service (startup.sh -  /endeca/PlatformServices/6.1.3/tools/server/bin). Now navigate to the folder where the endeca application is deployed and initialize the service with --force option or delete the current applications which is already provisioned and configure the cim to deploy your Endeca Application and try to initialize ,this time ideally this issue wont come.

See how to delete the Provisioned Application and re-initialize 

Comments

Popular posts from this blog

Weblogic Issues during EAR Deployment Exception in AppMerge flows progression

BCC site status inaccessible Agent Production in error state

DUseSunHttpHandler=true weblogic.net.http.SOAPHttpsURLConnection Weblogic/Java HttpHandler issues