Ebase fails to start

Post any questions regarding Installing or Upgrading Ebase, including problems starting up the Ebase Xi Server or Designer

Moderators: Ian, Dave, jcoulson, Jon, Wai

peterd
Ebase User
Posts: 4
Joined: Wed May 28, 2014 8:38 pm

Ebase fails to start

#1

Postby peterd » Mon Jun 18, 2018 3:50 pm

Following a Windows server update Ebase is failing to start due to a connection issue with the UFS database. Ebase is normally started as a service whenever the server is restarted. I have looked at the output but cannot determine the underlying cause of the problem.

We stopped the service and the "STDOUT.log" contained:

2018-06-16 23:37:23 Commons Daemon procrun stdout initialized
Ebase Server initialising....
************************************************************
*** Starting Ebase Xi version 4.5.2, Build 20140328
************************************************************
Loading Property file UFSSetup.properties
UFSSetup property file found
>> Start of UFS properties display
System name = Community Edition
DatasourceName = UFSREPOSITORY
Transaction JNDI Name = java:comp/UserTransaction
Designer Transaction JNDI Name = java:comp/UserTransaction
Logging Properties:-
LogError = true
LogInfo = false
LogDirName = ../logs
LogFileName = ufsserver.log
RetainOldLogs = false
AuditLogDirName = .
AuditLogFileName = security_audit.log
RetainOldAuditLogs = false
System Mode = Test
Email Host = localhost
MQ Host = null
Installation Preferences File Name = ../webapps/ufs/preferences/installation_preferences.xml
File access root = ../webapps/ufs
Transport Directory Name = ../../transport/
Scanning Config Export Directory = null
Scanning Config Export Filename = null
Scanning Config Template File = null
Ghostscript Home Directory = null
File Directory Name = ../../generatedfiles
PDF Directory Name = ../../generatedpdfs
XML Servlet = http://127.0.0.1:3030/ufs/UnattendedXMLClient
System Date Format = dd/mm/yyyy
Batch Servlet = http://127.0.0.1:3030/ufs/BatchServer
LDAP Registry Properties:-
Attributes File Name: ../webapps/ufs/preferences/ldap_attributes.xml
Host: null
Port: 389
Base Distinguished Name: null
Bind Distinguished Name: null
User Key Attribute Name: cn
Cache refresh period: 0
Allowable file types for upload = all
Maximum size for file upload = 1M
Encrypted parameters support = true
SSL Port = 443
Export/Import Location= ../../transport_files/
General Workflow Properties:-
ActivityType Classes:
- com.ebasetech.ufs.workflow.server.process.activity.EbaseActivityType
- com.ebasetech.ufs.workflow.server.process.activity.ManualTaskActivityType
Workflow Resource Management Properties:-
Assignment handler Class = com.ebasetech.ufs.xi.workflow.XIAssignmentHandler
Security handler Class = com.ebasetech.ufs.workflow.security.example.EbaseSecurityHandler
Calendar Id = ebasecal
Holiday Class Names = null
Proxy Settings:-
Proxy host = null
Proxy port = null
Proxy authentication = false
HTML Document Type:-
Output Document Type = HTML4_TRANS
Local Base Uri = null
>> End of UFS properties display
Logging to file C:\ebaseXi\UfsServer\tomcat\logs\ufsserver.log
Reading system configuration.
Sat Jun 16 23:38:07: UFS Designer server component initialised successfully
Sat Jun 16 23:38:07: Workflow servlet component initialised successfully
Sat Jun 16 23:38:17: FormCacheLoader: start
Sat Jun 16 23:38:17: FormCacheLoader: end
Ebase Server successfully initialised in 20 seconds
Scheduler Thread stopped successfully.
Mon Jun 18 16:17:44: Workflow servlet component shutdown....
Mon Jun 18 16:17:44: Workflow servlet component shutdown successful
Ebase Server has shutdown.


