DevTest Migration Error - Migration V14__Update_DDL.sql failed

Document ID : KB000103157
Last Modified Date : 28/06/2018
Show Technical Document Details
Issue:
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.
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.