source to target data is getting loaded partially via IICS

Nirmchan
Nirmchan
in Integrations and extensibility

Hello,

i'm fairly new to Anaplan but come from BI products world. I have a situation, an Import action is created in Anaplan dev. This action picks up the .csv file from source location (This has been working perfectly fine in our environment for last 4 years) and loads it in to one of the Modules. This process has been automated in IICS and works as expected in Dev environment.

Here comes the issue:

Push this action using compare sync option from Dev to UAT for Anaplan Action. Using Import/Export option from IICS, move the job. There are no issues seen.

Now try to run this job from IICS, there is an error seen as "Operation failed: com.informatica.adapter.sdkadapter.exceptions.MetadataAccessException: [SDK_APP_COM_20000] error [null]." If we try to select the target action or source file, they are able to fetch in correctly. research on the blogs point that the .csv file not available on the Anaplan, if we try to load manually using the actions in Model there is an error as file doesn't exist.

Has anyone seen this kind of issue? I have heard that getting a support from the product front takes a longer than usual time. Any help from the experts here is highly appreciated. Thank you in advance.

Tagged:

Answers

  • alexpavel
    alexpavel

    @Nirmchan I never worked with Informatica, but from your description it seems to be an IICS issue.

    When you talk about DEV and UAT, do you mean IICS environments?

    Do you also have DEV and UAT Anaplan models?

    From the Anaplan side, you just need to create an import action where the source is a CSV file.

    Everything else needs to be handled by the integration tool (no matter which method you are using: IICS, manual, REST API, Anaplan connect, CloudWorks…etc).

    After authentication, the integration tool needs to perform these steps:

    1. have access to the CSV file that coincides with the structure of the file that was used to build the Anaplan import action.
    2. The CSV file needs to be uploaded using as a target the same CSV file that was used to build the import action (the CSV files can be seen in the tab " Import Data sources" from the Actions section.
    3. it is needed to trigger the Anaplan Import action that will the data from the uploaded CSV file into the Anaplan target object (list or module)

    It is IICS and the Informatica Anaplan Connector that need to connect to the source, create and upload that CSV file and launch the Anaplan import action (or process that contains the import action).

    The reason why you receive an error when you maually launch the import action in Anaplan is that the CSV file on the Anaplan side is that the file that was used when the import action was created does not exist anymore. The CSV file on the Anaplan side has reason to exist only for the file structure.

    Not sure what option was used when the Anaplan import action was built, but the file present in "Import Data Sources" tab is not the file uploaded by IICS on the last run.

    To test an Anaplan import action you need to publish the Anaplan import/process on a page/dashboard, have a CSV file, push the button and then you are asked to select and upload the local CSV file, and the action is launched.

    Hope it helps

    Alex

  • Nirmchan
    Nirmchan

    hi @alexpavel Thank you so much for your reply. This gives me a greater insight in to what i might be missing. I did cross check the areas you had mentioned and all looks good. Yes, we do have Dev and UAT environments both in Anaplan as well as IICS. What i observed is when i compare and sync the actions in Anaplan which has the .csv action from Dev to UAT, the file seems to be lost. If i reload the file in UAT and rerun the action it works. As a workaround we could get this file loaded using cloud works, but this feature is still broken in IICS. Hopefully it will get resolved soon !

    Thanks for your help and appreciated !!

  • MadMon
    MadMon

    Hi @nirmchan,

    I have been working on Anaplan and IICS for more then 3 years. most of the error is related to Anaplan Actions only. So Whenever you get any error just check the action by testing manually first in anaplan,if its working then only include in IICS job.

    Hope it helps!

Categories