We stopped the service and then tried starting manually using the desktop shortcut we get the following output in the command window:
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getConnection(
DatabaseConnectionPoolFactory.java:39)
at com.ebasetech.ufs.kernel.RepositoryDatabaseConnectionFactory.getConne
ction(RepositoryDatabaseConnectionFactory.java:50)
at com.ebasetech.ufs.utility.PersistenceHelper.getConnection(Persistence
Helper.java:328)
at com.ebasetech.ufs.utility.PersistenceHelper.getDbType(PersistenceHelp
er.java:593)
at com.ebasetech.ufs.utility.PersistenceHelper.chooseDbSpecificString(Pe
rsistenceHelper.java:581)
at com.ebasetech.ufs.workflow.server.WorkItem.Top(WorkItem.java:362)
at com.ebasetech.ufs.workflow.server.enactment.WorkQueue$WorkThread.run(
WorkQueue.java:460)
java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection exce
ption: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnecti
on no connection available java.sql.SQLException: Cannot get connection for URL
jdbc:derby:UFS;create=false : Failed to start database 'UFS', see the next excep
tion for details.
at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPo
olDataSource.java:213)
at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPo
olDataSource.java:164)
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getPooledConne
ction(DatabaseConnectionPoolFactory.java:55)
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getConnection(
DatabaseConnectionPoolFactory.java:39)
at com.ebasetech.ufs.kernel.RepositoryDatabaseConnectionFactory.getConne
ction(RepositoryDatabaseConnectionFactory.java:50)
at com.ebasetech.ufs.utility.PersistenceHelper.getConnection(Persistence
Helper.java:328)
at com.ebasetech.ufs.utility.PersistenceHelper.getDbType(PersistenceHelp
er.java:593)
at com.ebasetech.ufs.utility.PersistenceHelper.chooseDbSpecificString(Pe
rsistenceHelper.java:581)
at com.ebasetech.ufs.workflow.server.WorkItem.Top(WorkItem.java:362)
at com.ebasetech.ufs.workflow.server.enactment.WorkQueue$WorkThread.run(
WorkQueue.java:460)
com.ebasetech.ufs.utility.PersistenceRuntimeException: Failed to get database co
nnection: Mon Jun 18 16:18:40: ERROR Error getting connection from datasource UF
SREPOSITORY, SQLException in StandardPoolDataSource:getConnection exception: jav
a.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no conn
ection available java.sql.SQLException: Cannot get connection for URL jdbc:derby
:UFS;create=false : Failed to start database 'UFS', see the next exception for d
etails.

