Getting Error during importing datasource of essbase hyperion ?

[Gourav Atalkar]

hi guys i am trying to load essbase data source in cognos 8.4 as data source from cognos administration at that time i getting following errors:


  DB2-ERR-0028 Unable to load the following Essbase/DB2 OLAP library: "H:/Program Files/cognos/c8\./bin\essapinu.dll".


I have copy and paste "essapinu.dll" file from Hyperion folder to directory given in above error but still the error is coming tell me what is the solution please

[tupac_rd]

any luck from support site docs?

http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bDB2-ERR-0028&uid=swg21366806&loc=en_US&cs=utf-8&cc=us&lang=all

http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bDB2-ERR-0028&uid=swg21341974&loc=en_US&cs=utf-8&cc=us&lang=all

and maybe there are others

[Gourav Atalkar]

Got the solution thanks for reply......................


If you install an earlier Essbase/DB2 OLAP client version than what is configured for IBM Cognos 8, you may receive this error:

DB2-ERR-0028 Unable to load the following DB2 OLAP library: "C:\ibm\db2olap\bin\essapin.dll"

For example, you installed DB2 OLAP 8.1 client and the qfs_config.xml file in IBM Cognos 8 is configured to use the DB2 OLAP library for Version 8.2.

To resolve this problem, you must edit the qfs_config.xml file and change the library name for the appropriate client version you are installing.
Steps

   1.

      In the c8_location\configuration directory, edit the qfs_config.xml file.
   2.

      Find the following code:

      <provider name="DB2OlapODP" libraryName="doodp82" connectionCode="DO"/>
   3.

      Change the library name from doodp82 or doodp81 and save the changes.

Hyperion Essbase version 9.3.1 is the default client configuration. If you are installing DB2 OLAP client for either Version 8.1 or 8.2, you must edit the qfs_config.xml file and change the library name for the appropriate client version you are installing.
Steps

   1.

      In the c8_location\configuration directory, edit the qfs_config.xml file.
   2.

      Find the following code:

      <provider name="DB2OlapODP" libraryName="essodp93" connectionCode="DO"/>
   3.

      Change the library name from essodp93 to doodp81 or doodp82 and save the changes.