cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Reports 11g Performance Issue

Former Member
0 Kudos

We just upgraded our database to Oracle 11g from Oracle 10g and we are having significant performance issues with Crystal Reports.

Our DEV and TEST environments are on 11g and are very slow to connect to the database and attach to specific tables. It is unusable. Our PROD environment is still 10g and works fine.

We have tested with both the lastest version - Crystal Reports 2008 V1 and Crystal Reports XI R2 SP6. We have also tested on several different machines.

We are using Oracle 10g ODBC drivers.

Does anyone have any recommendations?

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Can you try this with CR 2008 V1 SP3 and the Oracle 11g ODBC drivers?

Regards,

Stratos

Former Member
0 Kudos

We were on no service packs when we had the issue. I think we were given sp4 to bring us up to version 2, and then we applied 5 and 6. That did not fix the issue, so then we tried the demo version of the lastest release.

Former Member
0 Kudos

We have not rolled out 11g drivers yet. Do you know if that will make a difference?

0 Kudos

What you mention is for CR XI R2. I am talking about SP3 for CR 2008 V1. This is the latest service pack for this release

SAP supports access to Oracle 11g R1 in Crystal Reports over the Oracle 11g R1 ODBC driver. I woulöd recommend to try the the official recommendation.

Regards,

Stratos

0 Kudos

You could also try our Data direct drivers we have available on our WEB site using this [link|https://smpdl.sap-ag.de/~sapidp/012002523100008666562008E/cr_datadirect53_win32.zip].

Those drivers are the most recent and do support 11g. It also has a wired driver that doesn't require the client to be installed.

Also, highly recommended that when you do update the Oracle client to uninstall 10 first. There have been issues with CR and Oracle mixing the Oracle dependencies and causing problems.

Thank you

Don

Answers (0)