I written a post about upgrade CR (Crystal Report) from Oracle 9i to Oracle 11gR2 one month ago, at that post, I talked about how different version of Oracle Database make Crystal Report migrate tough/broken and how I have solving those problem. After the Crystal Report Travel Card (T-Card) online this month, I also meet some problem relative with the Windows Server, which I think also very interesting and hoping you will enjoy the story.

I used the Vim and UltraEdit quite a long time, but I'm always dissatisfy with the vim so unique key movement and larger and larger size of UltraEdit, recently I decided to switch to the Sublime, Sublime can be programmed with my most prefer language Python. Sublime also provide a same experience on Windows/OSX/Linux but only need to pay 1 license. So learning Sublime from the scratch is for a long time profitable and save money. After install the Sublime, I found the Sublime Package Control is also helpful, which can install the sublime plug-in from web directly; you can install the Alignment as a try after install package control and there are hundreds of packages already available. Currently I'm using below User Settings (with Global Settings Vintage Mode enable):

http://ie.microsoft.com/testdrive/Performance/SpeedReading/Default.html

Conclusion:  IE 9 maybe a little faster, but consider the Firefox more memory footprint saving and cross-platform and so many extension and plug-in. I still prefer Firefox as my primarily browser. (only right at 8/21/2011)

Conclusion:  Firefox13 is now four times faster than IE9!

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).

A lot of company windows domain system administrator will disable user to access Windows Update in Microsoft Site and push the patch to your desktop via a internal site, but for the developer who using tools like Visual Studio or SQL Server, the domain system administrator won't help you.

In Oct 28 2011, while I was working to recover a production reporting oracle database sync SQL facility provide by MES vendor Camstar, I meet the ORA-02049 error, Such error is never observed, but after kill session relative with sync SQL in production transaction database, the whole sync SQL facility return to normal.

So except the reason suggested by the Burleson Consulting, the root cause in my case can be the reporting server suddenly down and in it’s 2 phase commit, there is exist a lock in transaction database but rebooted reporting server’s oracle now can not known it. so after kill that pending session, the ORA-02049 error disappeared.

Suddenly UNIX server reboot/memory dump is still possible, so I record here and hoping its useful for you.

I perfer use the official Firefox (Not the China Zhimei .CN version) and here is the Add-on I install: