Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

jira 8.3.3 SQLServerException: Invalid object name 'fileattachment

cava cavamagie September 12, 2019

every 5 minutes in atlassian-jira.log

obtain:

 

2019-09-12 10:56:16,688 pool-11-thread-1 ERROR [r.a.a.p.promjiraexporter.service.ScheduledMetricEvaluator] Failed to resolve attachments size.
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'fileattachment'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:256)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1621)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:868)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:768)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2930)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:693)
at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at ru.andreymarkelov.atlas.plugins.promjiraexporter.service.ScheduledMetricEvaluatorImpl.calculateAttachmentSize(ScheduledMetricEvaluatorImpl.java:105)
at ru.andreymarkelov.atlas.plugins.promjiraexporter.service.ScheduledMetricEvaluatorImpl.access$000(ScheduledMetricEvaluatorImpl.java:24)
at ru.andreymarkelov.atlas.plugins.promjiraexporter.service.ScheduledMetricEvaluatorImpl$1.run(ScheduledMetricEvaluatorImpl.java:97)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

1 answer

0 votes
Rakesh Kumar
Contributor
September 12, 2019

Hi Cava,

 

What is the version of "Prometheus Exporter for Jira" you are using in your current JIRA Instance ? This error could be because of not using the compatible version of this plugin in your JIRA instance.

 

Regards,

Rakesh

cava cavamagie September 12, 2019

hi 

version: 1.0.30-jira8 

 

many thanks

Rakesh Kumar
Contributor
September 12, 2019

Hi Cava,

 

You may need to upgrade this plugin to version "1.0.31-jira8". I can see in its compatibility details, this latest version is compatible with JIRA versions "8.0.0 - 8.4.0".

 

Regards,

Rakesh

Rakesh Kumar
Contributor
September 15, 2019

Hi Cava,

Request you to accept the answer if it resolved your issue. :) 

Regards,

Rakesh

Suggest an answer

Log in or Sign up to answer