at com.ebasetech.ufs.utility.PersistenceHelper.getConnection(Persistence
Helper.java:333)
at com.ebasetech.ufs.utility.PersistenceHelper.getDbType(PersistenceHelp
er.java:593)
at com.ebasetech.ufs.utility.PersistenceHelper.chooseDbSpecificString(Pe
rsistenceHelper.java:581)
at com.ebasetech.ufs.workflow.server.WorkItem.Top(WorkItem.java:362)
at com.ebasetech.ufs.workflow.server.enactment.WorkQueue$WorkThread.run(
WorkQueue.java:460)
Caused by: com.ebasetech.ufs.utility.PersistenceException: Error getting connect
ion from datasource UFSREPOSITORY, SQLException in StandardPoolDataSource:getCon
nection exception: java.sql.SQLException: SQLException in StandardPoolDataSource
:getConnection no connection available java.sql.SQLException: Cannot get connect
ion for URL jdbc:derby:UFS;create=false : Failed to start database 'UFS', see th
e next exception for details.
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getPooledConne
ction(DatabaseConnectionPoolFactory.java:76)
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getConnection(
DatabaseConnectionPoolFactory.java:39)
at com.ebasetech.ufs.kernel.RepositoryDatabaseConnectionFactory.getConne
ction(RepositoryDatabaseConnectionFactory.java:50)
at com.ebasetech.ufs.utility.PersistenceHelper.getConnection(Persistence
Helper.java:328)
... 4 more
Mon Jun 18 16:18:40: Failed while enacting node: unknown: Failed to get databa
se connection:
java.sql.SQLException: Cannot get connection for URL jdbc:derby:UFS;create=false
: Failed to start database 'UFS', see the next exception for details.
at org.enhydra.jdbc.standard.StandardDataSource.getConnection(StandardDa
taSource.java:216)
at org.enhydra.jdbc.standard.StandardPooledConnection.<init>(StandardPoo
ledConnection.java:65)
at org.enhydra.jdbc.standard.StandardXAConnection.<init>(StandardXAConne
ction.java:81)
at org.enhydra.jdbc.standard.StandardXADataSource.getXAConnection(Standa
rdXADataSource.java:110)
at org.enhydra.jdbc.pool.StandardXAPoolDataSource.create(StandardXAPoolD
ataSource.java:159)
at org.enhydra.jdbc.pool.GenericPool.getFromPool(GenericPool.java:253)
at org.enhydra.jdbc.pool.GenericPool.checkOut(GenericPool.java:357)
at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPo
olDataSource.java:194)
at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPo
olDataSource.java:164)
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getPooledConne
ction(DatabaseConnectionPoolFactory.java:55)
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getConnection(
DatabaseConnectionPoolFactory.java:39)
at com.ebasetech.ufs.kernel.RepositoryDatabaseConnectionFactory.getConne
ction(RepositoryDatabaseConnectionFactory.java:50)
at com.ebasetech.ufs.utility.PersistenceHelper.getConnection(Persistence
Helper.java:328)
at com.ebasetech.ufs.utility.PersistenceHelper.getDbType(PersistenceHelp
er.java:593)
at com.ebasetech.ufs.utility.PersistenceHelper.chooseDbSpecificString(Pe
rsistenceHelper.java:581)
at com.ebasetech.ufs.workflow.server.WorkItem.Top(WorkItem.java:362)
at com.ebasetech.ufs.workflow.server.enactment.WorkQueue$WorkThread.run(
WorkQueue.java:460)
java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no c
onnection available java.sql.SQLException: Cannot get connection for URL jdbc:de
rby:UFS;create=false : Failed to start database 'UFS', see the next exception fo
r details.
at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPo
olDataSource.java:204)
at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPo
olDataSource.java:164)
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getPooledConne
ction(DatabaseConnectionPoolFactory.java:55)
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getConnection(
DatabaseConnectionPoolFactory.java:39)
at com.ebasetech.ufs.kernel.RepositoryDatabaseConnectionFactory.getConne
ction(RepositoryDatabaseConnectionFactory.java:50)
at com.ebasetech.ufs.utility.PersistenceHelper.getConnection(Persistence
Helper.java:328)
at com.ebasetech.ufs.utility.PersistenceHelper.getDbType(PersistenceHelp
er.java:593)
at com.ebasetech.ufs.utility.PersistenceHelper.chooseDbSpecificString(Pe
rsistenceHelper.java:581)
at com.ebasetech.ufs.workflow.server.WorkItem.Top(WorkItem.java:362)
at com.ebasetech.ufs.workflow.server.enactment.WorkQueue$WorkThread.run(
WorkQueue.java:460)
java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection exce
ption: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnecti
on no connection available java.sql.SQLException: Cannot get connection for URL
jdbc:derby:UFS;create=false : Failed to start database 'UFS', see the next excep
tion for details.
at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPo
olDataSource.java:213)
at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPo
olDataSource.java:164)
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getPooledConne
ction(DatabaseConnectionPoolFactory.java:55)
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getConnection(
DatabaseConnectionPoolFactory.java:39)
at com.ebasetech.ufs.kernel.RepositoryDatabaseConnectionFactory.getConne
ction(RepositoryDatabaseConnectionFactory.java:50)
at com.ebasetech.ufs.utility.PersistenceHelper.getConnection(Persistence
Helper.java:328)
at com.ebasetech.ufs.utility.PersistenceHelper.getDbType(PersistenceHelp
er.java:593)
at com.ebasetech.ufs.utility.PersistenceHelper.chooseDbSpecificString(Pe
rsistenceHelper.java:581)
at com.ebasetech.ufs.workflow.server.WorkItem.Top(WorkItem.java:362)
at com.ebasetech.ufs.workflow.server.enactment.WorkQueue$WorkThread.run(
WorkQueue.java:460)
com.ebasetech.ufs.utility.PersistenceRuntimeException: Failed to get database co
nnection: Mon Jun 18 16:18:40: ERROR Error getting connection from datasource UF
SREPOSITORY, SQLException in StandardPoolDataSource:getConnection exception: jav
a.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no conn
ection available java.sql.SQLException: Cannot get connection for URL jdbc:derby
:UFS;create=false : Failed to start database 'UFS', see the next exception for d
etails.

