1 Reply Latest reply on Sep 16, 2020 1:05 AM by Akshaye Shreenithi Kirupa

    Informatica Hyper Connect For Anaplan Error

    Amit Mehta New Member

      Hi,

       

      I am getting following error when trying hyper connect  synchronization task between SQL Server and Anaplan (using upsert option) -

       

      [ERROR] Error occured while writing data to the target native system : [Operation type 'Upsert' not supported.]

       

      When I change option to insert ( instead of upsert), it throwing error -

       

      Internal error. The DTM process terminated unexpectedly. Contact Informatica Global Customer Support.

       

      Please suggest.

       

      Regards,

      Amit

        • 1. Re: Informatica Hyper Connect For Anaplan Error
          Akshaye Shreenithi Kirupa Guru

          Hi Amit

           

          Please note with anaplan v2 connection in IICS, for anaplan targets only insert operation is supported. Please find the connector doc screenshot below: Thats the reason you are seeing "Operation type 'Upsert' not supported." error when trying to perform upsert.

           

          For the issue where you are seeing Internal DTM error, can you please share the entries that of the error stack that you see in session log. If the session log doesn't have any entries other than "Internal error. The DTM process terminated unexpectedly. Contact Informatica Global Customer Support." please retrigger the task and share the latest entries that you see in tomcat log for analysis, tomcat log path: Informatica Cloud Secure Agent\apps\Data_Integration_Server\logs\tomcat