Hi,
Thanks for the reply. Now am able to access the JIra UI in Browser. But i have mapped the jira to restored database . But its not reading the data. Its asking for application properties and database setup . Am not getting why its asking for again. I am just pasting the catalina.out log file . Please find the below details and please help to to come out of this
Catalina .out:
***********************************
___ FAILED PLUGIN REPORT _____________________
1 plugin failed to load during JIRA startup.
'com.atlassian.jira.plugins.jira-healthcheck-plugin' - 'Atlassian JIRA - Plugins - Instance Health Plugin' failed to load.
Cannot start plugin: com.atlassian.jira.plugins.jira-healthcheck-plugin
Unresolved constraint in bundle com.atlassian.jira.plugins.jira-healthcheck-plugin [89]: Unable to resolve 89.0: missing requirement [89.0] osgi.wiring.package; (&(osgi.wiring.package=com.atlassian.support.healthcheck)(version>=2.0.11))
It was loaded from /data/apps/jira7.2.1/atlassian-jira/WEB-INF/atlassian-bundled-plugins/jira-healthcheck-plugin-2.1.14.jar
********************************************************************************************************************************************************************************************************
2017-10-03 13:31:34,153 JIRA-Bootstrap INFO [c.a.jira.startup.DefaultInstantUpgradeManager] Late startup launchers took 1s
2017-10-03 13:31:34,157 JIRA-Bootstrap INFO [c.a.jira.startup.LauncherContextListener] Memory Usage:
---------------------------------------------------------------------------------
Heap memory : Used: 941 MiB. Committed: 2185 MiB. Max: 4007 MiB
Non-heap memory : Used: 203 MiB. Committed: 222 MiB. Max: 1264 MiB
---------------------------------------------------------------------------------
TOTAL : Used: 1144 MiB. Committed: 2407 MiB. Max: 5271 MiB
---------------------------------------------------------------------------------
2017-10-03 13:31:34,886 http-nio-8080-exec-19 INFO anonymous 811x3x1 1al0g13 199.63.92.5 /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Running JIRA Data Import...
2017-10-03 13:31:34,908 http-nio-8080-exec-19 INFO anonymous 811x3x1 1al0g13 199.63.92.5 /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing XML data...
2017-10-03 13:31:35,032 http-nio-8080-exec-19 DEBUG anonymous 811x3x1 1al0g13 199.63.92.5 /secure/SetupDatabase!default.jspa [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] startCleaning
2017-10-03 13:31:35,079 http-nio-8080-exec-19 DEBUG anonymous 811x3x1 1al0g13 199.63.92.5 /secure/SetupDatabase!default.jspa [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] stopCleaning
2017-10-03 13:31:35,079 http-nio-8080-exec-19 ERROR anonymous 811x3x1 1al0g13 199.63.92.5 /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Error importing data: java.lang.IllegalStateException: Could not find column 'EXCLUDE_ISSUE_DETAILS' in previously parsed query!
java.lang.IllegalStateException: Could not find column 'EXCLUDE_ISSUE_DETAILS' in previously parsed query!
at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:118)
at net.java.ao.schema.ddl.SchemaReader.readFields(SchemaReader.java:126)
at net.java.ao.schema.ddl.SchemaReader.readTable(SchemaReader.java:110)
at net.java.ao.schema.ddl.SchemaReader.access$000(SchemaReader.java:62)
at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:99)
at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:97)
at com.google.common.collect.Iterators$8.transform(Iterators.java:799)
at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48)
at com.google.common.collect.Iterators.addAll(Iterators.java:362)
at com.google.common.collect.Lists.newArrayList(Lists.java:160)
at com.google.common.collect.Lists.newArrayList(Lists.java:144)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:97)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:88)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:81)
at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.doCleanup(ActiveObjectsDatabaseCleaner.java:58)
at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.cleanup(ActiveObjectsDatabaseCleaner.java:45)
at com.atlassian.activeobjects.backup.ActiveObjectsBackup.clear(ActiveObjectsBackup.java:160)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.removeActiveObjects(DefaultDataImportService.java:984)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:704)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:324)
at com.atlassian.jira.startup.DatabaseInitialImporter.importInitialData(DatabaseInitialImporter.java:56)
at com.atlassian.jira.startup.DatabaseInitialImporter.importInitialData(DatabaseInitialImporter.java:48)
at com.atlassian.jira.web.action.setup.SetupDatabase.doDefault(SetupDatabase.java:141)
... 3 filtered
at java.lang.reflect.Method.invoke(Method.java:498)
at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:70)
at webwork.util.InjectionUtils.invoke(InjectionUtils.java:56)
... 2 filtered
at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)
... 7 filtered
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
... 56 filtered
at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
... 58 filtered
at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:76)
... 1 filtered
at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:74)
... 36 filtered
at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
... 10 filtered
at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
... 4 filtered
at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)
... 29 filtered
at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
... 27 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)
2017-10-03 13:31:35,093 http-nio-8080-exec-19 INFO anonymous 811x3x1 1al0g13 199.63.92.5 /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] JIRA Data Import has finished.
2017-10-03 13:31:35,094 http-nio-8080-exec-19 ERROR anonymous 811x3x1 1al0g13 199.63.92.5 /secure/SetupDatabase!default.jspa [c.a.jira.startup.DatabaseInitialImporter]
2017-10-03 13:31:35,094 http-nio-8080-exec-19 ERROR anonymous 811x3x1 1al0g13 199.63.92.5 /secure/SetupDatabase!default.jspa [c.a.jira.startup.DatabaseInitialImporter] Error importing data: java.lang.IllegalStateException: Could not find column 'EXCLUDE_ISSUE_DETAILS' in previously parsed query!
2017-10-03 13:31:35,161 Modification Check:thread-1 INFO [c.a.jira.startup.JiraStartupLogger]
___ Modifications ___________________________
Modified Files : jira-application.properties
Removed Files : None
2017-10-03 13:31:51,156 Timer-0 DEBUG [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] getService bundle [com.atlassian.plugin.automation.automation-module]
Hi Venu,
There are a few possible causes for this per Database operation in JIRA fails with "Could not find column <column_name> in previously parsed query":
dba or 'SELECT ANY TABLE'
) to the user that JIRA uses to connect with the database could cause the same problem as well.Each JIRA instance must have its own database on the database server. Running multiple JIRA instances against the same database, although using individual schemas will not work.
At this point try the following:
Cheers,
Branden
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.