0 Replies Latest reply on Jul 19, 2012 2:12 PM by NathanG

    erpi no longer loading to essbase. Failed to connect to sql database error

    NathanG
      Hi,

      ERPI 11.1.2.1 patch 501.

      I had successfully configured erpi to load to essbase. However, the data load from the erpi database is now failing. The error is 'Cannot begin data load. Essbase Error(1021001): Failed to Establish Connection With SQL Database Server.' The data from e-businessis in the erpi database though. I can connect using sql developer to it. When I open the aifdata load rule in EAS the OCI entry is no longer present. if I manually enter this and use a piece of maxl the data will load.

      How do I get the oci details automatically back in the load rule?

      For further context I have been trying to configure an odbc on a AIX box for essbase. The problem started then.

      Thanks,

      Nathan