Focal Point
[Closed not solved]Error on Reportcaster when printing

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/777108811

May 18, 2009, 04:06 AM
Majid Jeddi
[Closed not solved]Error on Reportcaster when printing
Hi,

I have a report which is scheduled on report caster. But I am getting the following error when i run it :
Task error:ibi.jlink.EdaPcb: Pcb2.: ibi.ngxxj.NGException: local error

The job is scheduled from a java application on report caster.

Any idea.

Thanks.

This message has been edited. Last edited by: Majid Jeddi,
May 18, 2009, 01:00 PM
Darin Lee
quote:
The job is scheduled from a java application on report caster


Does this mean you have created your own java application using the Report Caster API?


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
May 25, 2009, 07:50 AM
Majid Jeddi
Hi Daren Lee,

Yes we are.

Regards.


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
May 25, 2009, 08:04 AM
<JG>
Majid,

Are you able to run the report directly from caster?

Is the report generating output that is to be burst?

If the latter is the case take a look at
TROUBLESHOOTING: Final ReportCaster request does not burst in multi-step
June 03, 2009, 09:12 AM
Majid Jeddi
Hi,

Just to explain correctly the issue.
We have a java process that allow a user to select multiple invoices in order to generating them. As part of the invoice generation, the process is scheduling a job on report caster for each invoice and printing it.
Randomly some invoices do not print when they are scheduled.
When we go back and try to print these invoices they print without any issue.

Thanks for your help


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
June 03, 2009, 11:36 AM
Darin Lee
Any time I have run into these errors that occur "randomly" it has almst always been a code issue. I have found RC to be pretty consistent - either it works or it doesn't. Hoever, the processing sometimes causes issues. For example, if you are creating an intermediate hold file that two identical processes share (which we have in our environment) and they happen to process simultaneously, one overwriting the file which the other created before it can complete. Another example would be improper population of &vars - sometimes works, sometimes doesn't. Or one process locks a record/table that the other process is simultaneously trying to access.

Possibly, the java program is not scheduling or sett parm values correctly. My bet is that the error lies in the WF code and/or Java process, not in RC itself.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
June 03, 2009, 02:06 PM
Majid Jeddi
Hi Darin Lee,

Yes your anlyze seems to be logic and matching what is happening in this process.
Inside the same fex file we are creating 2 hold files which are used to generate an invoice.
Since the java process is doing this for many invoices at the same time, would it possible to give a unique name to these holdfiles inside this fex?

Thanks


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
June 03, 2009, 02:24 PM
Darin Lee
Are they temporary files (meaning are they created in the temporary work space of the agent) or are they created in an app directory that is shared? If they are in temp space, there should not be a conflict problem, as one agent will not use another's workspace.

There are many examples of code on the forum for creating unique names for hold files. There are several system variables (the simples of which would be &DATE, &TOD) which could be used in ON TABLE HOLD AS &HOLDNAME


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
June 03, 2009, 03:13 PM
Majid Jeddi
Hi Darin Lee,

They are created in workspace of the agent.
How can we be sure that there no conflict between the agents?
I will try to give a unique name and see if that helps.

Regards.


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
June 03, 2009, 03:17 PM
Majid Jeddi
Hi Darin Lee,

Since the fex is generating an invoice based on a parameter :invoiceid, would it be a solution to name the holdfile with this invoice id?

Regards.


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server