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     Truncating Of Reports

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Truncating Of Reports
 Login/Join
 
<Edgare>
posted
Here is sample code from some of my reports:

SET HOLDDEFAULT=ALPHA
SET DEFAULT=WORK
JOIN CLEAR *
END
TABLE FILE POS00
PRINT POS00_CLAIM_ID
POS00_SUBS_SSN
POS00_MBR_TYPE
POS00_TAX_ID
POS00_TAX_ID_SUFFIX
ON TABLE HOLD AS POS06P1
END

Report is deposited in the work directory of the server where we have alot of space. Althought the file should be about 1 gig but comes out to 1 MB. Records are truncated in there. I am not sure why this happens. Is there a way to set the temp location to work directory? (would limit on temp directory do this? or is it memory limitation?)

Here is the log:

This batch job is running on node FELIX under PID 204B5528
The job is entry 39 in queue FELIX_TOOLS_BATCH
%DCL-W-NOCOMD, no command on line - reenter with alphabetic first character
%DCL-W-MAXPARM, too many parameters - reenter command with fewer parameters
%SET-W-NOTSET, error modifying DSA7358:
-SET-E-INVDEV, device is invalid for requested operation
%SET-W-NOTSET, error modifying DSA7358:
-SET-E-INVDEV, device is invalid for requested operation
%DCL-W-SKPDAT, image data (records not beginning with "$") ignored
$! Created by SUBFEX.COM (FEXSUBMIT)
$! ---
$ set default SORT_DSK:[HNWRK]
$ focus
orauser.com: adding SERVER_2901523009 to LNM$FILE_DEV list.
FOCUS 6.9.8 CREATED 10/17/2000
(C)Copyright 2000 Information Builders Inc.

EX SORT_DSK:[HNWRK]PALL5 ECHO=ALL
>>>>>>>>>>>>>>>>



>>>>> JOININT CALLED TO READ DATA

MERGE: RECORDS= 827 LINES= 827

MERGE: RECORDS= 1654 LINES= 1654
.....

MERGE: RECORDS= 3056600 LINES= 3011991

NUMBER OF RECORDS IN TABLE= 3056600 LINES= 3011203

HOLDING...

FINISH
>
Exiting FOCUS
Cleaning up temporary FOCUS files
Cleaning up temporary FOCUS directory
$! --- Send completion mail
$ mail
send
P53
PALL5 FOCUS batch job complete
%MAIL-E-FILNOTDEL, error deleting DAY$SCRATCH:[YOUR_USERNAME]MAIL_204B5528_SEND.TMP;*
-RMS-F-DEV, error in device name or inappropriate device type for operation
%MAIL-E-FILNOTDEL, error deleting DAY$SCRATCH:[YOUR_USERNAME]MAIL_204B5528_SEND.TMP;*
-RMS-F-DEV, error in device name or inappropriate device type for operation
%MAIL-E-SENDABORT, no message sent
See log file: C4034_ROOT:[P53]PALL5.LOG
%CLI-W-IVVERB, unrecognized command verb - check validity and spelling
\SEE\

%MAIL-E-OPENIN, error opening C4034_ROOT:[P53.MAIL]MAIL.MAI as input
-RMS-E-FNF, file not found
%MAIL-E-NOMSGS, no messages
Created by FOCUS FEXSUBMIT
%CLI-W-IVVERB, unrecognized command verb - check validity and spelling
\CREATED\
%MAIL-E-FILNOTDEL, error deleting DAY$SCRATCH:[YOUR_USERNAME]MAIL_204B5528_SEND.TMP;*
-RMS-F-DEV, error in device name or inappropriate device type for operation
%MAIL-E-FILNOTDEL, error deleting DAY$SCRATCH:[YOUR_USERNAME]MAIL_204B5528_EDIT.TMP;*
-RMS-F-DEV, error in device name or inappropriate device type for operation
$
$! ---
$ exit
P53 job terminated at 5-MAY-2007 06:49:56.27

Accounting information:
Buffered I/O count: 13285 Peak working set size: 100000
Direct I/O count: 26993701 Peak virtual size: 444544
Page faults: 120928 Mounted volumes: 0
Charged CPU time: 0 01:31:11.00 Elapsed time: 0 04:49:56.26
 
Report This Post
Expert
posted Hide Post
Hi Edgar,

This is specific to a vax and we would need to look at what you are doing to start the process. It would require many more questions based on how the settings are done, and our internal expert said that he would like to try a repro here. Therefore, the best channel for assistance in this situation would be to open a case with Information Builders' Customer Support Services.

To open a case, you may either call at 1-800-736-6130, or access the online system InfoResponse. Here is a list of information to be ready when you call: http://techsupport.ibi.com/before_you_call.jsp.

Hope this helps. Smiler

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
Master
posted Hide Post
Edgar

VAX FOCUS runs a report in a subdirectory created with a random name. Hold files will be created there unless a FOC$HOLD or something like that logical is set or you could explicitly FILEDEF it or copy from the temporary directory.

I think when the batch job is complete the new output is being erased and you are looking at an old test output which thus seems truncated.

Regards

John



John



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report This Post
<Edgare>
posted
Thanks I will have IT submit ticket to find out if its VMS issue.

John:

Can you please give me the syntax on how to use FILEDEF or FOC$HOLD to copy from temp folder or use it to specify where temp folder should be located.

Thanks!
 
Report 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     Truncating Of Reports

Copyright © 1996-2020 Information Builders