at com.ebasetech.ufs.utility.PersistenceHelper.getConnection(Persistence
Helper.java:333)
at com.ebasetech.ufs.utility.PersistenceHelper.getDbType(PersistenceHelp
er.java:593)
at com.ebasetech.ufs.utility.PersistenceHelper.chooseDbSpecificString(Pe
rsistenceHelper.java:581)
at com.ebasetech.ufs.workflow.server.WorkItem.Top(WorkItem.java:362)
at com.ebasetech.ufs.workflow.server.enactment.WorkQueue$WorkThread.run(
WorkQueue.java:460)
Caused by: com.ebasetech.ufs.utility.PersistenceException: Error getting connect
ion from datasource UFSREPOSITORY, SQLException in StandardPoolDataSource:getCon
nection exception: java.sql.SQLException: SQLException in StandardPoolDataSource
:getConnection no connection available java.sql.SQLException: Cannot get connect
ion for URL jdbc:derby:UFS;create=false : Failed to start database 'UFS', see th
e next exception for details.
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getPooledConne
ction(DatabaseConnectionPoolFactory.java:76)
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getConnection(
DatabaseConnectionPoolFactory.java:39)
at com.ebasetech.ufs.kernel.RepositoryDatabaseConnectionFactory.getConne
ction(RepositoryDatabaseConnectionFactory.java:50)
at com.ebasetech.ufs.utility.PersistenceHelper.getConnection(Persistence
Helper.java:328)
... 4 more
Mon Jun 18 16:18:40: Failed while enacting node: unknown: Failed to get databa
se connection:
java.sql.SQLException: Cannot get connection for URL jdbc:derby:UFS;create=false
: Failed to start database 'UFS', see the next exception for details.
at org.enhydra.jdbc.standard.StandardDataSource.getConnection(StandardDa
taSource.java:216)
at org.enhydra.jdbc.standard.StandardPooledConnection.<init>(StandardPoo
ledConnection.java:65)
at org.enhydra.jdbc.standard.StandardXAConnection.<init>(StandardXAConne
ction.java:81)
at org.enhydra.jdbc.standard.StandardXADataSource.getXAConnection(Standa
rdXADataSource.java:110)
at org.enhydra.jdbc.pool.StandardXAPoolDataSource.create(StandardXAPoolD
ataSource.java:159)
at org.enhydra.jdbc.pool.GenericPool.getFromPool(GenericPool.java:253)
at org.enhydra.jdbc.pool.GenericPool.checkOut(GenericPool.java:357)
at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPo
olDataSource.java:194)
at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPo
olDataSource.java:164)
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getPooledConne
ction(DatabaseConnectionPoolFactory.java:55)
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getConnection(
DatabaseConnectionPoolFactory.java:39)
at com.ebasetech.ufs.kernel.RepositoryDatabaseConnectionFactory.getConne
ction(RepositoryDatabaseConnectionFactory.java:50)
at com.ebasetech.ufs.utility.PersistenceHelper.getConnection(Persistence
Helper.java:328)
at com.ebasetech.ufs.utility.PersistenceHelper.getDbType(PersistenceHelp
er.java:593)
at com.ebasetech.ufs.utility.PersistenceHelper.chooseDbSpecificString(Pe
rsistenceHelper.java:581)
at com.ebasetech.ufs.workflow.server.WorkItem.Top(WorkItem.java:362)
at com.ebasetech.ufs.workflow.server.enactment.WorkQueue$WorkThread.run(
WorkQueue.java:460)
java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no c
onnection available java.sql.SQLException: Cannot get connection for URL jdbc:de
rby:UFS;create=false : Failed to start database 'UFS', see the next exception fo
r details.
at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPo
olDataSource.java:204)
at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPo
olDataSource.java:164)
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getPooledConne
ction(DatabaseConnectionPoolFactory.java:55)
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getConnection(
DatabaseConnectionPoolFactory.java:39)
at com.ebasetech.ufs.kernel.RepositoryDatabaseConnectionFactory.getConne
ction(RepositoryDatabaseConnectionFactory.java:50)
at com.ebasetech.ufs.utility.PersistenceHelper.getConnection(Persistence
Helper.java:328)
at com.ebasetech.ufs.utility.PersistenceHelper.getDbType(PersistenceHelp
er.java:593)
at com.ebasetech.ufs.utility.PersistenceHelper.chooseDbSpecificString(Pe
rsistenceHelper.java:581)
at com.ebasetech.ufs.workflow.server.WorkItem.Top(WorkItem.java:362)
at com.ebasetech.ufs.workflow.server.enactment.WorkQueue$WorkThread.run(
WorkQueue.java:460)
java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection exce
ption: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnecti
on no connection available java.sql.SQLException: Cannot get connection for URL
jdbc:derby:UFS;create=false : Failed to start database 'UFS', see the next excep
tion for details.
at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPo
olDataSource.java:213)
at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection(StandardPo
olDataSource.java:164)
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getPooledConne
ction(DatabaseConnectionPoolFactory.java:55)
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getConnection(
DatabaseConnectionPoolFactory.java:39)
at com.ebasetech.ufs.kernel.RepositoryDatabaseConnectionFactory.getConne
ction(RepositoryDatabaseConnectionFactory.java:50)
at com.ebasetech.ufs.utility.PersistenceHelper.getConnection(Persistence
Helper.java:328)
at com.ebasetech.ufs.utility.PersistenceHelper.getDbType(PersistenceHelp
er.java:593)
at com.ebasetech.ufs.utility.PersistenceHelper.chooseDbSpecificString(Pe
rsistenceHelper.java:581)
at com.ebasetech.ufs.workflow.server.WorkItem.Top(WorkItem.java:362)
at com.ebasetech.ufs.workflow.server.enactment.WorkQueue$WorkThread.run(
WorkQueue.java:460)
com.ebasetech.ufs.utility.PersistenceRuntimeException: Failed to get database co
nnection: Mon Jun 18 16:18:40: ERROR Error getting connection from datasource UF
SREPOSITORY, SQLException in StandardPoolDataSource:getConnection exception: jav
a.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no conn
ection available java.sql.SQLException: Cannot get connection for URL jdbc:derby
:UFS;create=false : Failed to start database 'UFS', see the next exception for d
etails.

