Skip to main content

Error codes 20000 - 20399

FairCom SQL error codes 20000 - 20399

Abstract

FairCom SQL error codes 20000 - 20399

Table 1. SQL errors 20000 - 20264

Error code

SQLSTATE value

Class condition

Subclass message

20000

50501

FairCom DB SQL RDS error

SQL internal error

20001

50502

FairCom DB SQL RDS error

Memory allocation failure

20002

50503

FairCom DB SQL RDS error

Open database failed

20003

2a504

Syntax error

Syntax error

20004

28505

Invalid auth specs

User not found

20005

22506

Data exception

Table/View/Synonym not found

20006

22507

Data exception

Column not found/specified

If you get this error and feel like you have the table or field it cannot find, check the case of the name in the database. Lowercase identifiers are case insensitive, but Delimited Identifiers (that are a reserved word or contain upper case) are always case sensitive and you must double-quote them in queries, see Delimited Identifiers in the SQL documentation.

20007

22508

Data exception

No columns in table

20008

22509

Data exception

Inconsistent types

20009

22510

Data exception

Column ambiguously specified

20010

22511

Data exception

Duplicate column specification

20011

22512

Data exception

Invalid length at column

20012

22513

Data exception

Invalid precision at column

20013

22514

Data exception

Invalid scale at column

20014

22515

Data exception

Missing input parameters

20015

22516

Data exception

Subquery returns multiple rows

20016

22517

Data exception

Null value supplied for a mandatory (not null) column

20017

22518

Data exception

Too many values specified

20018

22519

Data exception

Too few values specified

20019

50520

FairCom DB SQL RDS error

Cannot modify table referred to in subquery

20020

42521

Access rule violation

Bad column specification for group by clause

20021

42522

Access rule violation

Non-group-by expression in having clause

20022

42523

Access rule violation

Non-group-by expression in select clause

20023

42524

Access rule violation

Aggregate function not allowed here

20024

0a000

feature not supported

Sorry, operation not yet implemented

20025

42526

Access rule violation

Aggregate functions nested

20026

50527

FairCom DB SQL RDS error

Too many table references

20027

42528

Access rule violation

Bad field specification in order by clause

20028

50529

FairCom DB SQL RDS error

Index with the same name already exists

20029

50530

FairCom DB SQL RDS error

Index referenced not found

20030

22531

Data exception

Table space with same name already exists

20031

50532

FairCom DB SQL RDS error

Cluster with same name already exists

20032

50533

FairCom DB SQL RDS error

No cluster with this name

20033

22534

Data exception

Tablespace not found

20034

50535

FairCom DB SQL RDS error

Bad free percentage specification

20035

50536

FairCom DB SQL RDS error

At least column spec or null clause should be specified

20036

07537

dynamic SQL error

Statement not prepared

20037

24538

Invalid cursor state

Executing select statement

20038

24539

Invalid cursor state

Cursor not closed

20039

24540

Invalid cursor state

Open for non-Select statement

20040

24541

Invalid cursor state

Cursor not opened

20041

22542

Data exception

Table/View/Synonym already exists

20042

2a543

Syntax error

Distinct specified more than once in query

20043

50544

FairCom DB SQL RDS error

Tuple size too high

20044

50545

FairCom DB SQL RDS error

Array size too high

20045

08546

Connection exception

File does not exist or not accessible

20046

50547

FairCom DB SQL RDS error

Field value not null for some tuples

20047

42548

Access rule violation

Granting to self not allowed

20048

42549

Access rule violation

Revoking for self not allowed

20049

22550

Data exception

Keyword used for a name

20050

21551

Cardinality violation

Too many fields specified

20051

21552

Cardinality violation

Too many indexes on the table

20052

22553

Data exception

Overflow/Underflow error

20053

08554

Connection exception

Database not opened

20054

08555

Connection exception

Database not specified or improperly specified

20055

08556

Connection exception

Database not specified or Database not started

20056

28557

Invalid auth specs

No DBA access rights

20057

28558

Invalid auth specs

User has no RESOURCE privileges

20058

40559

Transaction

Rollback

20059

22560

Data exception

No files in the table space

20060

22561

Data exception

Table not empty

20061

22562

Data exception

Input parameter size too high

20062

42563

Syntax error

Full pathname not specified

20063

50564

FairCom DB SQL RDS error

Duplicate file specification

20064

08565

Connection exception

Invalid attach type

20065

26000

Invalid SQL statement name

Invalid statement type

20066

33567

Invalid SQL descriptor name

Invalid sqlda

20067

08568

Connection exception

More than one database can't be attached locally

20068

42569

Syntax error

Bad arguments

20069

33570

Invalid SQL descriptor name

SQLDA size not enough

20070

33571

Invalid SQL descriptor name

SQLDA buffer length too high

20071

42572

Access rule violation

Specified operation not allowed on the view

20072

50573

FairCom DB SQL RDS error

Server is not allocated

20073

2a574

Access rule violation

View query specification for view too long

20074

2a575

Access rule violation

View column list must be specified as expressions are given

20075

21576

Cardinality violation

Number of columns in column list is less than in select list

20076

21577

Cardinality violation

Number of columns in column list is more than in select list

20077

42578

Access rule violation

Check option specified for non-insertable view

20078

42579

Access rule violation

Given SQL statement is not allowed on the view

20079

50580

FairCom DB SQL RDS error

More Tables cannot be created.

20080

44581

Check option violation

View check option violation

20081

22582

Data exception

No of expressions projected on either side of set-op don't match

20082

42583

Access rule violation

Column names not allowed in order by clause for this statement

20083

42584

Access rule violation

Outerjoin specified on a complex predicate

20084

42585

Access rule violation

Outerjoin specified on a sub_query

20085

42586

Access rule violation

Invalid Outerjoin specification

20086

42587

Access rule violation

Duplicate table constraint specification

20087

21588

Cardinality violation

Column count mismatch

20088

28589

Invalid auth specs

Invalid user name

20089

22590

Data exception

System date retrieval failed

20090

42591

Access rule violation

Table columnlist must be specified as expressions are given

20091

2a592

Access rule violation

Query statement too long

20092

2d593

Invalid transaction

termination

20093

22594

Data exception

Synonym already exists

20094

hz595

Remote database access

Database link with same name already exists

20095

hz596

Remote database access

Database link not found

20096

08597

Connection exception

Connect String not specified/incorrect

20097

hz598

Remote database access

Specified operation not allowed on a remote table

20098

22599

Data exception

More than one row selected by the query

20099

24000

Invalid cursor state

Cursor not positioned on a valid row

20100

4250a

Access rule violation

Subquery not allowed here

20101

2350b

Integrity constraint

No references for the table

20102

2350c

Integrity constraint

Primary key column defined null

20103

2350d

Integrity constraint

No matching key defined for the referenced table

20104

2350e

Integrity constraint

Keys in reference constraint incompatible

20105

5050f

FairCom DB SQL RDS error

Statement not allowed in readonly isolation level

20106

2150g

Cardinality violation

Invalid ROWID

20107

hz50h

Remote database access

Remote Database not started

20108

0850i

Connection exception

Remote Network Server not started

20109

hz50j

Remote database access

Remote Database Name not valid

20110

0850k

Connection exception

TCP/IP Remote HostName is unknown

20114

33002

Invalid SQL descriptor name

Fetched Value NULL & indicator var not defined

20115

5050l

FairCom DB SQL RDS error

References to the table/record present

20116

2350m

Integrity constraint

Constraint violation

20117

2350n

Integrity constraint

Table definition not complete

20118

4250o

Access rule violation

Duplicate constraint name

20119

2350p

Integrity constraint

Constraint name not found

20120

22000

Data exception

**use of reserved word

20121

5050q

FairCom DB SQL RDS error

Permission denied

20122

5050r

FairCom DB SQL RDS error

Procedure not found

20123

