Documentation

Error Code Reference

Previous Topic

Next Topic

ODBC Error Messages

General SQL error messages are documented elsewhere in this book. Aside from the SQL error messages, there is another known error that may occur when using FairCom DB ODBC Driver with Crystal Reports. This error may occur when generating reports that require a left outer join between tables. The cause of this error is due to the syntax used by Crystal Reports when creating the SQL statement. Users can specify the proper syntax to use by changing a key in the Windows registry. For more information about how to change the registry, please refer to this document: How to Resolve the Join Syntax Errors in Crystal Reports 9. Or search the SAP Community Network for: Crystal left outer registry.

See also:

ODBC Driver-Specific Errors

00000

Success

01000

General Warning

01000

Error while freeing statement

01001

Cursor operation conflict

01002

Disconnect Error

01003

NULL value eliminated in set function

01004

String data,right truncated

01006

Privilege not revoked

01007

Privilege not granted

01S00

Invalid connection string attribute

01S01

Error in row

01S02

Option value changed

01S06

Attempt to fetch before the result set returned the first result set

01S07

Fractional Truncation

01S08

Error saving File DSN

01S09

Invalid keyword

07001

Wrong number of parameters

07002

COUNT field incorrect

07005

Prepared statement not a cursor specification

07006

Restricted data type attribute violation

07009

Invalid descriptor index

07S01

Invalid use of default parameter

08001

Client unable to establish connection

08002

Connection name in use

08003

Connection does not exist

08004

Server rejected the connection

08007

Connection failure during transaction

08S01

Communication link failure

21S01

Insert value list does not match column list

21S02

Degree of derived table does not match column list

22001

String data right truncation

22002

Indicator variable required but not supplied

22003

Numeric value out of range

22007

Invalid datetime format

22008

Datetime field overflow

22012

Division by zero

22015

Interval field overflow

22018

Invalid character value for cast specification

22019

Invalid escape character

22025

Invalid escape sequence

22026

String data,length mismatch

23000

Integrity constraint violation

24000

Invalid cursor state

25000

Invalid transaction state

25S01

Transaction state

25S02

Transaction is still active

25S03

Transaction is rolled back

28000

Invalid authorization specification

34000

Invalid cursor name

3C000

Duplicate cursor name

3D000

Invalid catalog name

3F000

Invalid schema name

40001

Serialization failure

40003

Statement completion unknown

42000

Syntax error or access violation

42S01

Base Table or view already exists

42S02

Base Table or view not found

42S11

Index already exists

42S12

Index not found

42S21

Column already exists

42S22

Column not found

44000

WITH CHECK OPTION violation

HY000

General Error

HY000

Operation invalid on a Read only connection

HY000

User cancelled operation

HY000

Host and Database must be specified

HY000

Invalid column number

HY000

Table type out of range

HY000

No data at execution values pending

HY000

Not supported for long data

HY000

Failed to Obtain Mutex Lock

HY000

Failed to Acquire Mutex Handle

HY001

Memory Allocation Failure

HY003

Invalid application buffer type

HY004

Invalid SQL data type

HY007

Associated statement is not prepared

HY008

Operation cancelled

HY009

Invalid use of null pointer

HY010

Function Sequence Error

HY011

Attribute cannot be set now

HY012

Invalid transaction operation code

HY013

Memory management error

HY014

Limit on the number of handles exceeded

HY015

No cursor name available

HY016

Cannot modify an implementation row descriptor

HY017

Invalid use of an automatically allocated descriptor handle

HY018

Server declined cancel request

HY019

Non-character and non-binary data sent in pieces

HY020

Attempt to concatenate a null value

HY021

Inconsistent Descriptor Info

HY024

Invalid attribute value

HY090

Invalid string or buffer length

HY091

Invalid descriptor field identifier

HY092

Invalid attribute /option identifier

HY093

Invalid parameter number

HY095

Function type out of range

HY096

Invalid information type

HY097

Column type out of range

HY098

Scope type out of range

HY099

Nullable type out of range

HY100

Uniqueness option type out of range

HY101

Accuracy option type out of range

HY103

Invalid retrieval code

HY104

Invalid precision or scale value

HY105

Invalid parameter type

HY106

Fetch type out of range

HY107

Row value out of range

HY109

Invalid cursor position

HY110

Invalid driver completion

HY111

Invalid bookmark value

HYC00

Optional feature not implemented

HYT00

Timeout expired

HYT01

Connection timeout expired

IM001

Driver does not support this function

IM002

Data source not found and no default driver specified

IM003

Specified driver could not be loaded

IM004

Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

IM005

Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

IM006

Driver's SQLSetConnectAttr failed

IM007

No datasource or driver specified; dialog prohibited

IM008

Dialog failed

IM009

Unable to load translation DLL

IM010

Data source name too long

IM011

Driver name too long

IM012

DRIVER keyword syntax error

IM013

Trace file error

IM014

Invalid name of File DSN

IM015

Corrupt file data source

HY000

Invalid Character Set Name

Previous Topic

Next Topic

c-treeRTG Error Codes

Symbolic

Error Code

Description

CTE_NO_ERROR

0

Operation completed successfully

CTE_SYS_ERR

1

System error

CTE_PARAM_ERR

2

Parameter not correct

CTE_TOO_MANY_FILES

3

Too many files open. Check the FILES keyword in the configuration file

CTE_MODE_CLASH

4

File is open read-only

CTE_REC_LOCKED

5

Record locked by another user

CTE_BROKEN

6

File is corrupt. Rebuild it or restore it from a backup

CTE_DUPLICATE

7

Duplicate record not allowed

CTE_NOT_FOUND

8

Record not found

CTE_UNDEF_RECORD

9

Record position not set

CTE_DISK_FULL

10

Write error

CTE_FILE_LOCKED

11

File locked by another user

CTE_MISMATCH

13

File definition mismatch

CTE_NO_MEMORY

14

Out of memory error

CTE_MISSING_FILE

15

File not found

CTE_PERMISSION

16

User does not have appropriate access permission

CTE_NO_SUPPORT

17

Unsupported functionality

CTE_INTERFACE

19

Interface error, check FairCom DB error code (you may need to activate the error logging in ctree.conf and view the error log)

CTE_MODE_CLASH_W

23

File is open write-only

CTE_MODE_CLASH_RW

24

File is not open for read and write

CTE_AT_END

25

End of file

CTE_SYNTAX_ERR

31

Configuration syntax error

CTE_CONFIG_ERR

32

Configuration error

CTE_ENCRYPTED

33

Operation not allowed. File is encrypted

CTE_REDIRINST

34

Unexpected reference to redir instance

CTE_NOT_SQL

35

Server/database is not SQL

CTE_MISSING_TABLE

36

SQL table not found

CTE_INCOMPATIBLE

37

Client/server incompatibility

CTE_FILE_EXISTS

38

File already exists

CTE_NO_TRANSACTION

39

No active transaction

CTE_NOT_MODIFIABLE

40

Key is not modifiable

CTE_NOT_CTREE_FILE

41

Unknown file format

CTE_TRAN_EXIST

42

Transaction already active

CTE_XDD_RULE_ERR

43

XDD rule error

TOCIndex