Applications P0911, P09200, P4313, P4310, P03B102 and also other affected applications intermittently get invalid record error:
Fetch from table Fxxx failed (error number 078I and no specific table named) and Record Invalid.
Once the issue appears, it happens consistently and is only resolved by clearing JDBJ service cache (from Server Manager or SAW), but it will reoccur few days later. You may have row security setup on the F0010 - Company Constant table. F0010 table is cached on the JAS server in jdbj cache.
Once F0010 is updated, and the next moment, when there is any application accessing F0010, this error will occur, therefore cache needs to be cleared.
To resolve the issue, you can apply one of the following fixes:
- Change the LocalLogicCatalog.XML file (located in ...\webclient.war\WEB-INF\classes) to run the BSFN in server instead of local:
from
<business-logic module="B0000095" function="FormatCompany" run-local="true" />
to
<business-logic module="B0000095" function="FormatCompany" run-local="false" />
If Multi Currency is turned ON, two other functions should also be set to "false" to be executed on the Enterprise server:
- B0000069 RetrieveLedgerTypeCurrency
- B0000128 RetrieveCompanyCurrencyCode
Bounce Enterprise Server and HTML Server, after the change.
2. BSFN should allow to run locally with no issue by applying fix in Tools Release 8.98.2.1 and higher.
Issue seems to reoccur at certain Tools Release like 8.98.3.x or 8.98.4.x, if so, apply the first solution.
