REP-3301 error

Posted on 2001-07-16
Last Modified: 2012-05-07
Does anyone knows the conditions when error REP-3301 occurs?
The report, that worked fine, suddenly fails on some PCs but on the others it still works fine. I didn't
find some pattern why is that so (Platform, registry settings, installations, ...).
I've found one korean page (Oracle Korea Customer Support Technical Bulletins), but I can't read it
(I speak croatish; my native tonge, english and german, but don't expect too much of me).

If anyone knows anything at all, PLEASE respond.
Needless to say, it's urgent.

Thanks in advance.
(I hope that this time the question is postered at right place)

Damir Sovic
Question by:dsovic
  • 2

Expert Comment

ID: 6287933
We have received this error on couple of occasions along with some other errors as show below. This happened when we ran a report report that is using Julian date formatting:

  REP-0612 - Invalid date mask.
  ORA-1801 - Date format is too long for internal buffer.
  REP-3301 - Error occurred in '<component name>'.  Returning to the event
             loop'<product code>-<<number>:<product error>.
  REP-1401 - '<Program unit name>': Unhandled PL/SQL exception.
  ORA-0001 - unique constraint <table.column> violated.

This happens when passing a parameter(s) that uses Julian Date output.

The solution we received from Oracle was:

Enforce the use of Julian Date Formatting, based on the format mask. Otherwise, when the user enters nothing, zeroes will be returned in the field causing the above errors.

Zeroes as input with the date format of dd/mon/rr results in these errors,since the report does not know how to process zeroes for MON format.

Hope this helps.

Author Comment

ID: 6288656
Unfortunately, not.
My error is : REP-3301: Error occured in Error checking (RXGLER). I've tried to find out what is that "RXGLER", but there is no mention about it. Even Google returns no matching.
Talking about date format, mine is DD.MM.YYYY, and is same in registry as in reports (Win9x/Oracle Developer 2000 for Win95/Reports If I have to use dates, I pass them with 'to_date()' function, and only if they are filled in and in specific format. On the other hand, other reports are using the same date format, and are working fine. And I don't use date as parameter.
User's input has nothing with it, as this error occurs before Parameter form, so user cannot fill-in any parameter.

Seems to me that Murphy has his fingers in this.

Thanks anyway.

Damir Sovic

Accepted Solution

tvspriya earned 300 total points
ID: 6297600
May be this one can help you.


You are getting this error when running a report:

  REP-3301: Error occurred in'<RXGLER>'.  Returned to the event loop.


The REP-03301 an abnormal condition.

1.  Make sure that the tables and data that you are accessing are not corrupted.
    You can check this by selecting the tables in SQL*Plus or running your  
    report query in SQL*Plus.

2.  Make sure that you have privileges to these objects.

3.  Set the non-blocking SQL = off.  
      In report designer: Go to Tools --> Tools Option --> Runtime Settings tab,
      then uncheck the Non-blocking SQL box.

      NOTE:- When set to NO, other programs cannot execute while Oracle Reports
      is fetching data from the database.

4.  If the above steps did not work, look in the report's query.    
    You can just comment the user parameter line out and see if the report will
    run successfully w/out the user parameters.  If that works, then see if
    increasing the width for these user parameters will work.


1. Verify what version of reports was used to develop the report.

2. If an earlier version of reports was used, recompile the report using the
   convert tool to convert the report to an .rex file, then back to an rdf file.

NOTE:  Procedure on how to convert a report is detailed in the following notes:
       - NOTE:61519.1 Converting Reports
       - NOTE:66703.1 Batch Generation of Reports.



Author Comment

ID: 6302323
Thanks for Your effort, but the cause of error showed: clogged network!
Anyway, I'll try to give You both Your points.


Damir Sovic

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example, show how to take different types of Oracle backups using RMAN.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question