Hi guys, this is actually not a production issue (yet), but a request for knowledge. Challenge: We need to move the Confluence database from one server to another. Everywhere I see, I see guides fo...
Can you help me connect the DB? It seems the new install wizard blocks me from moving to MS SQL Server. I have Jira 6.1 on WinSvr 2008 and am switching DB from HSSQL to a named instance of MS SQL 2...
Dear Supporter, I have problem install Jira software connect to database MS SQL 2012 server and it has message error "Error reference: db875ea6-8756-46b1-8711-83136aa6d1a5" and i checked in database...
I am using crucible v2.7.7 I want to export all (500-1000) review comments / defects of a project, with all details like Review ID, reviewer name, creation date and all custom fields (crucible defe...
Hi, we have an issue with backup boards to database. After restoring xml files all tables are creating, complementing but tables with boards and sprints are empty. We are migrating from PostgreSQL ...
Hi all - I'm in process of the initial install of Confluence (hosting it on a VM alongside a Jira installation on the same server, both using MS SQL which is located on this machine as well).&...
We found out that when using offset and limit in an active objects query, if the underlying db is MS SQL Server, it fails with an SQL exception. The following query crashes @Override public List...
Hi all, I wanted to run a script which is located in in the BBS, when the change is committed to the bbs the bamboo plan will get trigger and the script need to be executed in the MS SQL server?? p...
Hi, My company is wanting to evaluate JIRA as a potential Issue/Bug Tracking tool, as well as to use it for our Agile development process, and Code Reviewing. We are trying to set up JIRA to connec...
Hi, I followed the (optional) instructions from https://confluence.atlassian.com/display/STASH/Connecting+Stash+to+SQL+Server for connecting to stash-(sql2008 db) using integrated authentication an...
Is it possible to create/update data on SAP with Jira REST API call and vise versa . My SAP Business One is configured in MSSQL Server.
Hi, I need to create our own reports based on JIRA and JIRA agile. Part of my report is in Agile sprint report, but I need to add more information to that and for that I need to know sql quesries. ...
The official MSSQL Linux Server Docker image expects at least 2GB of RAM: https://hub.docker.com/r/microsoft/mssql-server-linux/ It appears the Pipelines can only allocate at most 1GB to a...
I would like to get a list/report of users who have not logged in in a long time so I can deactivate them. I found way of getting that report from this page: https://confluence.atlassian.com/display...
This is my goal i need to update the external database whenever a ticket is raise in jira. Event has been triggered then script will run to update a table in MS SQL server . Anyone know how to do it...
Why is it necesssary to toggle this option at all? It's an instance option, not a database option - so it affects all other databases in the same instance, too. This can lead to undesired side-effe...
Hello! I need to see issue fixversion full history by using SQL query. How can I do this?
hi all, I am about to setup a JIRA VM and Confluence VM along with Microsoft SQL 2014 DB server/s. Do I need to have a DB server for each or can I get away with sharing 1 DB server but ha...
The documentation says I have to run the install wizard. Is this really neccessary for just changing the server ip? I was not able to find any clear text reference in the confluence folder.
H ello, I've completely upgraded my JIRA from 4.2 to 5.0.1 on a test server. For this upgrade, I've created a new database (MSSQL). Everything worked fine. Before upgrading on the producti...
Hi there, I try to do a pilot installation for using Confluence in our enterprise, since we are a pure MSFT shop I was a bit surprised to see that the example to host it with SQL Server is using sql ...
Our customer wants to use an SQL Server Cluster with dynamic ports, and so far, I have found the following solution: Install from ZIP 1) Replace jtds-1.2.4.jar with jtds-1.3.jar (possibly the one...
Hi, we are supporting for our customer JIRA 4.4.1. server. It's installed on Windows 2003 Server, using MS SQL 2005 database and JDTS 1.2.5 JDBC driver. Following problem seems to start after ...
I have a Jira instance set up on my SQL server and I am planning to set up a second Jira instance using the same SQL server. Can the 2 Jira's DB located on the same SQL instance.
I am trying to write an MS SQL query which will return the users who haven't logged in since new year. Here is the query. SELECT [jira].[dbo].[cwd_user].user_name, dateadd(second,cast(cast([jira]...
Copied to clipboard