4 Replies Latest reply on Nov 4, 2021 9:57 AM by Nico Heinze

    Can't get import control file work with Object XML

    John Lyons Seasoned Veteran

      I am trying to import a workflow XML and can't get the folder/repository combo to work. here is a picture of the control file.

       

      <?xml version="1.0" encoding="UTF-8"?>

      <!DOCTYPE IMPORTPARAMS SYSTEM "/apps/informatica/10_4_1/base/server/bin/impcntl.dtd">

      <IMPORTPARAMS RETAIN_GENERATED_VALUE ="YES">

      <FOLDERMAP SOURCEFOLDERNAME="ANH_EDR_DEV"

      SOURCEREPOSITORYNAME="RS_DEV"

      TARGETFOLDERNAME="JohnLyons_EDR"

      TARGETREPOSITORYNAME="RS_QA"/>

      <RESOLVECONFLICT>

      <SPECIFICOBJECT NAME="w_AHH_DIAGNOSIS_STG_LOAD" OBJECTTYPENAME="Workflow" FOLDERNAME="JohnLyons_EDR" REPOSITORYNAME="RS_QA" RESOLUTION="REPLACE"/>

       

      ============================================================================

      here is highlevel details on the XML file

       

      <REPOSITORY NAME="RS_DEV" VERSION="188" CODEPAGE="Latin1" DATABASETYPE="Oracle">

      <FOLDER NAME="ANH_EDR_DEV" GROUP="" OWNER="Administrator" SHARED="NOTSHARED" DESCRIPTION="" PERMISSIONS="rwx---r--" UUID="f2190ed5-8171-43f8-9788-7fa7413d9bce">

          <SOURCE BUSINESSNAME ="" DATABASETYPE ="Oracle" DBDNAME ="ETL_JOBS_DEV" DESCRIPTION ="" NAME ="AHH_DIAGNOSIS_STG" OBJECTVERSION ="1" OWNERNAME ="SFMARKET" VERSIONNUMBER ="1">

              <SOURCEFIELD BUSINESSNAME ="" DATATYPE ="varchar2" DESCRIPTION ="" FIELDNUMBER ="1" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="0" LEVEL ="0" NAME ="RECORDTYPEID" NULLABLE ="NULL" OCCURS ="0" OFFSET ="0" PH

       

      ======================================================================

      I get the following from object import:

       

      Folder [JohnLyons_EDR] cannot be found in repository [RS_QA].

      Failed to execute objectimport.

       

      Which does exist.