Print Page - Getting Error during importing datasource of essbase hyperion ?

Title: Getting Error during importing datasource of essbase hyperion ?
Post by: gouravatalkar on 08 Sep 2010 06:37:33 AM

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

Title: Re: Getting Error during importing datasource of essbase hyperion ?
Post by: tupac_rd on 09 Sep 2010 10:46:25 AM

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

Title: Re: Getting Error during importing datasource of essbase hyperion ?
Post by: gouravatalkar on 10 Sep 2010 05:21:27 AM

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.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: gouravatalkar on 08 Sep 2010 06:37:33 AM