New and Improved 3.13 Beta. Highlights: Shareable filters and dashboards and lots of other goodies. Any feedback can be raised as JIRA issues in the JIRA project.
Issue Details (XML | Word | Printable)

Key: JRA-8471
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Critical Critical
Assignee: Unassigned
Reporter: Gene Gotimer
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
JIRA

Bugzilla 2.16 import fails with exception

Created: 10/Nov/05 09:38 AM   Updated: 30/Jul/06 07:37 PM
Component/s: Import / Export
Affects Version/s: 3.4
Fix Version/s: 3.4.1

Time Tracking:
Not Specified

File Attachments: 1. Text File bugzilla-exception.txt (5 kB)
2. Zip Archive BugzillaImportBeanClasses.zip (21 kB)
Environment: Standalone Enterprise on SuSE Linux 9.1, using PostgreSQL 4.0.2. Importing from Bugzilla 2.16.7 on the same system running MySQL 4.0.23a.

Participants: Eric Weiss, Gene Gotimer, Jeff Turner [Atlassian] and Mark Chaimungkalanont [Atlassian]
Since last comment: 2 years, 40 weeks, 4 days ago
Resolution Date: 14/Nov/05 06:10 PM
Labels:


 Description  « Hide
When I tried to import a Bugzilla project into Enterprise 3.4, I got an exception (attached).

I was previously able to import the same project on the same server, using the same database drivers, into Enterprise 3.3.1.

I am using mysql-connector-java-3.1.10-bin.jar and postgresql-8.0-312.jdbc3.jar drivers.

 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
[ Permlink | « Hide ]
Gene Gotimer added a comment - 10/Nov/05 09:54 AM
More information: When I previously imported the project, I was using hsql, not postgres.

[ Permlink | « Hide ]
Mark Chaimungkalanont [Atlassian] added a comment - 10/Nov/05 07:30 PM
Gene,

JIRA 3.4 has been updated to work for Bugzilla 2.17, which unfortunately broke some older imports.

I'll attach a class file that you can patch at com\atlassian\jira\util\BugzillaImportBean.class and see if it works

Cheers

Mark C


[ Permlink | « Hide ]
Mark Chaimungkalanont [Atlassian] added a comment - 10/Nov/05 07:34 PM
Please unzip this into the com\atlassian\jira\util directory and see how you go

[ Permlink | « Hide ]
Jeff Turner [Atlassian] added a comment - 14/Nov/05 06:10 PM
The change has been made in JIRA 3.4.1, which hopefully resolves this problem. Please let us know if you still have troubles with 3.4.1 and we'll reopen this.

[ Permlink | « Hide ]
Eric Weiss added a comment - 17/Nov/05 03:04 PM
I am getting the same exception, and I am running 3.4.1. What now?

[ Permlink | « Hide ]
Eric Weiss added a comment - 17/Nov/05 03:29 PM
Followup to previoius....
I am getting the same error. I run Jira 3.4.1, Mysql 5.0.15, mysql-connector-java-3.1.10-bin.jar

Errors

  • Error importing data from bugzilla: java.sql.SQLException: Column 'product_id' not found. at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:910) at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2353) at com.atlassian.jira.util.BugzillaImportBean.getProductName(BugzillaImportBean.java:666) at com.atlassian.jira.util.BugzillaImportBean.createVersions(BugzillaImportBean.java:738) at com.atlassian.jira.util.BugzillaImportBean.create(BugzillaImportBean.java:195) at com.atlassian.jira.web.action.util.BugzillaImport.doRun(BugzillaImport.java:150) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:61) at webwork.util.InjectionUtils.invoke(InjectionUtils.java:52) at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:417) at webwork.action.ActionSupport.execute(ActionSupport.java:146) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:51) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:178) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:177) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678) at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)

[ Permlink | « Hide ]
Mark Chaimungkalanont [Atlassian] added a comment - 17/Nov/05 11:54 PM
Sorry about that, can you try apply the patch by unzipping the class files to

classes\com\atlassian\jira\util

directory?


[ Permlink | « Hide ]
Mark Chaimungkalanont [Atlassian] added a comment - 17/Nov/05 11:55 PM
Sorry about the hassle, we don't actually have a 2.16 version we can test on, just 2.17


Powered by Atlassian JIRA the Professional Issue Tracker. (Enterprise Edition, Version: 3.13_beta1-#328) - Bug/feature request - Atlassian news - Contact Administrators