New User? Sign Up  |  Sign In  |  Help
Barcode support and
tutorials from IDAutomation
and the community.
Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Resolved Questions Bookmark and Share

IDAutomation QRCode not working in Oracle Reports 10g(Linux)


After purchasing the IDA26-5DL Java Component package, we've downloaded the following signed jars: IDAAztec.jar IDADataMatrix.jar IDAMaxiCode.jar IDAPDF417.jar IDAQRCode.jar LinearBarCode.jar.

Once we are using Oracle Reports 10g as our reports server, installed in a Linux Distribution, we've uploaded them to the filesystem and configured the REPORTS_CLASSPATH environment variable pointing to that folder and including all those jar files. That variable has been declared in both reports.sh and in the user profile that executes the reports.

However, we are not able to execute a report with a QR Code, error attached. If we create a report through Reports Builder, we are able to use IDAutomation libraries, and also, the report is being compiled successfully, but when executing it in runtime, it is failing with an error message, that seems to be related with the libraries not being declared.

We've checked all the related discussions in this forum, but none is really helping in our problem. We tried also in Oracle Reports 12c (in Linux) and the problem is the same.

Could you please support?

Thanks

Operating System: Red Hat Enterprise Linux Server release 5.2 (Tikanga)

Application: Oracle Reports 10g and 12c

11-24-20     301 day(s) ago    

  Report Abuse

 

luisferreira2

Best Answer

Hi Team,

Increasing the ImageFile length, didn't solve the problem.

But meanwhile we tested the approach suggested in the following note: https://support.idautomation.com/Java-Barcode-Package/REP-1401-A-fatal-PL-/-SQL-error-occurred-using-Java-Component-on-LINUX/_2004.

