Forum Stats

  • 3,824,772 Users
  • 2,260,416 Discussions
  • 7,896,309 Comments

Discussions

DLR hangs, ODI-1217 and ODI-1280 errors

samlambert
samlambert Member Posts: 39 Green Ribbon
edited Feb 27, 2020 9:04AM in Financial Data Management

I'm executing a DLR after following the fishing with fdmee process and the DLR is hanging. I've had a look at the ODI Session Number and the logs show the following:

-<errorMessage>

-<![CDATA[ODI-1217: Session COMM_LOAD_BALANCES (346501) fails with return code 7000.

ODI-1280: The Target Logical Schema AIF_TGT and Context UDA_ORACLE of the task Update Process are not mapped to any Physical Schema.

Caused By: com.sunopsis.core.SnpsInexistantSchemaException: ODI-17523: There is no connection for this logical schema / context pair: AIF_TGT / UDA_ORACLE.

    at com.sunopsis.dwg.dbobj.SnpConnect.getSnpConnectByLSchemaNameAndContext

But my UDA_ORACLE is mapped to a physical schema. When I try to map AIF_TGT to a physical schema it only says [[not defined]].

samlambert

Best Answer

  • SH_INT
    SH_INT Member Posts: 3,192 Bronze Crown
    edited Feb 19, 2020 5:08AM Answer ✓

    In the ODI project that you reference in FDMEE for the UDA adapter make sure that the model datastores in use in the project reference the correct logical schema.

Answers