Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Task Error In Report Caster

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Task Error In Report Caster
 Login/Join
 
Member
posted
Hi,

In fex file we are using partitioning such that 4 physical partitions are pointing to the same Mar. Thus, modify statement is in loop as we need to modify the target mart with 4 different part files as shown below:

-SET &CTR = &CTR + 1;

-SET &FNAME = IF &CTR EQ 1 THEN 'TEMP1' ELSE IF &CTR EQ 2 THEN 'TEMP ELSE IF &CTR EQ 3 THEN 'TEMP ELSE 'TEMP4’;

-SET &PNAME = IF &CTR EQ 1 THEN 'part1' ELSE IF &CTR EQ 2 THEN 'part2' ELSE IF &CTR EQ 3 THEN 'part3' ELSE 'part4';



USE &P_PATH/&PNAME.FOC AS MART1

END

MODIFY FILE MART1

FIXFORM FROM &FNAME

COMPUTE LASTUPDATE_TS/HYYMDm = HGETC(8, 'HYYMDm');

MATCH KEY1 KEY2 KEY3

ON NOMATCH

INCLUDE

ON MATCH

UPDATE LASTUPDATE_TS

DATA ON &FNAME

CHECK 100000

END



-IF &CTR_TEST LT 4 THEN GOTO LBL_BEGIN;



OUTPUT of this code gives warning as follows:

(FOC1969) WARNING: USE/ALLOCATION FOR DDNAME MART1 OVERRIDES ACCESSFILE

0 TRANSACTIONS: TOTAL = 0 ACCEPTED= 0 REJECTED= 0 SEGMENTS: INPUT = 0 UPDATED = 0 DELETED = 0

(FOC1969) WARNING: USE/ALLOCATION FOR DDNAME MART1 OVERRIDES ACCESSFILE

0 TRANSACTIONS: TOTAL = 0 ACCEPTED= 0 REJECTED= 0 SEGMENTS: INPUT = 0 UPDATED = 0 DELETED = 0

(FOC1969) WARNING: USE/ALLOCATION FOR DDNAME MART1 OVERRIDES ACCESSFILE

0 TRANSACTIONS: TOTAL = 0 ACCEPTED= 0 REJECTED= 0 SEGMENTS: INPUT = 0 UPDATED = 0 DELETED = 0

(FOC1969) WARNING: USE/ALLOCATION FOR DDNAME MART1 OVERRIDES ACCESSFILE

0 TRANSACTIONS: TOTAL = 0 ACCEPTED= 0 REJECTED= 0 SEGMENTS: INPUT = 0 UPDATED = 0 DELETED = 0

Though this warning is ignored in Webfocus environment and also through controller the output is coming fine but when the same fex file we try to run through Report Caster it compltes the task but take warning as TASK ERROR and doesnot give the desired output.

BTP1020 REFERENCE...AT TRANS 400011
BTP1020 WARNING: USE/ALLOCATION FOR DDNAME MART OVERRIDES ACCESSFILE
BTP1020 WARNING: USE/ALLOCATION FOR DDNAME MART OVERRIDES ACCESSFILE
BTP1020 ERR YES
BTP1010 Task error: WARNING: USE/ALLOCATION FOR DDNAME MART OVERRIDES ACCESSFILE



Regards,
Sai Kumar
 
Posts: 6 | Location: Hyderabad, India | Registered: January 31, 2007Report This Post
Platinum Member
posted Hide Post
quote:
-SET &FNAME = IF &CTR EQ 1 THEN 'TEMP1' ELSE IF &CTR EQ 2 THEN 'TEMP ELSE IF &CTR EQ 3 THEN 'TEMP ELSE 'TEMP4’;


Seems you are missing some closing ' marks on your second and third instances? RC is a lot more sensitive to syntax.

Kevin


WF 7.6.10 / WIN-AIX
 
Posts: 141 | Location: Denver, CO | Registered: December 09, 2005Report This Post
Member
posted Hide Post
We understand that RC is sensitive to Syntax. However the quotes exist in the real code. what is reaelly needed is that how do we supress the Task Error "Task error: WARNING: USE/ALLOCATION FOR DDNAME MART OVERRIDES ACCESSFILE" that we are getting due to the warning message "(FOC1969) WARNING: USE/ALLOCATION FOR DDNAME MART1 OVERRIDES ACCESSFILE".
the warning message is generated when the report is executed from webfocus. However the task error is generated when the report is generated through RC.
through RC it is not working, however through webfocus it is working with warnings.
if somehow we can supress the warning message then we can run it through RC.

Also is there any other problem that can be the source of the warning???
 
Posts: 6 | Location: Hyderabad, India | Registered: January 31, 2007Report This Post
Platinum Member
posted Hide Post
Sai,

I don't think you can "suppress" the error handling in RC. What you need to do is to get the fex to run in WebFOCUS without generating errors in order for it to successfully run in RC. There is obviously something about your USE statement that FOCUS doesn't like. WF may continue through this non-critical error, but RC won't. From your code I don't see where &P_PATH is set, but you might try a -? & to verfiy that your & vars are being set the way you think they are.

Kevin


WF 7.6.10 / WIN-AIX
 
Posts: 141 | Location: Denver, CO | Registered: December 09, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Task Error In Report Caster

Copyright © 1996-2020 Information Builders