Solved

REP-3301 error

Posted on 2001-07-16
4
2,521 Views
Last Modified: 2012-05-07
Hi!
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
0
Comment
Question by:dsovic
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 3

Expert Comment

by:mathavra
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.
0
 

Author Comment

by:dsovic
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 2.5.5.2.7). 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
0
 
LVL 1

Accepted Solution

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

PROBLEM DESCRIPTION:
====================

You are getting this error when running a report:

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


SOLUTION DESCRIPTION:
=====================

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.

SOLUTION DESCRIPTION 2:
=======================

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.

Regards,

SP
0
 

Author Comment

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

Thanks!

Damir Sovic
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

728 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