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
May 09, 2009, 02:24 AM
<JG>
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.
May 09, 2009, 07:54 AM
Remya
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
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.
May 11, 2009, 07:03 AM
GamP
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
May 15, 2009, 01:12 AM
Remya
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
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.
May 21, 2009, 11:44 AM
Kerry
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.
