| BarCode Report Oracle 10g [message #507013] |
Thu, 12 May 2011 04:29  |
myclassic
Messages: 136
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 #507066 is a reply to message #507031] |
Thu, 12 May 2011 06:33  |
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
|
Senior Member |
|
|
Littlefoot wrote on Thu, 12 May 2011 04:58Please, 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 |
cookiemonster
Messages: 13963
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 |
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
|
Senior Member |
|
|
cookiemonster wrote on Thu, 12 May 2011 07:32myclassic 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 |
cookiemonster
Messages: 13963
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 #507206 is a reply to message #507095] |
Fri, 13 May 2011 02:46 |
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
|
Senior Member |
|
|
ramoradba wrote on Thu, 12 May 2011 07:53http://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 #612367 is a reply to message #507485] |
Wed, 16 April 2014 12:05 |
 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
