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,

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.

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.

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?

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.

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