Home » Developer & Programmer » Reports & Discoverer » rep 1800 formatter error (oracle 8i)
rep 1800 formatter error [message #402772] Tue, 12 May 2009 07:40 Go to next message
lacchhii
Messages: 151
Registered: May 2009
Location: bangalore
Senior Member

Hi,

I am working in oracle 8i and have generated a report which when i try to save it pdf format

file >> generate to file >> pdf

it gives an error rep 1800 formatter error

i would like to know the solution for this

thanks in advance

narayan
Re: rep 1800 formatter error [message #402776 is a reply to message #402772] Tue, 12 May 2009 07:46 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
REP-1800 indicates an abnormal condition.
Oracle
Sometimes you may encounter an error that is known as an abnormal condition, which may arise from one of the following causes:
  • Someone has done something that prevented your application from completing the requested task. For example, if someone bypassed the user interface and changed data in a database table, they might have typed an invalid value.
  • A software bug prevented the requested task from completing.
Action: First contact your system administrator to determine if the message was caused by something other than Oracle Reports. If you determine that the message was not the result of user error or a system problem, then contact Oracle Support Services.
Re: rep 1800 formatter error [message #403339 is a reply to message #402776] Thu, 14 May 2009 22:39 Go to previous messageGo to next message
lacchhii
Messages: 151
Registered: May 2009
Location: bangalore
Senior Member

hi,
We don't have any system administrator in our office. I am the only person using oracle, so someone changing data does not ar
ise.

Pl suggest some solution and I don't face such problem in any of my other report

narayan
Re: rep 1800 formatter error [message #403360 is a reply to message #403339] Fri, 15 May 2009 01:04 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Does the report work OK when you don't try to generate it to a PDF file?

You might try to install one of (free) virtual PDF printers (such as PrimoPDF) and "print" to it.
Re: rep 1800 formatter error [message #403707 is a reply to message #403360] Mon, 18 May 2009 03:25 Go to previous messageGo to next message
lacchhii
Messages: 151
Registered: May 2009
Location: bangalore
Senior Member

hi,

yes, it works perfectly fine .Only thing is i am unable to save it in pdf format

narayan
Re: rep 1800 formatter error [message #663102 is a reply to message #403707] Mon, 22 May 2017 07:38 Go to previous messageGo to next message
shawaj
Messages: 89
Registered: January 2016
Member
hello everyone ,
I am getting same errore as rep 1800 formatter error
and my report version is
Report Builder 11.1.1.2.0
ORACLE Server Release 11.1.0.7.0
Oracle Procedure Builder 11.1.1.2.0
Oracle ORACLE PL/SQL V11.1.0.7.0 - 64bit Production
Oracle CORE 11.1.0.7.0 Production
Oracle Tools Integration Services 11.1.1.2.0

If i run my report for 01-jan-2016 to 31-dec-2016 in report builder,It run without any error but
while i run this report by application then i got error -rep-1800
I have increased my report builder buffer size to (1024) [Edit-preferences-runtime setting -buffurs=10224]

Please help me
Thanks in advance
Re: rep 1800 formatter error [message #663105 is a reply to message #663102] Mon, 22 May 2017 07:42 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Consider applying TO_DATE function with the appropriate format mask, such as
where my_date_column between to_date('01.01.2016', 'dd.mm.yyyy')
                         and to_date('31.12.2016', 'dd.mm.yyyy')
Re: rep 1800 formatter error [message #663108 is a reply to message #663105] Mon, 22 May 2017 07:58 Go to previous messageGo to next message
shawaj
Messages: 89
Registered: January 2016
Member
Thanks for reply

All data and parameters are ok .

Report is running for 01-jan-2016 to 30-oct-2016
Re: rep 1800 formatter error [message #663136 is a reply to message #663108] Tue, 23 May 2017 06:07 Go to previous messageGo to next message
shawaj
Messages: 89
Registered: January 2016
Member
Please anyone guide me ...
Re: rep 1800 formatter error [message #663147 is a reply to message #663136] Tue, 23 May 2017 10:31 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
How do you know the parameters are ok?
Does it work for any date range in report builder?
Does it not work for any date range from application?

If so the trouble may be due to different nls_date_formats.
Re: rep 1800 formatter error [message #663157 is a reply to message #663147] Wed, 24 May 2017 02:27 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
... which might be avoided with the TO_DATE function.
Re: rep 1800 formatter error [message #663246 is a reply to message #663157] Fri, 26 May 2017 18:26 Go to previous messageGo to next message
shawaj
Messages: 89
Registered: January 2016
Member
Dear Littlefoot,
Yes, It works fine for 01-jan-2016 to 31-dec-2016 in report builder.
And it works also for 01-jan-2016 to 30-oct-2016 from application
but does not work for 01-jan-2016 to 31-dec-2016 from application
Re: rep 1800 formatter error [message #663273 is a reply to message #663246] Sat, 27 May 2017 08:34 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm not sure whether you applied TO_DATE function or not. In any case, you should have.

Take (copy) query from the report and run it (paste) in a tool you use to access the database (such as SQL*Plus, SQL Developer, TOAD, ...), passing November and December as parameters. Make sure query returns ALL rows (i.e. not only the first 100 or so that GUI tools usually return). What happens?
Previous Topic: How to subtract previous row from current row in Oracle Report
Next Topic: Function EAN 13 Oracle Forms 6i
Goto Forum:
  


Current Time: Fri Mar 29 01:14:48 CDT 2024