cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to Refresh the Crystal reports in infoview/BI Launch pad

Former Member
0 Kudos

Hi All,

I have created the reports using BOCR 2011 SP11 and published them in inofview which is of BOBI 4.0 SP4.

I am unable to refresh the report. It is throwing 

----------------------------------------------------------------------------------------------------

The viewer could not process an event. Error in File Teller Position Report:

Failed to load database information. []

---- Error code:0 [CRWEB00000119]

----------------------------------------------------------------------------------------------------


Please help me out..I am struggling from two days..

Regards,

Santhosh.S

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Santhosh,

Log-in to CMC > Right-click the report > Database configuration.

Make sure the database config is setup correctly.

Also make sure that the database drivers/ODBC is setup as required.

-Abhilash

Former Member
0 Kudos

Hi Abhilash,

I have configured by giving same database credentials. and

gave option as " Use Same Database log on as when report is run".

server is been installed with 64 bit on windows 2008. and in client with 32 bit driver.

Regards,

Santhosh.S

abhilash_kumar
Active Contributor
0 Kudos

What database are you reporting against?

-Abhilash

Former Member
0 Kudos

I used oracle server and wrote the query using add command ..and generated the report.

-Santhosh

abhilash_kumar
Active Contributor
0 Kudos

Make sure you've installed the '32-bit oracle Client' on the BO Server box.

Then, logon to CMC and browse to the report > Right-click > Database Configuration > Select 'Use Custom database logon information specified here' > Choose Oracle as the 'Database Type'.

Server: Database Server as specified in the TNS file

Database: Leave blank

User: DB User ID

Password: DB Password

Table Prefix: Scheme if any

Click Update.

If the report is based off of an ODBC, then make sure the same ODBC that exists on the 'client' machine is also created on the BO Server box and you can then use the 'use original database logon information from the report' option and type in the credentials.

-Abhilash

Former Member
0 Kudos

Hi Abhilash.

I have to raise a ticket to my IT Admin Team to install 32 bit in server.

Can you please provide KB or any official documents to meet the requirements.

Santhoshsreshta@gmail.com is my email id.

Thanks a lot,

Santhosh.S

abhilash_kumar
Active Contributor
0 Kudos

CR 2011 is a 32-bit application and uses 32-bit Services on the BI Platform. Hence it will need 32-bit drivers for ANY database.

I don't think you'd need an SAP Note for the IT Admin to know this!

You could still use the search bar on the top right corner of the page and see if any official documentation exists.

-Abhilash

Former Member
0 Kudos

Hi Abhilash.

My Servers Operating System is 64 bit version. which is already been installed with 64 bit odbc driver.Can we install 32 bit oracle driver to it.?

Can we use 32 and 64 bit oracle drivers side by side.?

abhilash_kumar
Active Contributor
0 Kudos

Yes.

-Abhilash

Answers (0)