Tag: "ms-sql"

I have mission about showing some data to Gantt char that mean is Timeline. But my data in the MSSQL database. How can I export data from SQL database to Jira? If there is more than one way please te...

• Jira
• Question
• cloud
• jira
• jira-cloud
• ms-sql

Bamboo 6.8 version installation with MS SQL server getting "Cannot insert duplicate key in object 'dbo.CWD_DIRECTORY'" Below is the error , i got. appreciate your input. Caused by: java.sql.Batch...

• Bamboo
• Question
• bamboo
• ms-sql

Hi,   We run Jira on-premise with a MS SQL Server 2019 back-end. The Jira team requests us to only run MS SQL Full backup while Jira is stopped. I can't find anything in the KB around the re...

• Jira
• Question
• jira
• jira-server
• ms-sql
• server

good morning,  I was looking at "Migrating Jira to new server and keeping same database" but it mentions Oracle database.  We are connecting to MS SQL database and have local users on the ...

• Jira
• Question
• jira
• jira-software
• jira-software-server
• ms-sql
• server

Hi All, We are using external user directory (Microsoft Active Directory). I found many users are not having email addresses, which results in error during JCMA user migration to Cloud.  I use...

• Jira
• Question
• server
• active-directory
• cloud
• jira-software
• ldap
• +4 more tags...

We are running Jira Data Center on prem (version 8.19). We have a Scriptrunner Database Picker custom field. During development, we used a SQL Server ID but would like to change the Resource to use a...

• Apps & Integrations
• Question
• active-directory
• atlassian-marketplace
• jdbc
• jira-server
• ms-sql
• +1 more tag...

Hi Team, I am trying to upgrade our JIRA form 8.20.1 to JIRA8.2012 version in order to remediate some vulnerabilities. As a pre-check on JIRA, heal check show 2 data base erros.    B...

• Jira
• Question
• jira
• jira-server
• ms-sql
• server

Hi All, Our sql database has gotten quite large and on checking the table sizes we've found that the following table AO_544E33_AUDIT_LOG_ENTRY is taking up the majority of the space.  Cur...

• Jira
• Question
• jira
• jira-server
• ms-sql
• server

We are looking to set up SQL Server 2019 on a virtual machine (VM) as the backend database for Jira Data Center (on premise) in our closed network.   Usually, we set the number of CPUs for ...

• Jira
• Question
• jira-software
• jira-software-server
• ms-sql
• server

Hi All: I´m creating a se of pages to document the data model from SQL Server database. I want just to run 8 or 9 parametrized queries to an aplication Database Server, and show the result tables i...

• Confluence
• Question
• confluence
• confluence-server
• ms-sql
• server

Hello, we are running on confluence 7.12.2 and are experiencing since mid december 2021 (nothing changed on the configuration since about 6 months) a strange effect. Every about 10-16 days it happe...

• Confluence
• Question
• confluence
• confluence-server
• log
• ms-sql
• server
• +1 more tag...

HI All,   There is requirement to migrate DB from postgresql to mssql server, can someone suggest best methods to do this  

• Jira
• Question
• jira
• jira-server
• ms-sql
• postgres
• server

Can not Set Up a Confluence instance with the Mircosoft SQL Server.  I get a "bad SQL grammar" Error ("StatementCallback; bad SQL grammar [CREATE OR ALTER FUNCTION [dbo].space_function_for_deno...

• Confluence
• Question
• confluence
• confluence-server
• ms-sql
• server

Hello, I have a very large Confluence instance here and need to migrate it to a new environment. The current database is a MSSQL but I need to migrate everything to a PostgreSQL db. Unfortunately ...

• Confluence
• Question
• confluence
• confluence-server
• migration
• ms-sql
• postgres
• +1 more tag...

I'm doing a completely vanilla install of Jira here, on a hyper-v VM, connecting to a SQL Server on a hyper-v VM on the same host.  SQL Server Management Studio connects just fine using the same...

• Jira
• Question
• jira-software
• jira-software-server
• ms-sql
• server

We plan to migrate ours from Oracle 12C to SQL Server 2017. If anyone has gone through such a process, or any other migration to a different database platform, please share your experiences and advi...

• Confluence
• Question
• backup
• confluence
• confluence-server
• export
• import
• +6 more tags...

Our self-hosted Confluence 7.4.0 installation started suddenly to display a system error when a user tries to log in. Wihtout logging in, everything works: I can see the pages, I cas use the search ...

• Confluence
• Question
• confluence
• confluence-server
• ms-sql
• server
• sql

Hi, I recently checked SQL Server that houses Confluence DB and was puzzled to find several Confluence v6.4.3 queries that literally run 3-4 thousand times (!) per minute each in our log. Needless t...

• Confluence
• Question
• confluence
• confluence-server
• database
• ms-sql
• performance
• +2 more tags...

Hi , Hope you are doing well.   We have a custom Jira plugin which actually generates the data into an excel based on some filters and calendar dates. Now we have requirement to populate thi...

• Jira
• Question
• app
• jira
• jira-server
• ms-sql
• server
• +1 more tag...

Dear all, We are using for years Jira datacenter connected to Azure SQL service database. The lastest version that microsoft provide as a SAS version of SQL server is 2014 ( wit a compatibility lev...

• Jira
• Question
• jira
• jira-server
• ms-sql
• server

Hi All, I am trying to migrate users from CROWD directory (ID-10000) to Microsoft server Directory (ID-10100). After sync i can see users are in both directory , duplicate usernames in both directo...

• Jira
• Question
• jira-software
• jira-software-server
• ms-sql
• server
• sql

Hi All, Is there a way to get the mount of user(s) of a given space within one SQL query? some of the spaces they have only users and some of them they have user plus group. Thanks

• Confluence
• Question
• confluence
• confluence-server
• ms-sql
• server
• sql

Hello ,   We have migrated Jira to latest version 8.8.1 after up gradation Jira health check fails and it is recommending to update MS SQL DATABASE to 2016 above . Now we want to migrate to MS...

• Jira
• Question
• database
• health-check
• jira
• jira-server
• migration
• +3 more tags...

Background: The original SQLServer database was setup with a particular collation.  this worked just fine until we tried to do an upgrade to 4.6.1 and we received and error that SQL_Latin1_Gene...

• Jira
• Question
• jira
• jira-server
• jira-service-desk
• ms-sql
• server

I am using MS SQL server 2019 and have gone through the process for setting up the SQL server and database. I've also set up a new user with the db_owner role and with a 'Windows Authenticated' ...

• Bitbucket
• Question
• bitbucket
• ms-sql