Crystal Server 2013 configuration on Linux

[Former Member]

Hi,

We are configuring Crystal server 2013 on Red Hat Enterprise Linux Server release 6.1. We have installed both the Oracle client 64 bit and Oracle client 32 bit. The following are the environment variables:

## Crystal Report
export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export ORACLE_HOME32=/usr/lib/oracle/11.2/client

export TNS_ADMIN=${ORACLE_HOME}/network/admin
export TNS_ADMIN32=${ORACLE_HOME32}/network/admin

export LD_LIBRARY_PATH=${ORACLE_HOME}/lib:/usr/lib64:/usr/lib:${LD_LIBRARY_PATH}
export LD_LIBRARY_PATH32=${ORACLE_HOME32}/lib:/usr/lib:/usr/lib64:${LD_LIBRARY_PATH}

export PATH=${ORACLE_HOME}/bin:$PATH
export PATH32=${ORACLE_HOME32}/bin:$PATH

#export PATH=${ORACLE_HOME}/bin:${ORACLE_HOME32}/bin:$PATH

#BOE_USE_32BIT_ENV_FOR=ORACLE_HOME,LD_LIBRARY_PATH,TNS_ADMIN,PATH
#export BOE_USE_32BIT_ENV_FOR

#BOE_USE_32BIT_ENV_FOR=ORACLE_HOME,TNS_ADMIN,LD_LIBRARY_PATH
#export BOE_USE_32BIT_ENV_FOR
#export BOE_USE_32BIT_ENV_FOR=ORACLE_HOME,TNS_ADMIN,LD_LIBRARY_PATH,PATH

When we uncomment the environment variable BOE_USE_32BIT_ENV_FOR we get an error

"The viewer could not process an event. Internal Error. Please contact your system administrator. [RCIRAS0216]. Error Code 0 [CRWEB00000119]".

Can anyone let us know the reason for the same.

Regards,

Simran

[Former Member]

Can anyone provide a solution for the same?

Regards,

Simran

[Former Member]

can you verify your settings using

-Nikhil Nair

[Former Member]

Hi Nikhil,

We have installed Oracle client 64 bit and Runtime and Oracle client 32 bit as insta client.
Following are the entries of our bash profile:

export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/client_64

export ORACLE_HOME32=/home/oracle32/app/oracle32/product/11.2.0/client_32

export PATH=$PATH:$ORACLE_HOME/bin

export PATH32=$PATH:$ORACLE_HOME32/bin

export TNS_ADMIN=$ORACLE_HOME/network/admin

export TNS_ADMIN32=$ORACLE_HOME32/network/admin

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

export LD_LIBRARY_PATH32=$ORACLE_HOME32/lib

export BOE_USE_32BIT_ENV_FOR=$ORACLE_HOME32,$TNS_ADMIN32,$LD_LIBRARY_PATH32,$PATH32

Still we are getting the error:

The viewer could not process an event. Error in File ETACTASPTAStatisticsReport: Failed to load database information. [] ---- Error code:0 [CRWEB00000119]

Can you please let us know the changes which we need do to connect to the database.

Regards,

Simran

[Former Member]

BOE_USE_32BIT_ENV_FOR is as following

export BOE_USE_32BIT_ENV_FOR=$ORACLE_HOME32,$TNS_ADMIN32,$LD_LIBRARY_PATH32,$PATH32

Regards,

Simran

[Former Member]

Hi,

Can anyone provide me a solution regarding the same?

Thanks,

Simran

[Former Member]

Hi!

I can only tell you the solution for AIX

• you have installed the 32bit Version of Oracle Client on your machine
• Change the .Profile of the User which the BI Server is running

And now the important stuff...

export BOE_USE_32BIT_ENV_FOR=ORACLE_HOME,LIBPATH

internally BOE is changing the ORACLE_HOME to $ORACLE_HOME32 and also LIBPATH to $LIBPATH32 and checking the paths of the 2 variables.

very important

before you restart your Server source the Profile again to be sure the new enviroment Variables were set.

check it with echo $ORACLE_HOME32 and so on....

Feel free to ask again...

[Former Member]

Hi,

We were able to install the Crystal server 2013. We have installed the bundled database which comes with Crystal server for CMS. For crystal report we have installed the Oracle client 32 bit. Using this configuration we have been able to set up the server.

Regards,

Simran