Forum Stats

  • 3,782,552 Users
  • 2,254,664 Discussions
  • 7,880,119 Comments

Discussions

barcode sample couldnot run in 9ias

307648
307648 Member Posts: 20
edited Jun 18, 2009 3:06AM in Reports
barcode sample couldnot run in 9ias
Oraclebarcode.jar Doesn't work on webserver

I have downloaded the example on how to print a barcode using the oraclebarcode.jar in 9i. It works on my local install of the reportserver(devloper9i), but when I move it out to the webserver(9ias), it doesn't work. It gives this error:

Terminated with error: <br>REP-771: 'beforereport': Fatal PL/SQL error occurred. ORA-39565: Message 39565 not found; product=RDBMS; facility=ORA
the beforreport trigger code below

"
globals.barcode_to_use:=BarCodeConstants.BAR_CODE_128;
"

The jar file is in the reports_classpath, as well as the report. What else to try????

Comments

  • 307648
    307648 Member Posts: 20
    1.I have reslove the problem.
    2.add d:\oracle\reports\jlib\oraclebarcode.jar to REPORTS_CLASSPATH。
    3.add d:\oracle\reports\jlib\oraclebarcode.jar to CLASSPATH。
    4.modify d:\oracle\reports\conf\<server_name>.conf。add d:\oracle\reports\jlib\oraclebarcode.jar 到engine element 的classpath attibute。
    <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">。
    <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"/>
  • 265667
    265667 Member Posts: 271
    Yong,

    This is good.
    But however you need the following alone to make it work
    For builder
    -add d:\oracle\reports\jlib\oraclebarcode.jar to REPORTS_CLASSPATHã

    For server
    - classPath="d:\oracle\reports\jlib\oraclebarcode.jar for engine attribute in server conf file

    Regards
    The Oracle Reports team
  • 397311
    397311 Member Posts: 408
    Hi all:

    I have been follow the above-mentioned method to try solve my RDF barcode printing prolem , but still can not succeed !
    I develope a barcode report by RDF report format, and execute well in my ReportBuilder env,

    but after I directly copy this report to "Oracle9i Reports Paper Report Tester" directory, then execute in Tester page, I got below error message !

    My error message like these:
    REP-771: 'afterpform': Fatal PL/SQL error occurred.
    ORA-39565: Message 39565 not found; product=RDBMS; facility=ORA

    please help me ...
    thanks a lot !
  • Kstore
    Kstore Member Posts: 562 Bronze Badge
    do you Know if it is possible to run barcode print on apllication 1.0.2.2.2.a ?
  • 503753
    503753 Member Posts: 7
    would you explain with detail how to set report_classpath in Linux?
    and how to modify classPath in the server conf file in Linux?
    Thanks
  • 607283
    607283 Member Posts: 144
    The classpath setting works like a charm thanks
This discussion has been closed.