Error while installing Datastage8.5 on windows 2008

sreddy666 · Post by **sreddy666** » Mon May 14, 2012 4:37 am

Hi Friends,

We are installing DataStage8.5 on Window2008 SQLservers as database.

Please find below issue occuring after giving XMETA details.

Issue:
--------

com.ibm.is.install.exception.InstallException: CDIIN3231E: Error Executing SQL statement
CREATE TRIGGER
ASCLHist_Term_U
ON ASCLModel_xmetagen_BusinessTermb1c497ce
INSTEAD OF UPDATE
AS
DECLARE @SWV_OLD_ABBREVIATION_XMETA VARCHAR(255)
DECLARE @SWV_OLD_ALTERNATEABBREVIATION_XMETA VARCHAR(255)
DECLARE @SWV_OLD_SHORTDESCRIPTION_XMETA VARCHAR(255)
DECLARE @SWV_OLD_EXAMPLE_XMETA NVARCHAR(MAX)
DECLARE @SWV_OLD_NAME_XMETA VARCHAR(255)
DECLARE @SWV_OLD_USAGE_XMETA NVARCHAR(MAX)
DECLARE @SWV_OLD_OF_SYNONYMGROUP_XMETA VARCHAR(255)
DECLARE @SWV_OLD_REPLACEDBY_BUSINESSTERM_XMETA VARCHAR(255)
DECLARE @SWV_OLD_XMETA_REPOS_OBJECT_ID_XMETA VARCHAR(255)
DECLARE @SWV_OLD_OF_BUSINESSCATEGORY_XMETA VARCHAR(255)
DECLARE @SWV_OLD_HAS_CONTACTASSIGNMENT_XMETA NVARCHAR(MAX)
DECLARE @SWV_OLD_CLASSIFICATION_XMETA VARCHAR(255)
DECLARE @SWV_OLD_STATUS_XMETA VARCHAR(255)
DECLARE @SWV_OLD_ISQUALIFIER_XMETA VARCHAR(255)
DECLARE @SWV_OLD_ISPREFEREDIN_SYNONYMGROUP_XMETA VARCHAR(255)
DECLARE @SWV_OLD_LONGDESCRIPTION_XMETA NVARCHAR(MAX)

DECLARE @SWV_Cursor_For_OLD CURSOR
DECLARE @SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA VARCHAR(255)
DECLARE @SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA VARCHAR(255)
DECLARE @SWV_NEW_XMETA_REPOS_OBJECT_ID_XMETA VARCHAR(255)
DECLARE @SWV_NEW_ABBREVIATION_XMETA VARCHAR(255)
DECLARE @SWV_NEW_ALTERNATEABBREVIATION_XMETA VARCHAR(255)
DECLARE @SWV_NEW_SHORTDESCRIPTION_XMETA VARCHAR(255)
DECLARE @SWV_NEW_EXAMPLE_XMETA NVARCHAR(MAX)
DECLARE @SWV_NEW_NAME_XMETA VARCHAR(255)
DECLARE @SWV_NEW_USAGE_XMETA NVARCHAR(MAX)
DECLARE @SWV_NEW_OF_SYNONYMGROUP_XMETA VARCHAR(255)
DECLARE @SWV_NEW_REPLACEDBY_BUSINESSTERM_XMETA VARCHAR(255)
DECLARE @SWV_NEW_OF_BUSINESSCATEGORY_XMETA VARCHAR(255)
DECLARE @SWV_NEW_HAS_CONTACTASSIGNMENT_XMETA NVARCHAR(MAX)
DECLARE @SWV_NEW_CLASSIFICATION_XMETA VARCHAR(255)
DECLARE @SWV_NEW_STATUS_XMETA VARCHAR(255)
DECLARE @SWV_NEW_ISQUALIFIER_XMETA VARCHAR(255)
DECLARE @SWV_NEW_ISPREFEREDIN_SYNONYMGROUP_XMETA VARCHAR(255)
DECLARE @SWV_NEW_LONGDESCRIPTION_XMETA NVARCHAR(MAX)
DECLARE @SWV_Cursor_For_NEW CURSOR
DECLARE @SWV_Null_Var INT
DECLARE @TermHistoryEnabledRes SMALLINT;