5050s

FairCom DB SQL RDS error

Invalid arguments to procedure

20124

5050t

FairCom DB SQL RDS error

Query conditionally terminated

20125

0750u

Dynamic SQL-error

Number of open cursors exceeds limit

20126

34000

Invalid cursor name

***Invalid cursor name

20127

07001

Dynamic SQL-error

Bad parameter specification for the statement

20128

2250x

Data Exception

Numeric value out of range

20129

2250y

Data Exception

Data truncated

20130

40000

FairCom DB SQL RDS error

Rolled back transaction

20131

50522

FairCom DB SQL RDS error

Value for Parameter marker is Missing

20132

5050u

FairCom DB SQL RDS error

Revoke failed because of restrict

20133

0a000

Feature not supported

Sorry, feature not supported in this Edition

20134

5050v

FairCom DB SQL RDS error

Invalid long datatype column references

20135

5050x

FairCom DB SQL RDS error

Contains operator is not supported in this context

20136

5050z

FairCom DB SQL RDS error

Contains operator is not supported for this datatype

20137

50514

FairCom DB SQL RDS error

Index is not defined or does not support CONTAINS

20138

50513

FairCom DB SQL RDS error

Index on long fields requires that it can push down only CONTAINS

20139

50540

FairCom DB SQL RDS error

Index on long fields not supported

20140

50512

FairCom DB SQL RDS error

Procedure already exists

20141

85001

FairCom DB SQL Stored procedure/function Compilation

Error in Stored Procedure/function Compilation

20142

86001

FairCom DB SQL Stored procedure/function Execution

Error in Stored Procedure/function Execution

20143

86002

FairCom DB SQL Stored procedure Execution

Too many recursions in call procedure

20144

86003

FairCom DB SQL Stored procedure Execution

Null value fetched

20145

86004

FairCom DB SQL Stored procedure Execution

Invalid field reference

20146

86005

FairCom DB SQL Triggers

Trigger with this name already exists

20147

86006

FairCom DB SQL Triggers

Trigger with this name does not exist

20148

86007

FairCom DB SQL Triggers

Trigger Execution Failed

20150

50551

FairCom DB SQL RDS error

View manager ID is not found

20151

50515

FairCom DB SQL RDS error

Cannot drop all columns; use DROP TABLE instead

20152

50516

FairCom DB SQL RDS error

Cannot preallocate memory for n cache items

20153

50517

FairCom DB SQL RDS error

Tree not present in cache ; search failed

20154

50518

FairCom DB SQL RDS error

Statement cache insert failed

20155

50519

FairCom DB SQL RDS error

Environment variable used for the creation of multi component index is not set properly

20156

50521

FairCom DB SQL RDS error

No SQL statement

20157

50523

FairCom DB SQL RDS error

Invalid Java Stored Procedure/Trigger method sequence

20158

50524

FairCom DB SQL RDS error

Can't create triggers on system tables

20159

28590

Invalid auth specs

Can't REVOKE privileges, you did not grant.

20160

28591

Feature not supported

Stored Procedure/Trigger Feature not supported

20161

28592

FairCom DB SQL Stored procedure Execution

Not all OUT/INOUT parameters are registered

20162

28593

FairCom DB SQL Stored procedure Execution

IN parameter can't be registered

20163

28594

FairCom DB SQL Stored procedure Execution

'Scale' for registerOutParam not implemented

20164

2a565

Syntax error

Escape character must be character string of length 1

20165

2a566

Syntax error

Missing or illegal character following the escape character

20166

50547

FairCom DB SQL RDS error

Column nullability and Default value do not match

20169

2a568

Query Execution Plan

Invalid plan table definition

20170

2a569

Query Execution Plan

No RESOURCE privileges to create plan table

20171

2a570

Query Execution Plan

No DBA access rights to create plan table

20172

2a571

Query Execution Plan

Plan table access denied

20173

2a572

Query Execution Plan

Statement ID not specified

20174

24543

FairCom DB SQL RDS error

