When attempting to create a report using the Web Intelligence Document and then Spectrum Ad Hoc MySQL EN universe an error: WIJ20002 is received.

Document ID : KB000018766
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Web Intelligence Processing Server gets restarted when creating Web Intelligence(Webi) report against universe which is using JDBC on Solaris
Error message: "Unexpected error. If you cannot reconnect to the server, close Web Intelligence and start again. (WIJ 20002)

Environment
BusinessObjects Enterprise(BOE) XI3.1 Service Pack(SP) 5
Sun Solaris 10

Solution:

NOTE: Change <BOE install folder> below to your actual install path:

  1. Stop all BOE servers.

  2. Backup the <BOE install folder>/setup/boconfig.cfg file before modification.

  3. Find the section below:

    [Software\Business Objects\Suite
    12.0\default\Shared\ConnectionServer\Configuration]
    "Config File"=string:"cs.cfg"
    "Config Directory"=string:"<BOE install
    folder>/bobje/enterprise120/solaris_sparc/dataAccess/RDBMS/connectionServer/
    "
    "ConnectionServer Jar"=string:"<BOE install
    folder>/bobje/enterprise120/solaris_sparc/classes/ConnectionServer.jar"
    "Version Directory"=string:"<BOE install
    folder>/bobje/enterprise120/solaris_sparc/dataAccess/RDBMS/connectionServer/
    setup"
    "JVM Library"=string:"<BOE install
    folder>/bobje/jdk/jre6/lib/sparc/server/libjvm.so"

  4. Change the JVM section to be:

    "JVM Library"=string:"<BOE install folder>/bobje/jdk/jre/lib/sparc/server/libjvm.so"

  5. Start all BOE servers.