Hi,
I used Jira for a few days and it was fine, but suddenly the site cannot open and it gives a http 500 error.
Database type: MSSQL 2008 R2
I have checked dbconfig file, all the settings are correct. No problem to open database with same ip address, username and password
dbconfig:
-<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mssql</database-type>
<schema-name>dbo</schema-name>
-<jdbc-datasource>
<url>jdbc:jtds:sqlserver://xx.xx.xx.xx:1433/JiraDB</url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<username>xx</username>
<password>xx</password>
<pool-min-size>20</pool-min-size>
<pool-max-size>20</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<pool-max-idle>20</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
</jdbc-datasource>
</jira-database-config>
No one has changed anything with Database or login or what so ever.
The error messages are:
HTTP Status 500 - org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Cannot open database "JiraDB" requested by the login. The login failed.)
type Exception report
message org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Cannot open database "JiraDB" requested by the login. The login failed.)
description The server encountered an internal error (org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Cannot open database "JiraDB" requested by the login. The login failed.)) that prevented it from fulfilling this request.
exception
com.atlassian.util.concurrent.LazyReference$InitializationException: org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Cannot open database "JiraDB" requested by the login. The login failed.)
com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:149)
com.atlassian.util.concurrent.LazyReference.get(LazyReference.java:112)
com.atlassian.util.concurrent.ResettableLazyReference.get(ResettableLazyReference.java:87)
com.atlassian.jira.config.properties.PropertiesManager.getPropertySet(PropertiesManager.java:27)
com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:268)
com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getString(ApplicationPropertiesImpl.java:50)
com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getEncoding(ApplicationPropertiesImpl.java:113)
com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getContentType(ApplicationPropertiesImpl.java:135)
com.atlassian.jira.web.filters.JiraEncodingFilter.getContentType(JiraEncodingFilter.java:59)
com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:39)
com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:49)
com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:78)
com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:87)
com.atlassian.jira.web.filters.JiraFirstFilter.doFilter(JiraFirstFilter.java:57)
root cause
org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (Cannot open database "JiraDB" requested by the login. The login failed.)
org.ofbiz.core.entity.config.DatasourceInfo.getDatabaseTypeFromJDBCConnection(DatasourceInfo.java:409)
org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:962)
org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:630)
org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:131)
org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:804)
org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:789)
org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:766)
com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.getKeys(OFBizPropertySet.java:82)
com.atlassian.jira.propertyset.PropertySetCache.bulkLoad(PropertySetCache.java:318)
com.atlassian.jira.propertyset.JiraCachingPropertySet$12.run(JiraCachingPropertySet.java:785)
com.atlassian.jira.propertyset.JiraCachingPropertySet.doLocked(JiraCachingPropertySet.java:846)
com.atlassian.jira.propertyset.JiraCachingPropertySet.init(JiraCachingPropertySet.java:770)
com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:58)
com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:31)
com.atlassian.jira.config.properties.PropertySetUtils.createDatabaseBackedPropertySet(PropertySetUtils.java:34)
com.atlassian.jira.config.properties.DbBackedPropertiesManager$1.create(DbBackedPropertiesManager.java:26)
com.atlassian.jira.config.properties.DbBackedPropertiesManager$1.create(DbBackedPropertiesManager.java:22)
com.atlassian.util.concurrent.ResettableLazyReference$InternalReference.create(ResettableLazyReference.java:140)
com.atlassian.util.concurrent.LazyReference$Sync.run(LazyReference.java:321)
com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:143)
com.atlassian.util.concurrent.LazyReference.get(LazyReference.java:112)
com.atlassian.util.concurrent.ResettableLazyReference.get(ResettableLazyReference.java:87)
com.atlassian.jira.config.properties.PropertiesManager.getPropertySet(PropertiesManager.java:27)
com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:268)
com.atlassian.jira.config.properties.ApplicationPropertiesStore.getString(ApplicationPropertiesStore.java:346)
com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getDefaultBackedString(ApplicationPropertiesImpl.java:60)
com.atlassian.jira.security.auth.trustedapps.UserNameTransformer$ApplicationPropertiesClassNameRetriever.get(UserNameTransformer.java:68)
com.atlassian.jira.security.auth.trustedapps.UserNameTransformer$Factory.get(UserNameTransformer.java:99)
com.atlassian.jira.security.auth.trustedapps.TrustedApplicationFilter$OSUserResolver.<init>(TrustedApplicationFilter.java:40)
com.atlassian.jira.security.auth.trustedapps.TrustedApplicationFilter.<init>(TrustedApplicationFilter.java:25)
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
java.lang.reflect.Constructor.newInstance(Unknown Source)
java.lang.Class.newInstance(Unknown Source)
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
java.util.concurrent.FutureTask.run(Unknown Source)
java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
java.lang.Thread.run(Unknown Source)