SET @SWV_Cursor_For_OLD = CURSOR FOR
SELECT
ABBREVIATION_XMETA,
ALTERNATEABBREVIATION_XMETA,
SHORTDESCRIPTION_XMETA,
EXAMPLE_XMETA,
name_xmeta,
USAGE_XMETA,
OF_SYNONYMGROUP_XMETA,
REPLACEDBY_BUSINESSTERM_XMETA,
_xmeta_repos_object_id_xmeta,
OF_BUSINESSCATEGORY_XMETA,
CLASSIFICATION_XMETA,
STATUS_XMETA,
ISQUALIFIER_XMETA,
ISPREFEREDIN_SYNONYMGROUP_XMETA,
LONGDESCRIPTION_XMETA,
HAS_CONTACTASSIGNMENT_XMETA
FROM deleted
OPEN @SWV_Cursor_For_OLD

SET @SWV_Cursor_For_NEW = CURSOR FOR
SELECT
_xmeta_modified_by_user_xmeta,
_xmeta_modification_timestamp_xmeta,
_xmeta_repos_object_id_xmeta,
abbreviation_xmeta,
alternateabbreviation_xmeta,
shortdescription_xmeta,
example_xmeta,
name_xmeta,
usage_xmeta,
of_synonymgroup_xmeta,
replacedby_businessterm_xmeta,
of_businesscategory_xmeta,
classification_xmeta,
status_xmeta,
isqualifier_xmeta,
ispreferedin_synonymgroup_xmeta,
longdescription_xmeta,
has_contactassignment_xmeta
FROM inserted
OPEN @SWV_Cursor_For_NEW

FETCH NEXT FROM @SWV_Cursor_For_OLD
INTO
@SWV_OLD_ABBREVIATION_XMETA,
@SWV_OLD_ALTERNATEABBREVIATION_XMETA,
@SWV_OLD_SHORTDESCRIPTION_XMETA,
@SWV_OLD_EXAMPLE_XMETA,
@SWV_OLD_NAME_XMETA,
@SWV_OLD_USAGE_XMETA,
@SWV_OLD_OF_SYNONYMGROUP_XMETA,
@SWV_OLD_REPLACEDBY_BUSINESSTERM_XMETA,
@SWV_OLD_XMETA_REPOS_OBJECT_ID_XMETA,
@SWV_OLD_OF_BUSINESSCATEGORY_XMETA,
@SWV_OLD_CLASSIFICATION_XMETA,
@SWV_OLD_STATUS_XMETA,
@SWV_OLD_ISQUALIFIER_XMETA,
@SWV_OLD_ISPREFEREDIN_SYNONYMGROUP_XMETA,
@SWV_OLD_LONGDESCRIPTION_XMETA,
@SWV_OLD_HAS_CONTACTASSIGNMENT_XMETA

FETCH NEXT FROM @SWV_Cursor_For_NEW
INTO
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA,
@SWV_NEW_XMETA_REPOS_OBJECT_ID_XMETA,
@SWV_NEW_ABBREVIATION_XMETA,
@SWV_NEW_ALTERNATEABBREVIATION_XMETA,
@SWV_NEW_SHORTDESCRIPTION_XMETA,
@SWV_NEW_EXAMPLE_XMETA,
@SWV_NEW_NAME_XMETA,
@SWV_NEW_USAGE_XMETA,
@SWV_NEW_OF_SYNONYMGROUP_XMETA,
@SWV_NEW_REPLACEDBY_BUSINESSTERM_XMETA,
@SWV_NEW_OF_BUSINESSCATEGORY_XMETA,
@SWV_NEW_CLASSIFICATION_XMETA,
@SWV_NEW_STATUS_XMETA,
@SWV_NEW_ISQUALIFIER_XMETA,
@SWV_NEW_ISPREFEREDIN_SYNONYMGROUP_XMETA,
@SWV_NEW_LONGDESCRIPTION_XMETA,
@SWV_NEW_HAS_CONTACTASSIGNMENT_XMETA