Forcing the classPath variable (pointing to all the jar files that we've uploaded to the filesystem) in the <engine id="rwEng"> at rwserver.conf (or <reports_server_name>.conf) seems to have solved the issue.

The QRCode was printed in the .pdf now, however it seems to be a little bit pixeled, with a shadow on it. Anyway, this is not the origin of this support ticket, we will open a different one if the issue persists.

Thanks,
Luís

Posted 300 day(s) ago

(0)
(0)
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.
Other Answers (3)
To resolve the pixeled shadow issue, try generating GIF instead of JPEG and see if that works.

Posted 300 day(s) ago

(0)
(0)
   Report Abuse
Increase the ImageFile VarChar2(500); to a much larger value, such as 1000, 1500, or 2000.

If this does not resolve the issue, let us know.

Posted 301 day(s) ago

(0)
(0)
   Report Abuse
This is the function code inside the report that seems to be failing:

function CF_1Formula return Char is
/*name of temp file. For 1D barcodes, set to VarChar2(250). For 2D barcodes, set to VarChar2(500).*/
ImageFile VarChar2(500);
/*object containing barcode properties*/
BarcodeObject ORA_JAVA.JOBJECT;
/*object that creates jpeg of barcode based on BarcodeObject*/
BarcodeEncoderObject ORA_JAVA.JOBJECT;
begin
/*Get a temporary file name for the jpeg*/
/*On Solaris Unix, use the following code to create the temp file: ImageFile := srw.create_temporary_filename() || '.jpg'; */
--original imageFile := srw.create_temporary_filename();
ImageFile := srw.create_temporary_filename() || '.jpg';
/*Create the barcode object. This example uses the LinearBarCode.jar*/
BarcodeObject := QRCode.new();
/*set the data to encode*/
QRCode.setDataToEncode(BarcodeObject, to_char('TESTE'));
/*Create the jpeg*/
BarcodeEncoderObject := BarcodeEncoder.new(BarcodeObject, 'JPEG',ImageFile);
/*If, for some reason, the barcode is not created, return null otherwise, return the name of the barcode image jpeg that was created */
if ORA_JAVA.IS_NULL(BarcodeEncoderObject) then
return(NULL);
else
return(ImageFile);
end if;
end;

And this is the error that is shown when running the report:

Error
Terminated with error: <br>REP-1401: MSG-00001: JFO1 MSG-00001: JFO2 REP-1401: 'cf_1formula': Fatal PL/SQL error occurred.

In the logs, I can see:

[2020/11/24 1:11:37:275] Info 50132 (JobObject:reset): jobid = 91530 Get command line: baseUrl=http://***********:80/reports/rwservlet/getfile/ userid=***********@rmsmcpp statusformat=xml SERVER_NAME=*********** jobname="60079267_teste_qrcode" getFilestr=/no> imagekey=reports9i desname=/npo/reportspp/teste_qrcode_arcunha_24112020131136.pdf REMOTE_ADDR=*********** SERVER_PROTOCOL=HTTP/1.1 authid=RWUser destype=FILE REMOTE_HOST=*********** batch=YES SERVER_PORT=80 server="reprmsmcpp" report="teste_qrcode.rep" background=YES expiredays=0 desformat=PDF SCRIPT_NAME=/rwservlet baseimageurl=http://***********:80/reports/rwservlet/getfile/HW/YX89+FE3dFOoLleaCiQ2mKAO5

(...)

[2020/11/24 1:11:37:735] State 56016 (JobManager:updateJobStatus): Job 91530 status is: Running the report Initializing report
[2020/11/24 1:11:37:735] Debug 50103 (JobManager:updateJobStatus): Finished updating job: 91530
[2020/11/24 1:11:37:750] State 56016 (JobManager:updateJobStatus): Job 91530 status is: Running the report Formatting page 1
[2020/11/24 1:11:37:750] Debug 50103 (JobManager:updateJobStatus): Finished updating job: 91530
[2020/11/24 1:11:37:765] State 56016 (JobManager:updateJobStatus): Job 91530 status is: Terminated with error:
REP-1401: MSG-00001: JFO1
MSG-00001: JFO2
REP-1401: 'cf_1formula': Fatal PL/SQL error occurred.

[2020/11/24 1:11:37:765] Debug 50103 (JobObject:writeLongUTF): Number of Break Index values=1
[2020/11/24 1:11:37:765] Debug 50103 (JobObject:writeLongUTF): String= MSG-00001: JFO1
MSG-00001: JFO2
REP-1401: 'cf_1formula': Fatal PL/SQL error occurred.
strlen=86
[2020/11/24 1:11:38:476] Debug 50103 (JobManager:notifyWaitingJobs): Master job 91530 notify its duplicated jobs.
[2020/11/24 1:11:38:476] Debug 50103 (JobManager:updateJobStatus): Finished updating job: 91530
[2020/11/24 1:11:38:476] Debug 50103 (EngineManager:updateEngineState): Engine rwEng-0 status is 1
[2020/11/24 1:11:38:476] State 56004 (EngineInfo:setState): Engine rwEng-0 state is: Ready
[2020/11/24 1:11:38:477] Exception 1401 (): MSG-00001: JFO1
MSG-00001: JFO2
REP-1401: 'cf_1formula': Fatal PL/SQL error occurred.

oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.RWExceptionHelper.read(RWExceptionHelper.java:67)
at oracle.reports.engine._EngineClassStub.run(_EngineClassStub.java:84)
at oracle.reports.server.JobManager.runJobInEngine(JobManager.java:975)
at oracle.reports.server.ExecAsynchJobThread.run(ExecAsynchJobThread.java:54)

[2020/11/24 1:11:38:477] Exception 1401 (): MSG-00001: JFO1
MSG-00001: JFO2
REP-1401: 'cf_1formula': Fatal PL/SQL error occurred.

oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.server.JobManager.runJobInEngine(JobManager.java:1116)
at oracle.reports.server.ExecAsynchJobThread.run(ExecAsynchJobThread.java:54)

[2020/11/24 1:11:38:477] Debug 50103 (JobManager:runJobInEngine): Encounted exception in job 91530
[2020/11/24 1:11:38:477] Exception 1401 (): MSG-00001: JFO1
MSG-00001: JFO2
REP-1401: 'cf_1formula': Fatal PL/SQL error occurred.

oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.server.JobManager.runJobInEngine(JobManager.java:1116)
at oracle.reports.server.

Posted 301 day(s) ago

(0)
(0)
   Report Abuse
Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must starts with "http://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always starts with " http:// ")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 Characters are allowed. Current Count: 0
  Your comment on this answer
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must start with "http://" or "https://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always start with "http://" or "https://")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 characters are allowed. Current Count: 0

You may answer and comment on any thread according to the Terms and Conditions.

 © Copyright 2021 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook