Home » Developer & Programmer » Reports & Discoverer » BarCode Report Oracle 10g (ORacle 10g, Report Builder 10.1.2.0.2, Windows XP)
BarCode Report Oracle 10g [message #507013] Thu, 12 May 2011 04:29 Go to next message
myclassic
Messages: 126
Registered: December 2006
Location: Pakistan
Senior Member
Dear All

I have created a report which generates barcode, it is working fine in development environment.(Report Builder 10.1.2.0.2)
but when i place it on Application server and want to call it from there, it terminates with error. and error log is

Terminated with error: REP-1401: 'beforereport': Fatal PL/SQL error occurred. ORA-39565: Message 39565 not found; product=RDBMS; facility=ORA

report attached: please help.

regards
Re: BarCode Report Oracle 10g [message #507031 is a reply to message #507013] Thu, 12 May 2011 04:58 Go to previous messageGo to next message
Littlefoot
Messages: 19600
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Please, post contents of Before Report trigger.
Re: BarCode Report Oracle 10g [message #507066 is a reply to message #507031] Thu, 12 May 2011 06:33 Go to previous messageGo to next message
myclassic
Messages: 126
Registered: December 2006
Location: Pakistan
Senior Member
Littlefoot wrote on Thu, 12 May 2011 04:58
Please, post contents of Before Report trigger.



function BeforeReport return boolean is
begin
globals.barcode_to_use:=BarCodeConstants.BAR_CODE_128;

globals.bcobj := barcodemaker.new();

return (TRUE);
end;

report is attached. please view it.

[Updated on: Thu, 12 May 2011 06:35]

Report message to a moderator

Re: BarCode Report Oracle 10g [message #507085 is a reply to message #507013] Thu, 12 May 2011 07:32 Go to previous messageGo to next message
cookiemonster
Messages: 10960
Registered: September 2008
Location: Rainy Manchester
Senior Member
myclassic wrote on Thu, 12 May 2011 10:29

Terminated with error: REP-1401: 'beforereport': Fatal PL/SQL error occurred. ORA-39565: Message 39565 not found; product=RDBMS; facility=ORA

The fact that it can't find the correct error message text strongly implies oracle isn't installed properly on that server. I suggest you fix that first.
Re: BarCode Report Oracle 10g [message #507092 is a reply to message #507085] Thu, 12 May 2011 07:40 Go to previous messageGo to next message
myclassic
Messages: 126
Registered: December 2006
Location: Pakistan
Senior Member
cookiemonster wrote on Thu, 12 May 2011 07:32
myclassic wrote on Thu, 12 May 2011 10:29

Terminated with error: REP-1401: 'beforereport': Fatal PL/SQL error occurred. ORA-39565: Message 39565 not found; product=RDBMS; facility=ORA

The fact that it can't find the correct error message text strongly implies oracle isn't installed properly on that server. I suggest you fix that first.

Sir Oracle is working fine. Apps server is working correctly with all forms and reports exept this report.
Re: BarCode Report Oracle 10g [message #507093 is a reply to message #507092] Thu, 12 May 2011 07:43 Go to previous messageGo to next message
cookiemonster
Messages: 10960
Registered: September 2008
Location: Rainy Manchester
Senior Member
The message you state clearly shows oracle is not installed properly. Unless it's giving a phantom error number - in which case you need to contact oracle support.
Re: BarCode Report Oracle 10g [message #507095 is a reply to message #507093] Thu, 12 May 2011 07:53 Go to previous messageGo to next message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
http://forums.oracle.com/forums/thread.jspa?threadID=154911


Sriram
Re: BarCode Report Oracle 10g [message #507097 is a reply to message #507095] Thu, 12 May 2011 07:56 Go to previous messageGo to next message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
http://translate.google.co.in/translate?hl=en&sl=ko&u=http://kr.forums.oracle.com/forums/thread.jspa%3FthreadID%3D346711& ei=EtjLTbrAFYTAgQfmnrTwBQ&sa=X&oi=translate&ct=result&resnum=2&ved=0CDUQ7gEwAQ&prev=/search%3Fq%3DORA-39565%2 6hl%3Den%26rls%3Dcom.microsoft:en-US%26prmd%3Divnsfd

Hope the above two will help you

Sriram
Re: BarCode Report Oracle 10g [message #507206 is a reply to message #507095] Fri, 13 May 2011 02:46 Go to previous messageGo to next message
myclassic
Messages: 126
Registered: December 2006
Location: Pakistan
Senior Member
ramoradba wrote on Thu, 12 May 2011 07:53
http://forums.oracle.com/forums/thread.jspa?threadID=154911


Sriram


Dear

Thanks a lot.

It is really a wonderful link.

Actually we need to add the classpath in conf file of Reports in Application server.
Simply modify the following lines

<engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="60000" classPath="d:\oracle\reports\jlib\oraclebarcode.jar"[/b]>?
<engine id="rwURLEng" class="oracle.reports.urlengine.URLEngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="60000" classPath="d:\oracle\reports\jlib\oraclebarcode.jar"/>
Re: BarCode Report Oracle 10g [message #507235 is a reply to message #507206] Fri, 13 May 2011 06:02 Go to previous messageGo to next message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Thanks for the feedback.

Glad to know that you resolved the issue.

Goodluck
Sriram
Re: BarCode Report Oracle 10g [message #507485 is a reply to message #507235] Mon, 16 May 2011 03:02 Go to previous messageGo to next message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
myclassic wrote on Mon, 16 May 2011 13:25
Dear

Thanks a lot for providing me help.

I want another favour from you.
I want to print this barcode on a sticker. and i am using it in 10g. i want to print it on client's printer.

how to do that?
client printer is not accessable in oracle report 10g. if i set the destination to printer in report .. i tries to access application server. where as i want it to print on client's local printer.

you may reply to maanosajnabi@yahoo.com


please help.

regards



Re: BarCode Report Oracle 10g [message #612367 is a reply to message #507485] Wed, 16 April 2014 12:05 Go to previous message
eehab_said
Messages: 1
Registered: April 2014
Location: Egypt
Junior Member
Hi Everybody,

unfortunately, after this cursed jar file called "oraclebarcode", working on your reports, it'll fails,
due to this jar file just demo, and is not grantee by oracle to be deployed in production environment,
its bug: if you tried to run your report and its records exceeded 500 records on application server, it will give you the same message that you have faced before, this message says: the product can not found, although the same report with the same configuration on the server working well with few number of records, less than 500 records.

BR,
Ehab Al-Qabbani
Previous Topic: Barcode font not printed properly
Next Topic: Display Table Column on Report Header
Goto Forum:
  


Current Time: Mon Sep 15 20:04:29 CDT 2014

Total time taken to generate the page: 0.06432 seconds