•
|
The file is damaged, and you must recover it. Refer to the Advanced Operations Guide for more information on recovering files.
|
•
|
A pre-v6.0 Btrieve engine attempted to open a v6.x or later MicroKernel file.
|
•
|
You attempted to load a remote file when your client configuration settings for Local MicroKernel Engine and Use Remote MicroKernel Engine are incorrectly set to On and Off, respectively. To resolve this condition, at the client workstation, open PSQL Control Center (see Starting PCC on Windows in PSQL User's Guide). Under the Access properties category for MicroKernel Router, set Use Remote MicroKernel Engine to On (click the option). See To access configuration settings in PCC for a local client in Advanced Operations Guide.
|
•
|
You attempted to open a local file with a Workgroup engine that isn’t the designated Gateway engine for the file. Go to the directory where the file you attempted to open resides. Check to see if the ~pvsw~.loc in that directory is flagged read only. If it is, change it to read-write.
|
•
|
A NET START FULL for the Windows for Workgroups workstation was not used when it was booted into DOS. Use a NET START FULL to get a full redirector in the DOS client mode. BREQNT.EXE requires a full redirection. At the DOS prompt type net ver and press Enter. Here is the list of required components for a DOS workstation to connect to a Windows server:
LSL.COM LAN Card Driver IPXODI.COM IFSHLP.SYS NET START FULL These can be loaded high, using emm386. NET START FULL will load in upper memory. |
•
|
You attempted to open a local file with a Workgroup engine that isn’t the designated Gateway engine for the file. Go to the directory where the file you attempted to open resides. Check to see if the ~pvsw~.loc in that directory is flagged read only. If it is, change it to read-write.
|
1
|
2
|
Expand the nodes for PSQL (click the plus (+) sign).
|
3
|
Expand the Local Client node.
|
4
|
5
|
Click Application Characteristics in the Properties tree.
|
6
|
Click Embedded Spaces (a check mark indicates that the option is enabled).
|
•
|
The MicroKernel cannot open the pre-image file to restore file integrity. If the pre-image file is erased or damaged, the MicroKernel cannot restore the file integrity. Refer to Advanced Operations Guide for more information about recovering damaged files.
|
•
|
The file structure of a pre-image file created by this MicroKernel is different from the file structure of a pre-image file created by a v5.x MicroKernel. If you have an extraneous .PRE file in v5.x format, the MicroKernel returns this status code when you try to open the data file to which the .PRE file belongs.
|
•
|
The pre-image file is damaged and the integrity of the data file cannot be ensured. Refer to Advanced Operations Guide for more information about recovering damaged files.
|
•
|
Make sure at least one of the client configuration options, AccessUse Local MicroKernel Engine or AccessUse Remote MicroKernel Engine is enabled. If your environment includes both a server engine and Workgroup engines, you should have both settings enabled.
|
•
|
Make sure both of the client configuration options, AccessUse Local MicroKernel Engine or AccessUse Remote MicroKernel Engine are enabled.
|
•
|
For Get or Step operations, the MicroKernel returns as much data as it can and this status code, indicating that it cannot return the entire record.
|
•
|
For the Create, Stat, and Create Index operations, the data buffer is not long enough to contain all the file specifications, the key specifications, and (if specified) the Alternate Collating Sequence (ACS) definition.
|
•
|
n/a1
|
|||
n/a1
|
n/a1
|
||
1”n/a” stands for “not applicable”
2”rounded up” means that the page size is rounded up to the next size supported by the file version. For example, 512 is rounded up to 1,024, 2,560 is rounded up to 4,096, and so forth.
3The maximum number of index segments that can be used with the Relational Engine is 119. For the MicroKernel Engine, the maximum number is 204 for a page size of 4,096, and 420 for page sizes 8,192 and 16,384.
|
•
|
The MicroKernel did not create the file, or a pre-v3.x MicroKernel created it.
|
•
|
•
|
Either the application tried to open a v5.x data file that was previously accessed in Accelerated mode by a v5.x MicroKernel and never successfully closed, or the application tried to open a file for which a v6.0 or later MicroKernel encountered an unrecoverable error during a Set or Clear Owner operation. The file integrity cannot be ensured. Refer to Advanced Operations Guide for information about recovering damaged files.
|
•
|
Your application tried to open a file in MicroKernel v5.x format using a v5.x MicroKernel; however, that same file was previously accessed by a v6.0 or later MicroKernel, which failed to close the file successfully and left a pre-image file on the disk. Version 5.x MicroKernels cannot read pre-image files created in v6.0 or later format.
|
•
|
If the records’ file is in v5.x format, this status code can indicate a file access conflict. For example, task 1 has a file locked in an exclusive transaction. Task 2 is reading records from the same file and tries to update a record that the transaction inserted. If task 2 reads the record and then task 1 aborts the transaction, task 2 receives this status code when issuing the Update operation.
|
•
|
The file may be corrupt, and you must recover it. Refer to Advanced Operations Guide for information about recovering damaged files.
|
•
|
•
|
The first byte of an Alternate Collating Sequence (ACS) definition (the identification byte) does not contain the hexadecimal value AC (for user-defined ACSs), AD (for locale-specific ACSs), or AE (for international sorting rules support). Make sure that the first byte contains the appropriate value.
|
•
|
You set the Create File Version option to v5.x, and you attempted to create a file that contains a key with a locale-specific ACS. Pre-v6.0 files do not support locale-specific ACSs.
|
•
|
You attempted to create a key segment with both the Case Insensitivity and the ACS flags set, and the MicroKernel is configured to create files in v5.x format. This combination is invalid for v5.x files.
|
•
|
You set the Create File Version value to v5.x, and you attempted to create a file with a NUMERICSA or NUMERICSTS key. Pre-v6.x files do not support these key types.
|
•
|
You set the Create File Version value to v6.x, and you attempted to use one of the new Pervasive.SQL V7 data types, such as CURRENCY or TIMESTAMP. Pre-v7.x files do not support these key types. Increase the setting for this component.
|
1
|
2
|
Expand Engines and find the desired engine name.
|
3
|
Right-click on the engine name and click Properties.
|
4
|
Click Compatibility.
|
5
|
In the right hand frame, adjust the Create File Version.
|
•
|
You attempted to create a file with the Replace option, and a bound MicroKernel data file with the same name and location already exists. However, the MicroKernel could not open the MicroKernel data dictionary file FILE.DDF, or the configuration file (DBNAMES.CFG).
|
•
|
If you attempted a Delete operation, the restrict rule is enforced, and a primary key value in the record you are trying to delete references a foreign key in the referenced file. Refer to Advanced Operations Guide for more information about RI.
|
•
|
You attempted to create a file with the Replace option, and a bound MicroKernel data file with the same name and location already exists. However, the MicroKernel detected that the existing bound file was out of sync (that is, an attempt to open the existing file would have returned this same status code).
|
•
|
Use the wait option (+100/+300) instead of the no-wait option (in versions that support the wait option).
|
•
|
The MicroKernel has reached the maximum limit for the number of sessions it can open at one time. To avoid receiving this status code, increase the value for the Number of Sessions configuration option. Beginning with Pervasive.SQL 8, the MicroKernel dynamically manages the number of sessions, and it cannot be manually increased or decreased.
|
1
|
Access the server properties in PCC (see To access configuration settings in PCC for a local client in Advanced Operations Guide.
|
2
|
Click Communication Buffer Size in the properties tree.
|
3
|
Ensure that the Receive Packet Size value is appropriate for your environment.
|
1
|
Access the server properties in PCC (see To access configuration settings in PCC for a local client in Advanced Operations Guide.
|
2
|
Click Communication Buffer Size in the properties tree.
|
3
|
Ensure that the Receive Packet Size value is appropriate for your environment.
|
•
|
For Windows servers, verify that the Maximum Packet Size registry setting is 576 decimal or 240h. The path to the MaxPktSize registry setting is
HKEY_LOCAL_MACHINE\System\currentControlSet\ Services\NwInkIPX\NetConfig\MaxPktSize. |
1
|
2
|
Type Regedit and click OK. The Registry Editor opens.
|
•
|
For an Update, Insert, or Create operation, the application receives this status code if the data buffer length it specifies for the record exceeds the message buffer length.
|
•
|
For a Get, Step, or Stat operation, the application receives this status code if the message buffer is shorter than the length of the data the MicroKernel would return, regardless of the data buffer length specified in the application.
|
•
|
DOS Requesters only: Reload the Btrieve Requester and specify a higher value for the message buffer size. This is done using the
/D parameter which is documented in Getting Started With PSQL. |
1
|
2
|
Expand Engines and find the desired engine name.
|
3
|
Right-click on the engine name and select Properties.
|
4
|
Click Performance Tuning.
|
5
|
In the right hand frame, adjust the Cache Allocation Size by entering the amount of memory to allocate for the cache. See Cache Allocation Size in Advanced Operations Guide.
|
•
|
Go to Performance tuning in the server configuration and decrease the value for the Cache Allocation configuration option.
|
•
|
The MicroKernel cannot read the BLOG.CFG file. Either the file does not use the correct format or it is corrupt. See Advanced Operations Guide for information about the BLOG.CFG file format.
|
•
|
Close all OPENs of the data file.
|
•
|
End Continuous Operations by issuing a butil -endbu command (or, if you use Backup Agent, you can issue the command pvbackup -off).
|
•
|
If Transaction Logging or Transaction Durability is active for the data file, perform a single OPEN of the data file to roll forward the transaction log.
|
•
|
After completing these corrective actions, move the delta file with invalid content to a different directory. This allows you to perform Continuous Operations on the same data file again and retains the delta file with invalid content if you need technical support.
|
•
|
•
|
•
|
If Backup Agent is on, complete your backup and turn off the agent before starting defragmentation. See also Backup Agent in Advanced Operations Guide.
|
•
|
The file reached its maximum size. This limit depends on the file version, the page size, and the number of records per page. See File Size in Advanced Operations Guide for a complete discussion.
|
•
|
The MicroKernel also returns this status code if you are not using the MicroKernel and all of the following are true:
|
•
|
You attempt to create a file with the Replace option.
|