Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

No SVN data visible in projects and a java.sql.SQLException is thrown Edited

I upgraded from Jira 6.4.14 to 7.0.11 and also upgraded the plugin from7.2.0-jira-6 to 8.5.4 on a test instance. The registered repositories on the add-ons page are showing the index data is updating and keeping in sync with changes in the SVN repos. i.e. the index number shown for projects matches the version in the SVN commit log and the production site.

Individual Jira issue show there SVN data and the subversion browser shows data correctly. I can search for issues using JQL and svn function and get data returned.


However on any project the SVN sumamry data on the project's navigation sidebar says "No commits were found!"

 

In the catalina log there is an exception when accessing the sidebar.

How do i get the data showing up again?

 



2019-08-30 10:24:39,109 http-nio-9080-exec-22 ERROR mcaljamj 624x1268x1 qpc9ws 10.114.18.159 /projects/PPCIRCA [c.k.j.p.e.subversion.reporting.Sql4JiraMgr]
2019-08-30 10:24:39,112 http-nio-9080-exec-22 ERROR mcaljamj 624x1268x1 qpc9ws 10.114.18.159 /projects/PPCIRCA [c.k.j.p.e.subversion.projecttabpanels.SubversionProjectTabPanel] There' a problem with the subversion plugin.
java.sql.SQLException
        at com.kintosoft.jira.plugin.ext.subversion.reporting.Sql4JiraMgr.getConnection(Sql4JiraMgr.java:117)
        at com.kintosoft.svnwebclient.jira.SWCUtils.getLogEntriesByJQL(SWCUtils.java:889)
        at com.kintosoft.svnwebclient.jira.SWCUtils.getLogEntriesByProject(SWCUtils.java:1116)
        at com.kintosoft.jira.plugin.ext.subversion.projecttabpanels.SubversionProjectTabPanel.getRecentCommits(SubversionProjectTabPanel.java:192)
        at com.kintosoft.jira.plugin.ext.subversion.projecttabpanels.SubversionProjectTabPanel.getHtml(SubversionProjectTabPanel.java:139)
        at com.atlassian.jira.projects.tabpanel.TabPanelWebPanelRenderer.renderPanel(TabPanelWebPanelRenderer.java:78)
        at com.atlassian.jira.projects.tabpanel.TabPanelWebPanelRenderer.access$000(TabPanelWebPanelRenderer.java:28)
        at com.atlassian.jira.projects.tabpanel.TabPanelWebPanelRenderer$1.visit(TabPanelWebPanelRenderer.java:63)
        at com.atlassian.jira.projects.tabpanel.TabPanelWebPanelRenderer$1.visit(TabPanelWebPanelRenderer.java:59)
        at com.atlassian.ozymandias.SafePluginPointAccess.invokeModule(SafePluginPointAccess.java:452)
        at com.atlassian.ozymandias.SafePluginPointAccess.descriptors(SafePluginPointAccess.java:150)
        at com.atlassian.jira.projects.tabpanel.TabPanelWebPanelRenderer.render(TabPanelWebPanelRenderer.java:58)
        at com.atlassian.plugin.web.model.ResourceTemplateWebPanel.writeHtml(ResourceTemplateWebPanel.java:50)
        at com.atlassian.plugin.web.descriptors.DefaultWebPanelModuleDescriptor$ContextAwareWebPanel.writeHtml(DefaultWebPanelModuleDescriptor.java:149)
        at com.atlassian.jira.projects.util.WebPanelRenderer.renderWebPanels(WebPanelRenderer.java:44)
        at com.atlassian.jira.projects.util.WebPanelRenderer.renderWebPanels(WebPanelRenderer.java:68)
        at com.atlassian.jira.projects.page.ProjectWebPanelRenderer.renderTabPanels(ProjectWebPanelRenderer.java:66)
        at com.atlassian.jira.projects.page.ProjectWebPanelRenderer.render(ProjectWebPanelRenderer.java:51)
        at com.atlassian.jira.projects.page.ProjectPageRenderer.render(ProjectPageRenderer.java:87)
        at com.atlassian.jira.projects.page.ProjectPageRenderer.renderWithSidebar(ProjectPageRenderer.java:62)
        at com.atlassian.jira.projects.page.ProjectPageServlet.getRenderResult(ProjectPageServlet.java:152)
        at com.atlassian.jira.projects.page.ProjectPageServlet.renderItem(ProjectPageServlet.java:135)
        at com.atlassian.jira.projects.page.ProjectPageServlet.doGet(ProjectPageServlet.java:105)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:618)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
        at com.atlassian.plugin.servlet.DelegatingPluginServlet.service(DelegatingPluginServlet.java:42)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
        at com.atlassian.plugin.servlet.ServletModuleContainerServlet.service(ServletModuleContainerServlet.java:52)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
        ... 43 filtered
        at com.atlassian.jira.software.internal.filters.ReleasesPageAccessControlFilter.doFilter(ReleasesPageAccessControlFilter.java:73)
        ... 109 filtered
        at com.atlassian.jira.projects.servlet.ReKeyedProjectFilter.doFilter(ReKeyedProjectFilter.java:54)
        ... 98 filtered
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:748)

1 answer

1 accepted

0 votes
Answer accepted

kintosoft support gave me the solution ...

uninstall the SQL+JQL Driver add-on
reinstall the SQL+JQL Driver add-on
re-enable the subversion ALM add-on

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

5 mobile apps for Jira Cloud to boost productivity

  It’s very important to have access to the workflow process from anywhere. Especially if you manage the work of others. There is no difference whether you’re out of office, or drive a ca...

260 views 2 5
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you