Wednesday, November 29, 2006

ORA-01403 in ApEx weighted page perfomance statistics

If you are wondering why you're getting:
ORA-01403: no data found
when you open "Page Views by Weighted Page Performance" in the Monitor Activity section of Oracle Application Express, version 2.2.1.00.04 (or earlier i presume), then check in the lower left corner of the page what is the current language detected by the browser.

This report is flawed by a problem with the default decimal point character derived from the browser language settings.

In brief, if you set your browser's primary language to en (english) or es-mx (spanish-mexico) , the report will work because the decimal point character is the period (.), but if you have it (italian) or es (Spanish international) or another language with the comma as decimal separator, the report will not work.
at

2 comments:

  1. AnonymousThursday, 11 January, 2007

    Excellent post, it should help a lot of people.

    ReplyDelete
  2. Byte64Thursday, 18 January, 2007

    Thanks John,
    if you remember, it took us a while to figure out this quirk, that day in october...

    ReplyDelete

I appreciate your comment however bear in mind that I might not have the time to reply soon.
Normally I do not reply to all comments but I am glad if you found something useful or if you learned something new, in that case I strongly encourage you to promote the article with the +1 google button.
Flavio