Error Connection with Database

[venugopal123]

Hi, 

I have migrated jira in Linux Environment and i map the Jira home directory & Dbconfig.Xml to New JIRA . But its still asking the Application Properties UI of JIRA server in Browser . Suppose if it really reads the data from database it should not ask for the remaind details sucha as application properties , setup db etc..

But here its asking for application proprties why am not getting . 

I have check the catalina.out log file : here "Error importing the data: could not find the column 'Exclude_issue_details' in previously parsed query '"

Please find the attached Screenshot of error message,Dbconfig.xml  and log messages .Please help me to fix this.Yur quick response is highly appreciated

Catalina.out:

2017-10-03 16:30:02,091 http-nio-8080-exec-3 INFO anonymous 990x4x1 1rs9oji 199.63.92.5 /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Running JIRA Data Import...
2017-10-03 16:30:02,111 http-nio-8080-exec-3 INFO anonymous 990x4x1 1rs9oji 199.63.92.5 /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing XML data...
2017-10-03 16:30:02,199 http-nio-8080-exec-3 DEBUG anonymous 990x4x1 1rs9oji 199.63.92.5 /secure/SetupDatabase!default.jspa [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] startCleaning
2017-10-03 16:30:02,282 http-nio-8080-exec-3 DEBUG anonymous 990x4x1 1rs9oji 199.63.92.5 /secure/SetupDatabase!default.jspa [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] stopCleaning
2017-10-03 16:30:02,282 http-nio-8080-exec-3 ERROR anonymous 990x4x1 1rs9oji 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 16:30:02,304 http-nio-8080-exec-3 INFO anonymous 990x4x1 1rs9oji 199.63.92.5 /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] JIRA Data Import has finished.
2017-10-03 16:30:02,304 http-nio-8080-exec-3 ERROR anonymous 990x4x1 1rs9oji 199.63.92.5 /secure/SetupDatabase!default.jspa [c.a.jira.startup.DatabaseInitialImporter]
2017-10-03 16:30:02,305 http-nio-8080-exec-3 ERROR anonymous 990x4x1 1rs9oji 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!

[Nic Brough -Adaptavist-]

Also check if you're running this stuff as "root".  It should not be run as root, and if you do run it that way, it clobbers all sorts of stuff.

[scherbank]

I would suggest to check db user permissions. The issue doesn't look like that but it cost nothing to check that.