at com.ebasetech.ufs.utility.PersistenceHelper.getConnection(Persistence
Helper.java:333)
at com.ebasetech.ufs.utility.PersistenceHelper.getDbType(PersistenceHelp
er.java:593)
at com.ebasetech.ufs.utility.PersistenceHelper.chooseDbSpecificString(Pe
rsistenceHelper.java:581)
at com.ebasetech.ufs.workflow.server.WorkItem.Top(WorkItem.java:362)
at com.ebasetech.ufs.workflow.server.enactment.WorkQueue$WorkThread.run(
WorkQueue.java:460)
Caused by: com.ebasetech.ufs.utility.PersistenceException: Error getting connect
ion from datasource UFSREPOSITORY, SQLException in StandardPoolDataSource:getCon
nection exception: java.sql.SQLException: SQLException in StandardPoolDataSource
:getConnection no connection available java.sql.SQLException: Cannot get connect
ion for URL jdbc:derby:UFS;create=false : Failed to start database 'UFS', see th
e next exception for details.
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getPooledConne
ction(DatabaseConnectionPoolFactory.java:76)
at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getConnection(
DatabaseConnectionPoolFactory.java:39)
at com.ebasetech.ufs.kernel.RepositoryDatabaseConnectionFactory.getConne
ction(RepositoryDatabaseConnectionFactory.java:50)
at com.ebasetech.ufs.utility.PersistenceHelper.getConnection(Persistence
Helper.java:328)
... 4 more
Mon Jun 18 16:18:40: Failed while enacting node: unknown: Failed to get databa
se connection:


Can you suggest what we should do next?

Thank you
0 x

Jon
Moderator
Moderator
Posts: 1213
Joined: Wed Sep 12, 2007 12:49 pm

Re: Ebase fails to start

#2

Postby Jon » Tue Jun 19, 2018 8:42 am

Does it start OK if you start it via the start_ebase_server.bat file?
0 x

peterd
Ebase User
Posts: 4
Joined: Wed May 28, 2014 8:38 pm

Re: Ebase fails to start

#3

Postby peterd » Tue Jun 19, 2018 9:04 am

