Monday, May 14, 2012

Apex 4.1 + RESULT_CACHE_MODE (FORCE) = Apex Bug

After banging my head with my Apex 4.1 upgraded laptop for a month, I finally invented the above equation.
Wondering what it means and how I found it, then you need to read the whole (real) story.
I was trying to upgrade my Apex 4.0 laptop to Apex 4.1 and after the upgrade everything seems to be fine. However when I tried to import an application, this is how my "File Character Set" drop down looked.


However I know some of my Post Apex upgrade steps are the one causing this error and I could not be able to believe the following statement is what actually causing this error/bug.

SQL> ALTER SYSTEM SET RESULT_CACHE_MODE = 'FORCE'     SCOPE = BOTH;

After changing this back to System Default which is MANUAL, I got my File Character Set back.

SQL> ALTER SYSTEM SET RESULT_CACHE_MODE = 'MANUAL'     SCOPE = BOTH;

Now my Application import screen looks like this.

Please check your  RESULT_CACHE_MODE settings on your Database server especially if you use Apex 4.1.

I have been using RESULT_CACHE_MODE = 'FORCE' with Apex 4.0 and I never had issues with that.

Please leave a comment if you are experiencing the same issue.