Error Connection with Database

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!Error while connecting with DB.pngDbConfig.Xml.png

 

 

2 answers

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

0 votes

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.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,889 views 12 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot