DevTest Migration Error - Migration V14__Update_DDL.sql failed

book

Article ID: 103157

calendar_today

Updated On:

Products

CA Application Test Service Virtualization CA Continuous Application Insight (PathFinder) CA Service Virtualization (DevTest / LISA / VSE / Application Test)

Issue/Introduction

Doing a migration from 10.1.0 to 10.3.0 using same databases.

Migration V14__Update_DDL.sql failed
------------------------------------
SQL State  : S00013
Error Code : 1088
Message    : Cannot find the object "component" because it does not exist or you do not have permissions.
Location   : com/ca/dradis/db/migration/sqlserver/scripts/V14__Update_DDL.sql (/opt/CA/DevTest10.3/file:/opt/CA/DevTest10.3/lib/dradis/dradis-10.3.0.jar!/com/ca/dradis/db/migration/sqlserver/scripts/V14__Update_DDL.sql)
Line       : 1
Statement  : UPDATE component SET is_sec_enabled = 0 WHERE is_sec_enabled IS NULL;
ALTER TABLE component ALTER COLUMN is_sec_enabled smallint NOT NULL
 
UPDATE component SET is_hidden = 0 WHERE is_hidden IS NULL;
ALTER TABLE component ALTER COLUMN is_hidden smallint NOT NULL
 
UPDATE component SET is_deleted = 0 WHERE is_deleted IS NULL;
ALTER TABLE component ALTER COLUMN is_deleted smallint NOT NULL;

Cause

Permissions issue.

Environment

Release:
Component: ITKOTF

Resolution

Problem is your user to start the Enterprise Dashboard (EDB) with does not DBA authority to do an ALTER on the database hence the error.

When creating or altering tables, the user must have DBA authority.