Error starting the server 5.0.1

Post any questions you have about using the Verj.io Studio, including client and server-side programming with Javascript or FPL, and integration with databases, web services etc.

Moderators: Jon, Steve, Ian, Dave

mkushwaha
Ebase User
Posts: 29
Joined: Mon Nov 02, 2015 7:19 pm

Error starting the server 5.0.1

#1

Postby mkushwaha » Wed May 04, 2016 12:56 pm

Code: Select all

Tue May 03 20:42:29:  Failed while enacting node:  unknown: Failed to get database connection: 
Tue May 03 20:42:29: INFO Transaction rolled back
May 03, 2016 8:42:30 PM org.enhydra.jdbc.util.Logger error
SEVERE: GenericPool:getFromPool Error Exception in GenericPool:getFromPool
java.sql.SQLException: Cannot get connection for URL jdbc:derby:UFS;create=false : Database 'UFS' not found.
	at org.enhydra.jdbc.standard.StandardDataSource.getConnection(StandardDataSource.java:216)
	at org.enhydra.jdbc.standard.StandardPooledConnection.<init>&#40;StandardPooledConnection.java&#58;65&#41;
	at org.enhydra.jdbc.standard.StandardXAConnection.<init>&#40;StandardXAConnection.java&#58;81&#41;
	at org.enhydra.jdbc.standard.StandardXADataSource.getXAConnection&#40;StandardXADataSource.java&#58;110&#41;
	at org.enhydra.jdbc.pool.StandardXAPoolDataSource.create&#40;StandardXAPoolDataSource.java&#58;159&#41;
	at org.enhydra.jdbc.pool.GenericPool.getFromPool&#40;GenericPool.java&#58;253&#41;
	at org.enhydra.jdbc.pool.GenericPool.checkOut&#40;GenericPool.java&#58;357&#41;
	at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection&#40;StandardPoolDataSource.java&#58;194&#41;
	at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection&#40;StandardPoolDataSource.java&#58;164&#41;
	at sun.reflect.GeneratedMethodAccessor38.invoke&#40;Unknown Source&#41;
	at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;43&#41;
	at java.lang.reflect.Method.invoke&#40;Method.java&#58;497&#41;
	at net.bull.javamelody.JdbcWrapper$3.invoke&#40;JdbcWrapper.java&#58;788&#41;
	at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke&#40;JdbcWrapper.java&#58;285&#41;
	at com.sun.proxy.$Proxy3.getConnection&#40;Unknown Source&#41;
	at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getPooledConnection&#40;DatabaseConnectionPoolFactory.java&#58;59&#41;
	at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getConnection&#40;DatabaseConnectionPoolFactory.java&#58;43&#41;
	at com.ebasetech.ufs.kernel.RepositoryDatabaseConnectionFactory.getConnection&#40;RepositoryDatabaseConnectionFactory.java&#58;38&#41;
	at com.ebasetech.ufs.utility.PersistenceHelper.getConnection&#40;PersistenceHelper.java&#58;341&#41;
	at com.ebasetech.ufs.utility.PersistenceHelper.getDbType&#40;PersistenceHelper.java&#58;607&#41;
	at com.ebasetech.ufs.utility.PersistenceHelper.chooseDbSpecificString&#40;PersistenceHelper.java&#58;594&#41;
	at com.ebasetech.ufs.workflow.server.dbpersist.WorkItemDbPersist.Top&#40;WorkItemDbPersist.java&#58;172&#41;
	at com.ebasetech.ufs.workflow.server.WorkItem.Top&#40;WorkItem.java&#58;218&#41;
	at com.ebasetech.ufs.workflow.server.enactment.WorkQueue$WorkThread.run&#40;WorkQueue.java&#58;467&#41;
