Solved

REP-3301 error

Posted on 2001-07-16
4
2,437 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
  • 2
4 Comments
 
LVL 3

Expert Comment

by:mathavra
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Calculating total percentage per row in Oracle Query 2 37
UNIX SCP 5 45
oracle query help 29 62
sql for Oracle views 8 36
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

771 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now