Problems testing data source connections with IBM Cognos Analytics deployed on SAP NetWeaver Application Server 7.1.1 on UNIX

If you have deployed IBM® Cognos® Analytics on SAP NetWeaver Application Server 7.1.1 running on a UNIX operating system, you may receive an error when you test your data source connections in IBM Cognos Administration.

To resolve this problem, you must update the library path and all paths used for database client access in a SAP environment file named .sapenv_servername.sh, where servername is the name of your server.

Procedure

  1. Go to the SAP administrator user's home directory.
  2. Locate the file named .sapenv_servername.sh, where servername is the name of your server.
  3. Open the file in a text editor.
  4. Add install_location/bin64 to the library path and any path locations required for database client access.

    For example, if you have installed IBM Cognos Analytics to /server1/home/ibm/cognos/install, your library path would look like the following:

    LIBPATH=/server1/home/ibm/cognos/install/bin64:/db/oracle/11.1.0.6/lib32:
/server1/home/db2user/sqllib/lib32:/usr/lib:/lib:$_DEF_EXE; export LIBPATH
  5. Save the file, and restart the SAP and IBM Cognos Analytics processes.
  6. Test your database connections.