none
DMA Assessment 실행시 오류 발생 RRS feed

  • 질문

  • 안녕하세요~

    mssql 2008 r2 -> 2016으로  마이그레이션을 위해 DMA툴로 Assessment를 실행했는데

    21개의 데이터베이스 assessment는 성공했는데  1개의 데이터베이스 에서 오류가 발생했습니다..

    OPENDATASOURCE,OPENROWSET  사용에 문제가 되는것 같은데.. 특정 DB에서만 안되는 현상인데.. 참고할만한 자료 부탁드리겠습니다 ㅜㅠ

    오류 메시지는 아래와 같습니다.

    There were errors assessing this database and/or xevent traces. Please review them before retrying. 

    The assessment of database 'EHR' on server 'VTDBSQL\TDBVSQL' failed.
    Failed to extract dacpac at location 'C:\Users\poscoenc\AppData\Local\DataMigrationAssistant\DacFxAnalyzer-d5e5460073974e6da0-EHR\EHR.dacpac'.
    Could not extract package from specified database.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetReHiredYNPJT]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetReHiredYN]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL71005: Error validating element [dbo].[EHRUF_MG_GetPreRetrdDatePJT]: The reference to the column X.RetiredDate could not be resolved.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetPreRetrdDatePJT]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL71005: Error validating element [dbo].[EHRUF_MG_GetPreRetrdDate]: The reference to the column X.RetiredDate could not be resolved.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetPreRetrdDate]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetMarriageYNPJT]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetMarriageYNPJT]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetMarriageYN]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetCodeCommon]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL71005: Error validating element [dbo].[EHRUF_MG_GetAppointDate]: The reference to the column X.AppointDate could not be resolved.
    Warning SQL70558: Error validating element [dbo].[EHRUF_MG_GetAppointDate]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.UserType        AS UserType could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.UserID        AS UserID could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.UserName        AS UserName could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.EnglishName       AS EnglishName could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.JobGDName        AS JobGDName could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.GroupMgrName       AS GroupMgrName could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.DeptName        AS DeptName could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.JobGDCode        AS JobGDCode could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.GroupMgrCode       AS GroupMgrCode could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.DeptCode        AS DeptCode could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.DeptRank        AS DeptRank could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.PersonID        AS PersonID could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.WorkRegCode       AS WorkRegCode could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.EmployeeStusCode      AS EmployeeStusCode could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.WorkRegName       AS WorkRegName could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.EmailAddr        AS EmailAddr could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.CellularPhoneNum      AS CellularPhoneNum could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.OfficePhone       AS OfficePhone could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.EmplSex        AS EmplSex could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.Sex         AS Sex could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.UserID could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.WedYN AS WedYN could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.Brth         AS Brth could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.HiredDate AS HiredDate could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTable]: The reference to the column AA.HiredTypeCode AS HiredTypeCode could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.UserType        AS UserType could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.UserID        AS UserID could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.UserName        AS UserName could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.EnglishName       AS EnglishName could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.JobGDName        AS JobGDName could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.GroupMgrName       AS GroupMgrName could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.DeptName        AS DeptName could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.JobGDCode        AS JobGDCode could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.GroupMgrCode       AS GroupMgrCode could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.DeptCode        AS DeptCode could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.DeptRank        AS DeptRank could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.PersonID        AS PersonID could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.WorkRegCode       AS WorkRegCode could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.EmployeeStusCode      AS EmployeeStusCode could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.WorkRegName       AS WorkRegName could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.EmailAddr        AS EmailAddr could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.CellularPhoneNum      AS CellularPhoneNum could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.OfficePhone       AS OfficePhone could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.EmplSex        AS EmplSex could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.Sex         AS Sex could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.UserID could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.WedYN AS WedYN could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.Brth         AS Brth could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.HiredDate AS HiredDate could not be resolved.
    Error SQL71005: Error validating element [dbo].[EGAUP_GetInOutUserInfoTableALL]: The reference to the column AA.HiredTypeCode AS HiredTypeCode could not be resolved.
    Warning SQL70558: Error validating element [dbo].[ETA_MIG_UpdateInvoiceAmt]: The column definition from this OPENROWSET function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[ETA_MIG_UpdateInvoiceAmt]: The column definition from this OPENROWSET function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRTB_EmpRecPrehired]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[DEAVW_IWFSetlDoc]: The column definition from this OPENROWSET function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[DEAVW_IWFSetlDocAppdFile]: The column definition from this OPENROWSET function cannot be verified, and the operations involved with it might not be understood correctly.
    Warning SQL70558: Error validating element [dbo].[EHRTB_EmpRecProjectCarrer]: The column definition from this OPENDATASOURCE function cannot be verified, and the operations involved with it might not be understood correctly.

    2020년 4월 8일 수요일 오전 6:00

답변

  • 해결했습니다..

    안에 open datasource에서 잘못된 DB, 오브젝트를 참조해서 나타나는 오류였습니다..

    봐주셔서 감사합니다 ㅎㅎ

    • 답변으로 표시됨 이경용 2020년 4월 8일 수요일 오전 6:25
    2020년 4월 8일 수요일 오전 6:25