Service Desk: Internal Server error.

[tech support]

I can no longer access my service desk instance.

service desk login error.PNG

I have tried to restart the JIRA service, reboot the server etc.

What are my options from here? Is the database corrupted? Is there a way to fix the connection/errors from the terminal?

Here is an output of the catalina.out file:

 >>tail -100 catalina.out

Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-185]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.message.DbException.convert(DbException.java:295)
at org.h2.engine.Database.openDatabase(Database.java:297)
at org.h2.engine.Database.<init>(Database.java:260)
at org.h2.engine.Engine.openSession(Engine.java:167)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145)
at org.h2.engine.Engine.createSession(Engine.java:128)
at org.h2.engine.Engine.createSession(Engine.java:26)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:347)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92)
at org.h2.Driver.connect(Driver.java:72)
at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39)
at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256)
at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2301)
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2287)
... 47 more
Caused by: java.lang.NullPointerException
at org.h2.mvstore.db.ValueDataType.compare(ValueDataType.java:102)
at org.h2.mvstore.MVMap.compare(MVMap.java:708)
at org.h2.mvstore.Page.binarySearch(Page.java:333)
at org.h2.mvstore.MVMap.binarySearch(MVMap.java:461)
at org.h2.mvstore.MVMap.get(MVMap.java:450)
at org.h2.mvstore.db.TransactionStore.rollbackTo(TransactionStore.java:485)
at org.h2.mvstore.db.TransactionStore$Transaction.rollback(TransactionStore.java:782)
at org.h2.mvstore.db.MVTableEngine$Store.initTransactions(MVTableEngine.java:226)
at org.h2.engine.Database.open(Database.java:736)
at org.h2.engine.Database.openDatabase(Database.java:266)
... 61 more
2016-11-30 19:49:39,079 http-nio-8080-exec-7 ERROR [NoModule] Could not determine database type.
org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-185]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.message.DbException.convert(DbException.java:295)
at org.h2.engine.Database.openDatabase(Database.java:297)
at org.h2.engine.Database.<init>(Database.java:260)
at org.h2.engine.Engine.openSession(Engine.java:60)
at org.h2.engine.Engine.openSession(Engine.java:167)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145)
at org.h2.engine.Engine.createSession(Engine.java:128)
at org.h2.engine.Engine.createSession(Engine.java:26)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:347)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92)
at org.h2.Driver.connect(Driver.java:72)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:87)
at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:164)
at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:136)
at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)
at org.ofbiz.core.entity.config.DatasourceInfo.getDatabaseTypeFromJDBCConnection(DatasourceInfo.java:402)
at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:831)
at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:730)
at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:150)
at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:903)
at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:881)
at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:850)
at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.findPropertyEntry(OFBizPropertySet.java:298)
at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.exists(OFBizPropertySet.java:170)
at com.atlassian.jira.propertyset.JiraCachingPropertySet.exists(JiraCachingPropertySet.java:566)
at com.atlassian.jira.propertyset.BootstrapOfBizPropertyEntryStore.getType(BootstrapOfBizPropertyEntryStore.java:67)
at com.atlassian.jira.propertyset.CachingOfBizPropertySet.exists(CachingOfBizPropertySet.java:139)
at com.atlassian.jira.config.properties.ApplicationPropertiesStore.getOption(ApplicationPropertiesStore.java:157)
at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getOption(ApplicationPropertiesImpl.java:85)
... 22 filtered
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
at org.h2.mvstore.db.ValueDataType.compare(ValueDataType.java:102)
at org.h2.mvstore.MVMap.compare(MVMap.java:708)
at org.h2.mvstore.Page.binarySearch(Page.java:333)
at org.h2.mvstore.MVMap.binarySearch(MVMap.java:461)
at org.h2.mvstore.MVMap.get(MVMap.java:450)
at org.h2.mvstore.db.TransactionStore.rollbackTo(TransactionStore.java:485)
at org.h2.mvstore.db.TransactionStore$Transaction.rollback(TransactionStore.java:782)
at org.h2.mvstore.db.MVTableEngine$Store.initTransactions(MVTableEngine.java:226)
at org.h2.engine.Database.open(Database.java:736)
at org.h2.engine.Database.openDatabase(Database.java:266)

service desk login error.PNG

[Nic Brough -Adaptavist-]

I think you've got a damaged database there.  I'm not sure there's a way to recover it either.  Howver, work your way back up the log until the first error and check what that says, it might have a better pointer.

[tech support]

2016-11-30 19:49:39,079 http-nio-8080-exec-7 ERROR [NoModule] Could not determine database type >>how can we reload the db?