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

[James McAllister]

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)

[James McAllister · Accepted solution]

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