Batch Update has resulted in resultset

20175

42588

Access rule violation

duplicate or conflicting NULL and/or NOT NULL specifications

20176

2a573

Query Execution Plan

Duplicate Statement ID specified

20177

42589

Access rule violation

Cannot define PRIMARY KEY constraint on nullable column

20178

0A500

Feature not supported

PERCENT and WITH TIES options not supported in TOP clause

20179

0A501

Data exception

View not found

20181

0A503

Data exception

Synonym not found

20182

50525

FairCom DB SQL RDS error

Function already exists

20183

50526

FairCom DB SQL RDS error

Function not found

20184

22543

Data exception

Table not found

20185

22544

Data exception

Literal length exceeds maximum limit

20186

22585

Data exception

Character column expected for LIKE predicate

20187

08006

Connection exception

JVM Initialization failed

20188

22543

Data exception

Multiple IDENTITY/DEFAULT clause specified or DEFAULT specified for IDENTITY column

20189

22543

Data exception

Insert/Update of an IDENTITY column not allowed

20190

22543

Data exception

Invalid IDENTITY Seed/Increment value specified

20191

22543

Data exception

Identity allowed only on columns of type Integer, Smallint, Tinyint, and Bigint

20192

22543

Data exception

IDENTITY cannot be specified if the table has only one column

20193

50530

FairCom DB SQL RDS error

Ambiguous Index reference , specify table name

20194

21588

Syntax error

Search condition required for recursive query

20195

22566

Invalid auth specs

User/Group already exists

20196

22567

Invalid auth specs

User/Group not found

20197

22568

Invalid auth specs

User already exists in User Group

20198

22569

Invalid auth specs

User Group not found

20199

22570

Invalid auth specs

User not found in User Group

20200

22571

Invalid auth specs

Cannot add a User Group to another User Group

20201

21589

SQL Stored procedure

Procedure has OUT/INOUT parameters

20202

21590

SQL Stored procedure

Procedure has no resultset

20203

21591

SQL Stored procedure

Scrollable cursor not supported on call statement

20211

22800

Data exception

Remote procedure call error

20212

08801

Connection exception

SQL client bind to daemon failed

20213

08802

Connection exception

SQL client bind to SQL server failed

20214

08803

Connection exception

SQL NETWORK service entry is not available

20215

08804

Connection exception

Invalid TCP/IP hostname

20216

hz805

Remote database access

Invalid remote database name

20217

08806

Connection exception

Network error on server

20218

08807

Connection exception

Invalid protocol

20219

2e000

Invalid connection name

***Invalid connection name

20220

08809

Connection exception

Duplicate connection name

20221

08810

Connection exception

No active connection

20222

08811

Connection exception

No environment defined database

20223

08812

Connection exception

Multiple local connections

20224

08813

Connection exception

Invalid protocol in connect_string

20225

08814

Connection exception

Exceeding permissible number of connections

20226

80815

FairCom DB SQL SNW errors

Bad database handle

20227

08816

Connection exception

Invalid host name in connect string

20228

28817

Invalid auth specs

Access denied (Authorization failed)

20229

22818

Data exception

Invalid date value

20230

22819

Data exception

Invalid date string

20231

22820

Data exception

Invalid number strings

20232

22821

Data exception

Invalid number string

20233

22822

Data exception

Invalid time value

20234

22523

Data exception

Invalid time string

20235

22007

Data exception

Invalid time stamp string

20236

22012

Data exception

Division by zero attempted

20238

22615

Data exception

Error in format type

20239

2c000

Invalid character set name

Invalid character set name specified

20240

5050y

FairCom DB SQL RDS errors

Invalid collation name specified

20241

08815

Connection Exception

Service in use

20242

22008

Data exception

Invalid timestamp

20243

2c001

Illegal Buffer Size

Illegal Buffer Size specified

20244

2c002

Invalid Coercion

Invalid Coercion Value Specified

20245

2c003

Missing Dboption

Value for specified dboption not found

20246

2c004

