Focal Point
Reportcaster Task error

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

February 05, 2008, 04:12 AM
Suji
Reportcaster Task error
Hi,
I am facing an issue while executing the focexec procedure for certain conditions. The exception is

Task error:Pcb2.: java.io.EOFException

I could not find out the root cause for this issue. Can anyone state what is the problem and solution for this kind of exception?

Thanks,
Suji.


WebFOCUS 7.7.02(Production)
WebFOCUS 7.7.02(Test region)
Oracle backend (10g)and Windows Frontend.
HTML,PDF,EXL2K,FLEX,AHTML
February 05, 2008, 09:07 AM
GinnyJakes
Try running the focexec from Dev Studio or a browser to see if you get more/better error messages.

Also, please go to your profile and update your signature so that it includes your product suite, releases, and platforms.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
February 05, 2008, 10:20 AM
Leah
We've faced that many times in older versions. The code may run just fine everywhere but from Report Caster, which uses a different code set, I believe. I know this sounds silly, but in one instance what fixed it was putting a space between the double quote ending a heading and the character just before it. Other times just deleted and added back a row. The really bad issue for us was a job had been running forever and then boom, java socket exception. The administrator always insisted it had to be the code, which it wasn't. We've had the issue recently on a job that gets the exception, queue it in again and it runs fine. I empathise with you completely on this one.


Leah
February 05, 2008, 01:22 PM
Carol Dobson
I'm not sure what release you are on...

...but back on 5.2.8 we've seen this error many times when someone makes a change to a config file or adds a data connection and restarts the services or kills a job by accident.



WebFOCUS 7.6.6/TomCat/Win2k3
February 06, 2008, 12:54 AM
Suji
We cannot try in Dev studio since we use standalone reports that run in browser. Is there any standard solution for this problem? We cannot queue the requests manually since that action is done independent of our control.

Thanks,
Suji.


WebFOCUS 7.7.02(Production)
WebFOCUS 7.7.02(Test region)
Oracle backend (10g)and Windows Frontend.
HTML,PDF,EXL2K,FLEX,AHTML
February 06, 2008, 09:20 AM
GinnyJakes
Then run from a browser or an adhoc window. You need to test in another environment to verify that the program does work before you blame RC for the problem.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
February 06, 2008, 09:33 AM
Leah
Do you mean in the managed reporting environment? If so do you edit the code? Are you allowed to run other than with Report Caster, such as in deferred mode or 'live' mode?


Leah
February 06, 2008, 02:37 PM
Bryan Klimek
We currently have an open issue similar to this where we occasionally we getting these types of failures. This is on release 7.6.1.

What it came down to was having 2 ReportCaster jobs scheduled to run at the same exact time (i.e. 11:05:00). Sometimes they would both work. Other times 1 would fail. Sometimes both would fail.

We finally did get a patch to address the issue. It did work. However it has since caused us another problem that has forced us to remove the patch.

By this time we had identifed all schedules that were doubling up on the execution time. So, removing the patch is not that big a deal.

Bryan Klimek
Mayo Clinic
February 07, 2008, 12:24 AM
Suji
Hi,
The same code is working fine in the browser "online".

Thanks,
Suji.


WebFOCUS 7.7.02(Production)
WebFOCUS 7.7.02(Test region)
Oracle backend (10g)and Windows Frontend.
HTML,PDF,EXL2K,FLEX,AHTML
February 07, 2008, 08:28 AM
Leah
I would suggest putting

-SET &ECHO = ALL;

in you fex and run it in reportcaster with full notification of error to you. Sometimes this reveals what it doesn't like, otherwise, change some little thing and see what happens then.

Good Luck


Leah