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     [CLOSED] Issue with sink machine in FOCUS 7.6.1

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Issue with sink machine in FOCUS 7.6.1
 Login/Join
 
Member
posted
I use FOCUS 7.6.1 to run an online application and it was working finr with my earlier version of FOCUS 7.3.6. But, after upgrading to FOCUS 7.6.1, we had been getting issues in on-lines with sink machine coming down at the first instance a compiled FOCEXEC is called using RUN. We changed all the 'RUN' to 'EX' and on-lines became very slow after that.

But now the issue is that after using same transaction for sometime, sink machine comes down. Also if one user is working on the on-line system and another user logs in, the first user is thrown out and the sink machine comes down. Sink machine is supposed to support multiple users, so not able to get why it is happening.

Every time sink machine comes down with the message 'ERROR MESSAGE TEXT MISSING: 198' (FOC198)

Any help in this regard would be great.

This message has been edited. Last edited by: Kerry,


FCOUS 7.6.1
Z/OS
use focus in report generaton as well as in online screens
 
Posts: 6 | Location: India | Registered: February 25, 2009Report This Post
<JG>
posted
quote:
FOC198

This error is generally associated with space problems or FOCUS DB size.

What size is the DB, FOCUS has a 2 gig limit but requires that you explicitly use

SET FOC2GIGDB=ON

Did they forget to set this when they upgraded. Otherwise the limit is 1 gig.
 
Report This Post
Member
posted Hide Post
Not sure whether SET FOC2GIGDB=ON. I will check that with my system person.
What do you mean by the size of the FOCUS DB? As an example, I am pasting one of the biggest database that we use:

? FILE BILLMAST

STATUS OF FOCUS FILE: BILLMAST ON 05/09/2009 AT 07.43.23

ACTIVE DELETED DATE OF TIME OF LAST TRANS
SEGNAME COUNT COUNT LAST CHG LAST CHG NUMBER

BILLDATA 130281 13652 05/09/2009 07.36.51 15833
BILLDETL 130281 13652 05/09/2009 07.36.51 15833
WHOHAS 45402 6573 05/09/2009 07.36.23 15547
ITEMSEG 51009 59172 05/09/2009 07.36.33 15655
ITEMCHRG 1450 128261 05/08/2009 09.28.39 9871
ITMWKSEG 573385 315523 05/09/2009 07.36.33 15655
ITMNARR 2287 19620 05/08/2009 00.53.47 823
INVOICE 00.00.00
BITEMSEG 00.00.00
BTMWKSEG 00.00.00
BITMNARR 00.00.00
JRNLDATA 00.00.00
*INDEXES*
BILLNO 05/08/2009 06.40.31 1840
RHD_KEY 05/09/2009 07.36.51 15833
COMMON_KEYA 05/08/2009 06.40.31 1840

TOTAL SEGS 934095 556453
TOTAL CHAR 57162388
TOTAL PAGES 29353
LAST CHANGE 05/09/2009 07.36.51 15833

The recent problem that we have is that it's not supporting multiple users to the on-line application (which uses many FOCUS databases). We use FOCUSSU and FOCSU. Let me know if you have any inputs on this.
 
Posts: 6 | Location: India | Registered: February 25, 2009Report This Post
Virtuoso
posted Hide Post
Total amount of characters in your database is 57 million, which is not even close to 1 GB. So you do not have to have the 2gig setting set to on. There must be something else that is causing the problems. quite possibly there is a configuration issue, since you also get the ERROR MESSAGE TEXT MISSING warning. In a correctly configuerd environment, this should not have happened, since it then would have been able to find the explanatory text for the error code.
Maybe a re-install is in place?


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Member
posted Hide Post
By adding ERRORS DD in the started task, I got the description of the error message and it says: (FOC198) FATAL ERROR IN DATABASE I/O. FOCUS TERMINATING ERROR READING PRODUCT

I ran ? FIL PRODUCT anf ? FDT PRODUCT and REBUILD/CHECK on PRODUCT database.

? FILE PRODUCT

STATUS OF FOCUS FILE: PRODUCT ON 05/14/2009 AT 08.38.06

ACTIVE DELETED DATE OF TIME OF LAST TRANS
SEGNAME COUNT COUNT LAST CHG LAST CHG NUMBER

PRODDATA 264 06/24/2008 21.14.35 14203
PRODFLDS 264 06/24/2008 21.14.35 14203
STATESEG 13676 06/24/2008 21.14.35 14203
*INDEXES*
PPROD_ID 06/24/2008 21.14.35 14203
PPROD_CODE 06/24/2008 21.14.35 14203

TOTAL SEGS 14204
TOTAL CHAR 2843952
TOTAL PAGES 796
LAST CHANGE 06/24/2008 21.14.35 14203


? FDT PRODUCT

DIRECTORY:PRODUCT ON 05/14/2009 AT 08.38.06
DATE/TIME OF LAST CHANGE: 05/14/2009 08.38.06


SEGNAME LENGTH PARENT START END PAGES LINKS TYPE

1 PRODDATA 35 1 754 10 3
2 PRODFLDS 332 1 2 791 132 2
3 STATESEG 47 1 3 796 652 2
PPROD_ID 4 4 1 NEW
PPROD_CODE 5 5 1 NEW


REBUILD
Enter option
1. REBUILD (Optimize the database structure)
2. REORG (Alter the database structure)
3. INDEX (Build/modify the database index)
4. EXTERNAL INDEX (Build/modify an external index database)
5. CHECK (Check the database structure)
6. TIMESTAMP (Change the database timestamp)
7. DATE NEW (Convert old date formats to smartdate formats)
8. MDINDEX (Build/modify a multidimensional index)
CHECK
CHECK
ENTER NAME OF FOCUS/FUSION FILE
PRODUCT
STARTING..
REFERENCE..AT SEGMENT 1000
REFERENCE..AT SEGMENT 2000
..
REFERENCE..AT SEGMENT 12000
REFERENCE..AT SEGMENT 13000
REFERENCE..AT SEGMENT 14000
NUMBER OF SEGMENTS RETRIEVED= 14204
CHECK COMPLETED...


Please let me know if there is anything wrong with PRODUCT database.
 
Posts: 6 | Location: India | Registered: February 25, 2009Report This Post
Expert
posted Hide Post
Hi Remya,

Has this issue been resolved on your side?

I consult with internals and was suggested that this one should be addressed in a case, since it's a little more complex and some more debugging needs to be done. To open a case, you may either call at 1-800-736-6130 or access online at InfoResponse.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report 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     [CLOSED] Issue with sink machine in FOCUS 7.6.1

Copyright © 1996-2020 Information Builders