Bad Dboption

Illegal Value specified for a dboption

20247

2c005

Invalid characters in String

String contains Invalid characters

20248

22601

Data Exception

Identifier too long

20249

22602

Data exception

Identifier incompatible character set

20250

22603

Data exception

Invalid identifier

20251

22604

Data exception

Quoted string not properly terminated

20252

22605

Data exception

Missing double quote in identifier

20253

22606

Invalid length

Storage Attribute too long

20254

2f000

Invalid handle

Invalid Environment Handle

20255

08818

Connection exception

Destination IP address validation failed; the destination IP address specified by the client is not authorized to access the server

20256

08817

Connection exception

Source IP address validation failed; client machine is not authorized to access the server

20257

08557

Connection exception

Length of the database name exceeds the maximum limit

20258

5051a

FairCom DB SQL RDS error

Invalid lob datatype column references

20259

50912

FairCom DB SQL RDS error

Index on lob types requires CONTAINS operator

20260

42523

Access rule violation

Non-group-by expression in order by clause

20261

42528

Access rule violation

Order by field not found in SELECT DISTINCT list

20262

42528

Access rule violation

Order by in subquery without top or skip

20263

08819

Connection exception

Client Server mismatch; both must be either Non-Commercial Trial or Pro

20264

2350p

Integrity constraint

Invalid constraint info from storage system



Table 2. SQL errors 20265 - 20276: sequence errors

Error code

SQLSTATE value

Class condition

Subclass message

20265

50582

dharma/SQL RDS error

CREATE SEQUENCE - Sequence with the same name already exists

20266

42592

Access rule violation

DROP SEQUENCE ALTER SEQUENCE - Sequence cannot be used here

20267

50583

dharma/SQL RDS error

DROP SEQUENCE ALTER SEQUENCE - Sequence not found

20268

50584

dharma/SQL RDS error

CREATE SEQUENCE ALTER SEQUENCE - START-WITH/CURRENT-VALUE cannot be greater than MAXVALUE

20269

50585

dharma/SQL RDS error

CREATE SEQUENCE ALTER SEQUENCE - START-WITH/CURRENT-VALUE cannot be less than MINVALUE

20270

50586

dharma/SQL RDS error

CREATE SEQUENCE ALTER SEQUENCE - Invalid sequence MINVALUE specified

20271

50587

dharma/SQL RDS error

CREATE SEQUENCE ALTER SEQUENCE - Invalid sequence INCREMENT specified

20272

50588

dharma/SQL RDS error

CREATE SEQUENCE ALTER SEQUENCE - START-WITH cannot be altered in sequence

20273

50589

dharma/SQL RDS error

CREATE SEQUENCE ALTER SEQUENCE - No options specified for ALTER SEQUENCE

20274

50590

dharma/SQL RDS error

CREATE SEQUENCE ALTER SEQUENCE - Sequence increment has exceeded MAXVALUE

20275

50591

dharma/SQL RDS error

CREATE SEQUENCE ALTER SEQUENCE - Sequence decrement has exceeded MINVALUE

20276

42593

Access rule violation

CREATE SEQUENCE ALTER SEQUENCE - Only SELECT and ALTER privileges are valid for sequences



Table 3. SQL errors 20277 - 20304: RDS errors

Error code

SQLSTATE value

Class condition

Subclass message

20277

m0m00

dharma/SQL RDS error

Multiple databases not supported

20278

m0m00

dharma/SQL RDS error

Parameters not supported for multiple row inserts

20279

50592

dharma/SQL RDS error

View contains a self reference

20300

90901

FairCom DB SQL/DBS errors

Column group column doesn't exist

20301

90902

FairCom DB SQL/DBS errors

Column group column already specified

20302

90903

FairCom DB SQL/DBS errors

Column group name already specified

20303

90904

FairCom DB SQL/DBS errors

Column groups haven't covered all columns

20304

90905

FairCom DB SQL/DBS errors

Column groups are not implemented in FairCom DB SQL storage