Hello All,
My JIRA machine got shutdown due to a cable issue and after the machine was brought back, I am facing below isssue.
Can someone suggest the solution?
HTTP Status 500 - Could not determine database type. (error in script file line: 487551 java.io.IOException: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff])
type Exception report
message Could not determine database type. (error in script file line: 487551 java.io.IOException: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff])
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (error in script file line: 487551 java.io.IOException: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff])
org.ofbiz.core.entity.config.DatasourceInfo.getDatabaseTypeFromJDBCConnection(DatasourceInfo.java:409)
org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:831)
org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:730)
org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:150)
org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:901)
org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:879)
org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:848)
com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.findPropertyEntry(OFBizPropertySet.java:298)
com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.exists(OFBizPropertySet.java:170)
com.atlassian.jira.propertyset.JiraCachingPropertySet.exists(JiraCachingPropertySet.java:744)
com.atlassian.jira.propertyset.BootstrapOfBizPropertyEntryStore.getEntry(BootstrapOfBizPropertyEntryStore.java:62)
com.atlassian.jira.propertyset.CachingOfBizPropertySet.get(CachingOfBizPropertySet.java:202)
com.opensymphony.module.propertyset.AbstractPropertySet.getString(AbstractPropertySet.java:305)
com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:272)
com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getString(ApplicationPropertiesImpl.java:57)
com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getEncoding(ApplicationPropertiesImpl.java:138)
com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getContentType(ApplicationPropertiesImpl.java:162)
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:79)
com.atlassian.jira.web.filters.MultipartBoundaryCheckFilter.doFilter(MultipartBoundaryCheckFilter.java:41)
com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:87)
com.atlassian.jira.web.filters.JiraFirstFilter.doFilter(JiraFirstFilter.java:61)
com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:121)
com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:92)
com.atlassian.jira.web.filters.gzip.JiraGzipFilter.doFilter(JiraGzipFilter.java:56)
root cause
java.sql.SQLException: error in script file line: 487551 java.io.IOException: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
org.hsqldb.jdbc.Util.sqlException(Unknown Source)
org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
org.hsqldb.jdbcDriver.getConnection(Unknown Source)
org.hsqldb.jdbcDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:87)
org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:146)
org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:136)
org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)
org.ofbiz.core.entity.config.DatasourceInfo.getDatabaseTypeFromJDBCConnection(DatasourceInfo.java:402)
org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:831)
org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:730)
org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:150)
org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:901)
org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:879)
org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:848)
com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.findPropertyEntry(OFBizPropertySet.java:298)
com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.exists(OFBizPropertySet.java:170)
com.atlassian.jira.propertyset.JiraCachingPropertySet.exists(JiraCachingPropertySet.java:744)
com.atlassian.jira.propertyset.BootstrapOfBizPropertyEntryStore.getEntry(BootstrapOfBizPropertyEntryStore.java:62)
com.atlassian.jira.propertyset.CachingOfBizPropertySet.get(CachingOfBizPropertySet.java:202)
com.opensymphony.module.propertyset.AbstractPropertySet.getString(AbstractPropertySet.java:305)
com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:272)
com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getString(ApplicationPropertiesImpl.java:57)
com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getEncoding(ApplicationPropertiesImpl.java:138)
com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getContentType(ApplicationPropertiesImpl.java:162)
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:79)
com.atlassian.jira.web.filters.MultipartBoundaryCheckFilter.doFilter(MultipartBoundaryCheckFilter.java:41)
com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:87)
com.atlassian.jira.web.filters.JiraFirstFilter.doFilter(JiraFirstFilter.java:61)
com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:121)
com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:92)
com.atlassian.jira.web.filters.gzip.JiraGzipFilter.doFilter(JiraGzipFilter.java:56)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.55 logs.
Apache Tomcat/7.0.55
