Migration from CE 8 to CE 9 problems

[obiwanfan]

My company is currently upgrading from CE 8 to CE 9. The reports that currently function in CE 8 without issue, either will not run or take a while to execute in CE 9. Did anyone else experience this type of problem and how did you resolve it.

I have found one article that indicates you should remove CE 8 first and then install CE 9 and to not upgrade. Before I did this I wanted to see if there were any other solutions.

 

[synapsevampire]

I don't know why the upgrade would cause this.

By does not run, does this mean an error, system crash, or nothing happens?

What does take a while to execute mean? Twice as long, or?

I would suspect the connectivity used or the record selection formula not passing.

Too little to go on.

-k

 

[Guyute97]

I ended up going the clean install route as I had heard of problems with just upgrading so I didn't even attempt the upgrade.

--Guyute

 

[obiwanfan]

By not running I mean that I sometimes get the Parameter window and the it just hangs. On several of the reports I can't even get the Parameter list to show up.

The reports are taking more than 2 to 3 times as long to run. The average respones time is 3 minutes or better for most reports.

In version 8 most of the reports ran in under a minute and they run run in under 3 minutes.

 

[gashandler]

I would definitely install CE9 on another server like you're planning on doing instead of upgrading the existing one.
It does take CE9 longer to run reports than CE85. I installed CE9 on faster hardware and it actually ran reports slower than CE85 on the inferior server. It's not a big difference. A scheduled report that took 3seconds in CE85 takes about 10seconds or so in CE9. Not a huge deal really unless you have a lot of reports scheduled to run in succession like I do--then you'll notice a BIG difference.

Also, if you have reports nested in the UserFolders directory don't bother using the ImportWizard. They import fine if they're in the parent directory but they don't import if they're in a subdirectory. This only affects UserFolders so it may not impact you. Crystal Support had no clue as to why it did this so they suggested I use the database migration "wizard" instead and then copy the filestore over to the new installation.
That worked pretty well. I've done it so many times now I can do it in my sleep.

Also, the Excel export drivers changed so you'll want to test that and the drop down list for parameters is now limited to 50 when it used to be apparently unlimited.

 

[MColeman]

When I upgraded to 9, I opened each report in 9 and did a verify database, and then a save.

Maybe your reports are trying to verify and update this information before they run. Perhaps that could explain the time lapse.

 

[gashandler]

Re.: verify database, and then a save

Yeah I did that already. Didn't make much of a difference.

 

[synapsevampire]

There have been problems with some viewers (In the early releases of CE 9 if a datetime was the first parm in an Active-X on XP machines, then the system hung).

Try changing viewers, and eliminating parms, you may have found a bugt similar to what I discovered druing BETA of CE 8.5, and it wasn't resolved until a few months after release, though their KB made no reference to it...

-k