EXECUTE isTermHistoryEnabled @TermHistoryEnabledRes OUT
WHILE @@FETCH_STATUS = 0
BEGIN
IF @TermHistoryEnabledRes = 1 BEGIN
DECLARE @objectEventRid VARCHAR(64)
DECLARE @replacesObjectEventRid VARCHAR(64)
DECLARE @sessionUser NVARCHAR(64)
DECLARE @sessionTimestamp BIGINT
DECLARE @attributeUpdateRid VARCHAR(64)
DECLARE @replacedTermName NVARCHAR(256)
DECLARE @contactAssignmentName NVARCHAR(256)
DECLARE @contactAssignmentId NVARCHAR(64)
DECLARE @updatedHasAssignmentId NVARCHAR(255)
DECLARE @oldHasAssignmentId NVARCHAR(255)
DECLARE @colAttributeName VARCHAR(256)
DECLARE @categoryName VARCHAR(255)
DECLARE @classificationName VARCHAR(255)
DECLARE @statusEnumName VARCHAR(256)
DECLARE @booleanName VARCHAR(255)
DECLARE @isPreffered VARCHAR(255)
DECLARE @SWV_func_CREATEATTRUPDATE_par101 VARCHAR(255)
SET @sessionUser = NULL
SET @sessionTimestamp = NULL
SET @replacedTermName = NULL
SET @contactAssignmentName = NULL
SET @contactAssignmentId = NULL
SET @updatedHasAssignmentId = NULL
SET @oldHasAssignmentId = NULL
SET @sessionUser = @SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA
SET @sessionTimestamp = @SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA

EXECUTE getOrCreateObjectEvent
@SWV_NEW_XMETA_REPOS_OBJECT_ID_XMETA,
@sessionUser OUT,
@sessionTimestamp OUT,
NULL,
'UPDATE',
@objectEventRid OUT

if COALESCE(@SWV_OLD_ABBREVIATION_XMETA,'') != COALESCE(@SWV_NEW_ABBREVIATION_XMETA,'')
begin
EXECUTE getAttributeNameForCol 'ABBREVIATION_XMETA', @colAttributeName OUT
EXECUTE CreateAttrUpdateC
@objectEventRid,
@colAttributeName,
@SWV_OLD_ABBREVIATION_XMETA,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA
end

if COALESCE(@SWV_OLD_ALTERNATEABBREVIATION_XMETA,'') != COALESCE(@SWV_NEW_ALTERNATEABBREVIATION_XMETA,'')
begin
EXECUTE getAttributeNameForCol 'ALTERNATEABBREVIATION_XMETA', @colAttributeName OUT
EXECUTE CreateAttrUpdateC
@objectEventRid,
@colAttributeName,
@SWV_OLD_ALTERNATEABBREVIATION_XMETA,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA
end

if COALESCE(@SWV_OLD_SHORTDESCRIPTION_XMETA,'') != COALESCE(@SWV_NEW_SHORTDESCRIPTION_XMETA,'')
begin
EXECUTE getAttributeNameForCol 'SHORTDESCRIPTION_XMETA', @colAttributeName OUT
EXECUTE CreateAttrUpdateC
@objectEventRid,
@colAttributeName,
@SWV_OLD_SHORTDESCRIPTION_XMETA,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA
end

if COALESCE(@SWV_OLD_LONGDESCRIPTION_XMETA,'') != COALESCE(@SWV_NEW_LONGDESCRIPTION_XMETA,'')
begin
EXECUTE getAttributeNameForCol 'LONGDESCRIPTION_XMETA', @colAttributeName OUT
EXECUTE CreateAttrUpdateC
@objectEventRid,
@colAttributeName,
@SWV_OLD_LONGDESCRIPTION_XMETA,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA
end

if COALESCE(@SWV_OLD_EXAMPLE_XMETA,'') != COALESCE(@SWV_NEW_EXAMPLE_XMETA,'')
begin
EXECUTE getAttributeNameForCol 'EXAMPLE_XMETA', @colAttributeName OUT
EXECUTE CreateAttrUpdateC
@objectEventRid,
@colAttributeName,
@SWV_OLD_EXAMPLE_XMETA,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA
end

if COALESCE(@SWV_OLD_NAME_XMETA,'') != COALESCE(@SWV_NEW_NAME_XMETA,'')
begin
EXECUTE getAttributeNameForCol 'NAME_XMETA', @colAttributeName OUT
EXECUTE CreateAttrUpdateC
@objectEventRid,
@colAttributeName,
@SWV_OLD_NAME_XMETA,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA
end

if COALESCE(@SWV_OLD_USAGE_XMETA,'') != COALESCE(@SWV_NEW_USAGE_XMETA,'')
begin
EXECUTE getAttributeNameForCol 'USAGE_XMETA', @colAttributeName OUT
EXECUTE CreateAttrUpdateC
@objectEventRid,
@colAttributeName,
@SWV_OLD_USAGE_XMETA,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA
end

