Focal Point
[SOLVED] Report Caster Job Failure on QA

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

January 31, 2018, 12:35 AM
asamant59
[SOLVED] Report Caster Job Failure on QA
Hello ,
I have a job on Report caster Quality system that has been failing repeatedly. However I have checked the source code for the same and they appear to be fine.The objects created show differences as compared to the ones created when last time successful, can anyone suggest for finding the exact root cause ?

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, all Outputs
January 31, 2018, 06:08 AM
Frans
What do you see in the job log?


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
February 01, 2018, 12:50 AM
asamant59
In the job log i see a job failure.
(FOC295) VALUE IS FOR: & 1
Task error: IBFSException 6000: Error executing procedure: wrotif_agg_002_rcaster_extrakt_starte_aggregation
There is no report to distribute.
Also I have checked the fex the very recent one along with the one which was last successful


WebFOCUS 8
Windows, all Outputs
February 01, 2018, 01:02 AM
Chaudhary
quote:
(FOC295) VALUE IS FOR: & 1


Do you have parameterized report to schedule ?
If yes please pass that parameter value while scheduling the report.


WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10
February 01, 2018, 01:59 AM
asamant59
Yes it is supposed to run at a particular time, but so far the changes made are also causing a failure. Although thanks for the suggestion I shall try for the same.


WebFOCUS 8
Windows, all Outputs
February 05, 2018, 06:06 AM
asamant59
The error is in row 2269 from where i take this code :

APP HOLD WROTIF_REP

-* b) Loop über alle 14 Monate, die POI Alerting verfügbar sein sollen:
-REPEAT AlleMonate &AnzMonate TIMES
-READ T_MONATE NOCLOSE &MyReadMonat.A6.
-*-SET &MyKw = &MyReadKWoche ;
-TYPE Kern fuer Monat &MyReadMonat ...
-SET &MyHoldFile = 'H_OTIF_AGGR_MON_&MyReadMonat.EVAL';

-*-SET &MyReadMonat = '201208';


WebFOCUS 8
Windows, all Outputs
February 12, 2018, 11:54 AM
FP Mod Chuck
Asamant59

If this is still an issue you better open a case with techsupport. Tough for us to debug..


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
February 13, 2018, 12:33 AM
asamant59
Hey Mod Chuck no its no longer an issue we managed to resolve the same, Thank you for the suggestion !! Smiler


WebFOCUS 8
Windows, all Outputs