11 Replies Latest reply on Mar 18, 2021 4:24 AM by David Lopez Cruz

    Pmrep objectimport unable to import objects and fails without error tracking.

    Raphael Amaral New Member

      I'm using PowerCenter, 10.2.0 HF2, and I'm trying to import objects to the repository by command line but I receive an error without details to track the problem.

       

      Someone can help me to solve this problem?

       

      Ps: The server is running on Linux and the client is running on Windows 10.

       

      Error:

      C:\Informatica\10.2.0\clients\PowerCenterClient\client\bin

      λ pmrep objectimport -c /pwc/controlFile.ctl -i /pwc/objects.xml -l /pwc/log_input.log

       

      Informatica(r) PMREP, versÒo [10.2.0 HotFix2], compilaþÒo [1911.0401], Windows 32-bit

      Copyright (c) 1993-2019 Informatica LLC. All Rights Reserved.

      See patents at https://www.informatica.com/legal/patents.html.

       

      Chamado Ós Sat Mar 13 18:53:22 2021

      Falha ao executar objectimport. (Fail to execute objectimport)

       

      ConcluÝdo Ós Sat Mar 13 18:53:27 2021

       

      I'm using this control file:

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

      <!DOCTYPE IMPORTPARAMS SYSTEM "impcntl.dtd">

      <IMPORTPARAMS CHECKIN_AFTER_IMPORT="NO"

                  RETAIN_GENERATED_VALUE="YES"

                  COPY_SAP_PROGRAM="NO"

                  APPLY_DEFAULT_CONNECTION="NO">

       

       

      <FOLDERMAP SOURCEFOLDERNAME="TEST_XML_IMPORT_INT"

                SOURCEREPOSITORYNAME="Data_HML"

                TARGETFOLDERNAME="TEST_XML_IMPORT_INT"

                TARGETREPOSITORYNAME="Data_HML"/>

      <TYPEFILTER TYPENAME="SOURCE"/>

      <TYPEFILTER TYPENAME="TARGET"/>

      <TYPEFILTER TYPENAME="MAPPLET"/>

      <TYPEFILTER TYPENAME="MAPPING"/>

      <TYPEFILTER TYPENAME="TRANSFORMATION"/>

      <TYPEFILTER TYPENAME="CONFIG"/>

      <TYPEFILTER TYPENAME="TASK"/>

      <TYPEFILTER TYPENAME="SESSION"/>

      <TYPEFILTER TYPENAME="SCHEDULER"/>

      <TYPEFILTER TYPENAME="WORKFLOW"/>

      <TYPEFILTER TYPENAME="WORKLET"/>

      <RESOLVECONFLICT>

      <TYPEOBJECT OBJECTTYPENAME="WORKFLOW" RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="WORKLET"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="SESSION"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="MAPPING"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="MAPPLET"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Source definition"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Target definition"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Expression"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Filter"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Aggregator"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Rank"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Normalizer"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Router"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Sequence"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Sorter"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="update strategy"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Custom Transformation"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Lookup Procedure"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Transaction control"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Stored Procedure"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="External Procedure"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Joiner"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="SessionConfig"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Email"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Command"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Scheduler"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="Shortcut"

                RESOLUTION="REPLACE"/>

      <TYPEOBJECT OBJECTTYPENAME="ALL"

                RESOLUTION="REPLACE"/>

      </RESOLVECONFLICT>

      </IMPORTPARAMS>