if COALESCE(@SWV_OLD_REPLACEDBY_BUSINESSTERM_XMETA,'') != COALESCE(@SWV_NEW_REPLACEDBY_BUSINESSTERM_XMETA,'')
begin
if @SWV_NEW_REPLACEDBY_BUSINESSTERM_XMETA IS NOT NULL
begin
EXECUTE getBusinessTermName
@SWV_NEW_REPLACEDBY_BUSINESSTERM_XMETA,
@replacedTermName OUT

EXECUTE getAttributeNameForCol 'REPLACEDBY_BUSINESSTERM_XMETA', @colAttributeName OUT
EXECUTE CreateRefUpdate
@objectEventRid,
@colAttributeName,
@replacedTermName,
@SWV_NEW_REPLACEDBY_BUSINESSTERM_XMETA,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA,
'ADDED'

EXECUTE getOrCreateObjectEvent
@SWV_NEW_REPLACEDBY_BUSINESSTERM_XMETA,
@sessionUser,
@sessionTimestamp,
NULL,
'UPDATE',
@replacesObjectEventRid OUT

EXECUTE getAttributeNameForCol 'REPLACES_BUSINESSTERM_XMETA', @colAttributeName OUT
EXECUTE CreateRefUpdate
@replacesObjectEventRid,
@colAttributeName,
@SWV_NEW_NAME_XMETA,
@SWV_NEW_XMETA_REPOS_OBJECT_ID_XMETA,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA,
'ADDED'
end

if @SWV_OLD_REPLACEDBY_BUSINESSTERM_XMETA IS NOT NULL
begin
EXECUTE getBusinessTermName
@SWV_OLD_REPLACEDBY_BUSINESSTERM_XMETA,
@replacedTermName OUT

EXECUTE getAttributeNameForCol 'REPLACEDBY_BUSINESSTERM_XMETA', @colAttributeName OUT
EXECUTE CreateRefUpdate
@objectEventRid,
@colAttributeName,
@replacedTermName,
@SWV_OLD_REPLACEDBY_BUSINESSTERM_XMETA,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA,
'REMOVED'

EXECUTE getOrCreateObjectEvent
@SWV_OLD_REPLACEDBY_BUSINESSTERM_XMETA,
@sessionUser,
@sessionTimestamp,
NULL,
'UPDATE',
@replacesObjectEventRid OUT

EXECUTE getAttributeNameForCol 'REPLACES_BUSINESSTERM_XMETA', @colAttributeName OUT
EXECUTE CreateRefUpdate
@replacesObjectEventRid,
@colAttributeName,
@SWV_NEW_NAME_XMETA,
@SWV_OLD_XMETA_REPOS_OBJECT_ID_XMETA,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA,
'REMOVED'
end
end

if COALESCE(@SWV_OLD_OF_BUSINESSCATEGORY_XMETA,'') != COALESCE(@SWV_NEW_OF_BUSINESSCATEGORY_XMETA,'')
begin
if @SWV_NEW_OF_BUSINESSCATEGORY_XMETA IS NOT NULL
begin
EXECUTE getAttributeNameForCol 'OF_BUSINESSCATEGORY_XMETA', @colAttributeName OUT
EXECUTE getBusinessCategoryName @SWV_NEW_OF_BUSINESSCATEGORY_XMETA, @categoryName OUT

EXECUTE CreateRefUpdate
@objectEventRid,
@colAttributeName,
@categoryName,
@SWV_NEW_OF_BUSINESSCATEGORY_XMETA,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA,
'ADDED'
end
if @SWV_OLD_OF_BUSINESSCATEGORY_XMETA IS NOT NULL
begin
EXECUTE getAttributeNameForCol 'OF_BUSINESSCATEGORY_XMETA', @colAttributeName OUT
EXECUTE getBusinessCategoryName @SWV_OLD_OF_BUSINESSCATEGORY_XMETA, @categoryName OUT

EXECUTE CreateRefUpdate
@objectEventRid,
@colAttributeName,
@categoryName,
@SWV_OLD_OF_BUSINESSCATEGORY_XMETA,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA,
'REMOVED'
end
end

SET @updatedHasAssignmentId = @SWV_NEW_HAS_CONTACTASSIGNMENT_XMETA
SET @oldHasAssignmentId = @SWV_OLD_HAS_CONTACTASSIGNMENT_XMETA
if COALESCE(@updatedHasAssignmentId,'') != COALESCE(@oldHasAssignmentId,'')
begin
if @updatedHasAssignmentId IS NOT NULL
begin
EXECUTE getPrincipalFromContactAssignment
@updatedHasAssignmentId,
@contactAssignmentId OUT,
@contactAssignmentName OUT

EXECUTE getAttributeNameForCol 'HAS_CONTACTASSIGNMENT_XMETA', @colAttributeName OUT
EXECUTE CreateRefUpdate
@objectEventRid,
@colAttributeName,
@contactAssignmentName,
@contactAssignmentId,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA,
'ADDED'
end
if @oldHasAssignmentId IS NOT NULL
begin
EXECUTE getPrincipalFromContactAssignment
@oldHasAssignmentId,
@contactAssignmentId OUT,
@contactAssignmentName OUT

EXECUTE getAttributeNameForCol 'HAS_CONTACTASSIGNMENT_XMETA', @colAttributeName OUT
EXECUTE CreateRefUpdate
@objectEventRid,
@colAttributeName,
@contactAssignmentName,
@contactAssignmentId,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA,
'REMOVED'
end
end

if @SWV_OLD_CLASSIFICATION_XMETA != @SWV_NEW_CLASSIFICATION_XMETA
begin
EXECUTE getAttributeNameForCol 'CLASSIFICATION_XMETA', @colAttributeName OUT
EXECUTE getClassificationEnumName @SWV_OLD_CLASSIFICATION_XMETA, @classificationName OUT

EXECUTE CreateAttrUpdateC
@objectEventRid,
@colAttributeName,
@classificationName,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA
end

if @SWV_OLD_STATUS_XMETA != @SWV_NEW_STATUS_XMETA
begin
EXECUTE getAttributeNameForCol 'STATUS_XMETA', @colAttributeName OUT
EXECUTE getStatusEnumName @SWV_OLD_STATUS_XMETA, @statusEnumName OUT
EXECUTE CreateAttrUpdateC
@objectEventRid,
@colAttributeName,
@statusEnumName,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA
end

if @SWV_OLD_ISQUALIFIER_XMETA != @SWV_NEW_ISQUALIFIER_XMETA
begin
EXECUTE getAttributeNameForCol 'ISQUALIFIER_XMETA', @colAttributeName OUT
EXECUTE getBooleanName @SWV_OLD_ISQUALIFIER_XMETA, @booleanName OUT
EXECUTE CreateAttrUpdateC
@objectEventRid,
@colAttributeName,
@booleanName,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA
end

if(@SWV_OLD_ISPREFEREDIN_SYNONYMGROUP_XMETA IS NULL AND @SWV_NEW_ISPREFEREDIN_SYNONYMGROUP_XMETA IS NOT NULL)
OR(@SWV_OLD_ISPREFEREDIN_SYNONYMGROUP_XMETA IS NOT NULL AND @SWV_NEW_ISPREFEREDIN_SYNONYMGROUP_XMETA IS NULL)
OR(@SWV_OLD_ISPREFEREDIN_SYNONYMGROUP_XMETA <> @SWV_NEW_ISPREFEREDIN_SYNONYMGROUP_XMETA)
begin
EXECUTE getAttributeNameForCol 'ISPREFEREDIN_SYNONYMGROUP_XMETA', @colAttributeName OUT
EXECUTE getIsPreferedSynonymName @SWV_OLD_ISPREFEREDIN_SYNONYMGROUP_XMETA, @isPreffered OUT
EXECUTE CreateAttrUpdateC
@objectEventRid,
@colAttributeName,
@isPreffered,
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA
end
end --IF @TermHistoryEnabledRes = 1

/* Manually update the business term table - this is an instead of trigger */
UPDATE ASCLModel_xmetagen_BusinessTermb1c497ce
SET
[_xmeta_created_by_user_xmeta] = ins._xmeta_created_by_user_xmeta
,[_xmeta_creation_timestamp_xmeta] = ins._xmeta_creation_timestamp_xmeta
,[_xmeta_modification_timestamp_xmeta] = ins._xmeta_modification_timestamp_xmeta
,[_xmeta_modified_by_user_xmeta] = ins._xmeta_modified_by_user_xmeta
,[abbreviation_xmeta] = ins.abbreviation_xmeta
,[alternateAbbreviation_xmeta] = ins.alternateAbbreviation_xmeta
,[classification_xmeta] = ins.classification_xmeta
,[container_rid] = ins.container_rid
,[createdBy_Principal_xmeta] = ins.createdBy_Principal_xmeta
,[example_xmeta] = ins.example_xmeta
,[has_Acl_xmeta] = ins.has_Acl_xmeta
,[has_Alias_xmeta] = ins.has_Alias_xmeta
,[has_Annotation_xmeta] = ins.has_Annotation_xmeta
,[has_ContactAssignment_xmeta] = ins.has_ContactAssignment_xmeta
,[isPreferedIn_SynonymGroup_xmeta] = ins.isPreferedIn_SynonymGroup_xmeta
,[isQualifier_xmeta] = ins.isQualifier_xmeta
,[isSystem_xmeta] = ins.isSystem_xmeta
,[longDescription_xmeta] = ins.longDescription_xmeta
,[name_xmeta] = ins.name_xmeta
,[of_BusinessCategory_xmeta] = ins.of_BusinessCategory_xmeta
,[of_SynonymGroup_xmeta] = ins.of_SynonymGroup_xmeta
,[replacedBy_BusinessTerm_xmeta] = ins.replacedBy_BusinessTerm_xmeta
,[replaces_BusinessTerm_xmeta] = ins.replaces_BusinessTerm_xmeta
,[shortDescription_xmeta] = ins.shortDescription_xmeta
,[status_xmeta] = ins.status_xmeta
,[subtype_xmeta] = ins.subtype_xmeta
,[updatedBy_Principal_xmeta] = ins.updatedBy_Principal_xmeta
,[usage_xmeta] = ins.usage_xmeta
FROM (SELECT * FROM INSERTED) AS ins
WHERE ASCLModel_xmetagen_BusinessTermb1c497ce._xmeta_repos_object_id_xmeta = ins._xmeta_repos_object_id_xmeta

FETCH NEXT FROM @SWV_Cursor_For_OLD INTO
@SWV_OLD_ABBREVIATION_XMETA,
@SWV_OLD_ALTERNATEABBREVIATION_XMETA,
@SWV_OLD_SHORTDESCRIPTION_XMETA,
@SWV_OLD_EXAMPLE_XMETA,
@SWV_OLD_NAME_XMETA,
@SWV_OLD_USAGE_XMETA,
@SWV_OLD_OF_SYNONYMGROUP_XMETA,
@SWV_OLD_REPLACEDBY_BUSINESSTERM_XMETA,
@SWV_OLD_XMETA_REPOS_OBJECT_ID_XMETA,
@SWV_OLD_OF_BUSINESSCATEGORY_XMETA,
@SWV_OLD_CLASSIFICATION_XMETA,
@SWV_OLD_STATUS_XMETA,
@SWV_OLD_ISQUALIFIER_XMETA,
@SWV_OLD_ISPREFEREDIN_SYNONYMGROUP_XMETA,
@SWV_OLD_LONGDESCRIPTION_XMETA,
@SWV_OLD_HAS_CONTACTASSIGNMENT_XMETA

FETCH NEXT FROM @SWV_Cursor_For_NEW INTO
@SWV_NEW_XMETA_MODIFIED_BY_USER_XMETA,
@SWV_NEW_XMETA_MODIFICATION_TIMESTAMP_XMETA,
@SWV_NEW_XMETA_REPOS_OBJECT_ID_XMETA,
@SWV_NEW_ABBREVIATION_XMETA,
@SWV_NEW_ALTERNATEABBREVIATION_XMETA,
@SWV_NEW_SHORTDESCRIPTION_XMETA,
@SWV_NEW_EXAMPLE_XMETA,
@SWV_NEW_NAME_XMETA,
@SWV_NEW_USAGE_XMETA,
@SWV_NEW_OF_SYNONYMGROUP_XMETA,
@SWV_NEW_REPLACEDBY_BUSINESSTERM_XMETA,
@SWV_NEW_OF_BUSINESSCATEGORY_XMETA,
@SWV_NEW_CLASSIFICATION_XMETA,
@SWV_NEW_STATUS_XMETA,
@SWV_NEW_ISQUALIFIER_XMETA,
@SWV_NEW_ISPREFEREDIN_SYNONYMGROUP_XMETA,
@SWV_NEW_LONGDESCRIPTION_XMETA,
@SWV_NEW_HAS_CONTACTASSIGNMENT_XMETA
end --while
IF @TermHistoryEnabledRes = 1 BEGIN
EXECUTE CLEAR_TEMP_TABLES
end

CLOSE @SWV_Cursor_For_OLD
CLOSE @SWV_Cursor_For_NEW

Thanks in advance.

arvind_ds · Post by **arvind_ds** » Mon May 14, 2012 5:08 am

Make sure that the xmeta owner(default name : xmeta) must have the below privileges across your metadata repository.

CREATE SESSION,CONNECT,RESOURCE
CREATE TABLE
CREATE VIEW
CREATE ANY INDEX
CREATE TRIGGER
CREATE PROCEDURE
ADMINISTER DATABASE TRIGGER

sreddy666 · Post by **sreddy666** » Mon May 14, 2012 6:02 am

Hi Aravind,

xmeta is having sysadmin server roles, additionally dbcreator also.

Could you suggest us , can we go ahead by skipping this issue.

Thanks in advance.

arvind_ds · Post by **arvind_ds** » Mon May 14, 2012 6:27 am

I think you must grant the mentioned privileges to xmeta user to avoid any issues.

arvind_ds · Post by **arvind_ds** » Mon May 14, 2012 6:47 am

Aditional Comments:
Where ever you have downloaded the product media, try to explore the below folders.This folder contains the pre-requisites for xmeta stuff.

.../is-suite/DatabaseSupport/Windows/MetadataRepository/SQLServer2005

sreddy666 · Post by **sreddy666** » Mon May 14, 2012 6:58 am

Hi Arvind,

I have checked log files created during installation : please find below error along with query.

`````````````````````````````````````````````
Caused by: java.sql.SQLException: [IBM][SQLServer JDBC Driver][SQLServer]Invalid column name 'ABBREVIATION_XMETA'.

````````````````````````````````
FULL log:
---------

at com.ibm.is.install.core.SQLHelper.executeSql(SQLHelper.java:98)
at com.ibm.is.install.core.SQLHelper.executeFile(SQLHelper.java:171)
at com.ibm.is.install.engine.action.builtin.ExecuteSQLAction.execute(ExecuteSQLAction.java:132)
at com.ibm.is.install.engine.runtime.InstallEngine.executeAction(InstallEngine.java:1318)
at com.ibm.is.install.engine.runtime.InstallEngine.processInstallActionStep(InstallEngine.java:1258)
at com.ibm.is.install.engine.runtime.InstallEngine.processActionStep(InstallEngine.java:1142)
at com.ibm.is.install.engine.runtime.InstallEngine.processInstallStep(InstallEngine.java:333)
at com.ibm.is.install.engine.runtime.InstallEngine.processAllSteps(InstallEngine.java:313)
at com.ibm.is.install.engine.runtime.InstallEngine.run(InstallEngine.java:235)
at com.ibm.is.install.engine.runtime.InstallEngine.execute(InstallEngine.java:626)
at com.ibm.is.install.atlasinstaller.ui.control.InstallEngineMonitor.execute(InstallEngineMonitor.java:371)
at com.ibm.is.install.atlasinstaller.ui.control.InstallEngineMonitor.beginInstall(InstallEngineMonitor.java:254)
at com.ibm.is.install.atlasinstaller.ui.control.InstallEngineMonitor.access$100(InstallEngineMonitor.java:39)
at com.ibm.is.install.atlasinstaller.ui.control.InstallEngineMonitor$1.run(InstallEngineMonitor.java:123)
at java.lang.Thread.run(Thread.java:810)
Caused by: java.sql.SQLException: [IBM][SQLServer JDBC Driver][SQLServer]Invalid column name 'ABBREVIATION_XMETA'.
at com.ibm.isf.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.ibm.isf.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.ibm.isf.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.ibm.isf.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.ibm.isf.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.ibm.isf.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.ibm.isf.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.ibm.isf.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.ibm.isf.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.ibm.isf.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at com.ibm.isf.jdbc.base.BaseStatement.execute(Unknown Source)
at com.ibm.is.install.core.SQLHelper.executeSql(SQLHelper.java:87)
... 14 more

chulett · Post by **chulett** » Mon May 14, 2012 7:19 am

You should be taking this to your official support provider.