Even after i mapped the JIRA to Existing Database .. JIra is not reading data

[venugopal123]

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]

[somethingblue]

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":

• Two JIRA instances are connecting to the same database, but individual database schemas. Each individual JIRA instance requires its own database on the database server. See more on our documentation for steps on connecting JIRA to Microsoft SQL Server:
  • Connecting JIRA to SQL Server 2012
  • Connecting JIRA to SQL Server 2008
  • Connecting JIRA to SQL Server 2005
• If using Oracle database, granting additional permission (such as dba or 'SELECT ANY TABLE') to the user that JIRA uses to connect with the database could cause the same problem as well.
• Also in Oracle, please check if the user JIRA is configured to connect the database has permissions as described here and also access permission to the tablespace.
• This could also be caused by two database schemas being referenced in the same database. If this is the case, please follow the steps in this KB article to alter the schema directly in the database.

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:

1. Verify there are no other JIRA instance's attached to this database
2. Delete the dbconfig.xml
3. Run the JIRA application configuration tool to connect the existing database
4. Start JIRA

Cheers,

Branden