No. We tried this but received the following errors in the ufsserver.log:
(a small extract of multiple messages)…..
Fri Jun 15 15:47:39: Failed while enacting node: unknown: Failed to get database connection:
Fri Jun 15 15:47:39: ERROR Error getting connection from datasource UFSREPOSITORY, SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.sql.SQLException: Cannot get connection for URL jdbc:derby:UFS;create=false : Failed to start database 'UFS', see the next exception for details.
Fri Jun 15 15:47:39: Failed while enacting node: unknown: Failed to get database connection:
Fri Jun 15 15:47:39: ERROR Error getting connection from datasource UFSREPOSITORY, SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.sql.SQLException: Cannot get connection for URL jdbc:derby:UFS;create=false : Failed to start database 'UFS', see the next exception for details.
Fri Jun 15 15:47:39: Failed while enacting node: unknown: Failed to get database connection:
Fri Jun 15 15:47:40: ERROR Error getting connection from datasource UFSREPOSITORY, SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.sql.SQLException: Cannot get connection for URL jdbc:derby:UFS;create=false : Failed to start database 'UFS', see the next exception for details.
Fri Jun 15 15:47:40: Failed while enacting node: unknown: Failed to get database connection:

We made sure that the service had been stopped before running the bat file.
0 x

Jon
Moderator
Moderator
Posts: 1213
Joined: Wed Sep 12, 2007 12:49 pm

Re: Ebase fails to start

#4

Postby Jon » Tue Jun 19, 2018 9:21 am

The system is trying to open the embedded Derby repository database and failing for some reason. Could you check:

1. No other processes are using this database e.g. a previous server instance, or a SQL client.
2. The database folder exists in UfsServer/DB/UFS
3. The derby.system.home parameter is set correctly - it should point to UfsServer/DB. When starting via the batch file this is set in start_ebase_server.bat. When starting via a service, double click the corresponding xxx.exe file in UfsServer/tomcat/bin then select the Java tab, the properties are listed under Options.
0 x

peterd
Ebase User
Posts: 4
Joined: Wed May 28, 2014 8:38 pm

Re: Ebase fails to start

#5

Postby peterd » Tue Jun 19, 2018 9:35 am

The ebase system has been running for four years. The first two years on server "A" without any issues. Two years ago the server was replaced with a new one, Ebase was reinstalled and the application exported from the old server to the new one. No-one has performed any tasks on the ebase environment for the past two years. The current problem occurred following a Windows server update. Could the problem be a new windows security issue or a java issue?

Answers to the questions are:

1. No other processes are using this database e.g. a previous server instance, or a SQL client.

The Derby database is only used by the Ebase system.

2. The database folder exists in UfsServer/DB/UFS

Yes.

3. The derby.system.home parameter is set correctly - it should point to UfsServer/DB. When starting via the batch file this is set in start_ebase_server.bat. When starting via a service, double click the corresponding xxx.exe file in UfsServer/tomcat/bin then select the Java tab, the properties are listed under Options.

The file has not been changed since originally installed two years ago.


Thank you for your assistance. We are thing if all else fails we will try (1) reboot server, and then (2) uninstall ebase and reinstall it.
0 x

Jon
Moderator
Moderator
Posts: 1213
Joined: Wed Sep 12, 2007 12:49 pm

Re: Ebase fails to start

#6

Postby Jon » Tue Jun 19, 2018 12:54 pm

Can you see if you can connect to the database using a SQL client. That will at least show if it's working OK. You can get the connection URL, userid and password from UfsServer/tomcat/conf/catalina/localhost/xxx.xml. But you will need to change the file path (a relative path of "UFS" ) to be an absolute address e.g. dbc:derby:c:/Ebase/UfsServer/DB/UFS;create=false. Normally you would need to shut down the server to do this as Derby only allows one client to connect when in embedded mode.
0 x

Jon
Moderator
Moderator
Posts: 1213
Joined: Wed Sep 12, 2007 12:49 pm

Re: Ebase fails to start

#7

Postby Jon » Tue Jun 19, 2018 1:25 pm

Probably the most likely cause is that another process has got a connection. If this is the case, a reboot will definitely fix it.
0 x

peterd
Ebase User
Posts: 4
Joined: Wed May 28, 2014 8:38 pm

Re: Ebase fails to start

#8

Postby peterd » Wed Jun 20, 2018 12:07 pm

We restarted the server and it is now working. Very strange, the first time we have had this problem.

Thank you for your help.

Peter
0 x


Who is online

Users browsing this forum: No registered users and 2 guests