Version 0.1.2 has been released that adds support for MS SQL Server. Get the new at the Marketplace (or use UPM to update).
Thanks everyone for the help resolving this issue. Please remember to rate the plugin (or update your rating if you already did so:)
Here is the error that is causing MSSQL to fail reading the notifications:
java.sql.SQLException: ResultSet may only be accessed in a forward direction.
I will investigate and hopefully release a fix ASAP.
There are two reasons that I am aware of that might cause notifications not being fired.
1. There is no SMTP server configured as outgoing mail for JIRA. This might cause JIRA not to fire social events like @mentions. But I will have to investigate to be sure.
2. The project does not have a Notification Scheme configured. If this is the case, then JIRA does not know the recipients for the event. We could add a default behaviour to overcome this limitation by sending notification to all watchers and participants regardless whether there is a notification scheme or not. But there might be a reason for the project not having a notification scheme so this would probably have to be optional.
If you have both SMTP server and Notification Scheme configure but are still not getting any notifications, then there is probably a bug that affects your browser. In that case, please provide browser information so I can investigate.
Thank you for taking the time to answer. I had indeed not set up a mail server. I have done that now but i still get empty notifications. I now receive the email from JIRA so email is set up correct. I do not have any notifications scheme set so you are right that it needs to be be set but for mentions it should not be necessary.
I am using Chrome 20.0.1132.
When i mention we see the number count up on the user mentioned.
Thank you for the details. It does indeed look like notifications are being fired (since the count is correct), but the view is failing to display them to you for some reason. This might be caused because Notify is having trouble with your database type. Please tell me if there are any SQL errors in the logs. It might also be a problem with the web service. Can you try accessing $JIRA_PATH/rest/jitter-notify/1.0/notification.json in your browser and tell me the result? (where $JIRA_PATH is the URL to the root of your JIRA.)
Hi, in my scenario I have notification schema setup and also the mail server as I'm receiving notifications by email to changes to issues. I assumed it was a config item under administration for notication schemes however couldn't find the option to add the jitter option in. Also I'm an an administrator of Jira so permissions shouldn't be an issue.
Thanks everyone for the help in identifiying this issue.
The issues is definitely SQL problems with MSSQL. Notify uses the Active Objects (AO) ORM provided in JIRA. I have seen problems with MSSQL in other plugins that use AO. This can usually be fixed easily if we can get access to the stacktrace. Unfortunately I don't have access to MSSQL server at the moment so it would be great if we can extract some logs. Then I can probably identify and fix the issue quickly.
This page might help with finding the logs: https://developer.atlassian.com/display/AO/Enabling+SQL+logging
@ranger: It just uses the standard notification schemes so there is no additional configuration needed. You should be all set. Do you also see the notification counter in the header of JIRA? (See first screenshot from @michaicph.)
If no logs can be extracted, then I will setup MSSQL and debug it from there. But I can't do that right now.
There should be some lines in the logs containing the following string: AO_0BE43A_NOTIFICATIONS
Caused by: java.sql.SQLException: Column not found: FOO in statement [SELECT LIMIT 0 10 * FROM PUBLIC.AO_0BE43A_NOTIFICATIONS WHERE FOO = 1, TO_USER = ? ORDER BY POSTED_DATE DESC]
You might need to enable logging on java.sql.* and net.java.ao.*
Thank you @donnib, this confirms the error. It looks like MSSQL can't deal well with offset when ordering the result set in descending order. I am looking for a workaround. Meanwhile, I have filed this in the AO project: https://studio.atlassian.com/browse/AO-358
Thank you for your patience.
It's now showing the notifications which is great however not marking them as read after i click on them. When I click on the @ symbol whilst at the dashboard it shows the notifications then the number disappears however on click to another section of Jira (lets say the dashboard) the number re-appears showing 23 unread notifications.
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
One of the newest products in the Microsoft family - Microsoft Teams, is a chat-based hub for teamwork that integrates all the people, content, and tools your team needs to be more engaged and ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG