Migration shows comp/error for record fields (4250670)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Migration shows comp/error for record fields
Description

The migration with record fields is consistently comp/error. However we were able to migrate these objects outside of Stat without any problem.
Cause

This problem only occur with Stat db on Oracle and Peoplesoft dbs on SQL Server.
Resolution

1. Take a good back-up of the stat schema
2. Run the following statements against the stat db:
DROP INDEX ST_PSDBFIELD_8F_IDX1 on STAT.ST_PSDBFIELD_8F
DROP INDEX ST_PSDBFIELD_8F_IDX2 on STAT.ST_PSDBFIELD_8F
ALTER TABLE STAT.ST_PSDBFIELD_8F ALTER COLUMN FIELDNAME nvarchar(18) not null
CREATE UNIQUE CLUSTERED INDEX ST_PSDBFIELD_8F_IDX1 ON STAT.ST_PSDBFIELD_8F (
SD_CD, CSR_ID, SWAT_ID, PS_DATABASE,FIELDNAME)
CREATE INDEX ST_PSDBFIELD_8F_IDX2 ON STAT.ST_PSDBFIELD_8F (FIELDNAME)
UPDATE STAT.ST_PSDBFIELD_8F SET FIELDNAME=RTRIM(FIELDNAME)
UPDATE STAT.CSR_PS_SWAT_SUBOBJ SET SUBOBJ_NAME=RTRIM(SUBOBJ_NAME)
3. Try the migration again

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title