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.
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';
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, 2007
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, 2007
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, 2005