Omega - Support Information

Page Updated: 24-6-14

Pervasive.SQL - Status Codes

When the Pervasive.SQL database engine needs to report an issue it returns a non-zero status code to the application (Omega, WIPC, etc.). Errors related to a database operation being attempted by this application usually fall within the 1 - 199 value range allocated to Btrieve API calls. Omega for DOS, or other applications running on Btrieve 6 or earlier are unlikely to return values outside of this range.

To get more information on these status codes, or codes outside of the 1 - 199 range, use the status code checker page.

Status Code

Description

1

The operation parameter is invalid

2

The application encountered an I/O error

3

The file is not open

4

The application cannot find the key value

5

The record has a key field containing a duplicate key value

6

The key number parameter is invalid

7

The key number has changed

8

The current positioning is invalid

9

The operation encountered the end-of-file

10

The key field is not modifiable

11

The specified filename is invalid

12

The MicroKernel cannot find the specified file

13

The MicroKernel could not open the extension file for an extended file

14

The MicroKernel cannot create or open the pre-image file

15

The application encountered an I/O error during pre-imaging

16

The application encountered an expansion error

18

The disk is full

19

The application encountered an unrecoverable error

20

The MicroKernel or Btrieve Requester is inactive

21

The key buffer parameter is too short

22

The data buffer parameter is too short

23

The position block parameter is not 128 bytes long

24

The page size or data buffer size is invalid

25

The application cannot create the specified file

26

The number of keys specified is invalid

27

The key position is invalid

28

The record length is invalid

29

The key length is invalid

30

The file specified is not a MicroKernel file

31

The file is already extended

32

The file cannot be extended

33

The MicroKernel cannot unload

34

The specified extension name is invalid

35

The application encountered a directory error

37

Another transaction is active

38

The MicroKernel encountered a transaction control file I/O error

39

A Begin Transaction operation must precede an End/Abort Transaction operation

40

The file access request exceeds the maximum number of files allowed

41

The MicroKernel does not allow the attempted operation

42

A file previously opened in Accelerated mode was not closed

43

The specified record address is invalid

44

The specified key path is invalid

45

The specified key flags are invalid

46

Access to the requested file is denied

47

The number of files opened exceeds the maximum allowed

48

The alternate collating sequence definition is invalid

49

The extended key type is invalid

50

The file owner is already set

51

The owner name is invalid

52

An error occurred while writing to the cache

53

The language interface version is invalid

54

The variable-length portion of the record is corrupt

55

The application specified an invalid attribute for an AUTOINCREMENT key

56

An index is incomplete

57

An expanded memory error occurred

58

The compression buffer length is too short

59

The specified file already exists

60

The specified reject count has been reached

61

The work space is too small

62

The descriptor is incorrect

63

The data buffer parameter specified on an Insert Extended operation is invalid

64

The filter limit has been reached

65

The field offset is incorrect

66

The maximum number of open databases has been exceeded

67

The MicroKernel cannot open the SQL data dictionary files

68

The MicroKernel cannot perform the RI Delete Cascade operation

69

The Delete operation specified a file that is damaged

71

There is a violation of the RI definitions

72

The MicroKernel cannot open the RI referenced file

73

The RI definition is out of sync

76

There is a conflict on the referenced file

77

The application encountered a wait error

78

The MicroKernel detected a deadlock condition

79

A programming error occurred

80

The MicroKernel encountered a record-level conflict

81

The MicroKernel encountered a lock error

82

The MicroKernel lost positioning

83

The MicroKernel attempted to update or delete a record that was read outside the transaction

84

The record or page is locked

85

The file is locked

86

The file table is full

87

The handle table is full

88

The application encountered an incompatible mode error

89

A name error occurred

90

The redirected device table is full

91

The application encountered a server error

92

The transaction table is full

93

The record lock types are incompatible

94

The application encountered a permission error

95

The session is no longer valid

96

A communications environment error occurred

97

The data buffer is too small

100

No cache buffers are available

101

Insufficient operating system memory is available

102

Insufficient stack space is available

103

The chunk offset is too big

104

The MicroKernel does not recognize the locale

105

The file cannot be created with Variable-tail Allocation Tables(VATs)

106

The MicroKernel cannot perform a Get Next Chunk operation

107

The application attempted to perform a chunk operation on a pre-v6.0 file

109

An unknown error was encountered either creating or accessing a semaphore

110

The MicroKernel cannot access the archival logging configuration file

111

The specified filename was not found in the archival logging configuration file

112

The specified file is in use by another client

113

The MicroKernel is unable to open the archival log for the specified file

114

The archival log for the specified file is invalid

115

The MicroKernel cannot access the archival logging dump file

116

The file is owned by another MicroKernel engine acting as a Gateway

120

Maximum number of B-Tree index levels reached

130

The MicroKernel ran out of system locks

132

The file has reached its size limit

133

More than 5 concurrent users attempted to access the same data file

134

The MicroKernel cannot read the International Sorting Rule

135

The specified ISR table is corrupt or otherwise invalid

136

The MicroKernel cannot find the specified Alternate Collating Sequence in the file

138

The NULL indicator position is invalid

139

The MicroKernel has detected an unacceptable value in the key number

143

The MicroKernel cannot allow unauthorized access to files in a secure MicroKernel database

146

Duplicate system key

147

The log segment is missing

148

A roll forward error occurred

149

SQL Trigger

151

Chunk Offset Too Small

160

Invalid parameters passed to MicroKernel

161

A key has reached a maximum limit for user count, session count, or data in use, or has changed state to expired or disabled

162

The client table is full

163

The NULL indicator cannot be the last segment

169

Protocol mismatch between client cache and remote engine

170

Database login required

171

Database login failed

172

Database name not found

173

Already logged in

174

Logout failed

175

Wrong database URI format

176

File or table not specified in URI

177

Table not in database

178

Directory not in database

 

 

This site is copyright 2003-2017 Neil Hughes. All rights reserved.
Company and product names on this site may be trademarks or registered trademarks and are hereby acknowledged.

Contact (Support)
Email: support@support4omega.co.uk
Skype: support4omega

Contact (Website/other)
Email: admin@support4omega.co.uk