JIRA 4.3 : MS SQL Server 2000 Startup errors
This page last changed on Jun 18, 2010 by jcostello.
A user reports getting errors like these every time JIRA starts up: [core.entity.jdbc.DatabaseUtil] Entity "Action" has no table in the database 2003-11-06 09:33:45,265 ERROR [core.entity.jdbc.DatabaseUtil] Could not create table "jiraaction" 2003-11-06 09:33:45,265 ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following: CREATE TABLE jiraaction (ID NUMERIC NOT NULL, issueid NUMERIC, AUTHOR VARCHAR(255), actiontype VARCHAR(255), actionlevel VARCHAR(255), actionbody TEXT, CREATED DATETIME, actionnum NUMERIC, CONSTRAINT PK_jiraaction PRIMARY KEY (ID)) Error was: java.sql.SQLException: There is already an object named 'jiraaction' in the database. 2003-11-06 09:33:45,265 WARN [core.entity.jdbc.DatabaseUtil] Entity "ChangeGroup" has no table in the database 2003-11-06 09:33:45,265 ERROR [core.entity.jdbc.DatabaseUtil] Could not create table "changegroup" JIRA functions correctly otherwise. A solution is suggested in this jira-user post:
We have also had reports from other users that there are also alternatives to this solution. The ddl_admin, db_datareader and db_datawriter roles could be used instead of db_owner role for the jirauser account. |
![]() |
Document generated by Confluence on Mar 27, 2011 18:52 |