jira 7: jira_total_attachments_gauge shows 0 as value

[AwraamFanariotis]

Hello everyone,

for jira 7 the total attachment size gauge shows 0 as value
metrics page:

• HELP jira_total_attachment_size_gauge Total Attachments Size Gauge
• TYPE jira_total_attachment_size_gauge gauge
  jira_total_attachment_size_gauge 0.0

In the jira logs the following is shown:
2019-09-02 15:07:09,358 pool-67-thread-1 ERROR jira-internal-sysadmin 574x1815x1 1uvdfio 53.18.156.27:24648,127.0.0.1 /rest/plugins/1.0/ [r.a.a.p.promjiraexporter.service.ScheduledMetricEvaluator] Failed to resolve attachments size.
com.microsoft.sqlserver.jdbc.SQLServerException: invalid object name "fileattachment".

Is this metric bugged or is it only availabe in jira 8 exporter? On older versions (1.0.27) this seems to work fine.

Jira is installed on a MS Server. Database is mssql.

BR

[AndreyVMarkelov]

Hi @AwraamFanariotis
Please check what value is set here:
https://filebin.ca/4ugetpW760iR/2019-09-120.03.33.png

[AwraamFanariotis]

Hi @AndreyVMarkelov
The value is set to 1 Minute, just like in your picture.
BR

[AndreyVMarkelov]

Could you check a log file please? пн, 16 сент. 2019 г. в 9:38, AwraamFanariotis <[email protected]>:

Hi @AndreyVMarkelov <https://github.com/AndreyVMarkelov> The value is set to 1 Minute, just like in your picture. BR — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#56?email_source=notifications&email_token=AAPXM4E53Q3AMP3O4L7QTQ3QJ4ZZDA5CNFSM4ITD2NO2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD6YKTIY#issuecomment-531671459>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAPXM4HWXVCHMBULRB7YGELQJ4ZZDANCNFSM4ITD2NOQ> .

-- *-- Andrey Markelov*

[AwraamFanariotis]

The jira logs show the following error:
2019-09-02 15:07:09,358 pool-67-thread-1 ERROR jira-internal-sysadmin 574x1815x1 1uvdfio 53.18.156.27:24648,127.0.0.1 /rest/plugins/1.0/ [r.a.a.p.promjiraexporter.service.ScheduledMetricEvaluator] Failed to resolve attachments size.
com.microsoft.sqlserver.jdbc.SQLServerException: invalid object name "fileattachment".

BR

[AndreyVMarkelov]

Ah sqlserver Sorry I will fix it Which Jira is used? вт, 17 сент. 2019 г. в 9:00, AwraamFanariotis <[email protected]>:

The jira logs show the following error: 2019-09-02 15:07:09,358 pool-67-thread-1 ERROR jira-internal-sysadmin 574x1815x1 1uvdfio 53.18.156.27:24648,127.0.0.1 /rest/plugins/1.0/ [r.a.a.p.promjiraexporter.service.ScheduledMetricEvaluator] Failed to resolve attachments size. com.microsoft.sqlserver.jdbc.SQLServerException: invalid object name "fileattachment". BR — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#56?email_source=notifications&email_token=AAPXM4FKA5DP2AS5JCHI25TQKB6BFA5CNFSM4ITD2NO2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD63QRJA#issuecomment-532088996>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAPXM4EZE2RLNR6KEQLXWG3QKB6BFANCNFSM4ITD2NOQ> .

-- *-- Andrey Markelov*

[AwraamFanariotis]

Hey no Problem :)
Jiraversion 7.13.6

BR

[ricardoecore]

Hello,
I'm getting same error on Jira Datacenter 7.13.9. How do we fix that?

ERROR [ru.andreymarkelov.atlas.plugins.promjiraexporter.service.ScheduledMetricEvaluator] Failed to resolve attachments size.
++++

[AndreyVMarkelov]

Hello mssql database? пн, 28 окт. 2019 г. в 21:50, ricardoecore <[email protected]>:

Hello, I'm getting same error on Jira Datacenter 7.13.9. How do we fix that? ERROR [ru.andreymarkelov.atlas.plugins.promjiraexporter.service.ScheduledMetricEvaluator] Failed to resolve attachments size. ++++ — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#56?email_source=notifications&email_token=AAPXM4AQSWC36SJQDA7UOB3QQ4X7FA5CNFSM4ITD2NO2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOECN7XSI#issuecomment-547093449>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAPXM4GJATWK24RHZVWWZCTQQ4X7FANCNFSM4ITD2NOQ> .

-- *-- Andrey Markelov*

[ricardoecore]

Hello mssql database? пн, 28 окт. 2019 г. в 21:50, ricardoecore [email protected]:
Hello, I'm getting same error on Jira Datacenter 7.13.9. How do we fix that? ERROR [ru.andreymarkelov.atlas.plugins.promjiraexporter.service.ScheduledMetricEvaluator] Failed to resolve attachments size. ++++ — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#56?email_source=notifications&email_token=AAPXM4AQSWC36SJQDA7UOB3QQ4X7FA5CNFSM4ITD2NO2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOECN7XSI#issuecomment-547093449>, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAPXM4GJATWK24RHZVWWZCTQQ4X7FANCNFSM4ITD2NOQ .
-- -- Andrey Markelov

No, it is a Jira DC on Azure, using AzureSQL (PAS - Platform As a Service).

[AndreyVMarkelov]

Aha Right know issue I will fix ASAP пн, 28 окт. 2019 г. в 21:54, ricardoecore <[email protected]>:

Hello mssql database? пн, 28 окт. 2019 г. в 21:50, ricardoecore ***@***.***: Hello, I'm getting same error on Jira Datacenter 7.13.9. How do we fix that? ERROR [ru.andreymarkelov.atlas.plugins.promjiraexporter.service.ScheduledMetricEvaluator] Failed to resolve attachments size. ++++ — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#56 <#56>?email_source=notifications&email_token=AAPXM4AQSWC36SJQDA7UOB3QQ4X7FA5CNFSM4ITD2NO2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOECN7XSI#issuecomment-547093449>, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAPXM4GJATWK24RHZVWWZCTQQ4X7FANCNFSM4ITD2NOQ . -- *-- Andrey Markelov* No, it is a Jira DC on Azure, using AzureSQL (PAS - Platform As a Service). — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#56?email_source=notifications&email_token=AAPXM4BL4FP2KXKRFAJBTPLQQ4YN7A5CNFSM4ITD2NO2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOECOAEFI#issuecomment-547095061>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAPXM4APPGSTOSNNZDTV2SLQQ4YN7ANCNFSM4ITD2NOQ> .

-- *-- Andrey Markelov*

[saldor100]

Same error on mssql 2017 with jira dc 8.2.4 here and lastest version of the plugin.

Martin

[vetalka]

i have same issue on Jira Software 8.5.3

Vitaly