Few months ago, my company decides and proceeds to upgrade our factory MES system, we create a new database for the new MES system, using Oracle 11gR2 instead of previous Oracle 9i, and we also create a new user and its schema meswip45 instead of previous mesprd on the new 11g database.
Every program which link to the MES system was upgrade side by side, one after another according to the project plan, it is barely smoothly according to the plan. Now, we will make MES system go live to the production in 2012/1/2 and it's the best time point as it is most idle time in a year and just following by Christmas and Chinese Spring Festival.
But during last two weeks UAT, one of our user found the Travel Card (just the Crystal Reporting business alternative name, you can read it as a specially report) cannot output via printer, after check the one of the slowest Crystal Reporting, we can easily conclude that there is no program logic bug to block the Crystal Travel Card printing. It is just the reporting execution time is unreasonable long (more than 2 minutes to output the actual content).