java.sql.SQLException&#58; SQLException in StandardPoolDataSource&#58;getConnection no connection available java.sql.SQLException&#58; Cannot get connection for URL jdbc&#58;derby&#58;UFS;create=false &#58; Database 'UFS' not found.
	at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection&#40;StandardPoolDataSource.java&#58;204&#41;
	at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection&#40;StandardPoolDataSource.java&#58;164&#41;
	at sun.reflect.GeneratedMethodAccessor38.invoke&#40;Unknown Source&#41;
	at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;43&#41;
	at java.lang.reflect.Method.invoke&#40;Method.java&#58;497&#41;
	at net.bull.javamelody.JdbcWrapper$3.invoke&#40;JdbcWrapper.java&#58;788&#41;
	at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke&#40;JdbcWrapper.java&#58;285&#41;
	at com.sun.proxy.$Proxy3.getConnection&#40;Unknown Source&#41;
	at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getPooledConnection&#40;DatabaseConnectionPoolFactory.java&#58;59&#41;
	at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getConnection&#40;DatabaseConnectionPoolFactory.java&#58;43&#41;
	at com.ebasetech.ufs.kernel.RepositoryDatabaseConnectionFactory.getConnection&#40;RepositoryDatabaseConnectionFactory.java&#58;38&#41;
	at com.ebasetech.ufs.utility.PersistenceHelper.getConnection&#40;PersistenceHelper.java&#58;341&#41;
	at com.ebasetech.ufs.utility.PersistenceHelper.getDbType&#40;PersistenceHelper.java&#58;607&#41;
	at com.ebasetech.ufs.utility.PersistenceHelper.chooseDbSpecificString&#40;PersistenceHelper.java&#58;594&#41;
	at com.ebasetech.ufs.workflow.server.dbpersist.WorkItemDbPersist.Top&#40;WorkItemDbPersist.java&#58;172&#41;
	at com.ebasetech.ufs.workflow.server.WorkItem.Top&#40;WorkItem.java&#58;218&#41;
	at com.ebasetech.ufs.workflow.server.enactment.WorkQueue$WorkThread.run&#40;WorkQueue.java&#58;467&#41;
java.sql.SQLException&#58; SQLException in StandardPoolDataSource&#58;getConnection exception&#58; java.sql.SQLException&#58; SQLException in StandardPoolDataSource&#58;getConnection no connection available java.sql.SQLException&#58; Cannot get connection for URL jdbc&#58;derby&#58;UFS;create=false &#58; Database 'UFS' not found.
	at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection&#40;StandardPoolDataSource.java&#58;213&#41;
	at org.enhydra.jdbc.pool.StandardPoolDataSource.getConnection&#40;StandardPoolDataSource.java&#58;164&#41;
	at sun.reflect.GeneratedMethodAccessor38.invoke&#40;Unknown Source&#41;
	at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;43&#41;
	at java.lang.reflect.Method.invoke&#40;Method.java&#58;497&#41;
	at net.bull.javamelody.JdbcWrapper$3.invoke&#40;JdbcWrapper.java&#58;788&#41;
	at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke&#40;JdbcWrapper.java&#58;285&#41;
	at com.sun.proxy.$Proxy3.getConnection&#40;Unknown Source&#41;
	at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getPooledConnection&#40;DatabaseConnectionPoolFactory.java&#58;59&#41;
	at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getConnection&#40;DatabaseConnectionPoolFactory.java&#58;43&#41;
	at com.ebasetech.ufs.kernel.RepositoryDatabaseConnectionFactory.getConnection&#40;RepositoryDatabaseConnectionFactory.java&#58;38&#41;
	at com.ebasetech.ufs.utility.PersistenceHelper.getConnection&#40;PersistenceHelper.java&#58;341&#41;
	at com.ebasetech.ufs.utility.PersistenceHelper.getDbType&#40;PersistenceHelper.java&#58;607&#41;
	at com.ebasetech.ufs.utility.PersistenceHelper.chooseDbSpecificString&#40;PersistenceHelper.java&#58;594&#41;
	at com.ebasetech.ufs.workflow.server.dbpersist.WorkItemDbPersist.Top&#40;WorkItemDbPersist.java&#58;172&#41;
	at com.ebasetech.ufs.workflow.server.WorkItem.Top&#40;WorkItem.java&#58;218&#41;
	at com.ebasetech.ufs.workflow.server.enactment.WorkQueue$WorkThread.run&#40;WorkQueue.java&#58;467&#41;
