Kbase P4949: SYSTEM ERROR: bffld: nxtfld: scan past last field. (16)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/08/2009 |
|
Status: Verified
SYMPTOM(s):
SYSTEM ERROR: bffld: nxtfld: scan past last field. (16)
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
Not using the -cache parameter in a parameter file.
To perform database activities, the Progress client keeps a copy of the database schema, called the schema cache, in memory. By default, Progress creates the schema cache by reading the database schema stored in the database file. The client reads the schema in two parts:
During connection, the client reads all the _Db and _File records.
When the database is referenced, the client reads all the _Index, _Index-field, _File-trig, and _Field-trig records.
The time required to read the schema is usually minimal. However, the time required to read the schema might be unacceptable under the following conditions:
If the client connects to the database over a wide area network.
When a large number of clients connect to a database simultaneously. For example, after a database shutdown or crash.
To reduce the amount of time required to connect, Progress lets you store the schema cache as a binary file, called a schema cache file, on a local disk. The client can then read the schema directly from the schema cache file.
FIX:
Add the -cache parameter and a cache file location to the parameter file.
To create the schema cache file, you build the desired schema cache and save it to a binary file using the Progress statement SAVE CACHE. The schema cache file is portable across systems, so you can create the file once and distribute it across a heterogeneous network of systems.