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.