Articles Tagged 'database'

Articles
Order of Database Table Deletes when Projects Deleted in Spira

Some of our customers wanted to know that we delete the data in the SpiraTest, SpiraPlan, and SpiraTeam tables when we delete a project.
This article outlines that approximate order of the data being deleted

Database Changes Between Spira v4.2 and v5.0

As part of the v5.0 update to SpiraTest, SpiraPlan and SpiraTeam, we made major changes to the database structure to improve performance and usability as well as lay the foundation for v5.1, v5.2 and v5.3 due out later this year. Customers using custom reports that relied on the old v4.2 database structure will need to modify their custom reports.

This article is obsolete.
This only applies to upgrading to v5.0 which was released in 2016.

Receiving database constraint error when trying to execute a test case or test set

If you are trying to run a test case or test set and you receive the following error:

Messages:
   Database constraint violation occurred [APPLICATION.Business.EntityConstraintViolationException]
   An error occurred while updating the entries. See the inner exception for details. [System.Data.UpdateException]
   Violation of PRIMARY KEY constraint 'XPKTST_ARTIFACT_CUSTOM_PROPERTY'. Cannot insert duplicate key in object 'dbo.TST_ARTIFACT_CUSTOM_PROPERTY'.
The statement has been terminated. [System.Data.SqlClient.SqlException]

Then this article provides the solution for you.

Changing SQL Servers or Updating Server Names

The steps to perform when needing to move the database to another SQl Server, or when changing the DNS name of your SQL Server.

Configuring MS SQL Server for Remote Access

When connecting from Spira or Krono installed on a separate application server to a remote SQL server, you may have difficulties connecting. This article describes the steps for making sure that your SQL Server can be accessed remotely.

Choosing a Database to Run SpiraTeam or KronoDesk On

This article answers some common questions about which databases you can run SpiraTest, SpiraPlan, SpiraTeam and KronoDesk on, and where you can get them from.

After restoring a backup of my database, I keep getting unable to login to database errors?

This usually just means that the restored database just needs to be linked to the existing database server login. This can be done by executing the appropriate SQL command listed below:

How do I migrate data from a trial installation of Spira or KronoDesk to the production one?

This is a common need, since you may have installed SpiraTest, SpiraPlan,  SpiraTeam, or KronoDesk  on a workstation to evaluate its capabilities and now need to install it on a production server for real use, but you don't want to lose all your existing data.

How do I move my SpiraTest/Plan/Team database to another server

This article describes the process and steps for moving your SpiraTest, SpiraPlan or SpiraTeam database from one computer to another.
The article will refer to SpiraTeam, but it applies equally to the other products.

Doing a SubString on a Database Value in Rapise

When you try and do a substring on a value returned from a database, you may get an error about the object not supporting the property.

Using Rapise to Validate Display of Data Grid Data

One common requirement is to run a query in an application being tested and verify that the data on the screen matches the data in the application. This article explains the recommended process for doing this.

Executing SQL Database Queries from Rapise

Sometimes when you are running Rapise tests you need to run direct database queries to prepare the data in the test application, or you need to make queries against the database to verify that some user interactions left the data in a specific state.

The sample script below illustrates how you can call database queries directly from the Rapise scripting editor:

"Column does not allow NULLS" system error after upgrading to v6.8

After upgrading to v6.8, you may get a system error with the text in it that states that the task can not be completed. This can affect creating users, copying Products, creating new Products, among other activities.

Connecting to PostgreSQL from Rapise

If you need to connect Database object to PostgreSQL database follow these simple steps.

Connecting to MySQL from Rapise

If you need to connect Database object to MySQL database follow these simple steps.

Tuning SQL Server Databases using SQL Engine Tuning Advisor

The SQL Server Database Engine Tuning Advisor examines how queries are processed in the databases you specify, and then recommends how you can improve query processing performance by modifying database structures such as indexes, indexed views, and partitioning. This can be used by on-premise customers to improve the performance of their Spira and KronoDesk instances.

Installing Spira or KronoDesk with a large SQL Server model database size

When you are installing SpiraTest, SpiraTeam, SpiraPlan or KronoDesk on a database server with a large 'model' database sometimes the install will fail because the initial Spira/KronoDesk database is not large enough to contain your model database. This article provides the solution

Extracting the tickets and attachments from a KronoDesk cloud instance

Sometimes customers want to download their list of tickets and file attachments. This article explains how to read the data that we provide.

How to migrate or downgrade a SQL Server database to a lower version

This post shows you how you can migrate or downgrade a SQL Server database from one version to a lower or earlier one. E.g. 2016 to 2014, 2014 to 2012, 2012 to 2008 etc. This can be useful if you maintain a heterogeneous environment of SQL Server instances and you have a backup from a newer version that needs to be hosted onto an older version. This happens to us quite a bit when customers installed a trial on SQL Server Express (latest version) and we need to host it on one our cloud servers.

Best Practices for Configuring Microsoft SQL Server for use with SpiraTest, SpiraTeam, and KronoDesk

When you install SpiraTest, SpiraTeam, SpiraPlan, or KronoDesk on premise, you have a choice in different ways to configure SQL Server. Every situation is different, but this article presents some recommendations.

Rebuilding the Database Indexes - Advanced Version

With the latest version of SpiraTest, SpiraPlan and SpiraTeam, we have provided a simple button in the Data Tools section that lets you rebuild the database indexes using the same script that we published in KB10. However sometimes the database is so large that the execution takes longer than the 30 minutes allowed by the application, or you want more control over the fragmentation levels that trigger a rebuild. This article provides guidance and a more advanced script for power users.