com.ebasetech.ufs.utility.PersistenceRuntimeException&#58; Failed to get database connection&#58; 
	at com.ebasetech.ufs.utility.PersistenceHelper.getConnection&#40;PersistenceHelper.java&#58;346&#41;
	at com.ebasetech.ufs.utility.PersistenceHelper.getDbType&#40;PersistenceHelper.java&#58;607&#41;
	at com.ebasetech.ufs.utility.PersistenceHelper.chooseDbSpecificString&#40;PersistenceHelper.java&#58;594&#41;
	at com.ebasetech.ufs.workflow.server.dbpersist.WorkItemDbPersist.Top&#40;WorkItemDbPersist.java&#58;172&#41;
	at com.ebasetech.ufs.workflow.server.WorkItem.Top&#40;WorkItem.java&#58;218&#41;
	at com.ebasetech.ufs.workflow.server.enactment.WorkQueue$WorkThread.run&#40;WorkQueue.java&#58;467&#41;
Caused by&#58; com.ebasetech.ufs.utility.PersistenceException&#58; Error getting connection from datasource UFSREPOSITORY, SQLException in StandardPoolDataSource&#58;getConnection exception&#58; java.sql.SQLException&#58; SQLException in StandardPoolDataSource&#58;getConnection no connection available java.sql.SQLException&#58; Cannot get connection for URL jdbc&#58;derby&#58;UFS;create=false &#58; Database 'UFS' not found.
	at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getPooledConnection&#40;DatabaseConnectionPoolFactory.java&#58;80&#41;
	at com.ebasetech.ufs.kernel.DatabaseConnectionPoolFactory.getConnection&#40;DatabaseConnectionPoolFactory.java&#58;43&#41;
	at com.ebasetech.ufs.kernel.RepositoryDatabaseConnectionFactory.getConnection&#40;RepositoryDatabaseConnectionFactory.java&#58;38&#41;
	at com.ebasetech.ufs.utility.PersistenceHelper.getConnection&#40;PersistenceHelper.java&#58;341&#41;
	... 5 more
My ebasetest.xml looks like this:
https://codeshare.io/xTOyi

Any clue where to look ?
0 x

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

#2

Postby Jon » Wed May 04, 2016 1:07 pm

First check whether the database is in the file system: for a standalone server it should be in UfsServer/DB/UFS, for the Integrated Server it should be in UfsClient/IntegratedServer/DB/UFS.

If you can't figure it out, here are some questions:
Which type of server are you using, Standalone or Integrated?
Which database type are you using for the Repository Database? The default is Derby and your error shows that the system is trying to use Derby.
What changed to introduce this error? Have you just upgraded to V5?
0 x

mkushwaha
Ebase User
Posts: 29
Joined: Mon Nov 02, 2015 7:19 pm

#3

Postby mkushwaha » Wed May 04, 2016 2:04 pm

I am new to Ebase 5.0.1

This might have been happening for long. I just noticed this while testing an application. My form wasn't finishing executing completely So I was wondering what was the cause. In the execution log, it just stops at a point.

So I opened sever log for the first time and I see this continuous stream of error printing (the one I posted).

I am using Integrated server. We use oracle here. All out database connection files are inside IntegratedServer\ebasetest\ebaseConf\databases

My DB folder inside Integrated Server was empty except file name derby which had server log details ( containing text "Cleanup action starting
java.sql.SQLException: Database 'UFS' not found").

So I added the original files from another project making sure seg0 folder was empty (it contains data files that are not necessary ?). I restarted the server and I am getting the same error.

Any help would be greatly appreciated as I am still leaning more about Ebase 5
0 x

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

#4

Postby Jon » Wed May 04, 2016 2:45 pm

You should copy all the files in the DB/UFS directory. This database contains runtime workflow data plus some of the things configured in the Server Admin app - particularly users, roles etc. So you may notice some strange effects if you copy a database from another system.
0 x

mkushwaha
Ebase User
Posts: 29
Joined: Mon Nov 02, 2015 7:19 pm

#5

Postby mkushwaha » Wed May 04, 2016 4:09 pm

Thanks Jon. Its fixed now.
0 x


Who is online

Users browsing this forum: No registered users and 16 guests